Search code examples
sql-serversql-server-2008replicationtransactional-replication

SQL Server doesn't accept server name

Today we tried to create a transactional replication on our SQL Server 2008, but when we are trying to Configure Distiribution or New Publication we couldn't do so, and an error message as shown below occurred. But also I was connected database with no server name.

enter image description here

Then when I try again to connect as error message server name WIN-7SRKNSIF0BK and this time I get error as below. I was thinking maybe cause of my windows authentication but I tried to connect with sa user but again same problem.

Now I realize my SQL Server version is shown as "PreRelease", can this be the reason for the issues?

Because I have no problem for example 2012 2016 and other 2008, and none of them is not "PreRelease".

Microsoft SQL Server Management Studio 10.0.1600.22    
((SQL_PreRelease).080709-1414)

enter image description here

Solution

  • Your instance name should be the same as your computer name.

    EXEC sp_dropserver @@Servername;
GO
EXEC sp_addserver 'WIN-7SRKNSIF0BK', 'local';
GO