error conection frm clients to the sqlserver

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
mode(user name=SA , password = blank
""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
"ahi" <ahi@.discussions.microsoft.com> wrote in message
news:594B3C9D-D780-462E-93B7-C3CF683AA3D3@.microsoft.com...
> 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
> mode(user name=SA , password = blank