Windows XP Home Issue with SQL Server

[B-Dog]

We have developed an application that connects to our sql server using the
windows authentication. 99.9% of all our pc's belong to the domain but we
have a couple of XP Home laptops that need to connect but of course you
can't join a domain with home edition. We are currently using this
connection string but with home since it isn't part of the domain and is
only logging in locally it will not authenticate with windows authentication
because it isn't part of the domain and sql server won't let me add a user
from a workgroup, does anyone have an idea on how to get this user
authenticated. Can I look for when he opens the app and force his username
and password or something. Any help would be appreciated. Thanks

Me.sqlConn.ConnectionString = "initial catalog=TSQL;data
source=SERVER1;Integrated Security=true;"

 

[Ken Tucker [MVP]]

Hi,

I would create a user for the sql server database with just the
permissions he or she needs for the application. You will have to provide a
user name and password in the connection string for the xp home
workstations.

Ken

 

[m.posseth]

Set sql server to mixed mode authentication , now create a user with the
apropriate rights in the database , connect with the username and password
in your connection string and it will work


regards

Michel Posseth

 

[B-Dog]

Thanks, I guess I'll have to do it that way. Thanks