Problem with Remote SQL Server Connectivity

H

Hammad Rajjoub

Hello
I am developing a web based application that needs to access data from varied data Sources (Sql Servers) placed at different locations within WAN. We dont have a domain and i am have set Authentication mode to "None" in web.config file. The problem is that some of the servers sometimes fails to authenticate or some how web server (IIS) fails to connect to the remote server. This is strange but this is what it looks like. I have set up a particular sql server user id at all servers and i build connection string at the runtime to connect to the particular remote server

Any idea that why is this happening

Thanks in advance

best regards
Hammad.Rajjoub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top