Click here to Skip to main content
15,891,033 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
HI
I have a VPS with public IP '192.xx.xx.xx'. when i installed sql server the sql server default name was the same as my vps let's say it's 'MYVPS'

now when i try to connect to sql server i use the public IP '192.xx.xx.xx' as server name and i had no problem with it.

the problem is when i try to configure a distribution on the sql server i got this message :

" server is unable to connect to server '192.xx.xx.xx'. ........ Specify the actual server name , 'MYVPS'. (Replication Utilities) "

So i tried to change sql server name to be similar to my public ip '192.xx.xx.xx' then i was able to see the configure distribution wizard BUT at the end of the wizard i got the error message :

" SQL SERVER could not configure '192.xx.xx.xx' as a Distributor. ...... Could not connect to server 'MYVPS' because 'distributor_admin' is not defined as a remote login at the server "

on a desperate try i create a new user on my vps computer with the name 'distributor_admin' and a new login with name 'distributor_admin' but nothing changed
Please help
Posted
Comments
Sergey Alexandrovich Kryukov 30-Dec-15 16:30pm    
Is the client part on the same LAN as your SQL server? It looks like you are using LAN IP 4 addresses. :-)
—SA
M. Rawan 30-Dec-15 17:55pm    
the server is public on the web and the client is not on the same network

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900