Forum Discussion
waqasqadri
Jan 28, 2024Copper Contributor
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
Jan 29, 2024Copper Contributor
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?
- olafhelperJan 29, 2024Bronze Contributor
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
- waqasqadriJan 29, 2024Copper ContributorHi, 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.
- Jan 29, 2024
waqasqadri I believe the problem was mostly related to permissions on the file system. Ser what happens if you run ssms as admin