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.
| Author |
Topic |
|
crashoverrride
Starting Member
3 Posts |
 Posted - 2012-01-20 : 08:15:23
|
| hi there.i have sql 2005 installed on my server with the default instance name MSSQLSERVER.i installed sql 2008 with instance SQL2008when i connect with "IP ADDRESS" as server name (with connection string or as servername in the SMSS) it works.but,i try to connect with "IP ADDRESS\SQL2008" and it doesn't workwhy ?!please helpthanks |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-20 : 12:13:12
|
| Is the service running? You can look it up in services.msc. The name should be something like "Sql Server (SQL2008)". |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-01-20 : 12:23:18
|
| check for the service nameJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2012-02-03 : 18:25:13
|
| I am a having the same problem, Yes the service is running. I see it in the service configuration manager. I even tried using named piped for the 2008 instance and TCP for the default 2005 but still cannot connect. Anyone can help.All help appreciated. |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-02-03 : 18:38:19
|
quote:
Originally posted by rohans
I am a having the same problem, Yes the service is running. I see it in the service configuration manager. I even tried using named piped for the 2008 instance and TCP for the default 2005 but still cannot connect. Anyone can help.All help appreciated.
Did you mean that you have two instances of SQL Server installed on the computer, that you can connect to the default instance, but not to the named instance when you try to connect using SERVERNAME\INSTANCENAME?Are you trying to connect from the computer where it is installed, or from a remote computer? |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-02-03 : 23:31:21
|
| A named instance is configured to use any available dynamic ports.For the named instance assign a fixed port and make sure that the port is open on the firewall.After Monday and Tuesday even the calendar says W T F .... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
connect to different instance (HELP!)