New Login with Trusted Connection

I have my development machine connected to my SQL 2000 server using trusted connection.

I want to setup another machine for testing purposes.

How do I setup SQL for another user? I can't get pass the Domain, when I setup a new login using trusted connection. It only shows the admin and my account on the sql server machine.

Once that is completed, how to I setup a w2k pc for trusted connection?

Thanks,
MikeD

Can you be a little more clear on what the error is that you're getting? Can you tell me exactly what steps you took to get you to where you're stuck?

Is your SQL Installation enabled for windows authentication?
Is your machine part of a domain?

|||

Greg,
Not getting an error, just could not complete the new login without a Domain.

What I ended up doing was adding a Local User Account to the server, using the same username and pwd as on the client pc.

I could then add the user login to SQL and use Windows Authentication, not SQL Server Authentication. I tried the new deployment and the win2k machine connected right up.

I don't have a domain controller. I have a small network with a server, 4 pcs, a router(broadband) and a lynksys hub that I uplink to the router.

My SQL2000 server is enabled for windows authentication. I enabled my XPpro a while back but forgot the steps. I thought it was somewhat obscure if I remember correctly.

Do you happen to have links to instructions on how to setup the different os
Thanks,
Mike

|||

Mike, I"m completely confused. What are you trying to do, create a new login using SQL Server Authentication? Not sure what an OS has to do with this.

|||Greg,

I have an application I'm developing that I'm using Windows Authentication for the SQL login instead of SQL Server Authentication.

Since I'm not using a Domain controller, I think things are a bit different.

Additionally I'm trying to setup the SQL Server for Windows Authentication.
1. Do you normally have to setup a Local User/Groups account on the server for each SQL login?. This is what I had to do to be able pick from a domain in the SQL Login setup window.

I'm trying to setup the best way to use Windows Authentication from different PC client OS's with SQL server.
2. On XPpro / home, is there anything special that has to be done?

Thanks,
Mike