April 2, 2012 at 6:52 am
I have a 2008 server with two instances of sql server 2008 r2 running a default instance and another named. After I had a server crash the named instance is only accessed locally, not being possible to connect via network. I do not have the slightest notion of what is happening. Can anyone help me?
Thank´s
April 2, 2012 at 7:03 am
What errors do you get?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 2, 2012 at 7:04 am
ivan-1015146 (4/2/2012)
I have a 2008 server with two instances of sql server 2008 r2 running a default instance and another named. After I had a server crash the named instance is only accessed locally, not being possible to connect via network. I do not have the slightest notion of what is happening. Can anyone help me?Thank´s
A few possibilities. the most obvious is that perhas the server is not configured to allow remote connections. Can you execute the following and post the result:
sp_configure 'remote access'
Another possibilty is a problem with the browser service and connecting to the correct port. By reviewing the errorlog, you should be able to determine what port the server is listening on. Shortly after startup, there will be an entry like "Server is listening on [ 'any' <ipv4> 1433]." where 1433 is the current port for the named instance.
You should be able to connect to SERVERNAME,PORT... so in my case MYDBSERVER,1433 using managment studio. do it exactly like that from the server and from a remote client. what's the result- can you connect from both or just locally or none?
Another possilbity to look at is which protocols are enabled- check that using sql server configuration manager.
If you're still not connecting, post the errorlog here for our review.
April 2, 2012 at 7:18 am
default message
Network error or the specific instance to connect 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, Error: -1)
Locally the two instances work remotely only the standard
April 2, 2012 at 8:06 am
how about the questions I posted above?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply