Archive for June, 2010

Another snapshot agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent

11, Jun 2010

When creating publication in a merge replication in MSSQL Server 2005, especially for beginners, it’s not new that while doing it in SSMS, you run into steps that makes your publication incorrectly configured thus forcing you to abort the process. Now when you cancel the publication and you’re in the middle of generating the snapshot, [...]

How to setup Oracle10g linked server in an MSSQL Server 2005 64-bit cluster

4, Jun 2010

The process in creating Oracle linked server on a 64-bit SQL Server instance should be: Install Oracle 10g Release 2 64-bit client software (available from Oracle website) Install Oracle 10g Release 2 64-bit ODAC software (available from Oracle website) Restart SQL services Configure OraOLEDB.Oracle under \Linked Servers\Providers in SSMS in its properties making sure that [...]

Configuring distribution in an MSSQL Server 2005 cluster

2, Jun 2010

For some reason that you receive an error trying to configure distribution on your MSSQL Server 2005 cluster and it will ask you to use the actual server name when connecting to the server, verify that your server name in the sys.servers catalogue is the same as your instance name. To verify, while connected to [...]


top