By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,866 Members | 1,660 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,866 IT Pros & Developers. It's quick & easy.

webservice call to Sql server sitting on a different machine fail

P: n/a
Environment:
OS of sql server 2000 server: windows 2003 standard server , .NEt framework
1.1 , sql server does not have any service pack, machine has the latest
Windows service pack. Personal firewall is not enabled on this machine. All
machine are within the same network.

All i am dong is trying to open a connection from a .Net webservice (using
ADO.NET which uses a connection string comming from web.config file) which
is sitting on machine A with
IIS installed on it and connecting to the sql server which is running on
Machine B.

This used to be working all the time till the sql server that i was pointing
my webserivce was sitting on a windows 2000 box but as soon as i started
pointing to Sql; sever sittign on Windows 2003 , my application says "sql
server does not exist or access denied".

Strange part is i can register this sql server on my mahcine using
enterprise manager as well connect using query analyser and a UDL file. but
websericce can not connect to it.

Another weird thing is when i created a test VB.NEt application running on
Machine A and connecting to sql server running on machine B, it connects
successfully.

Almost as if Machine B with sql server does not like it when IIS on Machine
A tries connecting, seems like an impersonation issue, please suggest.

also when i install the webserice ( which was running on Machine A ) on
Machine B itself( which has sql server) and try connecting to the sql server
on the same machine it works ... please help.

thanks
Sameer

Apr 20 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.