Service Startup Account in Domain?

[jgoodman00]

I am in the process of migrating our workgroup to a domain.

I previously had SQL Server Services running under a local user account with local admin privileges.
e.g.
Username: .\SQL

Obviously after migrating this account no longer exists, so I need to use a domain account.

I have tried specifying:
SQL@domain.com

But I get an error quoting unknown username, even though I can login with the username.

I also tried domain.com\SQL but got another error.

Any ideas?

James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures

 

[jgoodman00]

Solved this one & I think it might be a bug.

The login needs to be domain\login

I was trying to change the service startup account & it kept erroring.

I needed to change the service account to the system account, stop & restart the server, & then change it to the domain account. This allowed me to make the change...

James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures