August 21, 2003 at 3:35 am
Windows 2000
SQL 2000
If you right click on properties of a SQL instance and click logon "this account" you can set the account by typing as
DOMAIN\SQLAccount
or if you click on browse and choose the account from the domain it will be set as
If you choose to run the service as administrator and browse the domain the syntax will be
DOMAIN\Administrator
Which is the "correct" account syntax to use if NOT using Administrator account?
I am trying to connect Exchange as a linked server and access denied errors appear if SQL instance is started with an account other than administrator hence the question
August 21, 2003 at 4:19 pm
Is this a local account? Should be .\sqlserviceaccount. Or if it is a non-admin domain account, domainname\accountname
Steve Jones
August 22, 2003 at 8:52 am
Hi Steve
Thanks for the reply
Our Active Directory name is setup as XXXNet.Local
SQLAccount is a domain user which is a member of Administrators and domain users, but not domain admin etc
So what you are saying is that the syntax for the service account logon s/be XXXNet\SQLAccount - the pre Windows 2000 format and not the AD format of SQLAccount@XXXNet.Local?
August 24, 2003 at 9:06 am
Yes. You want to use the DOMAIN\UserName structure. The AD form (user principal name) of UserName@Domain is not currently supported in SQL Server 2000.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply