About SQL publish and subscribe to appear a problem, SQL Server replication needs to have the actual-CodePudding

About SQL publish and subscribe to appear a problem, SQL Server replication needs to have the actual Server name to connect to the Server

CodePudding user response:

I now I can't find where is the problem

CodePudding user response:

Added alias, use alias can connect login

CodePudding user response:

reference 4 floor RINK_1 response:

add the alias, use alias can you connect login

Even, I another SQL server is normal, is not the formal production server

CodePudding user response:

reference 4 floor RINK_1 response:

add the alias, use alias can you connect login

I also changed, including the host file

CodePudding user response:

Just a ghost, maybe I can only to SQL, but this thing reshipment basic system connected with

CodePudding user response:

refer to 6th floor 灬 Ann left reply:

Quote: refer to 4th floor RINK_1 response:

After added alias, use the alias can you connect login

Including the host file I also changed the

With IP can be connected, if the IP can be connected, the estimated alias is not correct, under the 32-bit add alias is a try,

CodePudding user response:

Your first figure (two results are given, is the same machine of two different methods of server name query? If so, is your name of SQL Server configuration is not correct

CodePudding user response:

Use alias connect to the database is feasible, but not a published

refer to the eighth floor RINK_1 response:

Quote: refer to the sixth floor Ann 灬 left reply:

Quote: refer to 4th floor RINK_1 response:

After added alias, use the alias can you connect login

Including the host file I also changed the

With IP can be connected, if the IP can be connected, the estimated alias is not correct, under the 32-bit add alias is a try,

also not line, finally gave up, the database files directly to the transfer, the original the server directly to empty redo when subscribe to the server