« MicroISV Show | Main | TimeSnapper »
February 01, 2006
SQL Server Express and Windows XP Home
If you are needing to run SQL Server (I was using the Express version in this case) do not use the integrated Windows authentication if your clients will be running on XP Home.
XP Home uses simple file sharing, which you can not turn off. This causes the client to access the remote SQL Server using the guest account, not the currently logged in user. Since you don't want to give the guest account access to your SQL Server, the best option is to use the SQL Server authentication.
Once I figured this all out, it was a pretty simple fix to turn on the SQL Server authentication, create an account, and change the connection string on the clients. But it took a long time to figure out that XP Home's simple file sharing was the cause.
Posted by mikel at February 1, 2006 09:36 AM
Trackback Pings
TrackBack URL for this entry:
http://WWW.mjberger.COM/cgi-bin/mt-tb.cgi/221
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)