DSN not able to connect to a remote SQL server

0
votes

I am moving all my existing applications to a new web server, applications use a DSN based connection using ODBC driver.

On the new server I am trying build DSN which connect's to remote SQL Server, but I am getting the error : 

System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Invalid connection string attribute

Connection string is : "Dsn=dsnName;uid=userID;pwd=pswd;Provider=SQLOLEDB;Integrated Security=SSPI"

It works fine on my local P.C, but I get this error while establishing DSN on the web server.

If I specify the port number along with the Server name (servername, 6000) then connection went's thru but my application throw the same error.

Please help.

1
c#asp.netsqlodbcdsn

1 Answers

1
votes

Try using connection string as follows:

Server=dsnName;uid=userID;pwd=pswd;Provider=SQLOLEDB;Integrated Security=SSPI"

or try using

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI; User ID=myDomain\myUsername;Password=myPassword;