SQL SERVER – Create Database Error in Windows Vista

I recently receive question from one of the blog reader that he is having problem creating database in Windows Vista. Read original comment here.

I have installed vista ultimate and sql server 2005 developer edition in my computer.I also connect SQL 2005 in window authentication but when I CREATE any database in following query

CREATE DATABASE MANEESH
USE MANEESH

Its give me everytime following error:-
Msg 262, Level 14, State 1, Line 1
CREATE DATABASE permission denied in database ‘master’.
&
Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database ‘maneesh’. No entry found with that name. Make sure that the name is entered correctly.

But i entered name correctly.and i am not making anytype tabels in sql2005. Solve these problem please.

Solution to above problem is very simple and I have already posted solution for this in my earlier article. SQL SERVER 2005 – FIX Error: 18456 : VISTA Windows Authentication

Reference : Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
SQL SERVER 2005 – FIX Error: 18456 : VISTA Windows Authentication
Next Post
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2

Related Posts

7 Comments. Leave new

  • Hello,

    I tried what you sad above, but still got error:
    “user not authorized”

    Please help.

    Thanks.

    Reply
  • Hi i am using vista businees and trying create one database in mssql and got the same error ‘262’ i installed sp2 and but still got the same error..pls anybody help me to solve this…

    alex

    Reply
  • Hi All,
    I got this error “””Msg 262, Level 14, State 1, Line 1, CREATE DATABASE permission denied in database ‘master’.”””

    when i m create new database ..
    i m using window vista ultimate …

    plz help me to short out this problem ..

    Thanks

    Reply
    • Hi Ashwani,

      Grant the CREATE DATABASE permission to user that you are using like:
      GRANT CREATE DATABASE TO yourLogin

      This error is not relevent to operating system.

      Regards,
      Pinal Dave

      Reply
  • Solution for Microsoft SQL Server, Error: 262

    * Click on Start -> Click in Microsoft SQL Server 2005
    * Now right click on SQL Server Management Studio
    * Click on Run as administrator

    Now the problem is solved. This is the actual process to login to our SQL server 2005 as an administrator with all the administrative rights. But I think in Microsoft SQL Server 2005 express edition we do not need to go through the above process. Well my problem is solved and tomorrow I am going to connect my VB.net project with SQL server 2005. Goodnight friends!

    Reply
  • CREATE DATABASE permission denied in database ‘master’.
    i’m using window 7 and sqlserver 2005
    my account is administrator
    plz help me..
    I used grant command also but says ‘can’t grant or revoke acces to admin or yourself ‘
    plz help

    Reply
  • Thnx Hitesh……it really help me

    Reply

Leave a Reply Cancel reply

Exit mobile version