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)
7 Comments. Leave new
Hello,
I tried what you sad above, but still got error:
“user not authorized”
Please help.
Thanks.
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
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
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!
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
Thnx Hitesh……it really help me