Problem in Data Driven Subscription

Hi all,

I had created a Data Driven Subsripiton last week and it was working fine.

But now when i try to run the same, it is not working.

But my log file does not say anything, all it has, is this

w3wp!library!5!06/19/2006-13:34:22:: i INFO: Call to GetPermissions:/Influe Reports/Out Of Stock Report (Missing) (This is report name)
w3wp!library!5!0 6/19/2006-13:34:22:: i INFO: Call to GetSystemPermissions
w3wp!library!5!06/19/2006-13:35:12:: i INFO: Call to GetPermissions:/Influe Reports/Out Of Stock Report (Missing)
w3wp!library!5!06/19/2006-13:35:12:: i INFO: Call to GetSystemPermissions
w3wp!library!1!6/19/2006-13:39:44:: i INFO: Cleaned 0 batch records, 0 policies, 3 sessions, 4 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams

i am looking at the file present in this path D:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\

Can any body tell me what is the problem all about.

Moving to reporting services group

Problem downloading the snapshot agent in a merge pull subscription.

Hello.

I've been having an error when downloading the snapshot agent from our Publisher.

The articles selected are all the tables and all the stored procedures.

The Subscription is created programmatically and so is the synchronization. When trying to synchronize for the first time and when the subscriber tries to download the snapshot I have the following error:

---

Error messages:
The schema script 'Distrito_2.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001
The process could not read file 'GESZif\unc\AFRODITE$SILVITEST_GESZIF_GESZIF\20070621182845\Distrito_2.sch' due to OS error 3. (Source: MSSQL_REPL, Error number: MSSQL_REPL20143)
Get help: http://help/MSSQL_REPL20143
The system cannot find the path specified.
(Source: MSSQL_REPL, Error number: MSSQL_REPL3)
Get help: http://help/MSSQL_REPL3

---

The snapshot folder is at c:\GESZifSnapshotFolder and the unc is \\Afrodite\Snapshot.

I'm getting a little desperate with this because we really need to propagate the schema changes around the subscribers.

Thanks in advance,

AVD

Has this ever worked before? Does agent account have the read access to your snapshot folder?

Gary

|||Hello Gary, thank you for your reply.

No, this has never worked before. When I was studying a way to implement replication I mostly used the management studio and management studio express. I created a database with backup/restore and put it at the client, so I disabled the initial snapshot when the error ocurred for the first time.

