April 24, 2014 at 9:33 am
Hi, i have this problem, when i try to disable publishing and distribution server, the wizard present this Error:
**************
TITLE: Disable Publishing and Distribution Wizard
------------------------------
SQL Server could not connect to the Distributor, 'Server_Distributor'. Do you want to disable publishing on 'Server_Publisher' without removing entries for this Publisher from the distribution database?
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not connect to server 'Server_Distributor' because 'Server_Publisher' is not defined as a remote server. Verify that you have specified the correct server name. . (Microsoft SQL Server, Error: 18482)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000&EvtSrc=MSSQLServer&EvtID=18482&LinkId=20476
------------------------------
************
And i click YES, then present this error:
************
TITLE: Microsoft.SqlServer.ConnectionInfo
------------------------------
SQL Server could not disable publishing on 'Server_Publisher'.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Invalid object name 'dbo.syssubscriptions'.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Changed database context to 'master'. (Microsoft SQL Server, Error: 208)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476
************
When i looking for the tables of Publisher Server in INSTANCE>>DATABASES>>DBNAME>>TABLES>>SYSTEM TABLES
syssubscriptions not Exist ...
when i run this Script in my DataBase
Select * from sys.databases
select * from master.dbo.sysdatabases
the database present this information:
SYS.DATABASES
Name: DBNAME
IS_PUBLISHED = 1
etc...
SYSDATABASES
Name: DBNAME
Category = 1
How can i Disable Publishing and Distribution in this Server ?
April 24, 2014 at 9:37 am
What do you mean "disable publishing and distribution"?
Without focusing on SSMS, what are you trying to accomplish?
-- Gianluca Sartori
April 24, 2014 at 9:48 am
I try to DISABLE the PUBLISHER Service in my Server
April 24, 2014 at 10:11 am
I suspect you have no publishing/distribution to disable.
Run this:
SELECT name, is_published, is_merge_published
FROM sys.databases
If any of your databases is published, you should see "1" in the "is_published" or "is_merge_published" columns.
If your instance is configured as a distributor, you should see the "distribution" database.
If you don't see any of those, you don't need to do anything.
-- Gianluca Sartori
April 24, 2014 at 10:12 am
mholguindomi (4/24/2014)
I try to DISABLE the PUBLISHER Service in my Server
BTW, writing all caps in forums is perceived as shouting and it is considered bad and unpolite.
-- Gianluca Sartori
April 24, 2014 at 10:26 am
Ok, sorry for Caps ... 😉 ...
and about your question ... yes i had configured Publisher and Distribution Services, i had this enviorenment:
3 Servers
1 Server (Publisher Server - Production)
2 Server (Distribution Server)
3 Server (Subscription Server)
Then i need to Uninstall or Remove this Services, when i remove this services of each server if present a error.
I can remove Suscription Server (No Problem)
I can remove Distribution Server (No Problem)
But when i try to remove Publisher Server was when present the Error or Problem.
April 24, 2014 at 10:44 am
You just need to drop the publications then.
You can do it manually in SSMS by clicking the publication and hitting DEL.
You can also do it in T-SQL.
See if this helps: http://technet.microsoft.com/en-us/library/ms147921(v=sql.105).aspx
-- Gianluca Sartori
April 24, 2014 at 11:05 am
Thanks ...
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply