Unable to connect to server instance
Hi, I have a sql server set up and the connection test is successful when i try it from the server part. The problem comes when I use remote desktop manager on a pc which is on the same network. I created an instance lets say name\RDM
There is no problem testing it from the server for that instance, but when i try it from the client, keeps giving me error 26 that destiation is unreachable. I tried giving an exception the firewall, and i made sure the sql server accepts remote control. It basically cant recognize the server and users.
All Comments (11)
Hi,
I'm not sure if this could help, but could you verify this FAQ:
http://remotedesktopmanager.com/remotedesktopmanager/Support/FAQ#e4
David Hervieux
I have tried doing what written in the FAQ but it really wont recognize my instance, it does recognize when i just put lets say test, but not the test\RDM. Says connection successful on the test just not the test\RDM
Is it possible that you can connect to the server but not the database?
David Hervieux
Well The server is reachable, not its instance or database. I do see it from the server the databases are there, but when i attempt to connect from another computer, the instance of the server doesn't show up neither do the database. I made sure tcp is enabled for the instance, made an exception inbound on firewall.
Could you please post the error message that you are getting? Take a look at the error logs (Help->Application Log...) Anything like "Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while..."
Please make sure you restart the SQL service (or reboot the machine) after enabling remote connections.
Thanks
Stéfane Lavergne
Unable to connect to the server!
A network-related or instance-specific error occurred while establishing a connection to SQL server. Ther 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)
Please follow the steps outlined on this website to test you SQL server connectivity.
http://teusje.wordpress.com/2012/02/21/how-to-test-an-sql-server-connection/
I've also attached a sample udl file.
Stéfane Lavergne
rdm.udl
I am still getting the same error message for my instance
Could you please send me a screen shot of the data source settings from both the server (which works) and the client (that doesn't work). You can send it via private message as to keep your information private.
Did you try with the udl file? Was that successful? Could you also send me a screen capture & the udl file?
Stéfane Lavergne
I finally managed to make it work, giving the instance as for example name\test, giving its database, creating the database from the server, but the client doesnt seem to be able to connect to the instance, but now i can see it from the server, which is an improvement
The problem remains in the authentification, i put in mixed mode, but the client cant login to access database saying that his id and password is not valid