BenRosa
Member
Greetings:
Ive an asp.net appl published to two different web svrs that use the web-config to establish a db connection. Problem is, one appl connects and the other doesnt.
About the one that doesnt, there are other appls on that web svr that do connect to the same db svr w/o issue. Also, this web svr is 64bit (not sure if thats a factor). Ive noticed on the conn str of the working db connection (the other appls) they use a "driver" attribute in the conn str. I did attempt to use that same driver attribute in my conn str, but no joy. BTW, the other appls that connect dont use a web-cofig, but rather, an include file for db conn str.
Finally, the actual error msg I get is:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
Thanks in advance for any and all guidance & advice.
Ed in Tampa
Ive an asp.net appl published to two different web svrs that use the web-config to establish a db connection. Problem is, one appl connects and the other doesnt.
About the one that doesnt, there are other appls on that web svr that do connect to the same db svr w/o issue. Also, this web svr is 64bit (not sure if thats a factor). Ive noticed on the conn str of the working db connection (the other appls) they use a "driver" attribute in the conn str. I did attempt to use that same driver attribute in my conn str, but no joy. BTW, the other appls that connect dont use a web-cofig, but rather, an include file for db conn str.
Finally, the actual error msg I get is:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
Thanks in advance for any and all guidance & advice.
Ed in Tampa