Cannot connect to SQL Server via ODBC on Win XP!!

[jaycast]

This is a problem that recently surfaced. We haven't had any prior problems like this. On newly formated Win XP machines, we are trying to establish ODBC connections to SQL Server Databases. As security at my company is very very lax, we only use one username and password company-wide.

After adding the System DSN, filling out the name of the connection and the SQL Server, we would typically accept all other default settings on the next screen:

:Windows NT Authentication
:Connect to SQL Server to obtain all other default settings for the additional configuration options.
:TCP/IP Selected in Client Configuration.

Everything else is default, with the exception of the default database selection.

It also shows that certain PCs with WinXP are having difficulties connecting to other PCs on the domain, with OS of 2000 and up. They are prompted for Username/Password, and when entered, the system does not accept them as valid.

I'm not sure why this is happening, but as our security is so lax, there shouldn't be any special usernames and passwords for individual machines and SQL Server connections. All other machines have no issues.

Please help!

 

[Erik160]

a few questions:
1. Do you really want to use the NT authentication? it will pull the permissions set up on your NT or 2000 server.
2. Is there a chance you can use SQL authentication. If you use SQL authentication you need to setup a user in the database that users can use to log in to the database.

If you have NT auth. then everyone is trying to login to the DSN using the exact same user that must have been set up on your NT or 2000 server. Is this correct?

Hope any of that helps

Erik


"There are no stupid questions, But there are A LOT of inquisitive idiots."