Need help with 2005 Replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Need help with 2005 Replication

I’m trying to replicate a db between 2 2k5 sql boxes. My first problem is that I cannot install Management Studio on my one sql box because it says it’s already there, yet when you go to start-programs-sql..- all you see is config tools. I ran setup from CD2 several times chose books, online, etc.. and client tools and get that error. Secondly,
I’m trying to create my subscriber sql box (the same one mentioned above) to pull replicate from my distributor but I keep getting an error saying: "Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online. SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, ‘SQL2005’. (Replication.Utilities)" What does that mean?
Run SELECT @@SERVERNAME and see the results. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
I ran it and it came back saying SQL2005, now what?
Has it returned correct servername? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
No, the SQL Server name is called DB01MOC
Then you need to perform SP_DROPSERVER and add back servername with SP_ADDSERVer, refer to books online for moreinformation. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>