Forum Discussion
Unable to import SQL Server backup using SSMS
Hi, I have just installed SQL server on my windows 10 machine and SSMS. Now I am doing the following: 1- Connecting to SSMS using windows authentication 2- Importing my SQL server backup using ...
waqasqadri I read the help page and it says that the user should have CREATE database access. I am connecting with default user (window authentication), using this user, if I try to create the DATABASE, I get permission denied error. I think this could be the reason its not restoring the backup.
Could you please help me in granting the admin rights to the user?
Could you please help me in granting the admin rights to the user?
waqasqadri use SSMS GUI, edit the user => "Server role/membership"
Or see GRANT Server Permissions (Transact-SQL) - SQL Server | Microsoft Learn
- Hi, Thanks for your response. I am able to resolve the issue by uninstalling and reinstalling SSMS and SQL server. Not sure why but after the reinstall, everything worked fine without any issues.
waqasqadri I believe the problem was mostly related to permissions on the file system. Ser what happens if you run ssms as admin
- Yes this could be the reason, but I ran the SSMS without admin and it worked for me. May I did something wrong somewhere.
