Incorrect connection string for local MSSQL database
I am trying to set up a local instance of Umbraco for development purposes and I'm having trouble getting the connection string right for the SQL database.
I have an MS SQL database installed using MS SQL Server 2017 (Developer Edition) on a PC called CVN-AL. It uses Windows Authentication. I've tried various connection strings like:
Incorrect connection string for local MSSQL database
I am trying to set up a local instance of Umbraco for development purposes and I'm having trouble getting the connection string right for the SQL database.
I have an MS SQL database installed using MS SQL Server 2017 (Developer Edition) on a PC called CVN-AL. It uses Windows Authentication. I've tried various connection strings like:
with no success. Can anyone tell me what the right way to phrase this would be?
Hi Alistair
Can you connect to database with mssql management studio and this connection string?
Is "User ID=CVN\alistair" right user?
Thanks,
Alex
Hi Alex,
Thanks for replying. I eventually found a solution on another post. I replaced the string with this one:
which worked fine.
Cheers, Alistair
Hi Alistair
Glad that you found a solution.
Thanks,
Alex
is working on a reply...