Post reply

cannot connect to 2005 ms sql dev version from 2005 sql ms sql express version

  • March 1, 2007 at 2:59 pm

    #116389

    I have a windows 2000 machine runing 2005 sql express and I installed sql 2005 dev on my laptop.  I can connect from DEV to EXPRESS but I cannot connect EXPRESS to DEV.

    I have the SQL browser running and I think the settings for the dev instance to allow remotre connections but no luck.

    I appreciate all the help.

    Thanks,

    Bill 

  • March 1, 2007 at 6:04 pm

    #692743

    Did you enable the remote connections in SAC? If not enable first...

    I believe in Express it is disabled by default..

     

    MohammedU
    Microsoft SQL Server MVP

  • March 1, 2007 at 8:12 pm

    #692752

    Thanks for the reply.

    My laptop used to have sql express.  The despktop and the laptop could each connect.  It is only since I installed sql 2005 DEV version that I can no longer connect to the desktop (EXPRESS VERSION).

    I also have a 2000 despktop that cannot connect to the DEV system.

    Thanks again , Bill 

  • March 2, 2007 at 8:27 am

    #692857

    Additonal information...

     

    I increased the timeout value fro both instances.  Tourns out to be a network problem after all.

     

    Thanks,

    Bill

  • March 3, 2007 at 3:50 am

    #692980

    I always refer http://support.microsoft.com/kb/914277/en-us

     

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

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