Error connecting to MS SQL
Posted on 2005-05-17
I have a webserver and database on two separate machines in a WORKGROUP - they are on different networks also.
Database = 10.0.0.2
Webserver = 10.0.1.2
Each can ping each other and I opened the firewall to allow all.
We are using an ASP application and when trying to connect to the database, I am getting the following:
"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
Would this have anything to do with the fact that its in a WORKGROUP? Does it have to be in a DOMAIN for the trust relationship? I believe we are using 'sa' as the username in the application.