473,769 Members | 1,694 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Windows XP Home Issue with SQL Server

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.Conn ectionString = "initial catalog=TSQL;da ta
source=SERVER1; Integrated Security=true;"
Nov 21 '05 #1
3 1088
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******** ******@TK2MSFTN GP09.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.Conn ectionString = "initial catalog=TSQL;da ta
source=SERVER1; Integrated Security=true;"

Nov 21 '05 #2
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******** ******@TK2MSFTN GP09.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.Conn ectionString = "initial catalog=TSQL;da ta
source=SERVER1; Integrated Security=true;"

Nov 21 '05 #3
Thanks, I guess I'll have to do it that way. Thanks

"m.posseth" <po*****@planet .nl> wrote in message
news:OI******** ******@TK2MSFTN GP10.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******** ******@TK2MSFTN GP09.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.Conn ectionString = "initial catalog=TSQL;da ta
source=SERVER1; Integrated Security=true;"


Nov 21 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
2244
by: GriffithsJ | last post by:
I have a series of websites, let's call them "customer1.mydomain.co.uk" --> "customer200.mydomain.co.uk". Each URL is bound to an individual IP address which can be resolved using nslookup. So, for example customer1.mydomain.co.uk = 100.200.300.1 customer200.mydomain.co.uk = 100.200.300.200
11
3764
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows 2003 Server or ADO or ODBC issue, I am posting this on all of the three newsgroups. That's the setup: Windows 2003 Server with IIS and ASP.NET actiavted Access 2002 mdb file (and yes, proper rights are set on TMP paths and path,
1
3438
by: Peter L.S. Trevor | last post by:
I just got Visual Studio 6 Enterprise which includes SQL Server 7. However, when I try to install SQL7 (Standard Edition ?) on Windows XP Home it only installs the client components and not the server component. The install routine claims this is because of the version of Windows I am using. Now I know that IIS isn't supposed to be installable on Windows XP Home but it is with a fairly straight forward hack, so what I was...
3
1634
by: chicken butt | last post by:
Hi - I am trying to move some of my web apps from my development machine running XP PRO SP2 to one of our Windows 2000 server boxes. I have created a new site for each of the apps and am using Host Headers to differentiate between them all. In IIS, if I redirect to another server running Windows 2003 Server, the 2.0 applications work very well.
0
2229
by: Charles Leonard | last post by:
I am having yet another issue with Windows Server 2003. This time, the web service (a file import web service) appears to run except for one odd message: "ActiveX component can't create object". There are no other statements to indicate what object cannot be created. Otherwise, everything on the test Windows Server 2003 works fine—all import data updates correctly. Unfortunately, my normal development environment is not Windows...
3
7489
by: Chris Paul | last post by:
I'm having trouble with PHP & PostgreSQL/OpenLDAP/Apache on Windows. I've set this up countless times on BSD (piece of cake) but I'm trying to do this on Windows now so that my developer can work on her local machine. Everything looks pretty good. OpenLDAP/cygwin works great. PostgreSQL works great. Apache runs. PHP runs. But when I try to connect to my PostgreSQL server using PHPPgAdmin, I
17
5101
by: Jon B | last post by:
Hi All! I have a ASP.NET 2.0 site that works on the Windows 2000 Server. However, when I tried to view this site on my local Windows XP machine, I get "Server Unavailable". If I switch the Windows XP IIS back to ASP.NET 1.1 then I get the Configuration Error (which is understandable because I'm trying to run an ASP.NET 2 site with 1.1 framework). I can however view other ASP.NET 1.1 sites on my local Windows XP machine. It's only the...
7
2068
by: programming | last post by:
Hi all, i have been having trouble with a login script that works on my windows machine, however when i upload it to the Unix server through VPN, the same script won't work! It won't parse member.txt properly i think. The password and usernames i am using are at the bottom of this post. Each time i go to login on the unix server, it clears the username and password field. I have been attempting to solve the problem, but have been...
9
8092
cyberking
by: cyberking | last post by:
Hi all. Hmm.. Firstly, I have never worked on the administration side and also know nothin bout it. So please forgive if my question sounds very dumb. I am looking to you guys to please help me 'cos theres not one page on the internet that can tell me what I am seekin for. Ok here's the scenario. I have a brilliant configuration on my machine. I have Win XP runnin healthy with a connection to the internet through a wireless gateway....
0
10032
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9978
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8860
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7392
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6661
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5293
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5432
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3947
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2810
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.