We do know the “SERVER NAME” should match the value of “@@SERVERNAME” or “Select * from sys.sysservers;
select * from sys.servers “
And if you find it doesn’t “MATCH”, then you have to do the step below:
For my situation, we used the name instance I have not the issues above, even though I did it again. It still doesn’t FIX it.SP_dropserver xxxxSP_addserver xxx, 'local'
But I’ve found 2 interesting things then I changed it, then it fixed. These 2 things you must ensure it’s available if you want to deploy SQL REPLICATION
- Open firewall UDP port 1434 for SQL Server Browser uses. I just opened TCP port 2382
- The SQL instance name CANNOT be hidden from network.
No comments
Post a Comment