Intermittent Failures Using Web Synchronisation

Dec 18, 2005

HI

We are using HTTPS anonymous merge subscriptions....

Sometimes when trying to synchonise, we will get the following error messages returned to the subscriber....

The upload message to be sent to Publisher '**thewebserver**' is being generated
The merge process is using Exchange ID '0F65CFCB-AF17-47DC-8D98-493A44C243E0' for this web synchronization session.
The Merge Agent could not connect to the URL 'https://**thewebserver**/client/replisapi.dll' during Web synchronization. Please verify that the URL, Internet login credentials and proxy server settings are correct and that the Web server is reachable.
The Merge Agent could not connect to the URL 'https://**thewebserver**/client/replisapi.dll' during Web synchronization. Please verify that the URL, Internet login credentials and proxy server settings are correct and that the Web server is reachable.
The Merge Agent received the following error status and message from the Internet Information Services (IIS) server during Web synchronization: [401 :'Unauthorized']. When troubleshooting, ensure that the Web synchronization settings for the subscription are correct, and increase the internet timeout setting at the Subscriber and the connection timeout at the Web server.


If I then go to a web brower, put in the HTTPS address, it brings up the logon dialog - I put in the admin username and password to confirm the connection and that's fine.

We try and synchronise again, and this time it works - it's as though I have 'woken' it up again and it's happy to play.

Is increasing the timeouts as suggested by the error message the way to go ? If so, where does one set the 'internet timeout setting at the subscriber', and the 'connection timeout at the webserver' ?

 

thanks

 

 

View 3 Replies


ADVERTISEMENT

SQL Synchronisation

Feb 26, 2007

Hi
 
I have been giving myself a headache over deploying and synchronising sql databases.
 
Can anybody point me in the right direction of a tool that can help me to synchronise changes of structure / data between two databases. I have used the demo version of SQL compare, but I think its way too expensive. Does Microsoft produce a tool that can perform similar functions? If not can anybody point mew in the way of a tutorial that can help me with migration / deployment / synchronisations of SAL Databases.
 
Many thanks

View 2 Replies View Related

Web Synchronisation On XP Pro Box

Oct 17, 2007

Hi

For our application we want two Publisher models:
1) running SQL Server 2005 standard on Windows Server 2003
2) running SQL Server 2005 standard (or workgroup) on Windows XP pro

The reaseon is simply cost. The first for clients that may have 10s / 100s of SQLce subscribers, the second for just 1-5 SQLce subscribers.

We want to use Web syncronisation. Problem is when setting up on the XP box I get to the final bits of Microsoft's setup document and it starts to tell you to set up an application pool. As far as I can tell this is only available on IIS6 on Windows Server 2003.

Searching the Internet I don't seem to be able to find a definative 'don't be a pratt' you can't run Web Synchronisation from a XP pro box.

Could someone let me know if it is or is not possible. If I could get SQL Express to be a publisher (to SQLce subscribers) I would have prefered not to have the cost of a full verision of SQL Server for our smaller clients.

Many thanks in advance

Alistair

View 1 Replies View Related

Web Synchronisation Using RMO

Jun 21, 2006

hi every body please help me out on this issue , since i am at final stage in finishing up the module.

Previously i had done web synchronisation using RMO it is working fine at my office where i have an 2003 server which is an domain controller , publisher i have configured on the 2003 server , and i had subscribers on xp Machines where it was well working fine, clients were not on the domain , it is an independent Machine. we had an security error which was resolve by this same forum, ie the client windows login id should exists on the server too. only then synchronisation is happening at our office,

Now the problem is i have an same setup , but the server 2003 is hosted at a remote place , which is not an domain controller, now if i try to synchronise from our office i am getting "A Security Erorr Occured" , is it so that the publisher should be configured as an domain controller please any body resolve this issue

Thanks

View 44 Replies View Related

Web Synchronisation

Jul 2, 2006

iam able to open the web sync diagnostic information using URL https://itneersrv.abitta.com:443/Synchronise/replisapi.dll in the internet explorer but while running throuth the c# code to run Merge agent i am gettin the following error ,

