Mysql 262 ошибка

MS SQL users sometimes run into “SQL Error 262” while creating a new database, logging into SQL Server Management Studio, etc.

Here at Bobcares, we routinely see & resolve MS SQL errors such as this as part of our MS SQL Support services.

Today we will go through the top causes for this error, and how to fix it.

SQL error 262 occurs when..

  • Trying to create new database in SQL Server Management Studio.
  • Logging on SQL Server Management Studio.
  • User tries to check the execution plan.
  • Trying to connect to local SQL Server Express instance using a third party application.

Now, lets see how to fix it.

MS SQL Error 262

Fixes for MS SQL Error 262

Some of the possible fixes for MS SQL error 262 are:

  • Grant Database Access to a single user.
  • Resolve issue in SQL Express.
  • Add Windows user to sysadmin role.

Now let’s see how to implement these fixes.

Grant Database Access to a single user

One of the scenarios where this SQL 262 error appears is when the user tries to check the execution plan using CTRL + M.

An execution plan is used to check how query will behave without having to execute it.

So, for including the execution plan in the query, we can allow SHOWPLAN access to the user.

Allowing particular user to grant the SHOWPLAN access using the commands shown helps in fixing SQL error 262.

USE DatabaseName
GO
GRANT SHOWPLAN TO UserName
GO

This helps fixing the error.

Fixing issue with SQL Server Express

We may encounter the 262 error while trying to connect to a  local SQL Server Express Instance from a third party application.

We can fix this error using the steps shown:

  • Firstly, follow the path:-  Start> All Programs > Microsoft SQL Server> Configuration Tools >SQL Server Surface area Configuration
  • Then, click on Add New Administrator
  • Next, move to Member of SQL Server SysAdmin role on SQLEXPRESS and Add it to right-box.
  • Finally, click on OK

Add Windows user to sysadmin role.

One of the reasons behind this 262 error to appear is not having an account available on SQL Server with sysadmin role.

There are two ways to add Windows user to the sysadmin fixed server role:

To add Windows user with login “machinenameAdministrator”

  • Using the credentials for the machinenameAdministrator account log on to the computer.
  • Then, click Start and follow the path:- All Programs > Microsoft SQL Server >SQL Server Management Studio
  • Next, connect to an instance of SQL Server.
  • Now, follow the path:- Security>right-click Logins>New Login.

MS SQL Error 262

  • Enter the user name In the Login name box,
  • Finally, in the Select a page>Server Roles

MS_SQL_Error_262.png

  • Finally, select sysadmin check box and then click OK.

To add Windows user with  login “domainname username”

  • Using the credentials for the domainnameusername account log on to the computer .
  • Next, follow the path:- Start> All Programs > Microsoft SQL Server >SQL Server Management Studio.
    Note: “Run As Administrator” option elevates the user permissions In the User Access Control dialog box, click Continue.
  • Then, connect to an instance of SQL Server in SQL Server Management Studio .
  • Next, follow the path >> Security>>right-click Logins>>click New Login.
  • Enter the user name in the Login name box,.
  • Finally, Go to Select a page, click Server Roles, select the sysadmin check box, and then click OK.

[Need assistance in fixing MS SQL errors? We are available 24×7.]

Conclusion

In short, MS SQL error 262 may occur in different scenarios like creating new database in SQL Server Management Studio, connecting to local SQL Server Express Instance from a third party application, etc. Today, we discussed in detail the possible ways by which we can handle such scenarios to fix this error.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

var google_conversion_label = «owonCMyG5nEQ0aD71QM»;

Источник

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,

enter image description here

How to fix it?

a_horse_with_no_name's user avatar

asked Jun 13, 2014 at 5:42

Sam1604's user avatar

From this blog post

To add a Windows user that has the login “machinenameAdministrator”
to the sysadmin fixed server role

  1. Log on to the computer using the credentials for the
    machinenameAdministrator account.
  2. Click the Start button, point to All Programs, click Microsoft SQL
    Server, and then click SQL Server Management Studio.
  3. Connect to an instance of SQL Server.
  4. Click Security, right-click Logins, and then click New Login.
  5. In the Login name box, enter the user name.
  6. 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

  1. Log on to the computer using the credentials for the
    domainnameusername account.

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

  3. In SQL Server Management Studio, connect to an instance of SQL
    Server.
  4. Click Security, right-click Logins, and then click New Login.
  5. In the Login name box, enter the user name.
  6. In the Select a page pane, click Server Roles, select the sysadmin
    check box, and then click OK.

