Post reply

Can't connect to sql server 2008 developer ed. using management studio

  • September 8, 2010 at 1:53 am

    #225928

    I am using Windows 200I am using Windows 2008 server R2 and SQL Server 2008 Developer Edition with SP1 and SP2.

    using sql server management studio I couldn't connect to the sql server. I opened up all the necessary ports. But still couldn't connect.

    Error message:

    A network related or instance-specific error occurred while establishing a connection to sql server.Error 40- ........

    Any idea?

  • September 8, 2010 at 7:19 am

    #1217917

    What was the rest of the error msg? Check you have enabled sql to allow remote connections, and check the configuration manager has the tcp/ip, shared memory, and named pipes protocols enabled. Without the full error msg its hard to diagnose.

  • September 8, 2010 at 7:42 am

    #1217933

    I'd double check the services have started.

  • September 8, 2010 at 9:03 am

    #1218015

    Is this on the same host that is running SQL Server?

Viewing 4 posts - 1 through 3 (of 3 total)

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