CODEWITHSUNDEEP
c#sql-servervisual-studioconnection-stringremote-access
Afshin
Afshin

Reputation: 497

Can connect to the remote SQL server, but connection string test fails

I have my application and SQL database on two different PCs in the same LAN. I use Visual Studio 2017 community version.

I can connect to the database through SQL Server Object Explorer, in VS17, but when I try to make a new connection string in my application setting using the same credentials, testing the connection fails.

Here is my connection string:

Data Source="192.168.1.194, 4135";Initial Catalog=Test_DB;Persist Security Info=True;User ID=remote_user;Password=1234

Any idea of how to fix it? Thanks.

Upvotes: 1

Views: 346

Answers (1)

Afshin
Afshin

Reputation: 497

Trying different ways, I finally made two other logins on the remote SQL Server, and interestingly those logins worked fine with my connection string. I suspect I could not use the same login on both SQL Server Object Explorer and the connection strings at the same time... just guessing... anyhow, it works fine for other logins.

Upvotes: 1

Related Questions