JSON Connection string configuration

Question

In the app settings JSON file I am passing through a connection string which contains the name of my server ' .\SQL2017 '

I recieve the following warning in error list when entering the server name verbaitam as so in the connection string

'Invalid escape sequence'

When I then run the 'dotnet ef database update' command in the terminal I get the error

An error occurred while accessing the Microsoft.Extensions.Hosting services. Continuing without the application service provider. Error: Could not parse the JSON file.

When I take away the .\ from the connection string to remove the warning for 'Invalid escape sequence I get passed the error above and am then faced with the error

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is conf igured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I am sure that the rest of my connection string properties are correctly entered with no warnings but I am not sure how to format the server name in the connection string in a JSON format so that it can accept without any errors

Use forward-slash instead - ./SQL2017, or encode it - .%5CSQL2017 — vitaly-t
– vitaly-t, Commented Sep 27, 2021 at 15:53

Charlieface · Accepted Answer · 2021-01-07 01:08:55Z

3

Double the backslash to escape it:

.\\SQL2017

answered Jan 7, 2021 at 1:08

Charlieface

78.6k8 gold badges35 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

JSON Connection string configuration

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related