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 |
|
Riemens
Starting Member
2 Posts |
 Posted - 2008-06-14 : 04:46:03
|
| Hi,I have just received my notebook from my work, and Sql Server 2005 is installed on it. There are 2 accounts, the SA (i dont know this password), and my Windows account.When I go to security - server roles; I see that only the SA account is assigned to the sysadmin role. But my account is not assigned to any server role and when I want to create a database I get the following error: CREATE DATABASE permission denied in database 'master'. (This is at my local database)Is there anyway I can get passed this restriction? (without hacking my own pc?)With kind regards |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-14 : 12:07:34
|
| Clearly indicate you don't have permission to do so. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-14 : 17:18:29
|
| Is builtin\administrators in sysadmin role? If so, you can logon windows with local admin account and add your account to sysadmin. |
|
|
|
Riemens
Starting Member
2 Posts |
Posted - 2008-06-15 : 08:08:42
|
quote:
Originally posted by rmiao
Is builtin\administrators in sysadmin role? If so, you can logon windows with local admin account and add your account to sysadmin.
I found out that I could login local (not the active directory as usual) and could add my AD account as SA, Thanks for the help |
|
|
|
|
|
|
server roles