Re: Windows XP Home Issue with SQL Server
- From: "Ken Tucker [MVP]" <vb2ae@xxxxxxxxxxxxx>
- Date: Fri, 21 Oct 2005 19:56:13 -0400
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" <bdog4@xxxxxxxxxxx> wrote in message
news:OiKaiIn1FHA.2964@xxxxxxxxxxxxxxxxxxxxxxx
> 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;"
>
>
.
- Prev by Date: Re: How to convert the email date in header to the date of vb.net?
- Next by Date: Re: Not Interop Compatable?
- Previous by thread: Re: initializing array without knowing it's type
- Next by thread: Re: Windows XP Home Issue with SQL Server
- Index(es):
Relevant Pages
|
