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 devloper 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 ev 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://www.SQLAuthority.com)
pinaldave
Hello,
I tried what you sad above, but still got error:
“user not authorized”
Please help.
Thanks.