i install desktop engine, then clients tools but cannot register s

[seminewbee2005]

when i register i select sql auth and use the sa and password i used for command line instal. I also specified in instal paremeters sql for security mode. but i get a failed login connection message. but when to register again and select win auth it succesfully registers. anyone know why?

 

[Catadmin]

Have you verified that the windows account the SQL services are running under are set to a domain account instead of the local machine account?



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[SQLBill]

It sounds like you actually set it up for Windows Authentication Only.

Register it in Enterprise Manager using your windows account. Then right click on the instance, select Properties and go to the Security tab. What authentication does it show being used?

You can not use SA account if it is set for Windows Authentication.

Also, as soon as you get the authentication worked out, create an account for yourself. Do not use the SA account except if you really need to do so...it's a bad habit to use it just to use it.

-SQLBill

Posting advice: FAQ481-4875