cannot connect to SQL server from VB.net program 1

[shaminda]

One of my VB.Net programs would not connect to SQL Server. I get the following error when I try to connect to server.

Login failed for user ‘HQPROD\honlot’.

I can login as my self and orun the program without any problem. On the client pc user ‘honlot’ has administrative rights. On the Windows 2000 server ‘honlot is a member of Administrators. On the SQL Server 2000 honlot has db owner permissions to the all the databases. HQPROD is the name of our domain. The PC that’s try to connect to is part of the WORKGROUP group, but not part of the domain. Why is it saying login failed for ‘HQPROD\honlot’ with domain name attached to user name. How do I have to do to connect SQL server?

 

[mrdenny]

Probably because the username exists on both the domain and the workstation. The login is failing because the workstation is passing the credentials across and they are failing because either the password is different, or because the domain is rejecting the group sid that's being passed. To use the NT authentication you'll need to add the workstation to the domain.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[shaminda]

I don't want to join the workstation to the domain because, if the domain goes down the workstation goes down too. We use to have all our workstation join to the damain and when the domain control goes down all the workstations were down too. Do I have an alternative?

 

[mrdenny]

You can try creating local accounts for the users on the SQL Server but this kind of defeates the purpose of having a domain.

Why not just get a second domain controller so that you have some redundancy.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[shaminda]

Thanks mrdenny,
I change my connection string to use SQL authentication and the program works now.