Login to SQL server through the internet - 12-02-2004 , 01:59 PM
The connection string below returns the error 'not associated with a trusted
SQL server connection'. The Windows 2000 server were the SQL instance resides
is in Mixed authentication mode and I have added the user login.
strConn = "workstation id=http://myDomainName.com/ServerName"
";packet size=4096;" +
";persist security info=false" +
";data source=ServerName" +
";initial catalog=DatabaseName" +
";user id = WEBSERV" +
";Password = enter";
RE: Login to SQL server through the internet - 12-03-2004 , 01:47 AM
I assume this is a default instance otherwise you will need to connect using
the instance name as well!
Have you tried connecting with this user through the ISQL?
You may want to try and profile attempted connections.
You may want to try a different network library.