[0%] InProgress The Merge Agent could not connect to the URL 'https://itneersrv.
abitta.com:443/Synchronise/replisapi.dll' during Web synchronization. Please ver
ify that the URL, Internet login credentials and proxy server settings are corre
ct and that the Web server is reachable.
A security error occurred

I am trying the synchronise through Internet where i have an publisher is at different country and subscriber at my office in India , i have given all privileges but then too i am getting same error , can any body help out on this..i have posted serveral times , few people responed but i could'nt resolve this issue



View 3 Replies View Related

Synchronisation Problems

Sep 14, 2000

We have a central server, with offices from other country's synchronising with our main DB. Some are fine, but many for some reason keep getting the same error message time after time:-

"The process could not log conflict information"

You then go into the problem and it says it can not read the file of a particular table due to Error 53.

I have no idea what this means. If anyone can help, I'd be very appreciative!

Thanks in advance,
Greg

View 1 Replies View Related

Synchronisation Problems

Jan 16, 2001

We have a fair number of databases in different countries and we synchronise with them everyday. Apart from all the problems we have, recently it has gone well. In HQ, we have local database and also 1 which the countries synch with. Therefore, the local database needs to synch with the synch database. That is successful every time. The only problem we have is that after synchronisation is complete, there are differences in data in the 2 databases and we don't understand why - after all, synchronisation is meant to keep the databases the same. If anyone has any ideas why this is happening, I would be very grateful if you could get back to me. Thanks.

View 3 Replies View Related

Replication / Synchronisation

Jun 22, 2006

Hi Guys, my first post here for quite a while.

I have a question regarding replication and or database synchronisation:

I am doing some work on a SCADA control system in .Net - (SCADA=[S]upervision, [C]ontrol And [D]ata [A]quisition)

Obviously, these are mission critical systems that must have uptimes of greater 99%.

