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 |
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
 Posted - 2005-11-30 : 07:04:20
|
| Greetings from Mongolia,Is there a difinitive way of determining whether the MS SQL Server service is using a domain account or a local account to log on.I've used the script found here:[url]http://www.windowsitpro.com/Article/ArticleID/46106/46106.html[/url], but it is only good for SQL Server 2000 and beyond. We have many SQL 7 servers.I need this info to setup SQL Mail.Cheers,Drew |
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2005-11-30 : 10:36:59
|
| Assuming you need to do this programmatically and not some really simple way like using Enterprise Manager | Properties or the services applet...You could use the xp_RegReadEXECUTE xp_regread [@rootkey=]'rootkey', [@key=]'key' [, [@value_name=]'value_name'] [, [@value=]@value OUTPUT] The value you are looking for is under HKLM\System\Services\MSSQLSERVER\ObjectName. If it doesn't say LocalSystem, you are using a Windows account of some sort.Jon-Like a kidney stone, this too shall pass.http://www.sqljunkies.com/weblog/outerjoin |
 |
|
|
|
|
|
Determining how the SQL Service logs on