Enterprise Publisher To Express Subscribers (2005)

Distinguish Between The Publisher And The Subscribers

I have a database on SQL Sever 2005 SP1 against which a Publication has been defined and to which many servers (both Workgroup and Express editions - SP1) Subscribe to.

I would like to be able to distinguish between the Publisher and the Subscribers programmatically via T-SQL.

From reading BoL and various forums it appears that the IsPublished, IsMergePublished and IsSubscribed options of the DatabasePropertyEx function should give me this information.

However within all our tested environments, whilst the IsMergePublished option returns expected values. IsPublished and IsSubscribed both return 0 on all servers (the Publisher and Subscribers).

Is this a know issue and how can I rectify the problem or alternatively does anyone know of another method to distinguishing between the Publishers and Subscribers.

Thanks

Replication :: One Publisher 2 Subscribers

Is it possible to replicate data from one publishers to a multiple subscribers in transaction replication? In other words I have Server A, Server B, Server C with databases A,B,C respectively. I need to replicate 10 articles from A to B but only 1 from A to C. In other words I want to use the same publisher but select one article from that publisher instead of all 10 to Server C/database C.

If it is possible what will be the drawbacks of such implementation? Will performance be a hit?

Run Sp_resyncmergesubscription To Solve Un-sync Data Problem Between Subscribers And Publisher

Hello,



I have set up a merge replication with 4 subscribers and a publisher on SS05 sp2 on 5 window servers. After running my application on the replication with big data for a while, the data in some of tables of subscriber are out of sync from the publisher. I tried to run sp_resyncmergesubscription to fix the problem according to http://doc.ddart.net/mssql/sql2000/html/replsql/replmon_9pwh.htm. The procedure run successfully. However, the problem is still exist.



Does anyone else have this problem. Please help!

SQL 2000 As Publisher And SQL Express 2005 As Subscriber?

I want to have transactional replication setup with SQL 2000 as a publisher and SQL Express 2005 as a subscriber? Where can I get some documentation around that?

Basically, the problem I am stuck with is that while registering the subscriber in SQL2000, SQL2000 cannot recognize my SQL Express 2005 instance as a subscriber. I have tried both SQL Ent. Mgr. and sp_addsubscription.

Please help.

Thanks,

Rupak Ganguly

How To Restore Sql Express 2005 DB In Sql Express Enterprise Edition 2005

Can I Upgrade From Sql 2005 Express To Sql Server 2005 Enterprise Edition ?

if i upgrade from sql server 2005 expressto sql server 2005 enterprise can i do it ?
am i need to uninstall 2005 express before ?

Upgrade From SQL Server 2005 Express To 2005 Enterprise Fails

Hi

I am trying to upgrade SQL Server 2005 Express to SQL Server 2005 Enterprise Edition.
(As a Preparation to install SQLServer2005 Service Pack 2 (CTP))

I tried to upgrade a particular Instance (OFFICESERVERS, which was based on SQL Server 2005 Express ).

During the upgrade I get a message saying that ...

.....Your upgrade is blocked because of edition upgrade rules.....

All other components I selected for Installation are propertly installed (Analysis, Reporting)

The setup log contains the following detail information:

---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources

Error Code: 29543
MSI (s) (DC!C8) [13:57:26:265]: Product: Microsoft SQL Server 2005 -- Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: ValidateUpgrade
PerfTime Start: ValidateUpgrade : Fri Dec 29 13:57:26 2006
<Func Name='ValidateUpgrade'>
<Func Name='updateFeatureSellection'>
Error Code: 0x80077367 (29543)
Windows Error Text: Source File Name: sqlcaupgradeproduct.cpp
Compiler Timestamp: Mon Sep 19 01:07:45 2005
Function Name: sqls::UpgradeProduct::CanUpgrade
Source Line Number: 142

---- Context -----------------------------------------------

I also tried to explicitly upgrade the OFFICESERVERS instance by executing Setup from the command shell:

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=OFFICESERVERS UPGRADE=SQL_Engine SKUU
PGRADE=1 /qb

The result is the same, i.e.... Your upgrade is blocked because of edition upgrade rules...

Does anybody know about this problem?
Some more information about the system:
W2K3 R2 Enterprise Edition
WSS3.0
MOSS2007
previously installed SQL Server 2005 Express Edition (Version 9.00.2047.00)

Kinde regards
Andreas

Enterprise Manager For SQL 2005 Express

Hi,

Ive received a .bak file of our company db from our hosting company and would like to import it into the SQL 2005 Express machine however, Ive never done this before using 2005. Previously with SQL 2000, I used the enterprise manager to view/import data into the database but Im unable to find this feature with 2005.

