View Single Post
Old 10-24-2006, 04:51 PM   #1
Scooby Specialist
Member#: 35705
Join Date: Apr 2003
Chapter/Region: South East
Location: Montgomery, AL
Default MSDE SQL Server on Peer-to-Peer Network (?)

I'm having a bit of a dilema networking these two WinXP PCs with one hosting an MSDE SQL Server. The other PC can telnet and connect properly to the PC that's hosting the SQL server - my dilema is, when I access the database using the POS (point of sales) software the sql server asks the user for the login ID and password - okay, good - let's the user log in. From then on, every menu that is accessed on the POS will require the user to keep entering the login ID and password.

Is there a way to set it up so that the sql server will only ask for the login ID and password once?

btw: I'm using ODBC with SQL Authentication to connect to the sql server.
* Registered users of the site do not see these ads.
GotWRX03 is offline   Reply With Quote