sql server connect: error conection frm clients to the sqlserver -- sql server connect

error conection frm clients to the sqlserver

ahi
6/30/2005 3:49:05 AM

sql server connect:

hi
dear members
we have a program that its database is SQLserver2000 that installed on a
computer with ' MIS' name.the type of SQLserver installation is mixed mode
(not Authentication ). so , 2 weeks ago the program did run on all of the
network clients without login to the SQlserver besuse the sqlserver is mixed
mod. but now our SQl server has a problem besouse for runing the program on
any client on the network, first we have to login to the SQLserver computer
then run the application program . but we want to run the software with
sqlserver database without login to SQLserver computer.
note: My connection from program to SQLserver is ADO Connection with mixed

Re: error conection frm clients to the sqlserver

Kevin3NF
6/30/2005 8:18:28 AM

""first we have to login to the SQLserver computer
then run the application program ""

Not sure what you mean....are you saying that when you open the application,
you get a username/password prompt, or are you actually logging into the
SQL Server via remote desktop/terminal server?

What is the application? Access? VB.Net?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

[quoted text, click to view]