I'm having a problem connecting to my server through enterprise manager. I'm running a website which connects to the server just fine, however when i try and connect via enterprise manager i get the dreaded cannot connect or access denied. I've triple checked the password and pinged the server in addition to my website connecting to it. Any ideas?

The first thing I'd try is to drop the [u]registration </u>for the db and regregister it. Do notice that I DIDN'T say to drop the db, eh?

--Jeff Moden

I've actually never registered it because it hasn't connected in enterprise manager. :-) as for the db i've done my db dropping for the year(twice. go backups).

No... Not that kind of registration... No offense, but it doesn't sound like you should be the one doing this type of stuff... Don't you have a DBA?

I'm talking about registering the databse with Enterprise Manager so it can see the server... I'm not talking about registering SQL Server with Microsoft.


--Jeff Moden

Well I'm a trite offended as a programmer I'm pretty well versed in my SQL server. I knew exactly what you meant which is why I mentioned the enterprise manager in my statement. I have since solved my problem, The port was not set to 1433(default) which for some reason the IIS found but enterprise manager would not.