If you're passing sql credentials, check that you have both sql and windows authentication enabled -- right-click on the sql instance in Enterprise manager, Security tab.
John -----Original Message----- From: dotnet discussion [mailto:[EMAIL PROTECTED]] On Behalf Of Joseph J. Sarna Jr. Sent: Wednesday, May 29, 2002 6:45 PM To: [EMAIL PROTECTED] Subject: Re: [DOTNET] Connecting to SQL database through a Web Service Agreed, however, this is just a proof-of-concept presentation to show the storage of data on one server, the webservice on another and the client running a WinForm app. I'll try putting a webservice on the SQL server domain and see if that helps. Thanks Joe -----Original Message----- From: dotnet discussion [mailto:[EMAIL PROTECTED]]On Behalf Of franklin gray Sent: Wednesday, May 29, 2002 12:13 PM To: [EMAIL PROTECTED] Subject: Re: [DOTNET] Connecting to SQL database through a Web Service I would suggest you have a web service inside the domain that is public, and have your other web service call it, or just go directly to the web service in the same domain as the SQL Server machine. I don't think making the SQL Server machine accessable from outside the firewall a good idea. -----Original Message----- From: Joseph J. Sarna Jr. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 10: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. 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.
