Post reply

Cannot create DSN with sql 2005 named instance

  • May 28, 2007 at 4:09 am

    #176861

    Dear All, I have installed sql 2000 and sql 2005 eterprise edition on same machine. When i try to create DSN with sql 2005 name instance, it gives error like server doesnot exist.

    however when i create with sql 2000 it works fine.

    sql 2000 server name is  :BroadcomQADC

    Sql 2005 server name is  :BroadcomQADC\QADC2005

     

    any help

     

  • May 29, 2007 at 2:55 pm

    #709487

    I had this same issue before. I had to create an alias on the server and use the default 1433 port. Seemed weird to me that I had to do this, but had to with a named instance.

    -Chuck Lathrope

  • May 30, 2007 at 4:10 am

    #709620

    well i got the solution, after disableing firewall i manage to create DSN with sql 2005 named instance from remote computer

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

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