Connection Problem with Enterprise Manager but not with Query Analyzer

Question

Connection Problem with Enterprise Manager but not with Query Analyzer

Jim Strong-445889

Valued Member

Points: 61
More actions
May 30, 2007 at 3:47 am

#62509

Hi
I've been tearing my hair out trying to understand this. I have a web hosted SQL Server and have happily been connecting to it with Query Analyser with my assigned password and username on the domain (nb not connecting with IP although I am now about to try this too).
However, when I try to connect with Enterprise Manager it trips up and gives me the standard "Sql Server does not exist or connection denied" message.
I'm a bit confused about the various connection protocols (TCP etc...) but am unsure if i should be looking at Client Network Utility or Server Utility.
What else...I'm on wireless broadband. My web host has also confirmed he can connect using my username and password to the server. I am 100% certain i'm not getting the uname/pword wrong!
Can anyone give me a clue about how to fix or at least some pointers on where to start looking/testing.
Jim
p.s. In particular I'm looking to import data to my local instance from the server..so if there's a nifty way to do this in QAnalyser let me know! Thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Norene Malaney SSCommitted Points: 1896 More actions · Answer 1

Are you trying to use a pre-existing SQL server registration in EM? Perhaps, this registration has some incorrect properties (incorrect username and/or password, using incorrect authentication (SQL Server or WIndows), etc.). You should verify the properties in the SQL Server registration.

Have a good day,

Norene Malaney

Jim Strong-445889 Valued Member Points: 61 More actions · Answer 2

Hi Norene, thanks for your message.

I can confirm the username/password are correct and indeed that the authentication is correct. (tried this at least 10 times now)

I have further defined my problem in case anyone recognises this:

- i can connect with the DTS import/export data utility

- i can connect with Query Analyser

- i can connect from the website ASP code to the database and return data happily.

HOWEVER ...if i try and connect using EM, not only does it fail, but I can no longer connect using QA, DTS, or even to the website itself from my laptop... its almost as if there entire server (email, http, sql ...everything..) has blocked me.

Rebooting doesnt help...waiting about an hour or so does. I can also confirm that the wesbite/email adn SQL Server are still available to everyone else.

Plllleeeeasse. Any ideas sooo welcome.

Thanks

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 3

One thought.

It seems to me that you have SQL Server client installed on your machine. Did you check the versions of the SQL Server and your SQL Server client tools? Inconsistency in the SQL Server versions may have this kind problem.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 4

Try an uninstall/reinstall of SQL Client 'stuff' on your laptop first. If that does not work maybe there is a firewall stopping you. To check this try using telnet to the IP address from your laptop on port 1433 and see what happens.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Jim Strong-445889 Valued Member Points: 61 More actions · Answer 5

Thanks both,

I'm holding off from the uninstall for a moment under the hope its a firewall. My host says they are putting me on a white list but dont know how QA would work and EM not. We'll see.

However, I did telnet to the IP on port 1433... and it worked. I immediatley did it again..and it caused the problem - no connect, and then web, email, QA etc all lost connection.

Could there be something to do with number or connections?

And does EM connect in a different way to QA?

Thoughts appreciated...and thanks again

Jim

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 6

Have your 'host' check for port UDP 1434. My guess is that they closed it off by default when slammer hit a while back. That would be the difference between QA and EM too.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Chintan Satish Shah Newbie Points: 1 More actions · Answer 7

I am facing a similar problem.

I am able to connect to the SQL server using the Query Analyzer. However, when I try to connect using Enterprise manager - it fails.

Some details -

I am using a Windows XP m/c to conect to a Windows 2003 server.

The server has multiple Db instances. Connection to default instance through Enterprise Manager is working. However, when I try to conect to other instances, it fails.

Any help would be of great value for me...