Can anyone help me?

Thanks

DW

SQL 2005 Express On Server 2k3 Enterprise

After a few failed installs I have gotten SQL2k5Exp installed. I have update my .net and my XML. I had the server running fine for about a week. The server still 'runs' fine, but when I connect to it with Server managment studio express I can't do anything with it. It will not allow me to expand the 'System Databases' It gives the error:

"Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)

Additional information:

An exception occured while executing a Transact-SQL statement or batch.

(Microsoft.SqlServer.Express.ConnectionInfo)

A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) (Microsoft SQL Server, Error: 109) "

I get just about the same error if I try to attach a database, the only change is the error code at the end.

After this error the SQL server service stops. I can restart it from the Services snap-in, but not inside SMSE. It will start and stop if i try to start it in SMSE.

I also find these types of errors in my event log:

"SQL Server is not ready to accept new client connections; the connection has been closed. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: <local machine>]"

"The SQL Server (SQLEXPRESS) service terminated unexpectedly. It has done this 8 time(s)."

"The SQL Server Active Directory Helper service terminated with service-specific error 3221225572 (0xC0000064)."

Any ideas on this?

Export Data From SQL Enterprise To SQL Express 2005

Hello everybody,does anybody know how to export databases from SQL Enterprise to SQLExpress 2005?thanks in advanceLuca

Sql Server 2005 Express/management &&amp; Enterprise Manager

I have presently installed on my local computer Enterprise Manager for access to our remote sql server. May I install sql server 2005 express and sql server management studio express on my local computer without causing conflicts with Enterprise Manager?



thanks,

damiata

Remotely Register SQL Server 2005 Express In Enterprise Manager

I have SQL Server 2005 Express installed on a windows server 2003 standard edition. I have configured the windows firewall to allow exceptions for sqlservr.exe and sqlbrowser.exe. I have enabled remote and local connections using tcp/ip & Named Pipes through the Sql Server Surface Area Connection utility. I am able to telnet into the server with: telnet <server ip> <1433>.

Here is the strange part: I am able to connect to the Sql Server remotely from a development machine via Sql Server Management Studio Express, but I am unable to connect to the Sql Server from the same development machine by registering it in Sql Server Enterprise Manager...Is it possible to register SQL Express through Enterprise Manager?

When registering the SQL Express DB in Enterprise Manager I tried both just the (IP Address) of the server and the (IP AddressSQLExpress) as the server/host but I am getting the following errors from enterprise manager:

Just the (IP Address) as the server/host:
Invalid Connection.
ConnectionOpen( Invalid Instance())

(IP AddressSQLEXPRESS) as the server/host:
Sql Server does not exist or access denied. ConnectOpen(Connect()).

Any idea why I can€™t register/mount the instance remotely in Enterprise Manager
but I can in Sql Server Management Studio Express?

Thanks,

Greg

SQL 2005 Replication Performance: More Than 3000 Subscribers

Hi All,


We are developing a system which will have to support more than 3000
subscribers. We will have to support both Transactional replication
and Merge replication.


I checked the following document about SQL 2005 replication <http://
www.microsoft.com/technet/prodtechnol/sql/2005/mergrepl.mspx>. The
document does not clearly specify what is the maximum number of
subscribers supported without a significant performance degradation.


The questions i have are:
1. Given the fact that there will be more than 3000 subscribers, there
will be more than 500-1000 subscribers trying to replicate at the same
time. Will be there be a performance degradtion in such a scenario


2. Has anyone used SQL Server 2005 in a scenario involving more than
3000 subscribers?


3. Will it be better if we develop our own system to perform
replication activity instead of relying on SQL Server 2005?

- Ngm

Mail me atnarasimha (DOT) gm (AT) gmail (DOT) com )

Cannot Upgrade SQL Server 2005 Express To SP2 After Upgrading SQL Server 2005 Enterprise To SP2

How do I upgrade Sql Server 2005 Express to SP2 if I also have SQL Server 2005 Enterprise SP2 already on the same box? I installed Sql Server 2005 Enterprise first, then applied SP2, then installed Visual Studio 2008 (which installed SQL Server 2005 Express).

When I try to upgrade Sql Server 2005 Express to SP2 using the special Express edition of SP2, I get an error message that says "None of the selected features can be installed". I end up having to cancel the install of SP2.

I'm left with SQL Server 2005 at level 9.0.3054 and SQL Server 2005 Express at 9.0.3042. How can I bring SQL Server Express 2005 to the same level as SQL Server 2005 Entperprise?

Upgrading SQL Server 2005 Express To SQL Server 2005 Enterprise Edition

Hello!! How can I upgrade from SQL Server 2005 Express Edition to SQL Server 2005 Enterprise Edition? I see allot of example of upgrading from SQL Server 2000 to SQL Server 2005, but no example on upgrading from SQL Server 2005 Express to SQL Server 2005 Enterprise or Standard. Is this possible?

Where Do I Find SQL 2005 Developer Edition For MSDN Subscribers.

As I am begininng to believe that is the only edition I am going to be able to run on my Vista Utlimate os.

Standard does not install server components.

I believe SQL Express was working as installed with Visual Studio 2005, but I need the use the tools that SQL Express does not contain.

Thanks,

_Greg

Msde Vs Express Edition & Transactional Publisher

Hi;
In http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=71679 topic, it is stated that SQL-DMO can be used to make msde publisher for transactional replication.
But in http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=71983 topic, Rishi said that "No Express Edition cant act as Publisher".
I am not clear about the difference btw msde and express.
Why msde can be publisher for transactional replication by SQL-DMO and why express edition can not be?
Thank you so much...

Is 2005 Merge Replication Reliable For Compact Edition Subscribers On WinXP Tablets Over VPN?

I posted a more detailed technical question a couple of weeks ago
with Subject = "Compact Edition 2005 Subscribers - Merge Agent failed after detecting that retention-based cleanup has deleted metadata"
But I got no replies.

Now my question is simpler: Is SQL Server 2005 Merge Replication reliable with Compact Edition subscribers on WindowsXP tablets?

We deleted all users' local databases a couple of weeks ago, and republished two publications with retention = 60 days.
Now we have at least one user who can't sync with the server, and replication monitor shows the error below.
But if she e-mails her sdf file to a support person, they can successfully sync her database.
We're sure that it's not a permissions issue, which is a normal suspicion when one user can perform a task that another can not.
It doesn't seem like a retention problem, because she's well inside the retention period.
She can successfully sync with the publication with upload/download tablers, but not with the publication with download only tables. Both publications were created on the same day, by the same DBA, with nearly identical properties.

This problem user has operated in the past with no problem, and she's configured identically to all of the others. It just seems like random flakyness with merge replication for Compact Edition subscribers.

I feel stupid saying that, because it sounds like I believe in a magical ghost in the machine. So my question is - IS MERGE REPLICATION A LITTLE BIT FLAKY FOR COMPACT EDITION SUBSCRIBERS ON XP MACHINES?


We've applied SP2 to the server, but no subsequent HotFixes.

We're trying to sell users and management on developing a larger occasionally connected system with the same replication scheme, so we need to know if it deserves our confidence.


Error messages:

The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload). (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402)
Get help: http://help/MSSQL_REPL-2147199402

Can SQL Server 2005 Express Edition Coexist With SQL Server 2000 Enterprise?

Not sure if this was posted but having a hard time finding an answer.
I'm currently running sql server 2000 enterprise edition on my machine and was wondering what would happen if i installed 2005 express edition and vice versa? I've found many blogs and post about compatibility issues with the 2005 Express Beta version but couldn't find any news with full version. It would be much appreciated if someone can help me out with this problem.
Thanks!

View SQL Sever 2005 Express Database On SQL Sever Enterprise Manager

Is it possible to connect SQL Sever 2005 Express from SQL Sever 2000 Enterprise Manager? Tried to connect but got the error message "must use SQL Server management tools to connect this sever"

Thanks

Upgrading SQL 2005 Enterprise Evaluation To Enterprise Full Not Supported On Win XP Professional

This may be a stupid question, but can someone from MS SQL Server Team kind enough to confirm it, please?

Migration From Sql Server Express 2005 To Sql Server 2000 Enterprise

hi, i need some help here,i made a simple data driven website in my development PC, at first, i used MS Access for my data base then i migrate it to sql server express 2005, and it works fine when i try to run it in my development PC with my IIS. but of course i will be deploying it to a real server, in our office were i will deploy my data driven site, we have a PC server Win Server 2003 with SQL Server 2000 Enterprise (im not pretty sure by the name but i know its not a free version, its something like a 2000 sql version with a word enterprise at the end).so my question is, i am developing an ASPdotNET site originally used SQL server 2005 express,how can i migrate my site to the Win Server 2003 and my database from SQL Server 2005 express to SQL server 2000 enterprisewill it work?? if not, what are the possible solution that i can do in cases like mine?i used Visual Web Developer 2008 Express Ed. in making my sites, and its DOES NOT allow databases in SQL Server 2000!!!!!it says "can't recognize the database"i hope you can help me with this.Thanks-SALAMAT PO....=) 

