I have a strange problem with recently installed WSS 3.0…
I can navigate to the site from front end server, but when I am on any other machine I receive “Unable to connect to database. Check database connection information and make sure the database server is running.” error. In event log
I see “Cannot connect to SQL Server. MYSQLSERVERNAME not found. Additional error information from SQL Server is included below. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.”
This message is logged only when user tries to reach the site from another machine. When I try this from front end server it works OK and there is no error in event log.
Due to our specific situation WSS was configured to use sql authentication for connecting to database.
What could be wrong?
Thanks in advance!
View Complete Post