bob esponja's user avatar

bob esponja

4,0833 gold badges31 silver badges29 bronze badges

answered Jun 13, 2014 at 5:52

Vignesh Kumar A's user avatar

Vignesh Kumar AVignesh Kumar A

27.7k13 gold badges62 silver badges114 bronze badges

Click Start —> All Programs —> SQL Server Management Studio Express

SQL Server Management Studio Express—> Right Click—>Run as Administrator—> Click Yes

It works

answered Nov 21, 2014 at 4:56

Naveen Goud's user avatar

0

you are probably running more than one user profile on your laptop. While opening the program, right click and run as administrator

answered Jan 18, 2022 at 1:53

Jlah Lami's user avatar

try this:
SqlSever>>Security>>Logins>>BUILTINUsers rightClick —>Properties
—>Server Roles
…select sysadimn

answered Apr 5, 2022 at 7:24

Ram-25's user avatar

1

Источник

Sql Server error 262 is common issue faced by SQ Server users when trying to create new database in SQL Server Management Studio. This error can appear also during login on SSMS. A message is returned that states that the account does not have “sysadmin” role to SQL Server.

Another reason si that starting with SQL 2008, local Administrators group is no longer added by default during SQL Server setup. You even have to use a manual step to add the current user as a local administrator. This means that it is possible, especially if you don’t use mixed authentication (or have forgotten the sa password), that you can be completely locked out of your own SQL Server instance.

For any reason you don’t have any account available on SQL Server with “sysadmin” role. So you can’t edit other users to add the specific database on their “user mapping”. The following article will tech how to fix those issue with privileges and permissions.

Error:

CREATE DATABASE permission denied in database ‘master’. (Microsoft SQL Server, Error: 262)

SQL Server error 262

SQL Server error 262

SQL server error 262

Case 1 – You have a login available account with “sysadmin” role.

This case assumes that you have an account with sysadmin roles on SQL Server like an Admin. During the setup of SQL Server you must have specified (at least one) system administrator for the instance of SQL Server, or SA account if you are using mixed mode authentication. You need to use credentials for that account to gain access to your SQL Server.

After accessing the SQL Server Management Studio with this account you can create or edit other users (The user that having the error in his case) in order to have sysadmin role.

  1. Log on to the computer using the credentials for the Administrator account.
  2. Click the Start button, point to All Programs, click Microsoft SQL Server, and then click SQL Server Management Studio.
  3. Connect to the instance of SQL Server.
  4. Click Security, right-click Logins, and then click New Login.

  5. In the Login name box, enter the user name.
  6. In the Select a page , click Server Roles, select the sysadmin check box, and then click OK.

Case 2 – How to gain sysadmin access on SQL Server when you don’t have any user with “sysadmin” role.

The worst case is when you don’t have any sysadmin user to login on the system. The single option is to start SQL server in a single user mode, in that case anyone who is local administrator on that computer can connect to SQL Server as a member of sysadmin fixed server role.

Start the instance of SQL Server in single-user mode by using either the -m or -f options. Any member of the computer’s local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role.

