SQL Server does not exist or access denied but management studio connection works

Asked May 23 '16 at 22:45

Active May 24 '16 at 04:25

Viewed 130 times

I am trying to log on to SQLServer express 2008R2 on a Windows 2003 server using Sql server authentication over a VPN. The login and password work for Management Studio but not for the connection string in a VB6 program.

The connection string is of format

Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=databasename;Data Source=ComputerIP\SQLEXPRESS;UID=usr;PWD=mypassword

where ComputerIP is the computer IP Address How should I proceed to troubleshoot?

edited May 24 '16 at 04:25

asked May 23 '16 at 22:45

Kirsten

Instead of user id and password, what happens if you try using Intergrated security=SSPI? – Peter May 24 '16 at 02:30
The user is not on the domain, hence I am not using it. – Kirsten May 24 '16 at 02:56
In management studio do use IP or host name to connect to server? – Alex May 24 '16 at 03:44
Actually I use IP in both management studio and the connection string. – Kirsten May 24 '16 at 04:24

SQL Server does not exist or access denied but management studio connection works

0 Answers0