Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
muhsinkamal
Starting Member
2 Posts |
 Posted - 2010-04-29 : 12:50:42
|
| Hi all,I have SQL SERVER 2005 installed.I have provided all the necessary credentials for windows authentication.When I tried to create a new Table ,I get the error as below.Msg 262, Level 14, State 1, Line 1CREATE TABLE permission denied in database 'master'.When I used SQL Authentication ,I was prompted to give username and password.I dont Know how to proceed.Can anyone please help me out.Thanks in Advance,Muhsin . |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-04-29 : 13:29:07
|
| You need to have neccassary permission like (DBO / Sysadmin) to create an object on master db..I am here to learn from Masters and help new bees in learning. |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-04-29 : 16:59:50
|
| Personally. never create any object in master. During an upgrade or server rebuild, you'll lose everything you've created in there - it's called master for a reason. Create a "work" database and do all your extra work there.Terry-- The problem with socialism is that you eventually run out of other people’s money. -- Margaret Thatcher |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-04-29 : 17:15:28
|
| set default database to master in connection properties and then check. |
|
|
|
muhsinkamal
Starting Member
2 Posts |
Posted - 2010-05-02 : 11:51:36
|
| Hi all,I got the solution for this issue.I tried following scenario and it worked fine."Turn off User Account Control in Vista by going to the following navigation" Control Panel->User Accounts->Turn User Account Control on or off . Thanks for all who gave suggestions. |
|
|
|
|
|
|
Unable to create table