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 |
|
jeffdavid
Starting Member
8 Posts |
 Posted - 2008-07-10 : 13:20:13
|
I installed a second instance on one of my servers and can't seem to access it. I read that it needs to be referenced as default_instance\named_instance. Is this how it should be registered in SSMS? I'm getting the following error quote:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-07-10 : 13:47:27
|
quote:
Originally posted by jeffdavid
I installed a second instance on one of my servers and can't seem to access it. I read that it needs to be referenced as default_instance\named_instance. Is this how it should be registered in SSMS? I'm getting the following error quote:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
You can have only one default instance.. so any subsequent instances should be named..and you would access them with WindowsServerName\DatabaseservernameDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
jeffdavid
Starting Member
8 Posts |
Posted - 2008-07-10 : 14:04:08
|
| Yeah, that's what I have in the original post. defaultinstance\namedinstance. I figured it out. SQL Server Browser was not running. Its all good. Thanks for looking. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-07-10 : 14:28:06
|
quote:
Originally posted by jeffdavid
Yeah, that's what I have in the original post. defaultinstance\namedinstance. I figured it out. SQL Server Browser was not running. Its all good. Thanks for looking.
its not defaultinstance\namedinstance..it is windowsservername\namedinstance.. it happens that default instance name = windows server name.. but just to get the naming convention right..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
trouble accessing second instance