Why can't I connect to the SQL server using Enterprise Manager/Management Studio

SQL Enterprise Manager tries, by default, to connect via Named Pipes. As this cannot run across the internet you need to "convince" it to use TCP/IP.

To do this, you can use the following proceedure.

On your computer go to CONTROL PANEL and then start the ODBC
application.

Create a new system DSN of type SQL SERVER

Follow the prompts to enter your connection information for your
database.

Make sure that you click on the CLIENT CONFIGURATION button and ensure that the connection type is TCP/IP and that the port is set to 1433

Follow the connection through to it's conclusion and save it.

Now try to connect with Enterprise Manager again. You should find that it is now OK.

Ensure that you are using the latest service pack for SQL Enterprise
Manager, SP3a at the time of writing and that you are using the latest version of MDAC.
  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

Connection Strings

We're often asked how to create a connection string to a database.  In fact a variety of...

How do I Publish my Microsoft SQL server database

In order to publish your database to your hosting package, you need to use the SQL database...

SQL Enterprise Manager reports 'no items'

Run this script in query analyzer against the master db ===================copy everything below...

SQL Object Ownership script

DECLARE @objname nvarchar(517),@DynSQL nvarchar(4000) DECLARE obj_cursor CURSOR FORSELECT name...

SQL db shrink code

--Select Count(name) from sysdatabases declare @db as varchar(100)set @db = 'db to be shrunk...