| Author |
Topic |
|
Sharon911
Starting Member
46 Posts |
 Posted - 2010-04-06 : 17:05:04
|
| I can't login to SSMS using my domain account which is used to logon WINDOWS. It says 'failed login for my id'.the sql is running under LOCAL SYSTEM account, and I am not sure which account was used to install the sql.Please advise what I can do in order to be able to login SSMS.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-06 : 17:12:34
|
| Is SQL Server installed on your local machine, or on a server? If it's on your local machine, you could ask to be made an administrator of your local machine. What Authentication mode is it running? If mixed, do you know the sa password? If so, try using that. Who administers the server? They'll probably be able to help you. And finally, have you been able to connect to the server in the past, or are you trying to access the server for the first time?There are 10 types of people in the world, those that understand binary, and those that don't. |
 |
|
|
Sharon911
Starting Member
46 Posts |
Posted - 2010-04-07 : 09:51:40
|
| This is my first time to logon(RDP) the server and try the sql which was setup by system administrator.How the password for sa account being setup? during the installation?If I change the sql server to run under my domain ID, would it make any difference for me to logon SSMS?Do I have to ask administrator account to logon the server?Thanks, |
|
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-07 : 10:09:16
|
quote:
Originally posted by Sharon911
This is my first time to logon(RDP) the server and try the sql which was setup by system administrator.
Then you'll need to get the sysadmin who set the server up to add you as a SQL Login, based on the user account you use when login into the remote desktop.quote:
How the password for sa account being setup? during the installation?
It's setup during installation. But unless you own the server, the sysadmin probably won't give it to you.quote:
If I change the sql server to run under my domain ID, would it make any difference for me to logon SSMS?
If you can't login to the server, you probably won't have permissions to do that either. In any case, that's a bad idea. SQL Server should run under a domain account that's specifically setup with the necessary permissions. The problem for you is that you haven't been granted access to the server. This has nothing to do with the account the server runs under. quote:
Do I have to ask administrator account to logon the server?
Looks like it.quote:
Thanks
Welcome.There are 10 types of people in the world, those that understand binary, and those that don't. |
|
|
|
Sharon911
Starting Member
46 Posts |
Posted - 2010-04-07 : 16:04:03
|
| Thanks for the reply, I have asked system admin to give me administrator privilege, but seems no luck.Another question here, how can I tell if the sql running in single mode?Thanks,Sharon |
|
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-07 : 16:42:17
|
| Single user mode is a database level property, so right click on a database, select properties. Select the options page, and scroll all the way down to Restrict Access. Of course, you'll need to be able to connect to SSMS first.There are 10 types of people in the world, those that understand binary, and those that don't. |
|
|
|
Sharon911
Starting Member
46 Posts |
Posted - 2010-04-08 : 13:59:31
|
| Thanks very much for your help. The installer has added my name with sysadmin role now I am able to logon. |
|
|
|
|
SSMS LOGIN