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.