Dotnet API and local DB connection string
Hey there, I can't for the life of me connect my Dotnet API to my local MSSQL server.
It works as it should when I'm connecting to my Azure SQL Database and querying data, so it's not a code problem. Outside of the Dotnet API I have successfully connected to my local db with these methods:
- DBeaver, sa user and password (URL)
- DBeaver, windows authentication (URL)
- DBeaver, sa user and password (Host)
- DBeaver, windows authentication (Host)
- Visual Studio SQL server object explorer
...So the server is working as it should.
I've tried a few dozen different connection strings. I've tried the connection string generated by SQL server object explorer. Judging by search results, it seems everyone on the internet has a different "default connection string" that works fine.
What should this thing even look like?
More info: I've enabled TCP connection on localhost:1433 in SQL Server Config Manager. When I installed the server, I enabled mixed login (windows or username/pwd)
It works as it should when I'm connecting to my Azure SQL Database and querying data, so it's not a code problem. Outside of the Dotnet API I have successfully connected to my local db with these methods:
- DBeaver, sa user and password (URL)
- DBeaver, windows authentication (URL)
- DBeaver, sa user and password (Host)
- DBeaver, windows authentication (Host)
- Visual Studio SQL server object explorer
...So the server is working as it should.
I've tried a few dozen different connection strings. I've tried the connection string generated by SQL server object explorer. Judging by search results, it seems everyone on the internet has a different "default connection string" that works fine.
What should this thing even look like?
More info: I've enabled TCP connection on localhost:1433 in SQL Server Config Manager. When I installed the server, I enabled mixed login (windows or username/pwd)
