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\jjsWeb
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.
