Post reply

Connecting to SQL DB 2005

  • May 25, 2009 at 4:48 am

    #131932

    Hi All

    Please advise on how to connect to SQL DB 2005(Multiple Instances) from SQL Query Analyser 2000

    Fg:- Instance = Pord_2005 on port 1111

    Thanks,

    Rao

  • May 25, 2009 at 5:24 am

    #999620

    SQL 2000 is not compatible with SQL 2005. Connect to the SQL 2005 instance using the SQL 2005 tools.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • May 25, 2009 at 5:47 am

    #999626

    HanShi (5/25/2009)

    SQL 2000 is not compatible with SQL 2005. Connect to the SQL 2005 instance using the SQL 2005 tools.

    the above advice is not correct. you can connect to a SQL 2005 database with Query Analyzer, but not Enterprise Manager.

    if your SQL browser service is on, you simply connect to the default name or instance name, ie machine or machinename\INSTANCENAME

    alternatively, if you need to specify the port, you add a comma and the port number:

    machinename\SQLEXPRESS,1111

    192.168.0.20,1111

    in your example, you said the server was Pord_2005, so assuming SQL 2005 is the default instance,and assuming one of the multiple instances was named "SQLEXPRESS" it is

    Pord_2005

    Pord_2005\SQLEXPRESS,1111

    if you are not sure of the isntance name, go to the Services Applet in the Control Panel and look for it there.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 25, 2009 at 7:08 am

    #999652

    Excellant. This is a perfect soution. Many thanks to you and forum.

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

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