August 12, 2009 at 10:39 pm
Hi
Sql Server 2008
I have server A with with instance INST; I have configured the instance for default port as per http://support.microsoft.com/kb/265808
I am trying to connect from another server B using Mgmt Studio by passing the following:
TYPE => DBEngine
SERVER : A\INST OR \\A\INST
Under Options ==> Connection properties ==> Connect to Database ==> Browser Server it does not bring up the instance INST; But if i make the SERVER as A then it connects but does not show the USER database ; Only shows the System and temp databases.
IF i put A\INST then i get the following error
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The
server was not found or was not accessible. Verify that the instance name is correct and that SQL Server
is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified) (Microsoft SQL Server)
Tried
Tried some of
No success.
Anyone out there who has an answer?
TIA
August 13, 2009 at 8:04 am
Have you gone into SQL Server Surface Area Configuration Manager and set the server to allow remote connections via either Named Pipes or TCP/IP Or both?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 13, 2009 at 11:02 am
This is SS2008 and hence Surface Area Configuration is discontinued. However, the same can be achieved by Right Clicking on the Service in the Mgmt Studio and under properties , connections i found the Remote connections are enabled and the time out is 600 seconds.
It still does not help.
Any ideas?
August 13, 2009 at 11:18 am
Sorry, you posted in a SQL Server 2005 forum so I supplied a 2005 answer.
Are there any firewalls running where you need to enable a port?
Have you verified through other means that Server A is accessible from Server B?
Are you using SSMS 2008 on server B?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply