Microsoft sql server ошибка 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 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?

asked Jun 13, 2014 at 5:42

Sam1604's user avatar

From this blog post

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

  1. Log on to the computer using the credentials for the
    machinename\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 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
    domainname\username 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,0933 gold badges32 silver badges29 bronze badges

answered Jun 13, 2014 at 5:52

Vignesh Kumar A's user avatar

Vignesh Kumar AVignesh Kumar A

27.9k13 gold badges63 silver badges115 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>>BUILTIN\Users rightClick —>Properties
—>Server Roles
…select sysadimn

answered Apr 5, 2022 at 7:24

Ram-25's user avatar

1

Источник

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 “machinename\Administrator”

  • Using the credentials for the machinename\Administrator 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 domainname\username 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»;

Источник

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 [Domain\Username] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

GO

EXEC master..sp_addsrvrolemember @loginame = N’ Domain\Username, @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.

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

  • Question

  • Hi

    I have migrated to a new computer using Windows 7, 6 gig memory, I7 chip (old machine had xp) and have installed Visual Studio 2008 and  SQL Server 2008 R2. 

    I get CREATE DATABASE permission denied in database ‘master’. (Microsoft SQL Server, Error: 262) when I try to create a new database. 

    Other posts (example:http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/28fee0ed-c7e2-40df-8f79-f513c9848f09/) work for Vista but I cannot find how to grant permissions.  Run as administrator (vista fix) does not work.

    I have admin privaleges on my machine.  There are no other accounts.   

    What do I need to do to update privaleges?

    Thanks and have a nice day.

Answers

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

    (Right Click —> Run as administrator)

    Then Click «Yes» in Dialog box

    Now you can Create the Database…

    It really works..

    • Proposed as answer by

      Thursday, February 24, 2011 4:37 PM

    • Marked as answer by
      Ed Price — MSFTMicrosoft employee
      Saturday, November 17, 2012 5:02 AM

  • During the setup of SQL 2008 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,

    The last option is to start SQL server in a singler 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. 

    • Proposed as answer by
      BalmukundMicrosoft employee
      Monday, August 9, 2010 8:31 PM
    • Marked as answer by
      Ed Price — MSFTMicrosoft employee
      Saturday, November 17, 2012 5:02 AM

  • yeah. if you don’t have sa password and you have not added you as sysadmin then as Chirag metioned, single use mode is the option to add yourself as sysadmin to SQL

    Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out

    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.

    http://msdn.microsoft.com/en-us/library/dd207004.aspx

    Balmukund Lakhani | Please mark solved if I’ve answered your question
    ———————————————————————————
    This posting is provided «AS IS» with no warranties, and confers no rights.

    ———————————————————————————
    My Blog: http://blogs.msdn.com/blakhani

    Team Blog: http://blogs.msdn.com/sqlserverfaq

    • Proposed as answer by
      Naomi N
      Sunday, February 27, 2011 10:11 PM
    • Marked as answer by
      Ed Price — MSFTMicrosoft employee
      Saturday, November 17, 2012 5:02 AM

Источник

Hi friends! In this article, we’ll be discussing about “SQL Server error 262: CREATE DATABASE permission denied in database ‘database_name’, and how you can resolve it.

About the above “permission denied” error

This error serves as a reminder that not every user in a SQL Server environment has the authority to create databases. This error means that the user who is attempting to execute the CREATE DATABASE statement does not have the appropriate access to perform this action within the given database.

This issue often results from the user account trying to create the database having insufficient administrative access or privileges. The CREATE DATABASE statement can only be successfully used by users who have the necessary administrative rights or particular permissions for creating databases.

Other factors for the “permission denied” error in the CREATE DATABASE SQL statement

Another factor that may contribute to the error we are examining in this article, is the user’s context and the current database in use. It is important to note, that the CREATE DATABASE SQL statement, should be executed within the context of the master database, which holds the necessary authority to create new databases. If the command is issued within a different database without the required permissions, the error message will be generated.

Let’s see an example

Let’s use an example to demonstrate this permission error. Let’s assume that we have been given the task of setting up a new database on a SQL Server instance with the name “SalesDB”. However, when we try to create the database, we get the error “SQL Server error 262: CREATE DATABASE permission denied in database ‘master’”. It is clear from this situation that our user account does not have the necessary permissions to create the database. In this case, we need the assistance of a higher-level administrator or a user with sufficient privileges to correctly run the CREATE DATABASE command to fix this problem.

Remarks

Giving the user account that is executing the CREATE DATABASE statement the necessary permissions is often the first step in fixing this error. To ensure a proper execution of the database creation process, it is crucial to comprehend the user’s security context, the target database, and the applicable permissions.

It’s important to keep in mind that, despite the SQL Server error 262 appearing to be a challenge, a solid understanding of permissions and administrative roles will enable you to go around it and successfully build databases in your SQL Server environment.

Strengthen your SQL Server Administration Skills – Enroll to our Online Course!

Enroll to our online course on Udemy titled “Essential SQL Server Administration Tips”
(special limited-time discount included in link).

Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!

Essential SQL Server Administration Tips - Online Course with Live Demonstrations and Hands-on Guides

(Lifetime Access/ Live Demos / Downloadable Resources and more!)

Enroll from $12.99

Featured Online Courses:

  • SQL Server 2022: What’s New – New and Enhanced Features
  • Working with Python on Windows and SQL Server Databases
  • Introduction to Azure Database for MySQL
  • Boost SQL Server Database Performance with In-Memory OLTP
  • Introduction to Azure SQL Database for Beginners
  • Essential SQL Server Administration Tips
  • SQL Server Fundamentals – SQL Database for Beginners
  • Essential SQL Server Development Tips for SQL Developers
  • Introduction to Computer Programming for Beginners
  • .NET Programming for Beginners – Windows Forms with C#
  • SQL Server 2019: What’s New – New and Enhanced Features
  • Entity Framework: Getting Started – Complete Beginners Guide
  • Data Management for Beginners – Main Principles
  • A Guide on How to Start and Monetize a Successful Blog

Read Also:

  • Advanced SQL Server Features and Techniques for Experienced DBAs
  • SQL Server 2022: What’s New – New and Enhanced Features (Course Preview)
  • SQL Server 2022 Generally Available!
  • An existing History Table cannot be specified with LEDGER=ON – How to Resolve
  • SQL Server 2022 Overview: A Hybrid Data Platform
  • Azure Synapse Link in SQL Server 2022
  • What is Data Management and why it is Important?
  • What is Data Security and which are its Main Characteristics?
  • Data Security vs. Data Privacy
  • What are NoSQL Databases?
  • Differences Between Batch and Streaming Data
  • What is Data Compliance within the Data Management Scope?
  • How to Connect to SQL Server Databases from a Python Program
  • How to Resolve: [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)
  • Useful Python Programming Tips
  • Main Data Structures in Python
  • Working with Python on Windows and SQL Server Databases (Course Preview)
  • How to Write to a Text File from a C++ Program
  • How to Establish a Simple Connection from a C# Program to SQL Server

Subscribe to our newsletter and stay up to date!

Subscribe to our YouTube channel (SQLNetHub TV)

Check our eBooks!

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

Loading…

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub

Artemakis Artemiou

Artemakis Artemiou is a Senior SQL Server Architect, Author, a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 20 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and {essentialDevTips.com}. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Moreover, Artemakis teaches on Udemy, you can check his courses here.

Views: 333

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit «Cookie Settings» to provide a controlled consent. Read More

Источник

Понравилась статья? Поделить с друзьями:
  • Microsoft sql server ошибка 233
  • Microsoft sql server ошибка 18456 как исправить
  • Microsoft sql server ошибка 18461
  • Microsoft sql server ошибка 15517
  • Microsoft sql server ошибка 15405