Sunday, February 19, 2012

Cant connect to sql server 2000 from asp.net

I installed sql server 2000 on a remote server. I can connect toit from the client with query analyzer, but I cannot connect to it fromASP.NET. I'm using Sql authentication, and the account has everypermission under the sun. I can also connect to it from theserver explorer in visual studio.net. I turned off thefirewall. I tried connecting with the same asp.net code from adifferent computer and still no luck. I've triple-double-checkedthe connectionstring. It's the same credentials I'm using forquery analyzer and server explorer, which both work fine. Anytroubleshooting tips would be GREATLY appreciated.

Thank you.What error message are you receiving?|||The problem ended up being with the version of .net I was using. I hadinstalled 1.1 initially, but someone installed commerce server 2002 andit installed .net 1.0 on top of that, which messed everything up. I reinstalled windows 2003 and then reinstalled .net 1.1, and all isgood.

No comments:

Post a Comment