Sql Server replication requires the actual server name to make a connection to the server

by

I found the solution in the following link http://www.cryer.co.uk/brian/sqlserver/replication_requires_actual_server_name.htm

thankful to Brian Cryer for his useful site

Quoting from the link to avoid link rot:

Cause:

This error has been observed on a server that had been renamed after the original installation of SQL Server, and where the SQL Server configuration function @@SERVERNAME still returned the original name of the server. This can be confirmed by:

select @@SERVERNAME
go

This should return the name of the server. If it does not then follow the procedure below to correct it.

Remedy:

To resolve the problem the server name needs to be updated. Use the following:

sp_addserver 'real-server-name', LOCAL

if this gives an error complaining that the name already exists then use the following sequence:

sp_dropserver 'real-server-name'
go

sp_addserver 'real-server-name', LOCAL
go

If instead the error reported is ‘There is already a local server.’ then use the following sequence:

sp_dropserver old-server-name
go

sp_addserver real-server-name, LOCAL
go

Where the “old-server-name” is the name contained in the body of the original error.

Stop and restart SQL Server.

More Related Contents:

  1. Create a view with ORDER BY clause
  2. How to run the same query on all the databases on an instance?
  3. SQL Update with row_number()
  4. How to write UTF-8 characters using bulk insert in SQL Server?
  5. Is a single SQL Server statement atomic and consistent?
  6. Connecting to MS SQL Server with Windows Authentication using Python?
  7. determining the character set of a table / database?
  8. How to query for Xml values and attributes from table in SQL Server?
  9. A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)
  10. Should every User Table have a Clustered Index?
  11. cross apply xml query performs exponentially worse as xml document grows
  12. SQL Server Configuration Manager cannot be found
  13. Compute MD5 hash of a UTF8 string
  14. Convert a string with ‘YYYYMMDDHHMMSS’ format to datetime
  15. Convert from DateTime to INT
  16. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  17. SQL Server 2008 Spatial: find a point in polygon
  18. Auto increment primary key in SQL Server Management Studio 2012
  19. SQL Server Linked Server Example Query
  20. Infinite loop CTE with OPTION (maxrecursion 0)
  21. SQL Server IN vs. EXISTS Performance
  22. PIVOT in sql 2005
  23. Atomic UPSERT in SQL Server 2005
  24. SQL Client for Mac OS X that works with MS SQL Server [closed]
  25. PRINT statement in T-SQL
  26. Programmatically retrieve SQL Server stored procedure source that is identical to the source returned by the SQL Server Management Studio gui?
  27. How do you kill all current connections to a SQL Server 2005 database?
  28. SQL Server Full Text Search Escape Characters?
  29. SQL-Server: The backup set holds a backup of a database other than the existing
  30. Escaping single quote in SQL Server

Leave a Comment