When you refer the agent account I suppose you mean the one at the Publication server (since SQLExpress doesn't have the SQL Agent)? Yes, it has full rights over the directory.

Best regards,

AVD
|||

Gary Chen wrote:

Has this ever worked before? Does agent account have the read access to your snapshot folder?

Gary

Ok, Gary i took your advice and found out that the permissions must be set for the UNC share and not the directory security.

After that it all worked wonders. Thanks for the help.

Problem creating SQL Server Mobile Subscription

Hi there

When I try and create a subscription in SQL Server Mobile to a published SQL Server 2005 database, I get the following problem error during the data synchronization process:

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.

HRESULT 0x80004005 (29061)

Any help would be gratefully appreciated.

Regards

JB

If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.|||

Mahesh

Thanks for the reply. I have to confess I am not too clear on what you mean by this...still learning...

I used the computername/iuser_computername account to create the publisher. This user has access to the snapshot folder and the virtual directory for the web server. (by the way, all of this is running on the same machine - VS2005, SQL Server 2005, IIS 5.1, and SQL Server Mobile 2005)

As far as I can see, computername/iuser_computername has been used consistently during the creation of the publication (it appears on the Publication Access List for example). I use my own log in on the PC which has admin rights as the Snapshot Agent login for creation of the snapshots.

Where am I going wrong?

Thanks

|||Can you verify if the IUSR_xxx has access to the database by connecting to the server and using the database from an osql command?|||

I am getting the same error as this. When I go to the SQLCESA30.LOG file in the "C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Server\SqlMobileReplication" directory, the two entries that I get in the log are as follows:

2006/01/07 16:59:36 Hr=00000000 SQLCESA30.DLL loaded 0
2006/01/07 16:59:58 Hr=80004005 ERR:OpenDB failed getting pub version 28627

I'll start a new thread.

|||I've started a new thread at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=193693&SiteID=1 for "Hr=80004005 ERR:OpenDB failed getting pub version 28627"|||

JB,

Chris, who started the other thread (with the note above) has had very similar issue. He troubleshooted the problem and has been kind enough to post the analysis and the resolution in his thread. Please go through that thread and see if it helps your problem. From what I see the error messages are very much related.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=194640&SiteID=1&mode=1

|||

Hi

I have been Getting the Same Error unable to connect to Sql server or IIS configured properly

Any one who any help me in this regard.

How we would make sure that --> If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.

Rg Ad

|||I try use IIS 7, but its difficult than I though. When create publication under IIS 6 I just only add IUSR into login, then create publication and put IUSR into PAL, then subscription just work fine. But when use IIS 7 I follow the steps for IIS 6 then when try synchronize data it said that the IUSR is not valid SQL Server user, is the IIS 7 have another guest account so I can put it into login?

Thanks,

Problem creating SQL Server Mobile Subscription

Hi there

When I try and create a subscription in SQL Server Mobile to a published SQL Server 2005 database, I get the following problem error during the data synchronization process:

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.

HRESULT 0x80004005 (29061)

Any help would be gratefully appreciated.

Regards

JB

If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.|||

Mahesh

Thanks for the reply. I have to confess I am not too clear on what you mean by this...still learning...

I used the computername/iuser_computername account to create the publisher. This user has access to the snapshot folder and the virtual directory for the web server. (by the way, all of this is running on the same machine - VS2005, SQL Server 2005, IIS 5.1, and SQL Server Mobile 2005)

As far as I can see, computername/iuser_computername has been used consistently during the creation of the publication (it appears on the Publication Access List for example). I use my own log in on the PC which has admin rights as the Snapshot Agent login for creation of the snapshots.

Where am I going wrong?

Thanks

|||Can you verify if the IUSR_xxx has access to the database by connecting to the server and using the database from an osql command?|||

I am getting the same error as this. When I go to the SQLCESA30.LOG file in the "C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Server\SqlMobileReplication" directory, the two entries that I get in the log are as follows:

2006/01/07 16:59:36 Hr=00000000 SQLCESA30.DLL loaded 0
2006/01/07 16:59:58 Hr=80004005 ERR:OpenDB failed getting pub version 28627

I'll start a new thread.

|||I've started a new thread at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=193693&SiteID=1 for "Hr=80004005 ERR:OpenDB failed getting pub version 28627"|||

JB,

Chris, who started the other thread (with the note above) has had very similar issue. He troubleshooted the problem and has been kind enough to post the analysis and the resolution in his thread. Please go through that thread and see if it helps your problem. From what I see the error messages are very much related.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=194640&SiteID=1&mode=1

|||

Hi

I have been Getting the Same Error unable to connect to Sql server or IIS configured properly

Any one who any help me in this regard.

How we would make sure that --> If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.

Rg Ad

|||I try use IIS 7, but its difficult than I though. When create publication under IIS 6 I just only add IUSR into login, then create publication and put IUSR into PAL, then subscription just work fine. But when use IIS 7 I follow the steps for IIS 6 then when try synchronize data it said that the IUSR is not valid SQL Server user, is the IIS 7 have another guest account so I can put it into login?

Thanks,

Problem creating SQL Server Mobile Subscription

Hi there

When I try and create a subscription in SQL Server Mobile to a published SQL Server 2005 database, I get the following problem error during the data synchronization process:

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.

HRESULT 0x80004005 (29061)

Any help would be gratefully appreciated.

Regards

JB

If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.|||

Mahesh

Thanks for the reply. I have to confess I am not too clear on what you mean by this...still learning...

I used the computername/iuser_computername account to create the publisher. This user has access to the snapshot folder and the virtual directory for the web server. (by the way, all of this is running on the same machine - VS2005, SQL Server 2005, IIS 5.1, and SQL Server Mobile 2005)

As far as I can see, computername/iuser_computername has been used consistently during the creation of the publication (it appears on the Publication Access List for example). I use my own log in on the PC which has admin rights as the Snapshot Agent login for creation of the snapshots.

Where am I going wrong?

Thanks

|||Can you verify if the IUSR_xxx has access to the database by connecting to the server and using the database from an osql command?|||

I am getting the same error as this. When I go to the SQLCESA30.LOG file in the "C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Server\SqlMobileReplication" directory, the two entries that I get in the log are as follows:

2006/01/07 16:59:36 Hr=00000000 SQLCESA30.DLL loaded 0
2006/01/07 16:59:58 Hr=80004005 ERR:OpenDB failed getting pub version 28627

I'll start a new thread.

|||I've started a new thread at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=193693&SiteID=1 for "Hr=80004005 ERR:OpenDB failed getting pub version 28627"|||

JB,

Chris, who started the other thread (with the note above) has had very similar issue. He troubleshooted the problem and has been kind enough to post the analysis and the resolution in his thread. Please go through that thread and see if it helps your problem. From what I see the error messages are very much related.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=194640&SiteID=1&mode=1

|||

Hi

I have been Getting the Same Error unable to connect to Sql server or IIS configured properly

Any one who any help me in this regard.

How we would make sure that --> If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.

Rg Ad

|||I try use IIS 7, but its difficult than I though. When create publication under IIS 6 I just only add IUSR into login, then create publication and put IUSR into PAL, then subscription just work fine. But when use IIS 7 I follow the steps for IIS 6 then when try synchronize data it said that the IUSR is not valid SQL Server user, is the IIS 7 have another guest account so I can put it into login?

Thanks,

Problem creating SQL Server Mobile Subscription

Hi there

When I try and create a subscription in SQL Server Mobile to a published SQL Server 2005 database, I get the following problem error during the data synchronization process:

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.

HRESULT 0x80004005 (29061)

Any help would be gratefully appreciated.

Regards

JB

If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.|||

Mahesh

Thanks for the reply. I have to confess I am not too clear on what you mean by this...still learning...

I used the computername/iuser_computername account to create the publisher. This user has access to the snapshot folder and the virtual directory for the web server. (by the way, all of this is running on the same machine - VS2005, SQL Server 2005, IIS 5.1, and SQL Server Mobile 2005)

As far as I can see, computername/iuser_computername has been used consistently during the creation of the publication (it appears on the Publication Access List for example). I use my own log in on the PC which has admin rights as the Snapshot Agent login for creation of the snapshots.

Where am I going wrong?

Thanks

|||Can you verify if the IUSR_xxx has access to the database by connecting to the server and using the database from an osql command?|||

I am getting the same error as this. When I go to the SQLCESA30.LOG file in the "C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Server\SqlMobileReplication" directory, the two entries that I get in the log are as follows:

2006/01/07 16:59:36 Hr=00000000 SQLCESA30.DLL loaded 0
2006/01/07 16:59:58 Hr=80004005 ERR:OpenDB failed getting pub version 28627

I'll start a new thread.

|||I've started a new thread at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=193693&SiteID=1 for "Hr=80004005 ERR:OpenDB failed getting pub version 28627"|||

JB,

Chris, who started the other thread (with the note above) has had very similar issue. He troubleshooted the problem and has been kind enough to post the analysis and the resolution in his thread. Please go through that thread and see if it helps your problem. From what I see the error messages are very much related.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=194640&SiteID=1&mode=1

|||

Hi

I have been Getting the Same Error unable to connect to Sql server or IIS configured properly

Any one who any help me in this regard.

How we would make sure that --> If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.

Rg Ad

|||I try use IIS 7, but its difficult than I though. When create publication under IIS 6 I just only add IUSR into login, then create publication and put IUSR into PAL, then subscription just work fine. But when use IIS 7 I follow the steps for IIS 6 then when try synchronize data it said that the IUSR is not valid SQL Server user, is the IIS 7 have another guest account so I can put it into login?

Thanks,

Problem creating Data-Driven Subscription

Using SS2005, I am trying to create a Data-Driven Subscription to query off a value. I have the value in my stored procedure like:

Procedure dbo.sp_ReportMaster @.myid int=null

When I run the report in the Reporting Services, it prompts for myid, which is fine. I then deployed the report to the Reports Manager and tried to create a Data-Driven Subscription. Where it says specify a command, I put in exec sp_ReportMaster. I put in the pertinent information, then it says, "The 'ReportMaster' has no parameters," even though I have the parameter in my stored procedure and I put myid as a parameter in my report in Reporting Services.

I don't know why it shows parameters in Reporting Services when I run the report from there, but when I try to create the subscription, it shows that I don't have any parameters.

Thanks, Iris

I figured out my problem.

Thanks, Iris

Problem Creating a subscription

I am trying to publish / subscribe a database onto SQL Server Mobile and when I run the following code that was, for the most part, generated by the SQL Server Management Studio Subscription Wizard,

repl.InternetUrl=@."file://chiefjoseph/walklisttransfersite/sqlcesa30.dll";

repl.InternetLogin = @."rr";

repl.InternetPassword = @."88";

repl.Publisher = @."CHIEFJOSEPH\SQLSERVER2005";

repl.PublisherDatabase = @."WalkList";

repl.PublisherSecurityMode = SecurityType.DBAuthentication;

repl.PublisherLogin = @."sx";

repl.PublisherPassword = @."xxx";

repl.Publication = @."WalkList";

repl.Subscriber = @."WalkListSubscription";

repl.SubscriberConnectionString = @."Data Source=""\My Documents\SQLServer\NewWalkList.sdf"";Password=""pwd"";Max Database Size=32;Default Lock Escalation =100;";

try

{

// repl.AddSubscription(AddOption.ExistingDatabase);

repl.AddSubscription(AddOption.ExistingDatabase);

repl.Synchronize();

}

catch (SqlCeException ex)

{

MessageBox.Show(ex.ToString());

}

I get the following error on the Pocket PC emulator

“A native exception has occurred in WalkLister.exe.Select Quit and then restart this program, or select Details for more information.”

When I try to use the subscription wizard to create the subscription, I get the following error:

Synchronizing Data (Error)

Messages

· Connection broken.
HRESULT 0x80004005 (0)

· The operation could not be completed.

Any insight to what the problem might be?

-Rob

I see a couple of odd things in your replication properties -

1. repl.InternetUrl=@.file://chiefjoseph/walklisttransfersite/sqlcesa30.dll

should be repl.InternetUrl = "http://chiefjoseph/walklisttransfersite/sqlcesa30.dll ";

2. the subscriber connection string should be

repl.SubscriberConnectionString = @."Data Source='\My Documents\SQLServer\NewWalkList.sdf';Password='pwd';Max Database Size=32;Default Lock Escalation =100";

I would recommend you start by using anonymous authentication (be sure to grant account IUSR_chiefjoseph permissions on your publication and the Walklist database if you do so) and then add SSL later. NT and DB authentication are a poor choice for merge replication because the userid and password are sent in the clear to the server.

-Darren

Problem connecting to SQL Server over the internet

I have opened ports 1433 and 1434 on a SQL Server on our network to allow
our customers to receive a monthly subscription "key" for the software they
lease from us. Within an encrypted Stored Procedure I am using the
OPENDATASOURCE method with a connect string containing our IP address. It is
working on 90% of the sites. However some of the sites are receiving an
error:
Server: Msg 17, Level 16, State 1, Procedure PLSPSYS_ALTER_KEYSP_REMOTE,
Line 37
SQL Server does not exist or access denied.
On most of the servers where the procedure is WORKING, a peek at the
firewall configuration using Shields-Up service from Gibson Research shows
that ports 1433 and 1434 are in Stealth mode. But, as I said, the connection
is still operating just fine. All sites, including the ones that don't work,
have the TCP/IP protocol enabled in the Client Network Utility on Port 1433.
So I am at a loss to figure out why the Internet connection is not working
at some sites. Any ideas?
Also, is there another way that I can distribute the "key" without user
intervention using "back-end" programs or procedures? Is there a way to
connect and retieve data via port 80 which is usually left open for outbound
requests? Thanks in advance...
I would make network traces at the problem site and either review the
firewall logs or
make simulataneous traces on the server. This sounds like a tcp issue not
a SQL issue.
Verify that the 3 way tcp handshake is completing. The login packet isn't
sent until this completes.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Thank you both for your replies. I will make sure that the TCP issues are
resolved at the client sites before looking any further.
"John Kotuby" <jkotuby@.snet.net> wrote in message
news:undiWF%23TEHA.2028@.TK2MSFTNGP11.phx.gbl...
> I have opened ports 1433 and 1434 on a SQL Server on our network to allow
> our customers to receive a monthly subscription "key" for the software
they
> lease from us. Within an encrypted Stored Procedure I am using the
> OPENDATASOURCE method with a connect string containing our IP address. It
is
> working on 90% of the sites. However some of the sites are receiving an
> error:
> Server: Msg 17, Level 16, State 1, Procedure PLSPSYS_ALTER_KEYSP_REMOTE,
> Line 37
> SQL Server does not exist or access denied.
> On most of the servers where the procedure is WORKING, a peek at the
> firewall configuration using Shields-Up service from Gibson Research shows
> that ports 1433 and 1434 are in Stealth mode. But, as I said, the
connection
> is still operating just fine. All sites, including the ones that don't
work,
> have the TCP/IP protocol enabled in the Client Network Utility on Port
1433.
> So I am at a loss to figure out why the Internet connection is not working
> at some sites. Any ideas?
> Also, is there another way that I can distribute the "key" without user
> intervention using "back-end" programs or procedures? Is there a way to
> connect and retieve data via port 80 which is usually left open for
outbound
> requests? Thanks in advance...
>

Problem connecting to SQL Server over the internet

I have opened ports 1433 and 1434 on a SQL Server on our network to allow
our customers to receive a monthly subscription "key" for the software they
lease from us. Within an encrypted Stored Procedure I am using the
OPENDATASOURCE method with a connect string containing our IP address. It is
working on 90% of the sites. However some of the sites are receiving an
error:
Server: Msg 17, Level 16, State 1, Procedure PLSPSYS_ALTER_KEYSP_REMOTE,
Line 37
SQL Server does not exist or access denied.
On most of the servers where the procedure is WORKING, a peek at the
firewall configuration using Shields-Up service from Gibson Research shows
that ports 1433 and 1434 are in Stealth mode. But, as I said, the connection
is still operating just fine. All sites, including the ones that don't work,
have the TCP/IP protocol enabled in the Client Network Utility on Port 1433.
So I am at a loss to figure out why the Internet connection is not working
at some sites. Any ideas?
Also, is there another way that I can distribute the "key" without user
intervention using "back-end" programs or procedures? Is there a way to
connect and retieve data via port 80 which is usually left open for outbound
requests? Thanks in advance...I would make network traces at the problem site and either review the
firewall logs or
make simulataneous traces on the server. This sounds like a tcp issue not
a SQL issue.
Verify that the 3 way tcp handshake is completing. The login packet isn't
sent until this completes.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thank you both for your replies. I will make sure that the TCP issues are
resolved at the client sites before looking any further.
"John Kotuby" <jkotuby@.snet.net> wrote in message
news:undiWF%23TEHA.2028@.TK2MSFTNGP11.phx.gbl...
> I have opened ports 1433 and 1434 on a SQL Server on our network to allow
> our customers to receive a monthly subscription "key" for the software
they
> lease from us. Within an encrypted Stored Procedure I am using the
> OPENDATASOURCE method with a connect string containing our IP address. It
is
> working on 90% of the sites. However some of the sites are receiving an
> error:
> Server: Msg 17, Level 16, State 1, Procedure PLSPSYS_ALTER_KEYSP_REMOTE,
> Line 37
> SQL Server does not exist or access denied.
> On most of the servers where the procedure is WORKING, a peek at the
> firewall configuration using Shields-Up service from Gibson Research shows
> that ports 1433 and 1434 are in Stealth mode. But, as I said, the
connection
> is still operating just fine. All sites, including the ones that don't
work,
> have the TCP/IP protocol enabled in the Client Network Utility on Port
1433.
> So I am at a loss to figure out why the Internet connection is not working
> at some sites. Any ideas?
> Also, is there another way that I can distribute the "key" without user
> intervention using "back-end" programs or procedures? Is there a way to
> connect and retieve data via port 80 which is usually left open for
outbound
> requests? Thanks in advance...
>