Connection to SQL DB 2005

• NemaniRao

  Valued Member

  Points: 68

  More actions

  May 25, 2009 at 1:57 am

  #95148

  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

• Kishore.P

  SSCrazy Eights

  Points: 8147

  More actions

  May 25, 2009 at 2:25 am

  #999593

  In SQL 2000, Query Analyzer give the \. Try it.

• NemaniRao

  Valued Member

  Points: 68

  More actions

  May 25, 2009 at 2:30 am

  #999594

  I have tried connecting with that fashion but coult not. I think this is something to do with port no but i am not sure.

  Please advise..........

  Thanks,

  Rao

• Vinay Thankur

  SSCarpal Tunnel

  Points: 4178

  More actions

  May 26, 2009 at 11:19 am

  #1000055

  try this.

  ,

  or

  ,

  FYI.

  http://www.haidongji.com/2006/02/15/connect-to-sql-server-2005-using-query-analyzer-osql-and-isql/

  HTH.

  Vinay

  Thanx.
  Vinay

  http://rdbmsexperts.com/Blogs/
  http://vinay-thakur.spaces.live.com/
  http://twitter.com/ThakurVinay

• Vinay Thankur

  SSCarpal Tunnel

  Points: 4178

  More actions

  May 26, 2009 at 11:20 am

  #1000056

  server_name,port_number

  or

  ip,port_number

  Dont know why last post could not see this.

  Thanx.
  Vinay

  http://rdbmsexperts.com/Blogs/
  http://vinay-thakur.spaces.live.com/
  http://twitter.com/ThakurVinay