Меню

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

Источник
  • 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

Источник

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.5k12 gold badges60 silver badges110 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.

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

  • Вопрос

  • Hey everyone I’m trying to create a new database in SQL Server 2012 and keep getting the 262 error.  (Create database permission denied in database «master».(microsoft sql server error:262)

    I’m running on Windows 7 home premium 64 bit, am on the administrative account and have set permissions in the properties to allow me to do everything…

    I’m not sure what else to try and any help would be much appreciated! Thanks in advance.

    -Joe

     

Ответы

  • hello Joseph

    could you try to create using t-sql in a query window?

    try the following:

    CREATE DATABASE [test]

    then try with explicitely specifying the path to the files.

    CREATE DATABASE [test1] ON  PRIMARY 
( NAME = N'test1', FILENAME = N'C:TEMPtest1.mdf' )
 LOG ON 
( NAME = N'test1_log', FILENAME = N'C:TEMPtest1.ldf')

    replace the path c:temp by a directory of your choice where the SQL Server service account does have full control.

    could you please check the default setting for database default locations ? start SSMS, connect to server, select server, open Properties dialog, select «Database Settings», check «Database default locations», they must not be empty and the SQL Server service
    account needs read/write access to this folder.

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

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

      17 мая 2012 г. 8:48

  • You said «I set it to windows authentication only» and you also said «am using the SA account». These are mutually exclusive. That is, if your instance of SQL Server is set to Windows Authentication only, then the sa account cannot be used to connect. So…
    I think you must really be connecting using your domain login and Windows Authentication. And that account is probably not a member of the sysadmin fixed server role. These three queries will help you figure out who SQL Server thinks you are, and what permissions
    you have.

    SELECT SUSER_NAME() AS YourLogin, USER_NAME() AS YourDBUserIdentity;
    SELECT IS_SRVROLEMEMBER(‘sysadmin’) AS True_is1_False_is0;
    SELECT permission_name, state_desc FROM sys.server_permissions WHERE grantee_principal_id = SUSER_ID();

    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

    • Помечено в качестве ответа
      Maggie Luo
      17 мая 2012 г. 8:48

Источник

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.

Источник

Descriptive Solution to Fix Microsoft SQL Error 262

I am launching Microsoft SQL Server management studio by running it with option of ‘Run as administrator’. I am facing none of the errors at the time of establishing Windows Authentication connection. But, when I select the option for creating ‘new database’, I encounter an error dialog box. This dialog box is restricting me from creating new database in SQL server. I don’t know what has happened in the servers but, all what I want is to fix the problem ASAP. Is there any SQL expert who can provide solution for this SQL error 262?

One of the popular error faced by Microsoft server administrators is denial of permissions to create a new database in MS SQL server management studio. Microsoft SQL server database creation error 262 usually occurs due to the presence of some issue in Windows Authentication connection. The error statement states that the current account is not having rights to sign into the SQL server.

Microsoft SQL server database creation error 262

Measures to Quickly Fix SQL Error 262

Following illustrated are the solution for troubleshooting the SQL server database creation error 262 in shortest time duration :

Measure 1 : Permit Database Access to Single User

The SQL server error 262 appears when the server users try to verify the execution plan via Ctrl + M. In comparison to the execution plan, it is quite tough to view the query plan. Therefore, an execution plan is calculated in place of the query plan, which is initiated without running the SQL server query plan. The main aim of doing so is to analyze the behavior of query, prior to its execution. Execution plan in a query can be consolidated by permitting end users with SHOWPLAN access. Following commands will help in resolving the Microsoft SQL error 262 after giving SHOWPLAN access permission :

USE DatabaseName
GO
GRANT SHOWPLAN TO UserName
GO

Execute the commands on the database where you are facing problem at the time of database creation in SQL server.

Measure 2 : Fix the Error Using Microsoft SQL Express

There might be a condition where end users face SQL server database creation error 262 when they are trying to establishing connection between the local instance of SQL server and 3rd party app. In this scenario, use following steps for SQL error 262 fixation :

1. Click on Start >> All Programs >> Microsoft SQL Server >> Configuration Tools >> SQL Server Surface Area Configuration
2. Click on the Add New Administrator and then navigate towards ‘Member of SQL Server SysAdmin role on SQLEXPRESS’
3.  Add the respective option in the right-box and then, click on OK button

Now there are two methods for adding Windows OS users in the SysAdmin fixed server role. Description of both these approaches are mentioned-below :

Using ‘machinenameAdministrator’

  • Sign-in into your Computer via account information of machineadministrator
  • Click on Start >> All Programs >> Microsoft SQL Server >> SQL Server Management Studio
  • Now establish a connection with SQL Server instance to proceed with resolving of SQL error 262
  • Click on the Security tab and right-click on Logins
  • From the list of options, select New Login option
  • Now in the login name box, type the new username
  • Navigate towards Select a page, choose the Server Roles and then, enable the checkbox of SysAdmin
  • At last, click on OK button to fix Microsoft SQL server database creation error 262

Using ‘domainnameusername’

  • Make use of domainnameusername credentials to login to the PC
  • Click on Start >> All Programs >> Microsoft SQL Server and then, right-click on the SQL Server Management Studio
  • Choose the option of Run As Administrator
  • When connection with SQL Server instance gets established, click on Security Tab
  • Right-click on the Logins for creation of new username
  • Go to the Select a Page section and click on Server Roles
  • Activate the checkbox of SysAdmin and then, click on OK

That’s It For Problem Resolving

All possible measures to troubleshoot SQL error 262 at the time of database creation is illustrated in this post. Microsoft server administrators can execute these measures, if they are encountering same sort of problem. The solutions are provided by Invorx team of SQL experts and they give assurance that one of the provided solutions will definitely work on your platform.

Источник

RRS feed

  • Remove From My Forums

  • Question

  • Cn not do anything with my sql server, everything i trt to do i get this message, user does not have permision, etc, ,

    I am running windows Vista Business, SQL SERVER 2005

    so what going on here

Answers

  • True and try to test it on a other Windows edition and see the user privileges are not an issue.

All replies

  • True and try to test it on a other Windows edition and see the user privileges are not an issue.

  • Just tryed with SP2.  Got the same error.  This is fun.  Can any Microsoft MVP enlighten us please?

  • Thank you very much. I spent some time to try to work with the SQL server management studio express on a VISTA machine and I could not figure out why I could not perform simple things like creating a new database. I became a bit frustrated by messages like  : CREATE DATABASE permission denied in database ‘master’; user does not have permission to perform this action; and SQL server error 262. Now I know it have to wait. This is not something I can not solve myself

  • Hey…

    Just start the management studio with administrator rights…

    ie: go to it from the start menu and right click it….then select run as administrtor..(if you are on vista you should have this option)

    it worked for me…

    All the best

  • havign same problem, been kicking myself in the head for an hour, keep forgeting about run as admin..

    Worked fine

    thanks

  • He.. Yeah, it works

    I have been trying fro several hours, searching google, various sites for some answers.

    Just open it as an administrator.

    Why does Vista suck with these programs?

    Just «Keep It Simple Stupid»….

  •   You don’t need to elevate to a full administrator token every time (actually I would recommend not to do it). As the article that Laurentiu pointed out, there is an easier solution.

      You still need to elevate to «run as administrator» once in order to connect as a member of sysadmin, then you can create a login for yourself and add yourself to sysadmin fixed server role. Once this step is done, next time you start from a UAC token in Vista you will be a member of sysadmin.

      Also notice that on SQL Server 2008 the assumption that builtinAdministrators are sysadmins is no longer true (See «SQL Server 2008 Security Changes» for more information). During setup it will be required to specify an explicit administrator account (there is a «quick-button» to add your current credentials as administrator).

    -Raul Garcia

      SDE/T

      SQL Server Engine

  • thanx wasif it works for me i was going to format my vista but at last ur post give me a chance to live with vista 🙂 thanx again 
    take care 
    god bless u Smile

  • Hi, thank you so much for your simple, powerful advise!!! After all day struggle, with your help I can create a database!!!!!!!!!

    so now i am thinking how you found out about this solution? and another thing is how long this painful opening of SMSE will carry on? Thanks again!

  •  Raul Garcia — MS wrote:

      You don’t need to elevate to a full administrator token every time (actually I would recommend not to do it). As the article that Laurentiu pointed out, there is an easier solution.

      You still need to elevate to «run as administrator» once in order to connect as a member of sysadmin, then you can create a login for yourself and add yourself to sysadmin fixed server role. Once this step is done, next time you start from a UAC token in Vista you will be a member of sysadmin.

      Also notice that on SQL Server 2008 the assumption that builtinAdministrators are sysadmins is no longer true (See «SQL Server 2008 Security Changes» for more information). During setup it will be required to specify an explicit administrator account (there is a «quick-button» to add your current credentials as administrator).

    -Raul Garcia

      SDE/T

      SQL Server Engine

    Hi, I tried but failed, please tell me in very simple instruction what to do to set up myself as sysadmin so I dont have to go to start and right click everytime!?

    Thank you for your help


  • thanx for your information.this was very useful to me.

  •  i was having this problem on vista too and got solved by opening management studio with admin rights. Thanks for your post.

  •  

    Vasif Nagarwala

    Thank You.
    Admin Rights «Run as Admin»  worked right away

    Vista Ultimate

    Joe P

  • hai buddy. I tried your infor and got the solution. actually i tried this at long time but your infor help me. THANK YOU.

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

  • The problem is easy.. Just go to: *Start *All Programs *Microsoft SQL Server *Right click the «Microsoft SQL Server Management Stud. *Properties *Compatibility *[Check] «Run this program in compatibility mode for: «Windows XP (Service Pack 3)» *[Check]
    «Run this program as an administrator» then click ok to apply the settings you made. test the Program and its now working.. ^_^

  • thanx genious… it worked for me..!!!

  • wow i did it you did it but im happy

    internet google.com did it


Источник

RRS feed

  • Remove From My Forums

  • Question

  • Cn not do anything with my sql server, everything i trt to do i get this message, user does not have permision, etc, ,

    I am running windows Vista Business, SQL SERVER 2005

    so what going on here

Answers

  • True and try to test it on a other Windows edition and see the user privileges are not an issue.

All replies

  • True and try to test it on a other Windows edition and see the user privileges are not an issue.

  • Just tryed with SP2.  Got the same error.  This is fun.  Can any Microsoft MVP enlighten us please?

  • Thank you very much. I spent some time to try to work with the SQL server management studio express on a VISTA machine and I could not figure out why I could not perform simple things like creating a new database. I became a bit frustrated by messages like  : CREATE DATABASE permission denied in database ‘master’; user does not have permission to perform this action; and SQL server error 262. Now I know it have to wait. This is not something I can not solve myself

  • Hey…

    Just start the management studio with administrator rights…

    ie: go to it from the start menu and right click it….then select run as administrtor..(if you are on vista you should have this option)

    it worked for me…

    All the best

  • havign same problem, been kicking myself in the head for an hour, keep forgeting about run as admin..

    Worked fine

    thanks

  • He.. Yeah, it works

    I have been trying fro several hours, searching google, various sites for some answers.

    Just open it as an administrator.

    Why does Vista suck with these programs?

    Just «Keep It Simple Stupid»….

  •   You don’t need to elevate to a full administrator token every time (actually I would recommend not to do it). As the article that Laurentiu pointed out, there is an easier solution.

      You still need to elevate to «run as administrator» once in order to connect as a member of sysadmin, then you can create a login for yourself and add yourself to sysadmin fixed server role. Once this step is done, next time you start from a UAC token in Vista you will be a member of sysadmin.

      Also notice that on SQL Server 2008 the assumption that builtinAdministrators are sysadmins is no longer true (See «SQL Server 2008 Security Changes» for more information). During setup it will be required to specify an explicit administrator account (there is a «quick-button» to add your current credentials as administrator).

    -Raul Garcia

      SDE/T

      SQL Server Engine

  • thanx wasif it works for me i was going to format my vista but at last ur post give me a chance to live with vista 🙂 thanx again 
    take care 
    god bless u Smile

  • Hi, thank you so much for your simple, powerful advise!!! After all day struggle, with your help I can create a database!!!!!!!!!

    so now i am thinking how you found out about this solution? and another thing is how long this painful opening of SMSE will carry on? Thanks again!

  •  Raul Garcia — MS wrote:

      You don’t need to elevate to a full administrator token every time (actually I would recommend not to do it). As the article that Laurentiu pointed out, there is an easier solution.

      You still need to elevate to «run as administrator» once in order to connect as a member of sysadmin, then you can create a login for yourself and add yourself to sysadmin fixed server role. Once this step is done, next time you start from a UAC token in Vista you will be a member of sysadmin.

      Also notice that on SQL Server 2008 the assumption that builtinAdministrators are sysadmins is no longer true (See «SQL Server 2008 Security Changes» for more information). During setup it will be required to specify an explicit administrator account (there is a «quick-button» to add your current credentials as administrator).

    -Raul Garcia

      SDE/T

      SQL Server Engine

    Hi, I tried but failed, please tell me in very simple instruction what to do to set up myself as sysadmin so I dont have to go to start and right click everytime!?

    Thank you for your help


  • thanx for your information.this was very useful to me.

  •  i was having this problem on vista too and got solved by opening management studio with admin rights. Thanks for your post.

  •  

    Vasif Nagarwala

    Thank You.
    Admin Rights «Run as Admin»  worked right away

    Vista Ultimate

    Joe P

  • hai buddy. I tried your infor and got the solution. actually i tried this at long time but your infor help me. THANK YOU.

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

  • The problem is easy.. Just go to: *Start *All Programs *Microsoft SQL Server *Right click the «Microsoft SQL Server Management Stud. *Properties *Compatibility *[Check] «Run this program in compatibility mode for: «Windows XP (Service Pack 3)» *[Check]
    «Run this program as an administrator» then click ok to apply the settings you made. test the Program and its now working.. ^_^

  • thanx genious… it worked for me..!!!

  • wow i did it you did it but im happy

    internet google.com did it


Источник

0 0 голоса
Рейтинг статьи
Подписаться
Уведомить о
guest

0 комментариев
Старые
Новые Популярные
Межтекстовые Отзывы
Посмотреть все комментарии

А вот еще интересные материалы:

  • Яшка сломя голову остановился исправьте ошибки
  • Ясность цели позволяет целеустремленно добиваться намеченного исправьте ошибки
  • Ясность цели позволяет целеустремленно добиваться намеченного где ошибка
  • Microsoft sql server ошибка 229
  • Microsoft sql server ошибка 223

    • ➤