Sharepoint database connection issue after upgrade to SQL Server 2008 R2
- by Neil Hoff
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?