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 ...
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.
