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 |
|
jpullam
Starting Member
2 Posts |
 Posted - 2010-11-09 : 11:59:57
|
| I just installed SQL Server 2005 and management Studio on my new Lenovo laptop running Windows 7 Professional. I have previously installed this on my Windows 7 desktop and did not have the problem, so I assume that something isn't right about the install.I can connect to databases on the Internet and everything is OK, but when I try to create a local database it fails. The error message says CREATE DATABASE permission denied in database 'master', (Microsoft SQL Server, Error 262)I suspected that there is something wrong with loin authority so I looked at Logins and only see 2 entries (BUILTIN\Users and sa), unlike my desktop which also has BUILTIN\ADMINISTRATORS and NT AUTHORITY\SYSTEM.I'm not a db expert, just an application developer and this stuff is a bit over my head. Can anyone point me in the right direction so I can get this working? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-11-09 : 12:09:38
|
| either add BUILTIN\ADMINISTRATORS as sysadmin, or log in as sa.or make your account member of dbcreator server role.you'll need to log in with a current sysadmin account to do this. |
 |
|
|
jpullam
Starting Member
2 Posts |
Posted - 2010-11-09 : 13:06:43
|
| Sorry, I'm not much of a db admin guy so I don't know what that means. I didn't create the sa account ... what is it? Does it have a password? Usually I just put in my server name and use Windows auth to login (and for remotes I have their URL and the assigned username and password).If I do login as "sa" will I be able to add a login then? (I can't do that right now). Sorry to be a dummy on this but I haven't had to do anything like this in the past and don't know what some of the words mean. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-11-09 : 13:52:33
|
| if you installed it, then it prompted you for an sa password.anyway, expand the security node, then logins, and see if one is a member of the sysadmin server role. if not, follow this link for instructions on adding bultin/administrators back in.oh...you are local admin on the box, right? |
|
|
|
|
|
|
|
|
Cannot create a database on new install