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 (http://blog.SQLAuthority.com)

About these ads

7 thoughts on “SQL SERVER – Create Database Error in Windows Vista

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

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

    • 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

  3. 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!

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s