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
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)