How to Fix Microsoft Sql Server, Error: 262?
I'm Opening the Sql Server Management Studio with Run as Administrator. .. and There Is No Problem with Windows Authentication Connection. I'm Choosing "New...
I'm opening the SQL Server Management Studio with run as administrator...
And there is no problem with Windows Authentication Connection.
I'm choosing "New Database" by right-click the Databases folder.
And giving name 'BTS' for the Database.
When i'm choosing OK, i get the error as,
How to fix it?
4 Answers
From this blog post
To add a Windows user that has the login “machinename\Administrator” to the sysadmin fixed server role
- Log on to the computer using the credentials for the machinename\Administrator account.
- Click the Start button, point to All Programs, click Microsoft SQL Server, and then click SQL Server Management Studio.
- Connect to an instance of SQL Server.
- Click Security, right-click Logins, and then click New Login.
- In the Login name box, enter the user name.
- In the Select a page pane, click Server Roles, select the sysadmin check box, and then click OK.
To add a Windows user that has the login “domainname \username” to the sysadmin fixed server role
- Log on to the computer using the credentials for the domainname\username account.
Click the Start button, point to All Programs, click Microsoft SQL Server, right-click SQL Server Management Studio, and then click Run as administrator.
ps: “Run As Administrator” option elevates the user permissions In the User Access Control dialog box, click Continue.
- In SQL Server Management Studio, connect to an instance of SQL Server.
- Click Security, right-click Logins, and then click New Login.
- In the Login name box, enter the user name.
- In the Select a page pane, click Server Roles, select the sysadmin check box, and then click OK.
Click Start --> All Programs --> SQL Server Management Studio Express
SQL Server Management Studio Express---> Right Click--->Run as Administrator--> Click Yes
It works
you are probably running more than one user profile on your laptop. While opening the program, right click and run as administrator
try this: SqlSever>>Security>>Logins>>BUILTIN\Users rightClick -->Properties -->Server Roles ...select sysadimn
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