Replicar SQL 7 ( Publisher ) Y SQL 2005 ( Subscriber )

Quisiera saber si se puede y como llevar a cabo la replicación con SQL 7 (Publisher) y SQL 2005 (Subscriber). Desde ya muchas gracias.

Replication - DB2 As Publisher - SQL 2005 As Subscriber

I have been looking for a way to replicate data from a DB2 system running on an AIX machine. I found some information related to doing this with SQL2000, but not with 2005. Can this be done - preferably without writing our own provider.

Thanks in advance

SQL 2000 SP 4 Publisher To SQL 2005 Distributor

Hi - hoping some folks here can help me. I've got a SQL 2000, Service Pack 4 database that I need to publish, but I'm getting the following error on the exec sp_addpublication statement when I try to set up publication in Management Studio:


Msg 8526, Level 16, State 2, Procedure sp_addpublication, Line 802
Cannot go remote while the session is enlisted in a distributed transaction that has an active savepoint.

I also tried to set up the Publisher in Enterprise Studio, on the theory that the system sproc was not backwards compatible, and there I got this error:


Error 627: Cannot use SAVE TRANSACTION within a distributed transaction

There is one proc in the publisher's database that uses SAVE TRANSACTION, but it isn't currently being run and it isn't dependent on the table being published. Has anybody else encountered this? Any ideas about how to make this go away?

SQL 2000 Publisher And SQL 2005 Suscriber

Where can I found information on how its works and how to do it?

I tried to do it but I always received an error message

(publisher Sql 2000)-(distributor 2005):problem

hi,
Im I want to configure my sqlserver 2005 server as both subscriber and distributor for transactional replication purposes.
I want to configure the sql server 2000 as the publisher.

When I try to configure the publisher in the sql 2000 server, Im not being able to establish the connection with the distributor 2005 sql server in any of the 2 possible cases.
case1-Using windows authentication- message:need to use management studio or SMO
case2-Using sql server authentication-message:authentication failed

Question:
Is it possible at all to do this? or should I make the distributor to reside in a sql 2000 server?

thank you

32-bit SQL 2000 Publisher And SQL 2005 64-bit SQL Distributor And Subscriber

For transactional replication, are there any issues and is it even possible to have 32-bit SQL 2000 publisher and SQL 2005 64-bit distributor and subscriber? Thanks

Moving A SQL2K Publisher To A SQL 2005 Instance.

Hi,

Oracle 10g R2 To Sql Server 2005 - Publisher Set Up Error

I am receiving the following error message when trying to create a new Oracle Publisher.



Msg 21684, Level 16, State 1, Procedure sp_ORACheckAdminPrivileges, Line 136

The permissions associated with the administrator login for Oracle publisher 'NT02' are not sufficient.



We have added the following permissions manually (not through a role) in Oracle:

CREATE PUBLIC SYNONYM and DROP PUBLIC SYNONYM
CREATE PROCEDURE
CREATE SEQUENCE
CREATE SESSION
CREATE ANY TRIGGER.
CREATE TABLE
CREATE VIEW



And we have also tried the Program FilesMicrosoft SQL Server<InstanceName>MSSQLInstalloracleadmin.sql script.



In both cases we are receiving the error message above. The only way we seem to be able to get around the error is to grant the DBA role to the replication schema user, which doesn't seem right.



Has anybody run into this problem before? How did you get around the problem?



Also is there a way to view sp_ORACheckAdminPrivileges because it's doesn't seem to be viewable anywhere in the database? This would at least let us know what it's looking for from an Oracle standpoint.



Help would be appreciated.



Thanks

SQL 2000 (publisher &&amp; Distributor) &&<&&> SQL 2005 (subscriber) - Is It Possible

We have a SQL 2000 Server (publisher & distributor) with around 15 databases being replicated (all using merge replication).

My question is the following:

Is it possible to perform Merge replication from a SQL 2000 (acting as the publisher & distributor) to a SQL 2005 server acting as the Subscriber)?

If anyone has a link to any instructions somewhere that would be great.

Thanks

SQL Replication: 2005 (Publisher) And A 2000 (Subscriber)???

Hi,

I was wondering if it is possible to setup replication between a 2005 SQL Publisher and a 2000 SQL Subscriber? Is there any special setup steps I need?

Thanks so much,

David