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