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 |
|
CanadaDBA
583 Posts |
 Posted - 2007-11-01 : 11:41:42
|
| How can I find out what is the SQL Server Service start up account without looking into Windows Services on the server?Canada DBA |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-11-01 : 13:16:38
|
| in EM, right-click server, click properties. go to security tab. startup account is at the bottom of the page |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2007-11-01 : 13:29:08
|
| There are "System account" and "This account" but both are in gray meaning they are not accessible or off. While I know on the machine, the starter account is an account mentioned in "This account" box. Why is like that?Isn't there a SQL command for it?Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-01 : 13:47:54
|
| It's stored in the registry, so you can use xp_regread to get it. Just find the registry key.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-01 : 23:22:39
|
| Or check it in services applet. |
|
|
|
CanadaDBA
583 Posts |
Posted - 2007-11-05 : 14:40:32
|
| I thought there is a TSQL command that I can run in QA and find out the account easily but it seems the best way is to use Services.msc and connect to other computers and look for the accounts.Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-05 : 14:43:05
|
| Well you can use T-SQL to do it. Just find the location in the registry where this information is stored, then use xp_regread to read it programmatically.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
CanadaDBA
583 Posts |
Posted - 2007-11-05 : 14:51:31
|
| I was not sure if I had to do this (finding the location in the registery) for every server.Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-05 : 14:53:38
|
| It will be the same location for all servers!Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
CanadaDBA
583 Posts |
Posted - 2007-11-05 : 15:10:03
|
| Good to know. I will find and make it handy. Thanks Tara!Canada DBA |
|
|
|
|
|
|
Start up login account