Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

The Distributer Has not been Installed Correctly - Error 2036 SQL 2008 R2 Expand / Collapse
Author
Message
Posted Tuesday, March 25, 2014 10:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 7:41 AM
Points: 30, Visits: 289
Hi Can some one assist,

I managed to find a few spare mins today looking into this problem.

I zoned in that the problem is relating to the sp_helpqreader_agent SP, and is the problem SP as it returns null for the @loc_distribdb which it retrieves from the CONVERT(sysname, SERVERPROPERTY('ServerName')) .

When I run @@Servername is showing correctly my alias name, but when I run the serverproperty statement above i recieve the actual SERVERNAME\ALIAS, which seems wrong and like its a bug. I've trawled around to find a solution but have not yet found a solution.

Is there any way around this so the name is displayed correctly?
Post #1554593
Posted Tuesday, April 1, 2014 8:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 7:41 AM
Points: 30, Visits: 289
logged this with microsoft a while ago:

http://connect.microsoft.com/SQLServer/feedback/details/814236/the-distributer-has-not-been-installed-correctly-microsoft-sql-server-error-20036

not sure what the solution is as the replicated machine is clustered using SteelEye Lifekeeper and the network name is the machinename.
Post #1557021
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse