I've got a Problem.
In november we moved our server system locally. For that we have to shutdown the sharepoint sever (virtual).
When we restart all the systems the sharepoint sever have lost the LUNs where the database originally was set.
We attached them again and try to open the teamsites. Doesn't work. It turns out, that the database was now on the local disk and the necessary rights where missing.
We add the rights again. Now the teamsites works.
At least I've tried to migrate the database back to the LUNs. That doesn't works.
I can connect the SQL, but when I tried to associate the Database with the available Disks following failure appers:
Cannot export the config xml. Please check your SMSQL configuration and try again.
So I've tried to reconfigure the connection in the SnapManager for SQL Server. When I've tried to open the database this failure appears:
Failed to connect to SQL Server "...". Verify the log-in credentials.
You may only perform restore operation. Please start the SQL Server you are connectiong to, and SnapManager will also try to start SQL Server during restore if it's stopped.
Details: Error Code: 0xC0040804 Faild to connect to the specified SQL Server.
The SQL Server is startet. The connection is made by windows login, exactly how i configured it, by installing Sharepoint the first time.
So I've go on with trying to reconfigure it with the Configuration Wizard. An other failure appears when the database selection should be done:
Faild to load configuration data. Details:[SQL-DMO API Error]:
Source: Microsoft SQL-DMO (ODBC SQLState: 42000)
Error Message: Unkonwn Error 0x800400E5
Description: Die EXECUTE-Berechtigung wurde für das 'xp_instance_regenumvalues'-Objekt, 'mssqlsystemresource'-Datenbank, 'sys'-Schema, verweigert.
(The EXECUTE permission was denied on the object 'xp_instance_regenumvalues', database 'mssqlsystemresource', schema 'sys'.)
Now I run out of Ideas. I've checked the Database permissions, but can't find a mistake.
Systems we use:
MS Sharepoint Foundation 2010
MS SQL Server 2008
NetApp SnapManager for SQL Server Management
NetApp SMSP Agent Tools & Manager Tools
Thanks for any suggestions.