Click here to Skip to main content
15,902,198 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi,....

i try to restore backup in sharepoint2010 i use sqlserver 2008 Re version,but i get below error when i try to restore backup

-
CSS
SharePoint - 18001  Error 3/29/2013 7:12 AM Object SharePoint - 18001 failed in event OnRestore. For more information, see the spbackup.log or sprestore.log file located in the backup directory.
ArgumentException: The IIS Web Site you have selected is in use by SharePoint.  You must select another port or hostname.

-WSS_Content_18001  Error 3/29/2013 7:12 AM Object WSS_Content_18001 failed in event OnRestore. For more information, see the spbackup.log or sprestore.log file located in the backup directory.
SqlException: CREATE DATABASE permission denied in database 'master'.
RESTORE DATABASE is terminating abnormally.



- i already try to chnage iis website name and also give permission all server role to user but still i get error how i can solve it any idea abou it please tell me.
Posted
Comments
ZurdoDev 29-Mar-13 8:11am    
The error says it doesn't have permissions to create a database.
bhavesh002 29-Mar-13 8:52am    
SqlException: CREATE DATABASE permission denied in database 'master'.

yes but i give all permission any other extra permission for create share point database or any other setting for create database
ZurdoDev 29-Mar-13 8:54am    
Apparently you did not give the proper permission. I am unaware of what context it is running under so you'll need to figure that out and grant the proper permissions.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900