Maybe you need SQL Server to use Mixed Mode instead of Windows Only authentication.
-----Original Message----- From: dotnet discussion [mailto:[EMAIL PROTECTED]] On Behalf Of Joseph J. Sarna Jr. Sent: Wednesday, May 29, 2002 11:49 AM To: [EMAIL PROTECTED] Subject: [DOTNET] Connecting to SQL database through a Web Service Searched the archives, and can't seem to find an answer... I have a webservice which will be hosted on a remote box. This webservice calls another box to gather data from a SQL 2000 server (not in my domain and also remote) and returns the values in an arraylist. Running on my development machine (the webservice) I get the expected results and return a proper array. However when I move the webservice to the proper remote server, I get the following error: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.SqlConnection.Open() at jjsWebService.Service1.GetList() in C:\Documents and Settings\Administrator.MARXBROS\VSWebCache\webservices.jjssystems.net\jj sWeb Service\Service1.asmx.vb:line 69 I have the IP to the webservice opened in the firewall, the user account that exists on the webservice is in the user table, and I am passing the UID and Password for the SQL server in the connection string. OK, what am I missing? (Running in VB.NET, but I can understand and translate from C# if that is what you use) Thanks Joe ==================================== Joseph J. Sarna Jr. Microsoft Certified Professional JJS Systems, LLC mailto:[EMAIL PROTECTED] http://www.jjssystems.net You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
