Wednesday, January 6, 2010

System.Data.SqlClient.SqlException: Cannot open database "WSS_Search_WINSER08"

While installing SharePoint 2010 Beta 2 Configuration Wizard on Standalone box, I got the following error on Step 5.

Exception: System.Data.SqlClient.SqlException: Cannot open database "WSS_Search_WINSER08" requested by the login. The login failed.
Login failed for user 'Domain\Administrator'.


Actually my closest guess is the warning I got while installing SQL sever.
Warning was : SQL Server is not supported on Domain Controller box, which is what I had.

1. Re-install the sharepoint 2010 on a box which is not a domain controller
2. Remove the domain controller , but make sure you re-install sharepoint 2010 bits after remove the Active Directory role as otherwise you might get other error related to accounts used.