June 25, 2015 at 12:59 am
HI All,
I was trying to connect to SQL server Express 2008 from Jumphost / Jumpbox because there is no SQL Management Studio in that server . But I could not connect . Error comes up “ A network- related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessable . Verify that the instance name is correct and that SQL server is configured to allow remote connections “
I have checked TCP/IP , it has been enabled
But I can’t check it allow remote connection or not because no SQL Management Studio in that server .
I tried to ping from jumphost to that server , It is successful
I couldn’t start SQL Browser because it is sql express ( I am not sure it helps as well even though I read the article about the successful story )
Could you please point out what I should do ? Much appreciate it .
Cheers
June 25, 2015 at 2:53 am
If you installed SQL Server Express using the default settings, it installed a named instance (SQLEXPRESS). This instance is listening on a dynamic port by default. The only way to know this port is to query the SQLBrowser service, which is stopped. SQL Server Express has no limitations regarding SQLBrowser, so it should definitely start without issues. If it doesn't, there's a problem to fix.
You have three options:
1) Fix the SQLBrowser service
2) Make SQLEXPRESS listen on port 1433, so that you just have to specify the machine name while connecting
3) Make SQLEXPRESS listen on a static port other than 1433 and include the port in the "server name" box in the connect dialog (e.g. machinename,51415)
-- Gianluca Sartori
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply