connect to 2005 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

connect to 2005

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-27 : 02:33:52

Dear All,
i've installed sql server 2005(standard) on a server which is already running sql server 2000 ent edition.

when i'm connecting SSMS in any mode()sql or windows) it is directly connecting to 2000. how can i connect to 2005? the instance name is default.

please guide me.

Arnav
Even you learn 1%, Learn it with 100% confidence.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-06-27 : 04:21:45

In SQL 2000 the default instance? If so, what is the instance name of the SQL 2005 service? One of them will be the default instancwe and one of them will be named.

Open the SQL configuration manager on the server and select SQL Server 2005 Services. What services are listed in the right hand window?

--
Gail Shaw

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-27 : 04:31:48

sql server 2000 is the named instance. 2005 is the default instance

Arnav
Even you learn 1%, Learn it with 100% confidence.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-06-27 : 04:52:21

Ok, then connecting to the machine name should get you the 2005 server. MachineName\Instance name should get you the 2000 server.

In management studio when you connect, make sure you select the correct name that you want.

--
Gail Shaw

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-03 : 05:30:34

quote:
Originally posted by GilaMonster

Ok, then connecting to the machine name should get you the 2005 server. MachineName\Instance name should get you the 2000 server.

In management studio when you connect, make sure you select the correct name that you want.

--
Gail Shaw

Gail, still the problem is that i'm connecting to the 2000 server only. unable to connect to 2005 server. i'm trying to connect through ipaddress. even then, it is going to 2000 server only. please let me know what actions hould i take to connect to 2005 server

Arnav
Even you learn 1%, Learn it with 100% confidence.

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2008-07-03 : 07:42:24

Hi

I'm unsure if you mean connect through an application (some sort of connection driver), or connect with one of the management tools.

I've got the same setup as you for one of our development db servers.

In Management Studio.....
To connect to the 2000 instance it is just <machineName> (+ Authentication)

To connect to the 2005 instance it is <machineName>\<instanceName> (+ Authentication)

For Example My connections are
DEVDB2 (2000)
DEVDB2\SQLSERVER2005 (2005)

For an application driver.....
We use the jtds driver (java). I'm not sure what you'll be using but mt connection string for a 2005 db is::

jdbc:jtds:sqlserver://DEVDB2:<portNumber>/<databaseName>;instance=<instanceName>

Example ::
jdbc:jtds:sqlserver://DEVDB2:1433/<databaseName>;instance=SQLSERVER2005

Hope this helps.

-------------
Charlie

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-04 : 21:22:10

Did you try connect to sql2k5 instance with ip address AND port number?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources