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 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy