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
----------------
"B-Dog" <bd***@hotmail.com> wrote in message
news:Oi**************@TK2MSFTNGP09.phx.gbl...

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;"

[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" <bd***@hotmail.com> schreef in bericht
news:Oi**************@TK2MSFTNGP09.phx.gbl...

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;"

[B-Dog]

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

"m.posseth" <po*****@planet.nl> wrote in message
news:OI**************@TK2MSFTNGP10.phx.gbl...

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" <bd***@hotmail.com> schreef in bericht
news:Oi**************@TK2MSFTNGP09.phx.gbl...

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;"