Problem when adding new registration in SQL Server2000

I couldn't add new registration in SQL Server2000 using SQL Server Authentication mode even I've already entered correct server name, username sa and correct password.
I've tried to ping this server from command line and it's ok.
But if I run Windows Explorer (\\servername) and put Windows'username and password then add new registration again, it's successful.
Please explain me why? I want to add new registraion from some server which I only have SQL Server username and password but don't have Windows username and password. Is it possible?Are you suing a default instance or a named instance ? If its a named instance you would have to use the syntax Servername\Instancenmae instead of just the servername. make also sure the server is running Mixed mode authentication if you want to use SQL Server authentication. You won′t need the Windows user name or password then.

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

Hi JensK.Suessmeyer,

After reading your answer, I've checked and found that the SQL Server has default instance(MSSQLSERVER) and server is running mixed mode authentication.

Following are all the complicated steps I must do to add new registration:
Ping SERVERNAME to check connection
Add new registration, using SA and SApassword
The previous step failed, then run windows explorer (\\SERVERNAME)
Put windows logon info: SERVERNAME\trunghd & mypassword
Add new registration again and it's successful

If I add registration from some server that I've already entered windows logon info once, it's successful too.

The question is why I have to give Windows logon information to the server when it's running in SQL authentication mode. I found no relation between my Windows username in this server with the installed SQL server in it.

Thank you very much for your answer.