I took a backup of all our Sharepoint WSS 3.0 databases and restored them to a new Windows 2008 R2 server.

The new SQL server has the same name and IP address as the old one. The only difference between the two is the new one has SQL 2008 R2 and the old one has SQL 2005.

When I navigate to the sharepoint url I get this error:

Cannot connect to the configuration database.

I checked the logs at this location: "%commonprogramfiles%/Microsoft Shared/web server extensions/12/Logs" and found this error:

System.Data.SqlClient.SqlException: Login failed. The login is from an untrusted
domain and cannot be used with Windows authentication.

Any ideas?


Sounds like your SharePoint farm might be trying to connect via SQL Authentication and the SQL Server isn't setup to accept SQL Authentication.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.