Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
Have you looked at this article? blogs.msdn.com/b/sql_protocols/archive/2008/05/03/… –  DanBig Jun 5 '12 at 19:43

1 Answer 1

up vote 0 down vote accepted

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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