467,104 Members | 1,042 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,104 developers. It's quick & easy.

webservice call to Sql server sitting on a different machine fail

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

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.


Apr 20 '06 #1
  • viewed: 1056

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Nalaka | last post: by
5 posts views Thread by David++ | last post: by
2 posts views Thread by =?Utf-8?B?TGFycnlLdXBlcm1hbg==?= | last post: by
5 posts views Thread by =?Utf-8?B?QWRyaWFuTW9ycmlz?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.