Scripts from SQL Domian Accounts

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Scripts from SQL Domian Accounts

Scripts from SQL Domian Accounts

Rate Topic

Display Mode

Topic Options

Author

Message

Sree Arjun Div

Posted Friday, October 05, 2012 1:38 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 3:44 AM
Points: 2,173, Visits: 1,350

hi,

i need sql script which will give the domain account services accounts should be used.

Thanks
Arjun

Post #1368857

KumarSQLDBA

Posted Monday, October 08, 2012 8:08 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, April 29, 2013 4:03 AM
Points: 81, Visits: 824

Hi ,
Try to use the below script

DECLARE @ServiceaccountName varchar(250)
EXECUTE master.dbo.xp_instance_regread
N'HKEY_LOCAL_MACHINE', N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',
N'ObjectName',@ServiceAccountName OUTPUT, N'no_output'
SELECT @ServiceAccountName

Regards,
Kumar
http://www.sqldbatask.blogspot.com/

Post #1369838

« Prev Topic | Next Topic »

Permissions