Make sure you stop SQL agent service, before you put SQL server service in Single user mode else you can error saying only one user can be connected.

  1. Stop the SQL Server Service:
    • Use SQL Server Configuration manager and stop the SQL service or use services to locate and stop SQL Service.
  2. Start SQL Server in Single User mode
    • Use start-up parameter m to start SQL Service in single user mode.
      • “net start MSSQLServer /m SQLCMD” if you want to use command line
      • Using configuration Manager – Locate the service which you have stopped earlier. Go to its properties, “Advanced”, click on drop down at “Startup Parameters” and add ;-m
  3. Connect to SQL Server and add desired account in SysAdmin role.
    • Open administrator command prompt. (i.e. right click on command prompt shortcut and choose “Run As Administrator”
    • Type sqlcmd –S For example
      • sqlcmd –S. (for default instance)
      • sqlcmd –S.MyInstance
    • You are connected as System Administrator, because you are part of local administrator group in windows.
    • Use this script I normally use to add local administrator group as a part of SysAdmin group in SQL Server Instance.

USE [master]

GO

CREATE LOGIN [DomainUsername] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

GO

EXEC master..sp_addsrvrolemember @loginame = N’ DomainUsername, @rolename = N’sysadmin’

GO

  1. Stop SQL Server Service.
  2. Remove startup parameter and Start SQL Service normally

This procedure is described on MSDN

Read also other SQL Server Helping Posts:

  1. Find Location of SQL Server Error Log
  2. SQL Server Error 300
  3. Restore Master Database

Case 3 – Adding specific permissions to the user

Grant SHOWPLAN access to the SQL user

SQL Server Error 262 can appear when user tries to check the execution plan using CTRL + M. A calculated execution plan is a SQL Server query plan that is created without actually running the query plan. Its main purpose is to check how query will behave without having to execute it. In order to include the execution plan in the query, we can allow user to grant SHOWPLAN access to the user. Fixing the error is possible by providing particular user the SHOWPLAN access using following commands:

USE DatabaseName

GO

GRANT SHOWPLAN TO UserName

GO

We can run the commands in the database where user faces the issue to make them view the query execution plan without any complications.

Let me know if you have any issue with the solutions regarding the Sql Server error 262.

Источник

An Effective Solution to Resolve SQL Server Error 262

Problem

One of the common errors faced by SQL Server Database users is denial of permission while trying to create a new database in SQL Server Management Studio displaying an error code 262. The problem is encountered due to issues in Windows Authentication Connection that states that the account does not have rights to login to SQL Server. The SQL Server Error 262 displays the following error message defined below:

Microsoft SQL Server Error 262

Solutions To Fix Microsoft SQL Server Error 262

Below are the possible solutions to resolve the create database permission denied error 262:

Grant Database Access to a single user

SQL Server Error 262 can appear when user tries to check the execution plan using CTRL + M. As it is difficult to see the plan for any query, execution plan can be used. A calculated execution plan is a SQL Server query plan that is created without actually running the query plan. Its main purpose is to check how query will behave without having to execute it. In order to include the execution plan in the query, we can allow user to grant SHOWPLAN access to the user. Fixing the error is possible by providing particular user the SHOWPLAN access using following commands:

USE DatabaseName
GO
GRANT SHOWPLAN TO UserName
GO

We can run the commands in the database where user faces the issue to make them view the query execution plan without any complications.

Resolve issue in SQL Express

User may encounter Microsoft SQL Server Error 262 while trying to connect to local SQL Server Express Instance from a third party application. We can fix the issue using the steps below:

  • Go to Start> All Programs > Microsoft SQL Server> Configuration Tools >SQL Server Surface area Configuration
  • Click on Add New Administrator
  • Go to ‘Member of SQL Server SysAdmin role on SQLEXPRESS’ and Add it to right-box
  • Click on OK

There are two ways to add Windows user to the SysAdmin fixed server role:

In case of ‘machinenameAdministrator’

  • Log on the Computer using account details of machineadministrator
  • Go to Start> All Programs > Microsoft SQL Server >SQL Server Management Studio
  • Now, we will connect to an instance of SQL Server
  • Go to Security tab, right-click on Logins and then Click New Login
  • Enter a new user name on the login name box.
  • Go to Select a page, select Server Roles and click on check box of SysAdmin and then OK

In case of ‘domainnameusername’

  • Using the account details of domainnameusername, log on to the computer
  • Go to Start> All Programs > Microsoft SQL Server and right-click on SQL Server Management Studio and select Run as Administrator
  • After connecting to an instance of SQL Server, go to Security Tab> right-click on Logins to create a new user name
  • Click on Server Roles under Select a Page tab, click on check box of SysAdmin and then click on OK

Conclusion

The blog has been aimed to focus on one of the SQL Server Error that user encounters while trying to create a new database, i.e. Microsoft SQL Server error 262. It further describes the possible solutions to guide users in resolving the create database permission denied error.

Источник
  • Remove From My Forums

  • Вопрос

  • Здравствуйте! У меня такой вопрос. Когда я пытаюсь создать базу данных с помощью SQL Server Management Studio Express, у меня возникает ошибка:

    Msg 262, Level 14, State 1, Line 1

    CREATE DATABASE permission denied in database ‘master’. 

    Я новичок. Подскажите пожалуйста, как мне решить данную проблему. Заранее благодарен за ответ.

Ответы

  • Нехватает прав. Залогиньтесь либо под sa либо под Windows аккаунтом (который вы указали как администратора при установке).

    • Помечено в качестве ответа

      8 февраля 2011 г. 5:27

Источник

Понравилась статья? Поделить с друзьями:
  • Mysql 134 ошибка
  • Mysql 1089 ошибка
  • Mysql 1055 ошибка
  • Mysql 1045 ошибка 1045 password yes
  • Myphoneexplorer ошибка obex errorcode c1 unauthorized