Tradiotionally, we have used custom written database in assembler or C, but these are getting rather long in the tooth, and, in my opinion, represent a massive man-time investment developing something that already exists 'off the shelf' (for example, our custom written database, the first version of which roled out nearly 20 years ago doesn't support SQL)

So, I'm looking to see if there is an off the shelf DB that can do what we need it to do. I lean towards Microsoft because of it's integration with the .Net platform.

However, probably the most important criteria for us is that of database synchronisation - as data from the plant arrives it is stored in a database (obviously) - however, at the SAME TIME, it is sent to a back up (standby) database which is identical in every respect, except it does not 'answer' queries, it only listens and keeps it's database up to date. Then, should the 'primary' database server fall over, the standby will become active, and it is up-to-date ready to run.

Does SQL server offer such a facility that changes to a database can be immediately and automatically 'echoed' to a standby database? Automatic promotion from standby to main is not an issue, as this decision would be taken by the application software 'in front' of the database - if it cannot contact the main DB server, it will elect to start talking to the standby, thus, philisophically (sp?) the standby is now the main server.

Hope I haven't confused anyone here with my rambling?

The problem is my hunch (not being a DB guru) is that replication is NOT what I am looking for - I *think* replication does sync data and schema (correct me if i'm wrong) but not immediately - it is scheduled? Yes?

I am looking more for synchronisation - but it has to be 'on the fly' - not every 15 minutes or 8 hours etc...

If SQL server cannot do it, then it's not a major problem, since the DB access layers of the applications themselves can simply write their data to two DB's, and queue writes in a buffer if one of the partners is offline, such that they will be written to the partner when it comes online - however, I'm all for an easy life, and if the boys at Microsoft have already settled this issue, then i'm all for that!

Your advice would be appreciated.

Regards

Mark Wills

View 2 Replies View Related

SQL Server Synchronisation

Apr 13, 2008

Hi

I am using a sql server database for storing gps data from a remote location. The average data stored in the db is around 2 GB/day. For security reasons, my application is working on another server which has same db. I need to update data in the second database within an interval of 2 seconds. The user entry in the application server has to be synchronised with first server also. Is replication is possible in such a small interval?. Anybody have any suggestion?

Thanks in advance

Kuttan

View 4 Replies View Related

Performance Of Web Synchronisation?

Nov 14, 2007

We have a SQL Server 2005 database supporting our main ecommerce site. It is hosted remotely by our ISP. We currently maintain a local copy of this database by running daily stored procedures to keep the local copy up to date. However we'd like to explore the use of replication over HTTPS as an alternative means of keeping the local copy in sync with the ISP database.

Could anyone comment on the technical feasibility of doing this, given that transaction throughput on the ISP server can be several hundred hits per hour? Is web-based synchronisation likely to suffer from poor performance, or to adversely affect users of our ecommerce site?

View 2 Replies View Related

Data Synchronisation

Jul 20, 2005

Hi,I'm working with two databases on to physicaly separated servers: #1is on a local machine en I can only connect to #2 via an ADSLconnection.I need to syncrhonise the data. This works fine via the wizard fromthe Enterprise Manager. But I want to get this done via a script formthe Query Analyzer that I can run whenever I want to. Something like:insert into srv1.database.dbo.table1select * from srv2.database.dbo.table1When I do this I get an error about "linked servers". That surprisesme, because I have no linked servers configured and yet the wizardworks fine?Can anyone tell me how to accomplish this?tavJan Willems

View 1 Replies View Related

Web Synchronisation Throuth SSL

Jun 19, 2006

hi,

i have done Web Synchronisation Using RMO , where i have an remote server at a remote place, where the Virtual Directory is Configured With SSL, for testing purpose if i access from the Client Computer entering http://72.17.246.214/SyncAbita/replisapi.dll?diag " in the address of IE giving an errormessage "Unable to Reach Remote Host", if i remove SSL on the Server , i am able to access "SQL Websync diagnostic information" Page from the Client Machine, is it not possible to get perform Web Synchronisation With SSL, then i have inStalled 7 days Trial Version SSL on the Sever. Can any body help me out on this Issue

View 15 Replies View Related

Wireless Synchronisation

Dec 28, 2005

How can i synchronise (wireless) data from desktop to ppc?

View 1 Replies View Related

Database Synchronisation

Feb 22, 2007

Hi..

I hope this is the right forum for my question. I am very new in Databases. I have such a problem:

There is a Database on SQL-Server in a country X. This database has tables like

Table 1,Table 2 ,.....Table 10;

I develope an Application with Visual C#.NET 2.0. I use a local SQLExpress database, which has tables like

Table1,Table 2..Table 6,Table A,Table B.

As you see Table 1-Table 6 are same in both databases (not the whole database ). And these tables must always have the same information (Server database changes->local database must read the changes). Because of that there must be a Synchronisation between them.

How can I solve this Problem? Do I need to write code or is there any simple solution?

Thank you.

View 1 Replies View Related

SQL Server Synchronisation

Apr 13, 2008

Hi

I am using a sql server database for storing gps data from a remote location. The average data stored in the db is around 2 GB/day. For security reasons, my application is working on another server which has same db. I need to update data in the second database within an interval of 2 seconds. The user entry in the application server has to be synchronised with first server also. Is replication is possible in such a small interval?. Anybody have any suggestion?

Thanks in advance

Kuttan

View 6 Replies View Related

Scheduled DTS Failures

Mar 12, 2002

Hello

I have a number of DTS packages which when run manually complete successfully however, when run as scheduled tasks they always fail. Can anyone offer any advice?

Many thanks

View 3 Replies View Related

Help With Xp_sendmail Failures

Jul 9, 2002

Where I work, we use a lot of triggers on our tables. And most of the time we use them to send email out (using xp_sendmail). For example, a user enters data and there is an insert trigger on that table to send email out to the appropriate individuals. This is all well and good until the SQL Mail Agent stops running for one reason or another. People try to enter their data and because there is an insert trigger on the table which tries to send mail out the entire transaction fails and the data can't be saved simply because the trigger can't successfully execute xp_sendmail. Does anyone know of a way around this? A better way to accomplish this? Any suggestions are appreciated!

View 2 Replies View Related

DBCC Failures

Apr 16, 2001

Hi. I am running SQL2000 standard edition on a Windows 2K server. I have this annoying problem that the jobs I create through the maintenance plan wizard fail consistantly on a certain database that has one table in it. Just the database integrity check and update statistics part of the maintenence plan fail, the backups are fine.
This will occur on a brand new database, with the default options selected and with only one empty table in it. The script to create the table and indexes is below. The errors I get from the maintenance plan are:

--Check Data and Index Linkage
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.

--Update QP Statistics
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.

I have messed around with setting these db options on and off with no effect on the success of the maintainence plan. I am wondering if anyone can replicate the problem on there own installation or have any thoughts on how to fix. Oh if I take the formula off of the table the jobs run successfully.
Thanks in advance.

Script:
/****** Object: Table [dbo].[UserLog] Script Date: 4/10/2001 2:39:48 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserLog]
GO

/****** Object: Table [dbo].[UserLog] Script Date: 4/10/2001 2:39:51 PM ******/
CREATE TABLE [dbo].[UserLog] (
[LogId] [int] NOT NULL ,
[Website] [tinyint] NOT NULL ,
[SessionID] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Time] [datetime] NULL ,
[DayOfYear] AS (datepart(dayofyear,[Time])) ,
[PageID] [smallint] NULL ,
[ZipCode] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ReferringDomain] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

CREATE CLUSTERED INDEX [IX_Time_PageID] ON [dbo].[UserLog]([Time], [PageID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[UserLog] WITH NOCHECK ADD
CONSTRAINT [DF_UserLog_Website] DEFAULT (1) FOR [Website]
GO

CREATE INDEX [IX_Time_SessionID] ON [dbo].[UserLog]([Time], [SessionID]) ON [PRIMARY]
GO

CREATE INDEX [IX_Time_SessionID_ReferringDomain] ON [dbo].[UserLog]([Time], [SessionID], [ReferringDomain]) ON [PRIMARY]
GO

CREATE INDEX [IX_Time_SessionID_PageID_ReferringDomain] ON [dbo].[UserLog]([Time], [SessionID], [PageID], [ReferringDomain]) ON [PRIMARY]
GO

set ANSI_PADDING,ANSI_WARNINGS,CONCAT_NULL_YIELDS_NULL ,ARITHABORT,QUOTED_IDENTIFIER,ANSI_NULLS on


set NUMERIC_ROUNDABORT off


CREATE UNIQUE INDEX [IX_SessionID_DayOfYear_PageID] ON [dbo].[UserLog]([SessionID], [DayOfYear], [PageID]) WITH IGNORE_DUP_KEY ON [PRIMARY]
GO

set arithabort OFF
GO

set numeric_roundabort OFF
GO

set quoted_identifier OFF
GO

View 1 Replies View Related

DTS Job Reporting Failures

May 4, 2007

I have a DTS Job that is reporting failures but it looks to me as ifthe job is actually completing successfully. The job only has acouple steps. Step 1 (DTSStep_DTSExecuteSQLTask_1) Execute SQL Task,runs a stored procedure to export blobs (pdf files) out of sql serverand onto the local machine.Here is the code in the storedprocedure called sp_PDFExportCREATE PROCEDURE [dbo].[sp_PDFExport] ASbeginset quoted_identifier offdeclare @pk intdeclare @where_clause varchar(100)declare @file_name varchar (50)declare @debug varchar (50)Declare @cmd varchar (50)--debug/*if @Debug = 1print @cmdexec Master..xp_cmdShell @cmd */-- begin cursorDECLARE LOOKUP CURSOR FOR select pr.[id]from plan_report pr, plan_version pvwhere pv.plan_id = pr.plan_id and pv.status = '30' and pr.create_time


Quote:

View 7 Replies View Related

Database Synchronisation Tools

Aug 9, 2007

Im looking for some recommendations on tools I can use to keeo my dev/test/prod databases in synch. Im tired of doing this manually. I use SQLSever 99% of the time but if there is a tool that can manage other database also I would be interested in hearing about it also.

View 1 Replies View Related

Real Time Synchronisation

Oct 24, 2000

Hello,

Can anyone guide me. which is the best method for real time synchronisation of my production server. Is it Transactional Replication or Stand By Server?

Thanks In Advance

Sejal

View 2 Replies View Related

Alternate Synchronisation Partners

Jun 8, 2006

Yes, I know synchronisation to alternate partners is deprecated in SQL2005 but....

In SQL2000 there is a Sync Partners tab in the publication properties dialog that allows you tick a checkbox for each co-publisher to be enabled as an alternate synchronisation partner. What is the equivalent in SQL2005?

I've set up replication in SQL2000 following these instructions http://support.microsoft.com/?kbid=321176 and it works. Now I'm trying to do the same thing in SQL2005 but I can't find a substitute for steps 10 & 11 in the section "Set Up the Alternate Synchronisation Partner". What's the answer?

Thanks in advance.

View 10 Replies View Related

Synchronisation Using Web Service For PDA Application

Feb 6, 2006

I am developing a application on PDA using c# compact framework. I would like to do synchornisation of sql mobile 2005 database with sql server 2005 database using web service.

The reason for going to webservice is based on the client request.

Will anybody help me on this, how to perform conflict management etc.

View 4 Replies View Related

Transaction Log Backup Failures

Dec 29, 2000

We have a job created by the maintenance job wizard that backs up the transaction logs for all of our databases on an hourly basis. At random intervals, one of the tranaction log backups will fail with the following message in the job history:
sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

The next scheduled transaction log backup will run fine the next hour. The sqlmaint.exe is present and executable. There are no additional messages in the SQL Server error log or SQL Agent error log. Any ideas what causes this random failure?

View 1 Replies View Related

Unexplained Login Failures

Apr 12, 2004

Hi all,

I could really use some assistance. I have been researching this problem for over a month now and I have not made any headway or progress.

I am running SQL Server 2000 on Windows 2000 Server. Hardware is Dual Xeon 2.4/400 Procs, 2GB ram and 1 Raid10 Array with 4x 36 GB 10K RPM drives.

The server has about 50 dbs on it. All are primarly used in conjuction with some web application or site. On average the server sees about 270ish connections/sessions.

About 1 - 2 months ago, we started seeing random login failures. We have no explanation for these failures. Our coldfusion code gives us detailed logging information regarding the exact statement that was being executed when the login failed. We try to reproduce the failed login, we cannot. There are no misspelling, code inconsitencies in this regards because the logins are set in the data source which verify.

We are using per-processor licensing, so unless there is a hidden limit we are hitting or MS is lying about per-processor licensing having unlimmited connections, that is not the issue. Also, I've ruled out some kind of network issue because if that were the case, the login would have timed out, as opposed to failing. I've been running a trace and viewing the failed logins.

Has anyone dealt with this issue before?



Best Regards,


Errol Neal

View 9 Replies View Related

SQL Agent Job Failures And Duration

Nov 6, 2003

/*
This SP has 2 functions.
a) if @method='duration' gives the average run duration in minutes for successful jobs
b) if @method='failures' displays failures/cancels/still executing jobs
It defaults to today's date. Specify @xdate for a different date
-- Louis Nguyen
*/

CREATE PROCEDURE UtilityJobsHistory
(
@method varchar(100)='duration'
,@xdate datetime=null
)
AS
set nocount on
set transaction isolation level read uncommitted

if @method='duration' begin

select @xdate=isnull(@xdate,getdate())

/*run_duration is in HHMMSS format; drop SS*/
/*run_staus: 1 complete 2 retry*/
/*step_id: 0 is final job outcome*/
/*run_date: yyyymmdd format*/

/*today's performance*/
select a.name,minutes=avg((b.run_duration / 100)/100*60 + (b.run_duration / 100)%100)
into #today
from msdb..sysjobs as a
join msdb..sysjobhistory as b
on a.job_id=b.job_id
where run_status in ('1','2') and step_id=0 and run_date =convert(varchar,@xdate,112)
group by a.name

/*7 day average performance*/
/*populate #D with dates in yyyymmdd format*/
create table #D (run_date varchar(50))
declare @idate datetime set @idate=@xdate
while @idate>dateadd(day,-7,@xdate) begin
insert into #D
select run_date=convert(varchar,@idate,112)
select @idate=dateadd(day,-1,@idate)
end

/*Avg7Days*/
select a.name,minutes=avg((b.run_duration / 100)/100*60 + (b.run_duration / 100)%100)
into #avg7Days
from msdb..sysjobs as a
join msdb..sysjobhistory as b
on a.job_id=b.job_id
join #D as c
on b.run_date = c.run_date
where run_status in ('1','2') and step_id=0
group by a.name

/*output*/
select name=cast(a.name as varchar(35)),OneDayAvg=a.minutes,SevenDayAvg=b.minutes
from #today as a
join #avg7days as b
on a.name=b.name
order by a.name

return end


if @method='failures' begin

select @xdate=isnull(@xdate,getdate())

select status=case run_status when 0 then 'FAILED' when 3 then 'CANCELED' when 4 then 'EXECUTING' end
,name=cast(a.name as varchar(35)),step_name
,time=replace(convert(varchar,@xdate,107),' ','')+' '+right('0000'+cast(b.run_time/100 as varchar),4)
,b.message
from msdb..sysjobs as a
join msdb..sysjobhistory as b
on a.job_id=b.job_id
where run_status in ('0','3','4') and run_date=convert(varchar,@xdate,112)
order by run_status,a.name

return end

View 1 Replies View Related

Failures During Install Of SP2 On SQL 2005

Nov 9, 2007




I've installed the SP2 on three dev/test servers. I went to install on production and the install failed on the Nofication and Client updates.

The error message was -

MSP Error: 29549 Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The transaction has aborted.



MSP Error: 29549 Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The transaction has aborted.



Any ideas?

View 5 Replies View Related

How Do I Handle Connection Failures

Oct 15, 2007

I have a package that loops through a list of servers. I keep the list in a table, read it, then loop through it and dynamically set the ServerName in the Connection Manager so that I can connect to one server after another without having to set up separate Connection Managers for each. A Data Flow task queries each server for configuration information and writes that to a central database. Everything works well, unless a server is offline for some reason.

As long as it doesn't exceed the max number of errors, the package logs the error, skips over that server and continues along just fine. What I'd like to do is trap that error and manually write a row to the central database with the server name and an error message, so that at least all the servers show up in the report, even if they don't all have configuration data listed.

How do I handle this type of connection error? Everything I've seen on error handling either assumes it's a data error or that you want to log the error in some external log file. I want to execute a SQL script that writes the value of a variable (the server name) to a table.

View 1 Replies View Related

Random Failures Jobs

Jun 4, 2007

Hi,

I have two packages that run successfuly.

But when I run them as jobs, (every 10 minutes) they failed randomly.

(They run as the proxy name I have created)

The error is: "The package execution failed. The step failed."

Do you have any idea how I can resolved this problem?



Thank you in advance







View 7 Replies View Related

Inconsistent Package Failures

Jan 19, 2006

I'm debugging my first SSIS package and is getting inconsistent results. The package does not always complete successfully. When the package does fail, it fails at different tasks that accquire database connections. Any of the following error message would show up:
[Execute SQL Task] Error: Failed to acquire connection "FORGE.FMC". Connection may not be configured correctly or you may not have the right permissions on this connection.

[OLE DB Destination [6374]] Error: The AcquireConnection method call to the connection manager "FORGE.FMC" failed with error code 0xC0202009.

[Connection manager "FORGE.FMC"] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Named Pipes Provider: No process is on the other end of the pipe. ".

I never experienced any connection error when executing query through management studio. It's only SSIS packages that fails to connect every now and then. Any help is appreciated.

Thanks.

View 21 Replies View Related

Dotnet 3.5 Runtime For Synchronisation Of Sql Server

Jun 1, 2007

Hi,

I downloaded orcas and created an application which also has sql server synchronisation, now if i wish to run it on another m/c, where can i get the runtime for 3.5, I searched but could not find it.



Thanks

arnab

View 1 Replies View Related

SQL Express - Synchronisation And Updates At The Same Time

May 16, 2007

If my application updates a SQL Express database at the same time as my service is performing synchronisation of the same database via RMO, intermittently some of the rows updated will not be included the next time synchronisation is performed.



Does anyone know what's happening and what I can do about it?

View 3 Replies View Related

Disk Backup Failures (file In Use)

Feb 21, 2000

I am getting occasional failures of a SQL Server 7.0 complete backup to disk on a production database. The errors seem to indicate that another process has the disk file open at the time of the backup. The errors contain the following texts : -

'Cannot open backup device'
'Operating System Error=32 Process cannot access file because it is being used by another process'.

The only other process that should access the disk file is an ARCserveIT scheduled job to copy the disk backup to tape but this is completing long before.

Any ideas or suggestions?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved