I have a database thats got sql as the engine and access 2000 for the client side.Now my problem is every time I edit a record this "Write Conflict" comes up. I did some investigating and I found out its due to a REPLICATIONCONFLICT ERROR.
Can anyone help me plsIs your Access FE running against a database that participates in merge replication? You need to have a serious talk with your DBA about whether you should be developing any app using a db that is already part of another app.|||the only application involved is access 2000, and the network techs are the dba|||what do you mean pls explain FE??sql
Showing posts with label access. Show all posts
Showing posts with label access. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
Replication Disrupting Other Access
We have setup merge replication on a production server/database that
is also used for our web applications. We need the replication for
disconnected computing using an MSDE database. The replication works
exceptionally well, however, we had to publish ID ranges on the tables
so that data could be merged with the server correctly. This has
caused a problem with our web based applications. Once the end of the
ID range is reached, our other applications cannot insert data into
the tables without resetting the ranges or removing replication.
Has anyone else seen this problem? If so, is there a good work-around
to allow both entities to co-exist using the same database? We would
like to avoid adding a significant amount of code/scripts to manage
this automatically. Would we be better off to use a snapshot method
of replication and insert data directly from that?
Thanks for any suggestions you may have.
Dan Broomall
Dan,
there are 2 ways I can think of:
you can use large ranges - so large in fact that no new ranges are required,
or you can select to manually manage the ranges and select a simple
algorithm that ensures there is never any overlap between publisher and
subscriber(s). EG if you have a publisher and a single subscriber, the
publisher could have a seed of 1 and increment of 2 while the subscriber has
a seed of 2 and increment of 2 - the publisher has odd identity values and
the subscriber evens.
HTH,
Paul Ibison
is also used for our web applications. We need the replication for
disconnected computing using an MSDE database. The replication works
exceptionally well, however, we had to publish ID ranges on the tables
so that data could be merged with the server correctly. This has
caused a problem with our web based applications. Once the end of the
ID range is reached, our other applications cannot insert data into
the tables without resetting the ranges or removing replication.
Has anyone else seen this problem? If so, is there a good work-around
to allow both entities to co-exist using the same database? We would
like to avoid adding a significant amount of code/scripts to manage
this automatically. Would we be better off to use a snapshot method
of replication and insert data directly from that?
Thanks for any suggestions you may have.
Dan Broomall
Dan,
there are 2 ways I can think of:
you can use large ranges - so large in fact that no new ranges are required,
or you can select to manually manage the ranges and select a simple
algorithm that ensures there is never any overlap between publisher and
subscriber(s). EG if you have a publisher and a single subscriber, the
publisher could have a seed of 1 and increment of 2 while the subscriber has
a seed of 2 and increment of 2 - the publisher has odd identity values and
the subscriber evens.
HTH,
Paul Ibison
Friday, March 23, 2012
Replication concept
Hi,
I got a new application with Access front end and sql server back-end. This
application has replication features where users can directly upload their
changes on the main server. I have no knowledge about replication. However, I
need to maintain this sytem. Is there any article or book that will help me
achieve this? Please let me know. Thanks in advance.
Are you sure that this is being replicated? If users are sending their access
changes to sql server, it sounds like this might be the way that the Access
application is designed, and not SQL Server replication. If it is somehow SQL
Server Replication, then there are 2 books out there (see
www.replicationanswers.com for links on homepage) and books on line (BOL).
Cheers,
Paul Ibison
|||Thanks Paul for your advise. I appreciate it.
Best Regards,
"Paul Ibison" wrote:
> Are you sure that this is being replicated? If users are sending their access
> changes to sql server, it sounds like this might be the way that the Access
> application is designed, and not SQL Server replication. If it is somehow SQL
> Server Replication, then there are 2 books out there (see
> www.replicationanswers.com for links on homepage) and books on line (BOL).
> Cheers,
> Paul Ibison
>
|||Hope the books help, but I'd check first of all verify that you do have
replication occurring. It's possible that heterogenous subscribers have been
configured so your Access database is a subscriber to a SQL Server publisher,
and the uploading of changes in Access is a triggering of the synchronization
process (starting the ActiveX control to merge a pull subscription). Having a
look at the SQL Server box should show if this is the case and if so, looking
for heterogenous subscribers in BOL should help.
Paul Ibison
|||I would check to see if they have linked tables or if they have code in the
access project to write to SQL Server.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:2F158A54-ACE0-4C5B-913E-AD13C89DEF19@.microsoft.com...
> Hi,
> I got a new application with Access front end and sql server back-end.
> This
> application has replication features where users can directly upload their
> changes on the main server. I have no knowledge about replication.
> However, I
> need to maintain this sytem. Is there any article or book that will help
> me
> achieve this? Please let me know. Thanks in advance.
>
I got a new application with Access front end and sql server back-end. This
application has replication features where users can directly upload their
changes on the main server. I have no knowledge about replication. However, I
need to maintain this sytem. Is there any article or book that will help me
achieve this? Please let me know. Thanks in advance.
Are you sure that this is being replicated? If users are sending their access
changes to sql server, it sounds like this might be the way that the Access
application is designed, and not SQL Server replication. If it is somehow SQL
Server Replication, then there are 2 books out there (see
www.replicationanswers.com for links on homepage) and books on line (BOL).
Cheers,
Paul Ibison
|||Thanks Paul for your advise. I appreciate it.
Best Regards,
"Paul Ibison" wrote:
> Are you sure that this is being replicated? If users are sending their access
> changes to sql server, it sounds like this might be the way that the Access
> application is designed, and not SQL Server replication. If it is somehow SQL
> Server Replication, then there are 2 books out there (see
> www.replicationanswers.com for links on homepage) and books on line (BOL).
> Cheers,
> Paul Ibison
>
|||Hope the books help, but I'd check first of all verify that you do have
replication occurring. It's possible that heterogenous subscribers have been
configured so your Access database is a subscriber to a SQL Server publisher,
and the uploading of changes in Access is a triggering of the synchronization
process (starting the ActiveX control to merge a pull subscription). Having a
look at the SQL Server box should show if this is the case and if so, looking
for heterogenous subscribers in BOL should help.
Paul Ibison
|||I would check to see if they have linked tables or if they have code in the
access project to write to SQL Server.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:2F158A54-ACE0-4C5B-913E-AD13C89DEF19@.microsoft.com...
> Hi,
> I got a new application with Access front end and sql server back-end.
> This
> application has replication features where users can directly upload their
> changes on the main server. I have no knowledge about replication.
> However, I
> need to maintain this sytem. Is there any article or book that will help
> me
> achieve this? Please let me know. Thanks in advance.
>
Replication between two servers without db_owner
Hello there
I have destination database which i'm not db_owner on it but guest
The user i'm using to access between two servers is:
1. Source is connected by linked server to destination
2. on the destination none of the servers roles are active for the user i'm
trying to access
3. the user has only access to one of my databases whith permittion of:
db_public, db_ddladmin
, db_datareader, db_datawriter
What else i need to use replication between two sides?
You'll need rights to create tables. There are two system tables which are
necessary and you should be able to precreate these using an account in the
ddl_admin role.
This is a push subscription right? What version of SQL Server is running on
the publisher and subscriber?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:uu6vAScGGHA.3864@.tk2msftngp13.phx.gbl...
> Hello there
> I have destination database which i'm not db_owner on it but guest
> The user i'm using to access between two servers is:
> 1. Source is connected by linked server to destination
> 2. on the destination none of the servers roles are active for the user
> i'm trying to access
> 3. the user has only access to one of my databases whith permittion of:
> db_public, db_ddladmin
> , db_datareader, db_datawriter
> What else i need to use replication between two sides?
>
|||Thankes Hilary.
Now the replication succedded on the other side. In fact it gave me db_owner
to do that.
The problem now is that it create new tables what replicated with the
username owner that i used to access the subscriber, instead of entering the
data to my existing databses with dbo owners.
How can i cause the subscriber to transfare data to the original tables with
dbo owners?
' 03-5611606
' 050-7709399
: roy@.atidsm.co.il
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:e$6nsyfGGHA.1180@.TK2MSFTNGP09.phx.gbl...
> You'll need rights to create tables. There are two system tables which are
> necessary and you should be able to precreate these using an account in
> the ddl_admin role.
> This is a push subscription right? What version of SQL Server is running
> on the publisher and subscriber?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:uu6vAScGGHA.3864@.tk2msftngp13.phx.gbl...
>
|||Right click on your publication and select properties, click on the articles
tab, and select the browse button to the right of each table, in the general
tab, specify destination table owner name to be dbo.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23xLlJkCHGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Thankes Hilary.
> Now the replication succedded on the other side. In fact it gave me
> db_owner to do that.
> The problem now is that it create new tables what replicated with the
> username owner that i used to access the subscriber, instead of entering
> the data to my existing databses with dbo owners.
> How can i cause the subscriber to transfare data to the original tables
> with dbo owners?
> --
>
> ' 03-5611606
> ' 050-7709399
> : roy@.atidsm.co.il
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:e$6nsyfGGHA.1180@.TK2MSFTNGP09.phx.gbl...
>
|||Thankes A lot hilary
' 03-5611606
' 050-7709399
: roy@.atidsm.co.il
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u6j6N8EHGHA.2300@.TK2MSFTNGP15.phx.gbl...
> Right click on your publication and select properties, click on the
> articles tab, and select the browse button to the right of each table, in
> the general tab, specify destination table owner name to be dbo.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:%23xLlJkCHGHA.1032@.TK2MSFTNGP11.phx.gbl...
>
I have destination database which i'm not db_owner on it but guest
The user i'm using to access between two servers is:
1. Source is connected by linked server to destination
2. on the destination none of the servers roles are active for the user i'm
trying to access
3. the user has only access to one of my databases whith permittion of:
db_public, db_ddladmin
, db_datareader, db_datawriter
What else i need to use replication between two sides?
You'll need rights to create tables. There are two system tables which are
necessary and you should be able to precreate these using an account in the
ddl_admin role.
This is a push subscription right? What version of SQL Server is running on
the publisher and subscriber?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:uu6vAScGGHA.3864@.tk2msftngp13.phx.gbl...
> Hello there
> I have destination database which i'm not db_owner on it but guest
> The user i'm using to access between two servers is:
> 1. Source is connected by linked server to destination
> 2. on the destination none of the servers roles are active for the user
> i'm trying to access
> 3. the user has only access to one of my databases whith permittion of:
> db_public, db_ddladmin
> , db_datareader, db_datawriter
> What else i need to use replication between two sides?
>
|||Thankes Hilary.
Now the replication succedded on the other side. In fact it gave me db_owner
to do that.
The problem now is that it create new tables what replicated with the
username owner that i used to access the subscriber, instead of entering the
data to my existing databses with dbo owners.
How can i cause the subscriber to transfare data to the original tables with
dbo owners?
' 03-5611606
' 050-7709399
: roy@.atidsm.co.il
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:e$6nsyfGGHA.1180@.TK2MSFTNGP09.phx.gbl...
> You'll need rights to create tables. There are two system tables which are
> necessary and you should be able to precreate these using an account in
> the ddl_admin role.
> This is a push subscription right? What version of SQL Server is running
> on the publisher and subscriber?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:uu6vAScGGHA.3864@.tk2msftngp13.phx.gbl...
>
|||Right click on your publication and select properties, click on the articles
tab, and select the browse button to the right of each table, in the general
tab, specify destination table owner name to be dbo.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23xLlJkCHGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Thankes Hilary.
> Now the replication succedded on the other side. In fact it gave me
> db_owner to do that.
> The problem now is that it create new tables what replicated with the
> username owner that i used to access the subscriber, instead of entering
> the data to my existing databses with dbo owners.
> How can i cause the subscriber to transfare data to the original tables
> with dbo owners?
> --
>
> ' 03-5611606
> ' 050-7709399
> : roy@.atidsm.co.il
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:e$6nsyfGGHA.1180@.TK2MSFTNGP09.phx.gbl...
>
|||Thankes A lot hilary
' 03-5611606
' 050-7709399
: roy@.atidsm.co.il
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u6j6N8EHGHA.2300@.TK2MSFTNGP15.phx.gbl...
> Right click on your publication and select properties, click on the
> articles tab, and select the browse button to the right of each table, in
> the general tab, specify destination table owner name to be dbo.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:%23xLlJkCHGHA.1032@.TK2MSFTNGP11.phx.gbl...
>
Replication between SQL and Access97?
I have an Access 97 database that I would like to "mirror" in my SQL server 2000 database.
Basically I would like SQL server to keep a current copy of an Access 97 database table which exists on remote machine on our network. Any time there is a change made to the Access table, I would like the SQL server to be updated automatically.
Is this something that is possible to do with replication/synchronization, or do I have to push the data up with another app?
ThanksTo my knowledge you can not set up relication from Access to SQL Server. Are you sure your tables are in Access? Or are you using an Access Data Project or tables linked into a mdb file?
If your tables are truly located locally in your access database the only way I can think of doing what you want to do is to link in your SQL Server tables and for every insert, update and delete you run the same queries against the SQL tables at the same time.
Why not just move your tables in your access application to SQL Server?|||The tables are definately in an Access 97.
I thought about moving the tables into the SQL database but I really need a copy locally in the event of a network failure. (The app which generates the data and fills the tables runs on the machine remote to the SQL database.)
Thanks for your suggestions.|||move the tables to sql. and then you can have DTS packages that push them down to your local access app.
Is'nt your SQL Server running backups on itself anyways?|||Depending on why you want to do this, you could
1)put a copy of sql server on the remote server and then use those tables in your access app. Replication to the other server is then easy if you still want this.
2)use dts packages to copy the data into your sql server tables using a scheduled job.
3)use heterogenous transactional replication but it looks a little complicated at first sight and I know nothing of the implications and practicality of implementing this type of replication|||I clearly need to bone this. I did find some info in the SQL Server Books Online under "Access Subscribers" which looks promising.
I believe this is item 3 refered to in the previous post.
Thanks for your help.sql
Basically I would like SQL server to keep a current copy of an Access 97 database table which exists on remote machine on our network. Any time there is a change made to the Access table, I would like the SQL server to be updated automatically.
Is this something that is possible to do with replication/synchronization, or do I have to push the data up with another app?
ThanksTo my knowledge you can not set up relication from Access to SQL Server. Are you sure your tables are in Access? Or are you using an Access Data Project or tables linked into a mdb file?
If your tables are truly located locally in your access database the only way I can think of doing what you want to do is to link in your SQL Server tables and for every insert, update and delete you run the same queries against the SQL tables at the same time.
Why not just move your tables in your access application to SQL Server?|||The tables are definately in an Access 97.
I thought about moving the tables into the SQL database but I really need a copy locally in the event of a network failure. (The app which generates the data and fills the tables runs on the machine remote to the SQL database.)
Thanks for your suggestions.|||move the tables to sql. and then you can have DTS packages that push them down to your local access app.
Is'nt your SQL Server running backups on itself anyways?|||Depending on why you want to do this, you could
1)put a copy of sql server on the remote server and then use those tables in your access app. Replication to the other server is then easy if you still want this.
2)use dts packages to copy the data into your sql server tables using a scheduled job.
3)use heterogenous transactional replication but it looks a little complicated at first sight and I know nothing of the implications and practicality of implementing this type of replication|||I clearly need to bone this. I did find some info in the SQL Server Books Online under "Access Subscribers" which looks promising.
I believe this is item 3 refered to in the previous post.
Thanks for your help.sql
Wednesday, March 21, 2012
replication between MS Access and SQL Server
Does anyone know the correct procedure to setup a pull relationship from MS Access to a SQL database and vice versa?http://vyaskn.tripod.com/repl_ans5.htm#sqljetsub for information.
And refer to books online
And refer to books online
Replication Between Different Versions of SQL Server causes access denied error.
I am getting the following error:
SQL Server does not exist or access denied. Error number 17.
The publication and distributor is SQL Server 7.0 from internal lan.
The subscriber is SQL Server 2000 from external wan outside of the firewall.
Using SQL Server Enterprise Manager 7.0 on the publication server will not
allow me to register the subscriber as it says "You must upgrade your SQL
Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000(SQLDMO) to
connecti to this server". But if I use a non participanting SQL Server
Enterprise Manager 2000 within the internal lan it will allow me to register
and connect to the browser and I am able to view the database and its
tables.
In addition I can connect to the subscriber using Query Analyzer in version
7.0.
According to the MSDN under the section Replication Between Different
Versions of SQL Server, I fit the same criteria as Combination 2 for
snapshot replication ie. Publisher SQL Server 7.0/Distributor SQL Server
7.0/Subscriber SQL Server 2000.
So why does the push subscription fail?
Regards
Peter
Hello Peter,
This is expected behavior when trying to access SQL Server 2000 from SQL
7.0 version of SQL DMO. You will be able to connect to SQL Server 2000 from
SQL 7.0 version of Query Analyzer, but not Enterprise Manager. The
resolution is to upgrade the client tools to SQL 2000.
Also, as you have mentioned, you could use a SQL 2000 Eneterprise Manager
on a different server to work around this issue.
Combination 2 you referred to does not indicate that you could configure
this in SQL 7 Enterprise Manager. Since it is from SQL 2000 BOL, actually
you could only configure this from a SQL 2000 Enterprise Manager.
Hope this helps.
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default...national.aspx.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Peter Lapic" <plapic@.shop-a-docket.com.au>
>Subject: Replication Between Different Versions of SQL Server causes
access denied error.
>Date: Mon, 31 Oct 2005 16:30:49 +1000
>Lines: 32
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <u130mSe3FHA.3136@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: 61.88.17.230
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:17479
>X-Tomcat-NG: microsoft.public.sqlserver.replication
>I am getting the following error:
>SQL Server does not exist or access denied. Error number 17.
>The publication and distributor is SQL Server 7.0 from internal lan.
>The subscriber is SQL Server 2000 from external wan outside of the
firewall.
>Using SQL Server Enterprise Manager 7.0 on the publication server will not
>allow me to register the subscriber as it says "You must upgrade your SQL
>Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000(SQLDMO) to
>connecti to this server". But if I use a non participanting SQL Server
>Enterprise Manager 2000 within the internal lan it will allow me to
register
>and connect to the browser and I am able to view the database and its
>tables.
>In addition I can connect to the subscriber using Query Analyzer in
version
>7.0.
>According to the MSDN under the section Replication Between Different
>Versions of SQL Server, I fit the same criteria as Combination 2 for
>snapshot replication ie. Publisher SQL Server 7.0/Distributor SQL Server
>7.0/Subscriber SQL Server 2000.
>So why does the push subscription fail?
>Regards
>Peter
>
>
>
>
|||I have created the publication on SQL Server 7.0 server via SQL Server 2000
Enterprise and created a push subscription. As soon as the snapshoot was
ready to send I get the same error "The process could not connect to
Subscriber" (SQL Server does not exist or access denied. Error number: 17)
even though I could setup the subscriber and select the destination
database.
Regards
Peter
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:exdZMBf3FHA.3220@.TK2MSFTNGXA01.phx.gbl...
> Hello Peter,
> This is expected behavior when trying to access SQL Server 2000 from SQL
> 7.0 version of SQL DMO. You will be able to connect to SQL Server 2000
> from
> SQL 7.0 version of Query Analyzer, but not Enterprise Manager. The
> resolution is to upgrade the client tools to SQL 2000.
> Also, as you have mentioned, you could use a SQL 2000 Eneterprise Manager
> on a different server to work around this issue.
> Combination 2 you referred to does not indicate that you could configure
> this in SQL 7 Enterprise Manager. Since it is from SQL 2000 BOL, actually
> you could only configure this from a SQL 2000 Enterprise Manager.
> Hope this helps.
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/tec...rview/40010469
> Others: https://partner.microsoft.com/US/tec...pportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default...national.aspx.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
> access denied error.
> firewall.
> register
> version
>
|||Hello Peter,
This seems to be a MDAC issue. I suggest that you install latest MDAC 2.8
SP1 if it is on Win2000 server.
899456 Release manifest for MDAC 2.8 Service Pack 1 (2.81.1117.6)
http://support.microsoft.com/?id=899456
Also, please use SQL client network utility to make sure TCPIP and named
pipes are enabled. Also, you may want to create an Alais for SQL 2000
(subscriber) to test the situation.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Peter Lapic" <plapic@.shop-a-docket.com.au>
>References: <u130mSe3FHA.3136@.TK2MSFTNGP09.phx.gbl>
<exdZMBf3FHA.3220@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Replication Between Different Versions of SQL Server causes
access denied error.
>Date: Tue, 1 Nov 2005 10:09:26 +1000
>Lines: 117
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <uaV8Pin3FHA.700@.TK2MSFTNGP15.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: 61.88.17.230
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP15.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:17507
>X-Tomcat-NG: microsoft.public.sqlserver.replication
>I have created the publication on SQL Server 7.0 server via SQL Server
2000[vbcol=seagreen]
>Enterprise and created a push subscription. As soon as the snapshoot was
>ready to send I get the same error "The process could not connect to
>Subscriber" (SQL Server does not exist or access denied. Error number: 17)
>even though I could setup the subscriber and select the destination
>database.
>Regards
>Peter
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:exdZMBf3FHA.3220@.TK2MSFTNGXA01.phx.gbl...
all[vbcol=seagreen]
https://partner.microsoft.com/US/tec...rview/40010469[vbcol=seagreen]
https://partner.microsoft.com/US/tec...pportoverview/[vbcol=seagreen]
not
>
>
|||The penny dropped!
Whilst I did configure SQL client network on my development pc to browse the
external database I didn't realise I had to configure it again on the
distributor server. The replication wizard sort of misled me as part of it
process what to nonimate the subscriber which it found on my development pc
whereas it should have failed it the distributor couldn't recognise it.
Regards
Peter
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:bCGcbYo3FHA.2984@.TK2MSFTNGXA01.phx.gbl...
> Hello Peter,
> This seems to be a MDAC issue. I suggest that you install latest MDAC 2.8
> SP1 if it is on Win2000 server.
> 899456 Release manifest for MDAC 2.8 Service Pack 1 (2.81.1117.6)
> http://support.microsoft.com/?id=899456
> Also, please use SQL client network utility to make sure TCPIP and named
> pipes are enabled. Also, you may want to create an Alais for SQL 2000
> (subscriber) to test the situation.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
> <exdZMBf3FHA.3220@.TK2MSFTNGXA01.phx.gbl>
> access denied error.
> 2000
> all
> https://partner.microsoft.com/US/tec...rview/40010469
> https://partner.microsoft.com/US/tec...pportoverview/
> not
>
|||Hello Peter,
Glad to hear the issue is resolved. :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Peter Lapic" <plapic@.shop-a-docket.com.au>
| References: <u130mSe3FHA.3136@.TK2MSFTNGP09.phx.gbl>
<exdZMBf3FHA.3220@.TK2MSFTNGXA01.phx.gbl>
<uaV8Pin3FHA.700@.TK2MSFTNGP15.phx.gbl>
<bCGcbYo3FHA.2984@.TK2MSFTNGXA01.phx.gbl>
| Subject: Re: Replication Between Different Versions of SQL Server causes
access denied error.
| Date: Thu, 3 Nov 2005 10:00:07 +1000
| Lines: 190
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <Ow70RmA4FHA.3540@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.replication
| NNTP-Posting-Host: 61.88.17.230
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP10.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:17574
| X-Tomcat-NG: microsoft.public.sqlserver.replication
|
| The penny dropped!
| Whilst I did configure SQL client network on my development pc to browse
the
| external database I didn't realise I had to configure it again on the
| distributor server. The replication wizard sort of misled me as part of
it
| process what to nonimate the subscriber which it found on my development
pc
| whereas it should have failed it the distributor couldn't recognise it.
|
| Regards
| Peter
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:bCGcbYo3FHA.2984@.TK2MSFTNGXA01.phx.gbl...
| > Hello Peter,
| >
| > This seems to be a MDAC issue. I suggest that you install latest MDAC
2.8
| > SP1 if it is on Win2000 server.
| >
| > 899456 Release manifest for MDAC 2.8 Service Pack 1 (2.81.1117.6)
| > http://support.microsoft.com/?id=899456
| >
| > Also, please use SQL client network utility to make sure TCPIP and named
| > pipes are enabled. Also, you may want to create an Alais for SQL 2000
| > (subscriber) to test the situation.
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader so
| > that others may learn and benefit from your issue.
| >
| > ================================================== ===
| >
| >
| >
| > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| >
| >
| > --
| >>From: "Peter Lapic" <plapic@.shop-a-docket.com.au>
| >>References: <u130mSe3FHA.3136@.TK2MSFTNGP09.phx.gbl>
| > <exdZMBf3FHA.3220@.TK2MSFTNGXA01.phx.gbl>
| >>Subject: Re: Replication Between Different Versions of SQL Server causes
| > access denied error.
| >>Date: Tue, 1 Nov 2005 10:09:26 +1000
| >>Lines: 117
| >>X-Priority: 3
| >>X-MSMail-Priority: Normal
| >>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| >>X-RFC2646: Format=Flowed; Original
| >>Message-ID: <uaV8Pin3FHA.700@.TK2MSFTNGP15.phx.gbl>
| >>Newsgroups: microsoft.public.sqlserver.replication
| >>NNTP-Posting-Host: 61.88.17.230
| >>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP15.phx.gbl
| >>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:17507
| >>X-Tomcat-NG: microsoft.public.sqlserver.replication
| >>
| >>I have created the publication on SQL Server 7.0 server via SQL Server
| > 2000
| >>Enterprise and created a push subscription. As soon as the snapshoot was
| >>ready to send I get the same error "The process could not connect to
| >>Subscriber" (SQL Server does not exist or access denied. Error number:
17)
| >>even though I could setup the subscriber and select the destination
| >>database.
| >>
| >>Regards
| >>Peter
| >>
| >>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| >>news:exdZMBf3FHA.3220@.TK2MSFTNGXA01.phx.gbl...
| >>> Hello Peter,
| >>>
| >>> This is expected behavior when trying to access SQL Server 2000 from
SQL
| >>> 7.0 version of SQL DMO. You will be able to connect to SQL Server 2000
| >>> from
| >>> SQL 7.0 version of Query Analyzer, but not Enterprise Manager. The
| >>> resolution is to upgrade the client tools to SQL 2000.
| >>>
| >>> Also, as you have mentioned, you could use a SQL 2000 Eneterprise
| >>> Manager
| >>> on a different server to work around this issue.
| >>>
| >>> Combination 2 you referred to does not indicate that you could
configure
| >>> this in SQL 7 Enterprise Manager. Since it is from SQL 2000 BOL,
| >>> actually
| >>> you could only configure this from a SQL 2000 Enterprise Manager.
| >>>
| >>> Hope this helps.
| >>>
| >>> Peter Yang
| >>> MCSE2000/2003, MCSA, MCDBA
| >>> Microsoft Online Partner Support
| >>>
| >>> When responding to posts, please "Reply to Group" via your newsreader
so
| >>> that others may learn and benefit from your issue.
| >>>
| >>> ================================================== ===
| >>>
| >>> Business-Critical Phone Support (BCPS) provides you with technical
phone
| >>> support at no charge during critical LAN outages or "business down"
| >>> situations. This benefit is available 24 hours a day, 7 days a week to
| > all
| >>> Microsoft technology partners in the United States and Canada.
| >>>
| >>> This and other support options are available here:
| >>>
| >>> BCPS:
| >>>
| >
https://partner.microsoft.com/US/tec...rview/40010469
| >>>
| >>> Others:
| > https://partner.microsoft.com/US/tec...pportoverview/
| >>>
| >>> If you are outside the United States, please visit our International
| >>> Support page:
| >>> http://support.microsoft.com/default...national.aspx.
| >>>
| >>> ================================================== ===
| >>>
| >>> This posting is provided "AS IS" with no warranties, and confers no
| >>> rights.
| >>>
| >>>
| >>> --
| >>>>From: "Peter Lapic" <plapic@.shop-a-docket.com.au>
| >>>>Subject: Replication Between Different Versions of SQL Server causes
| >>> access denied error.
| >>>>Date: Mon, 31 Oct 2005 16:30:49 +1000
| >>>>Lines: 32
| >>>>X-Priority: 3
| >>>>X-MSMail-Priority: Normal
| >>>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| >>>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| >>>>X-RFC2646: Format=Flowed; Original
| >>>>Message-ID: <u130mSe3FHA.3136@.TK2MSFTNGP09.phx.gbl>
| >>>>Newsgroups: microsoft.public.sqlserver.replication
| >>>>NNTP-Posting-Host: 61.88.17.230
| >>>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP09.phx.gbl
| >>>>Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.replication:17479
| >>>>X-Tomcat-NG: microsoft.public.sqlserver.replication
| >>>>
| >>>>I am getting the following error:
| >>>>SQL Server does not exist or access denied. Error number 17.
| >>>>
| >>>>The publication and distributor is SQL Server 7.0 from internal lan.
| >>>>The subscriber is SQL Server 2000 from external wan outside of the
| >>> firewall.
| >>>>
| >>>>Using SQL Server Enterprise Manager 7.0 on the publication server will
| > not
| >>>>allow me to register the subscriber as it says "You must upgrade your
| >>>>SQL
| >>>>Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000(SQLDMO) to
| >>>>connecti to this server". But if I use a non participanting SQL Server
| >>>>Enterprise Manager 2000 within the internal lan it will allow me to
| >>> register
| >>>>and connect to the browser and I am able to view the database and its
| >>>>tables.
| >>>>
| >>>>In addition I can connect to the subscriber using Query Analyzer in
| >>> version
| >>>>7.0.
| >>>>
| >>>>According to the MSDN under the section Replication Between Different
| >>>>Versions of SQL Server, I fit the same criteria as Combination 2 for
| >>>>snapshot replication ie. Publisher SQL Server 7.0/Distributor SQL
Server
| >>>>7.0/Subscriber SQL Server 2000.
| >>>>
| >>>>So why does the push subscription fail?
| >>>>
| >>>>Regards
| >>>>Peter
| >>>>
| >>>>
| >>>>
| >>>>
| >>>>
| >>>>
| >>>>
| >>>
| >>
| >>
| >>
| >
|
|
|
SQL Server does not exist or access denied. Error number 17.
The publication and distributor is SQL Server 7.0 from internal lan.
The subscriber is SQL Server 2000 from external wan outside of the firewall.
Using SQL Server Enterprise Manager 7.0 on the publication server will not
allow me to register the subscriber as it says "You must upgrade your SQL
Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000(SQLDMO) to
connecti to this server". But if I use a non participanting SQL Server
Enterprise Manager 2000 within the internal lan it will allow me to register
and connect to the browser and I am able to view the database and its
tables.
In addition I can connect to the subscriber using Query Analyzer in version
7.0.
According to the MSDN under the section Replication Between Different
Versions of SQL Server, I fit the same criteria as Combination 2 for
snapshot replication ie. Publisher SQL Server 7.0/Distributor SQL Server
7.0/Subscriber SQL Server 2000.
So why does the push subscription fail?
Regards
Peter
Hello Peter,
This is expected behavior when trying to access SQL Server 2000 from SQL
7.0 version of SQL DMO. You will be able to connect to SQL Server 2000 from
SQL 7.0 version of Query Analyzer, but not Enterprise Manager. The
resolution is to upgrade the client tools to SQL 2000.
Also, as you have mentioned, you could use a SQL 2000 Eneterprise Manager
on a different server to work around this issue.
Combination 2 you referred to does not indicate that you could configure
this in SQL 7 Enterprise Manager. Since it is from SQL 2000 BOL, actually
you could only configure this from a SQL 2000 Enterprise Manager.
Hope this helps.
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default...national.aspx.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Peter Lapic" <plapic@.shop-a-docket.com.au>
>Subject: Replication Between Different Versions of SQL Server causes
access denied error.
>Date: Mon, 31 Oct 2005 16:30:49 +1000
>Lines: 32
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <u130mSe3FHA.3136@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: 61.88.17.230
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:17479
>X-Tomcat-NG: microsoft.public.sqlserver.replication
>I am getting the following error:
>SQL Server does not exist or access denied. Error number 17.
>The publication and distributor is SQL Server 7.0 from internal lan.
>The subscriber is SQL Server 2000 from external wan outside of the
firewall.
>Using SQL Server Enterprise Manager 7.0 on the publication server will not
>allow me to register the subscriber as it says "You must upgrade your SQL
>Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000(SQLDMO) to
>connecti to this server". But if I use a non participanting SQL Server
>Enterprise Manager 2000 within the internal lan it will allow me to
register
>and connect to the browser and I am able to view the database and its
>tables.
>In addition I can connect to the subscriber using Query Analyzer in
version
>7.0.
>According to the MSDN under the section Replication Between Different
>Versions of SQL Server, I fit the same criteria as Combination 2 for
>snapshot replication ie. Publisher SQL Server 7.0/Distributor SQL Server
>7.0/Subscriber SQL Server 2000.
>So why does the push subscription fail?
>Regards
>Peter
>
>
>
>
|||I have created the publication on SQL Server 7.0 server via SQL Server 2000
Enterprise and created a push subscription. As soon as the snapshoot was
ready to send I get the same error "The process could not connect to
Subscriber" (SQL Server does not exist or access denied. Error number: 17)
even though I could setup the subscriber and select the destination
database.
Regards
Peter
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:exdZMBf3FHA.3220@.TK2MSFTNGXA01.phx.gbl...
> Hello Peter,
> This is expected behavior when trying to access SQL Server 2000 from SQL
> 7.0 version of SQL DMO. You will be able to connect to SQL Server 2000
> from
> SQL 7.0 version of Query Analyzer, but not Enterprise Manager. The
> resolution is to upgrade the client tools to SQL 2000.
> Also, as you have mentioned, you could use a SQL 2000 Eneterprise Manager
> on a different server to work around this issue.
> Combination 2 you referred to does not indicate that you could configure
> this in SQL 7 Enterprise Manager. Since it is from SQL 2000 BOL, actually
> you could only configure this from a SQL 2000 Enterprise Manager.
> Hope this helps.
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/tec...rview/40010469
> Others: https://partner.microsoft.com/US/tec...pportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default...national.aspx.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
> access denied error.
> firewall.
> register
> version
>
|||Hello Peter,
This seems to be a MDAC issue. I suggest that you install latest MDAC 2.8
SP1 if it is on Win2000 server.
899456 Release manifest for MDAC 2.8 Service Pack 1 (2.81.1117.6)
http://support.microsoft.com/?id=899456
Also, please use SQL client network utility to make sure TCPIP and named
pipes are enabled. Also, you may want to create an Alais for SQL 2000
(subscriber) to test the situation.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Peter Lapic" <plapic@.shop-a-docket.com.au>
>References: <u130mSe3FHA.3136@.TK2MSFTNGP09.phx.gbl>
<exdZMBf3FHA.3220@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Replication Between Different Versions of SQL Server causes
access denied error.
>Date: Tue, 1 Nov 2005 10:09:26 +1000
>Lines: 117
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <uaV8Pin3FHA.700@.TK2MSFTNGP15.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: 61.88.17.230
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP15.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:17507
>X-Tomcat-NG: microsoft.public.sqlserver.replication
>I have created the publication on SQL Server 7.0 server via SQL Server
2000[vbcol=seagreen]
>Enterprise and created a push subscription. As soon as the snapshoot was
>ready to send I get the same error "The process could not connect to
>Subscriber" (SQL Server does not exist or access denied. Error number: 17)
>even though I could setup the subscriber and select the destination
>database.
>Regards
>Peter
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:exdZMBf3FHA.3220@.TK2MSFTNGXA01.phx.gbl...
all[vbcol=seagreen]
https://partner.microsoft.com/US/tec...rview/40010469[vbcol=seagreen]
https://partner.microsoft.com/US/tec...pportoverview/[vbcol=seagreen]
not
>
>
|||The penny dropped!
Whilst I did configure SQL client network on my development pc to browse the
external database I didn't realise I had to configure it again on the
distributor server. The replication wizard sort of misled me as part of it
process what to nonimate the subscriber which it found on my development pc
whereas it should have failed it the distributor couldn't recognise it.
Regards
Peter
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:bCGcbYo3FHA.2984@.TK2MSFTNGXA01.phx.gbl...
> Hello Peter,
> This seems to be a MDAC issue. I suggest that you install latest MDAC 2.8
> SP1 if it is on Win2000 server.
> 899456 Release manifest for MDAC 2.8 Service Pack 1 (2.81.1117.6)
> http://support.microsoft.com/?id=899456
> Also, please use SQL client network utility to make sure TCPIP and named
> pipes are enabled. Also, you may want to create an Alais for SQL 2000
> (subscriber) to test the situation.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
> <exdZMBf3FHA.3220@.TK2MSFTNGXA01.phx.gbl>
> access denied error.
> 2000
> all
> https://partner.microsoft.com/US/tec...rview/40010469
> https://partner.microsoft.com/US/tec...pportoverview/
> not
>
|||Hello Peter,
Glad to hear the issue is resolved. :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Peter Lapic" <plapic@.shop-a-docket.com.au>
| References: <u130mSe3FHA.3136@.TK2MSFTNGP09.phx.gbl>
<exdZMBf3FHA.3220@.TK2MSFTNGXA01.phx.gbl>
<uaV8Pin3FHA.700@.TK2MSFTNGP15.phx.gbl>
<bCGcbYo3FHA.2984@.TK2MSFTNGXA01.phx.gbl>
| Subject: Re: Replication Between Different Versions of SQL Server causes
access denied error.
| Date: Thu, 3 Nov 2005 10:00:07 +1000
| Lines: 190
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <Ow70RmA4FHA.3540@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.replication
| NNTP-Posting-Host: 61.88.17.230
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP10.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:17574
| X-Tomcat-NG: microsoft.public.sqlserver.replication
|
| The penny dropped!
| Whilst I did configure SQL client network on my development pc to browse
the
| external database I didn't realise I had to configure it again on the
| distributor server. The replication wizard sort of misled me as part of
it
| process what to nonimate the subscriber which it found on my development
pc
| whereas it should have failed it the distributor couldn't recognise it.
|
| Regards
| Peter
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:bCGcbYo3FHA.2984@.TK2MSFTNGXA01.phx.gbl...
| > Hello Peter,
| >
| > This seems to be a MDAC issue. I suggest that you install latest MDAC
2.8
| > SP1 if it is on Win2000 server.
| >
| > 899456 Release manifest for MDAC 2.8 Service Pack 1 (2.81.1117.6)
| > http://support.microsoft.com/?id=899456
| >
| > Also, please use SQL client network utility to make sure TCPIP and named
| > pipes are enabled. Also, you may want to create an Alais for SQL 2000
| > (subscriber) to test the situation.
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader so
| > that others may learn and benefit from your issue.
| >
| > ================================================== ===
| >
| >
| >
| > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| >
| >
| > --
| >>From: "Peter Lapic" <plapic@.shop-a-docket.com.au>
| >>References: <u130mSe3FHA.3136@.TK2MSFTNGP09.phx.gbl>
| > <exdZMBf3FHA.3220@.TK2MSFTNGXA01.phx.gbl>
| >>Subject: Re: Replication Between Different Versions of SQL Server causes
| > access denied error.
| >>Date: Tue, 1 Nov 2005 10:09:26 +1000
| >>Lines: 117
| >>X-Priority: 3
| >>X-MSMail-Priority: Normal
| >>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| >>X-RFC2646: Format=Flowed; Original
| >>Message-ID: <uaV8Pin3FHA.700@.TK2MSFTNGP15.phx.gbl>
| >>Newsgroups: microsoft.public.sqlserver.replication
| >>NNTP-Posting-Host: 61.88.17.230
| >>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP15.phx.gbl
| >>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:17507
| >>X-Tomcat-NG: microsoft.public.sqlserver.replication
| >>
| >>I have created the publication on SQL Server 7.0 server via SQL Server
| > 2000
| >>Enterprise and created a push subscription. As soon as the snapshoot was
| >>ready to send I get the same error "The process could not connect to
| >>Subscriber" (SQL Server does not exist or access denied. Error number:
17)
| >>even though I could setup the subscriber and select the destination
| >>database.
| >>
| >>Regards
| >>Peter
| >>
| >>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| >>news:exdZMBf3FHA.3220@.TK2MSFTNGXA01.phx.gbl...
| >>> Hello Peter,
| >>>
| >>> This is expected behavior when trying to access SQL Server 2000 from
SQL
| >>> 7.0 version of SQL DMO. You will be able to connect to SQL Server 2000
| >>> from
| >>> SQL 7.0 version of Query Analyzer, but not Enterprise Manager. The
| >>> resolution is to upgrade the client tools to SQL 2000.
| >>>
| >>> Also, as you have mentioned, you could use a SQL 2000 Eneterprise
| >>> Manager
| >>> on a different server to work around this issue.
| >>>
| >>> Combination 2 you referred to does not indicate that you could
configure
| >>> this in SQL 7 Enterprise Manager. Since it is from SQL 2000 BOL,
| >>> actually
| >>> you could only configure this from a SQL 2000 Enterprise Manager.
| >>>
| >>> Hope this helps.
| >>>
| >>> Peter Yang
| >>> MCSE2000/2003, MCSA, MCDBA
| >>> Microsoft Online Partner Support
| >>>
| >>> When responding to posts, please "Reply to Group" via your newsreader
so
| >>> that others may learn and benefit from your issue.
| >>>
| >>> ================================================== ===
| >>>
| >>> Business-Critical Phone Support (BCPS) provides you with technical
phone
| >>> support at no charge during critical LAN outages or "business down"
| >>> situations. This benefit is available 24 hours a day, 7 days a week to
| > all
| >>> Microsoft technology partners in the United States and Canada.
| >>>
| >>> This and other support options are available here:
| >>>
| >>> BCPS:
| >>>
| >
https://partner.microsoft.com/US/tec...rview/40010469
| >>>
| >>> Others:
| > https://partner.microsoft.com/US/tec...pportoverview/
| >>>
| >>> If you are outside the United States, please visit our International
| >>> Support page:
| >>> http://support.microsoft.com/default...national.aspx.
| >>>
| >>> ================================================== ===
| >>>
| >>> This posting is provided "AS IS" with no warranties, and confers no
| >>> rights.
| >>>
| >>>
| >>> --
| >>>>From: "Peter Lapic" <plapic@.shop-a-docket.com.au>
| >>>>Subject: Replication Between Different Versions of SQL Server causes
| >>> access denied error.
| >>>>Date: Mon, 31 Oct 2005 16:30:49 +1000
| >>>>Lines: 32
| >>>>X-Priority: 3
| >>>>X-MSMail-Priority: Normal
| >>>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| >>>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| >>>>X-RFC2646: Format=Flowed; Original
| >>>>Message-ID: <u130mSe3FHA.3136@.TK2MSFTNGP09.phx.gbl>
| >>>>Newsgroups: microsoft.public.sqlserver.replication
| >>>>NNTP-Posting-Host: 61.88.17.230
| >>>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP09.phx.gbl
| >>>>Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.replication:17479
| >>>>X-Tomcat-NG: microsoft.public.sqlserver.replication
| >>>>
| >>>>I am getting the following error:
| >>>>SQL Server does not exist or access denied. Error number 17.
| >>>>
| >>>>The publication and distributor is SQL Server 7.0 from internal lan.
| >>>>The subscriber is SQL Server 2000 from external wan outside of the
| >>> firewall.
| >>>>
| >>>>Using SQL Server Enterprise Manager 7.0 on the publication server will
| > not
| >>>>allow me to register the subscriber as it says "You must upgrade your
| >>>>SQL
| >>>>Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000(SQLDMO) to
| >>>>connecti to this server". But if I use a non participanting SQL Server
| >>>>Enterprise Manager 2000 within the internal lan it will allow me to
| >>> register
| >>>>and connect to the browser and I am able to view the database and its
| >>>>tables.
| >>>>
| >>>>In addition I can connect to the subscriber using Query Analyzer in
| >>> version
| >>>>7.0.
| >>>>
| >>>>According to the MSDN under the section Replication Between Different
| >>>>Versions of SQL Server, I fit the same criteria as Combination 2 for
| >>>>snapshot replication ie. Publisher SQL Server 7.0/Distributor SQL
Server
| >>>>7.0/Subscriber SQL Server 2000.
| >>>>
| >>>>So why does the push subscription fail?
| >>>>
| >>>>Regards
| >>>>Peter
| >>>>
| >>>>
| >>>>
| >>>>
| >>>>
| >>>>
| >>>>
| >>>
| >>
| >>
| >>
| >
|
|
|
Replication back to SQL Server
Hi, I had did replication from SQL Server 2000 to Ms Access in same server. Now, how I do it replication back to SQL Server from Ms Access in same server also. very Urgent!! Thanks You.
it can't be done with transactional or snapshot. With merger replication all
you do is rerun the snapshot.
"karencyl" <anonymous@.discussions.microsoft.com> wrote in message
news:0DAE1729-E1D6-465C-92F6-AB10CE9E920D@.microsoft.com...
> Hi, I had did replication from SQL Server 2000 to Ms Access in same
server. Now, how I do it replication back to SQL Server from Ms Access in
same server also. very Urgent!! Thanks You.
it can't be done with transactional or snapshot. With merger replication all
you do is rerun the snapshot.
"karencyl" <anonymous@.discussions.microsoft.com> wrote in message
news:0DAE1729-E1D6-465C-92F6-AB10CE9E920D@.microsoft.com...
> Hi, I had did replication from SQL Server 2000 to Ms Access in same
server. Now, how I do it replication back to SQL Server from Ms Access in
same server also. very Urgent!! Thanks You.
Tuesday, March 20, 2012
Replication and Log shipping
Sql server 2005 heavily hit database
Plans
1)Create a replicated databases to let users with query only access
2)Log shipping to allow a 4hour lag time with Disaster recovery just in
case
users gaff..
Your opinion
1)Transactional replication
2)Log shipping with a stagger of 4 hours
Not done this and wondering are there things to watch out for?
Are there better ways to go about this?
Is replication and log shipping in 2005 configured as a single setup?
Again your time and ideas are appreciated as alwaysI would create database snapshots on the local server if you have a large
tempdb and lots of memory. Otherwise I would use replication.
With log shipping your exposure to data loss if in excess of 4 hours. When
you apply the log you will have to kick your users off the system as you
apply the log to the database. With replication you can put user indexes on
the replicated subscriber database to offer better querying performance.
With log shipping the database is read only - you can't create indexes
there.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Massa Batheli" <mngong@.gmail.com> wrote in message
news:1159285642.485892.323850@.b28g2000cwb.googlegroups.com...
> Sql server 2005 heavily hit database
> Plans
> 1)Create a replicated databases to let users with query only access
> 2)Log shipping to allow a 4hour lag time with Disaster recovery just in
> case
> users gaff..
> Your opinion
> 1)Transactional replication
> 2)Log shipping with a stagger of 4 hours
> Not done this and wondering are there things to watch out for?
> Are there better ways to go about this?
> Is replication and log shipping in 2005 configured as a single setup?
> Again your time and ideas are appreciated as always
>|||Massa,
I did an article a while back that will help you decide between the 2
options: http://www.replicationanswers.com/Standby.asp.
As you're using SQL Server 2005, I'd also add a couple more options for you
to consider looking at:
(a) Mirroring and database snapshots
(b) READ_COMMITTED_SNAPSHOT option to transactional replication as a
variant on the standard Transactional Replication
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Thanks Folks for your time and great ideas ...............
Paul Ibison wrote:
> Massa,
> I did an article a while back that will help you decide between the 2
> options: http://www.replicationanswers.com/Standby.asp.
> As you're using SQL Server 2005, I'd also add a couple more options for you
> to consider looking at:
> (a) Mirroring and database snapshots
> (b) READ_COMMITTED_SNAPSHOT option to transactional replication as a
> variant on the standard Transactional Replication
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
Plans
1)Create a replicated databases to let users with query only access
2)Log shipping to allow a 4hour lag time with Disaster recovery just in
case
users gaff..
Your opinion
1)Transactional replication
2)Log shipping with a stagger of 4 hours
Not done this and wondering are there things to watch out for?
Are there better ways to go about this?
Is replication and log shipping in 2005 configured as a single setup?
Again your time and ideas are appreciated as alwaysI would create database snapshots on the local server if you have a large
tempdb and lots of memory. Otherwise I would use replication.
With log shipping your exposure to data loss if in excess of 4 hours. When
you apply the log you will have to kick your users off the system as you
apply the log to the database. With replication you can put user indexes on
the replicated subscriber database to offer better querying performance.
With log shipping the database is read only - you can't create indexes
there.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Massa Batheli" <mngong@.gmail.com> wrote in message
news:1159285642.485892.323850@.b28g2000cwb.googlegroups.com...
> Sql server 2005 heavily hit database
> Plans
> 1)Create a replicated databases to let users with query only access
> 2)Log shipping to allow a 4hour lag time with Disaster recovery just in
> case
> users gaff..
> Your opinion
> 1)Transactional replication
> 2)Log shipping with a stagger of 4 hours
> Not done this and wondering are there things to watch out for?
> Are there better ways to go about this?
> Is replication and log shipping in 2005 configured as a single setup?
> Again your time and ideas are appreciated as always
>|||Massa,
I did an article a while back that will help you decide between the 2
options: http://www.replicationanswers.com/Standby.asp.
As you're using SQL Server 2005, I'd also add a couple more options for you
to consider looking at:
(a) Mirroring and database snapshots
(b) READ_COMMITTED_SNAPSHOT option to transactional replication as a
variant on the standard Transactional Replication
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Thanks Folks for your time and great ideas ...............
Paul Ibison wrote:
> Massa,
> I did an article a while back that will help you decide between the 2
> options: http://www.replicationanswers.com/Standby.asp.
> As you're using SQL Server 2005, I'd also add a couple more options for you
> to consider looking at:
> (a) Mirroring and database snapshots
> (b) READ_COMMITTED_SNAPSHOT option to transactional replication as a
> variant on the standard Transactional Replication
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
Wednesday, March 7, 2012
Replication
Can any one let me know the process of Replication b/w access - SQL Server
and Access to MySQL...
Thanks and waiting for your reply
Hi
SQL Server Replication:
http://www.microsoft.com/sql/evaluat...eplication.asp
http://msdn.microsoft.com/library/de...ogrdi_63ar.asp
For MySQL, ask the guys who wrote that.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John" <naissani@.hotmail.com> wrote in message
news:eDE1VQELFHA.3788@.tk2msftngp13.phx.gbl...
> Can any one let me know the process of Replication b/w access - SQL Server
> and Access to MySQL...
> Thanks and waiting for your reply
>
>
and Access to MySQL...
Thanks and waiting for your reply
Hi
SQL Server Replication:
http://www.microsoft.com/sql/evaluat...eplication.asp
http://msdn.microsoft.com/library/de...ogrdi_63ar.asp
For MySQL, ask the guys who wrote that.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John" <naissani@.hotmail.com> wrote in message
news:eDE1VQELFHA.3788@.tk2msftngp13.phx.gbl...
> Can any one let me know the process of Replication b/w access - SQL Server
> and Access to MySQL...
> Thanks and waiting for your reply
>
>
Saturday, February 25, 2012
Replication
Hi everybody,
Could someone explain me how to use replication in sql server with access as
frontend?This is such a large topic, I would suggest you begin by reading and
following the directions in Books onLine ( the SQL Server Help files..)
THere is enough information there to get you started...
"Nicollo Machiaveli" <machiaveli280278@.hotmail.com> wrote in message
news:eR%23IffTcDHA.3872@.TK2MSFTNGP11.phx.gbl...
> Hi everybody,
> Could someone explain me how to use replication in sql server with access
as
> frontend?
>
Could someone explain me how to use replication in sql server with access as
frontend?This is such a large topic, I would suggest you begin by reading and
following the directions in Books onLine ( the SQL Server Help files..)
THere is enough information there to get you started...
"Nicollo Machiaveli" <machiaveli280278@.hotmail.com> wrote in message
news:eR%23IffTcDHA.3872@.TK2MSFTNGP11.phx.gbl...
> Hi everybody,
> Could someone explain me how to use replication in sql server with access
as
> frontend?
>
Replication
I have a customer who has Access databases at local sites who wants the data
replicated nightly to MS-SQL Server using broadband connection. I have very
limited knowledge of best practices to accomplish this reliably.
replicated nightly to MS-SQL Server using broadband connection. I have very
limited knowledge of best practices to accomplish this reliably.
Right now they are using some Java app that exports the Access data then
emails the files as CSV. The emails are then manually taken, copied then
imported. Very cumbersome process and VERY unreliable. There's gotaa be a
better way.
I want to recomend that they contract an expert to set this up but really
can't even say for certian what type of person they should look for at this
point.
Any ideas from a 40,000 foot perspective?
Thanks in advance.
- Ben"Ben" <Sorry@.TooManyViruses.com> wrote in message
news:6Eeic.14065$d7.7176@.twister.rdc-kc.rr.com...
> I have a customer who has Access databases at local sites who wants the
data
> replicated nightly to MS-SQL Server using broadband connection.
Clarification: They want data stored in Access at many sites replicated to a
centralized MS-SQL Database via broadband connections (Cable, DSL, etc.).
> I have very limited knowledge of best practices to accomplish this
reliably.
> Right now they are using some Java app that exports the Access data then
> emails the files as CSV. The emails are then manually taken, copied then
> imported. Very cumbersome process and VERY unreliable. There's gotaa be
a
> better way.
> I want to recomend that they contract an expert to set this up but really
> can't even say for certian what type of person they should look for at
this
> point.
> Any ideas from a 40,000 foot perspective?
> Thanks in advance.
> - Ben|||"Ben" <Sorry@.TooManyViruses.com> wrote in message
news:1Geic.14066$d7.8263@.twister.rdc-kc.rr.com...
> "Ben" <Sorry@.TooManyViruses.com> wrote in message
> news:6Eeic.14065$d7.7176@.twister.rdc-kc.rr.com...
> > I have a customer who has Access databases at local sites who wants the
> data
> > replicated nightly to MS-SQL Server using broadband connection.
> Clarification: They want data stored in Access at many sites replicated to
a
> centralized MS-SQL Database via broadband connections (Cable, DSL, etc.).
> > I have very limited knowledge of best practices to accomplish this
> reliably.
> > Right now they are using some Java app that exports the Access data then
> > emails the files as CSV. The emails are then manually taken, copied
then
> > imported. Very cumbersome process and VERY unreliable. There's gotaa
be
> a
> > better way.
> > I want to recomend that they contract an expert to set this up but
really
> > can't even say for certian what type of person they should look for at
> this
> > point.
> > Any ideas from a 40,000 foot perspective?
> > Thanks in advance.
> > - Ben
You might want to post in microsoft.public.sqlserver.replication for more
information, but I believe that Access is only supported as a subscriber
(receives data) not a publisher (sends data).
Alternatives would include setting up linked servers to the Access
databases, and pulling in the data with direct SELECT queries. Or use DTS to
create a generic data transfer package, which is parameterized based on the
Access DB location.
See "sp_addlinkedserver" and "Heterogeneous Subscribers" in Books Online for
more information.
Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in message
news:4089b32d_2@.news.bluewin.ch...
> "Ben" <Sorry@.TooManyViruses.com> wrote in message
> news:1Geic.14066$d7.8263@.twister.rdc-kc.rr.com...
> > "Ben" <Sorry@.TooManyViruses.com> wrote in message
> > news:6Eeic.14065$d7.7176@.twister.rdc-kc.rr.com...
> > > I have a customer who has Access databases at local sites who wants
the
> > data
> > > replicated nightly to MS-SQL Server using broadband connection.
> > Clarification: They want data stored in Access at many sites replicated
to
> a
> > centralized MS-SQL Database via broadband connections (Cable, DSL,
etc.).
> > > I have very limited knowledge of best practices to accomplish this
> > reliably.
> > > > Right now they are using some Java app that exports the Access data
then
> > > emails the files as CSV. The emails are then manually taken, copied
> then
> > > imported. Very cumbersome process and VERY unreliable. There's gotaa
> be
> > a
> > > better way.
> > > > I want to recomend that they contract an expert to set this up but
> really
> > > can't even say for certian what type of person they should look for at
> > this
> > > point.
> > > > Any ideas from a 40,000 foot perspective?
> > > > Thanks in advance.
> > > > - Ben
> > > You might want to post in microsoft.public.sqlserver.replication for more
> information, but I believe that Access is only supported as a subscriber
> (receives data) not a publisher (sends data).
> Alternatives would include setting up linked servers to the Access
> databases, and pulling in the data with direct SELECT queries. Or use DTS
to
> create a generic data transfer package, which is parameterized based on
the
> Access DB location.
> See "sp_addlinkedserver" and "Heterogeneous Subscribers" in Books Online
for
> more information.
> Simon
Thanks for the leads.
Replication
I have a customer who has Access databases at local sites who wants the data
replicated nightly to MS-SQL Server using broadband connection. I have very
limited knowledge of best practices to accomplish this reliably.
replicated nightly to MS-SQL Server using broadband connection. I have very
limited knowledge of best practices to accomplish this reliably.
Right now they are using some Java app that exports the Access data then
emails the files as CSV. The emails are then manually taken, copied then
imported. Very cumbersome process and VERY unreliable. There's gotaa be a
better way.
I want to recomend that they contract an expert to set this up but really
can't even say for certian what type of person they should look for at this
point.
Any ideas from a 40,000 foot perspective?
Thanks in advance.
- Ben"Ben" <Sorry@.TooManyViruses.com> wrote in message
news:6Eeic.14065$d7.7176@.twister.rdc-kc.rr.com...
> I have a customer who has Access databases at local sites who wants the
data
> replicated nightly to MS-SQL Server using broadband connection.
Clarification: They want data stored in Access at many sites replicated to a
centralized MS-SQL Database via broadband connections (Cable, DSL, etc.).
> I have very limited knowledge of best practices to accomplish this
reliably.
> Right now they are using some Java app that exports the Access data then
> emails the files as CSV. The emails are then manually taken, copied then
> imported. Very cumbersome process and VERY unreliable. There's gotaa be
a
> better way.
> I want to recomend that they contract an expert to set this up but really
> can't even say for certian what type of person they should look for at
this
> point.
> Any ideas from a 40,000 foot perspective?
> Thanks in advance.
> - Ben|||"Ben" <Sorry@.TooManyViruses.com> wrote in message
news:1Geic.14066$d7.8263@.twister.rdc-kc.rr.com...
> "Ben" <Sorry@.TooManyViruses.com> wrote in message
> news:6Eeic.14065$d7.7176@.twister.rdc-kc.rr.com...
> > I have a customer who has Access databases at local sites who wants the
> data
> > replicated nightly to MS-SQL Server using broadband connection.
> Clarification: They want data stored in Access at many sites replicated to
a
> centralized MS-SQL Database via broadband connections (Cable, DSL, etc.).
> > I have very limited knowledge of best practices to accomplish this
> reliably.
> > Right now they are using some Java app that exports the Access data then
> > emails the files as CSV. The emails are then manually taken, copied
then
> > imported. Very cumbersome process and VERY unreliable. There's gotaa
be
> a
> > better way.
> > I want to recomend that they contract an expert to set this up but
really
> > can't even say for certian what type of person they should look for at
> this
> > point.
> > Any ideas from a 40,000 foot perspective?
> > Thanks in advance.
> > - Ben
You might want to post in microsoft.public.sqlserver.replication for more
information, but I believe that Access is only supported as a subscriber
(receives data) not a publisher (sends data).
Alternatives would include setting up linked servers to the Access
databases, and pulling in the data with direct SELECT queries. Or use DTS to
create a generic data transfer package, which is parameterized based on the
Access DB location.
See "sp_addlinkedserver" and "Heterogeneous Subscribers" in Books Online for
more information.
Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in message
news:4089b32d_2@.news.bluewin.ch...
> "Ben" <Sorry@.TooManyViruses.com> wrote in message
> news:1Geic.14066$d7.8263@.twister.rdc-kc.rr.com...
> > "Ben" <Sorry@.TooManyViruses.com> wrote in message
> > news:6Eeic.14065$d7.7176@.twister.rdc-kc.rr.com...
> > > I have a customer who has Access databases at local sites who wants
the
> > data
> > > replicated nightly to MS-SQL Server using broadband connection.
> > Clarification: They want data stored in Access at many sites replicated
to
> a
> > centralized MS-SQL Database via broadband connections (Cable, DSL,
etc.).
> > > I have very limited knowledge of best practices to accomplish this
> > reliably.
> > > > Right now they are using some Java app that exports the Access data
then
> > > emails the files as CSV. The emails are then manually taken, copied
> then
> > > imported. Very cumbersome process and VERY unreliable. There's gotaa
> be
> > a
> > > better way.
> > > > I want to recomend that they contract an expert to set this up but
> really
> > > can't even say for certian what type of person they should look for at
> > this
> > > point.
> > > > Any ideas from a 40,000 foot perspective?
> > > > Thanks in advance.
> > > > - Ben
> > > You might want to post in microsoft.public.sqlserver.replication for more
> information, but I believe that Access is only supported as a subscriber
> (receives data) not a publisher (sends data).
> Alternatives would include setting up linked servers to the Access
> databases, and pulling in the data with direct SELECT queries. Or use DTS
to
> create a generic data transfer package, which is parameterized based on
the
> Access DB location.
> See "sp_addlinkedserver" and "Heterogeneous Subscribers" in Books Online
for
> more information.
> Simon
Thanks for the leads.|||I have more than 7 years of Experience with Replication if you want I can
Help u out in this. Please email me nehapatel75@.yahoo.com
Replicating with Access in Hilary's book
On page 50, you discuss replicating SQL Server to Access. Two questions:
1. While you discuss all 3 replication types, it sounds like you are
recommending Merge as the solution?
2. In the hint, it says in part, "all transactions occuring on the Merge
Subscriber [Access] will be "published" or merged to the SQL Server
database." Do you mean the transactions are merged on the SQL Server's
schedule (both directions?) or via some user interaction on the Access side?
1) while you can use snapshot, transactional, or merge replication; what I
was trying to get at was that many people want the access database to
publish to sql server, and I was suggesting that you could set up the access
database as a subscriber and if all the changes originate there it could act
as the publisher.
2) All transactions will be merged with the publisher, but they all
originate with the subcriber/access database. the synchronization will be
kicked off each time the push agent runs - I don't believe you can do a
pull.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:%239ZFAV2cFHA.1044@.TK2MSFTNGP10.phx.gbl...
> On page 50, you discuss replicating SQL Server to Access. Two questions:
> 1. While you discuss all 3 replication types, it sounds like you are
> recommending Merge as the solution?
> 2. In the hint, it says in part, "all transactions occuring on the Merge
> Subscriber [Access] will be "published" or merged to the SQL Server
> database." Do you mean the transactions are merged on the SQL Server's
> schedule (both directions?) or via some user interaction on the Access
> side?
>
1. While you discuss all 3 replication types, it sounds like you are
recommending Merge as the solution?
2. In the hint, it says in part, "all transactions occuring on the Merge
Subscriber [Access] will be "published" or merged to the SQL Server
database." Do you mean the transactions are merged on the SQL Server's
schedule (both directions?) or via some user interaction on the Access side?
1) while you can use snapshot, transactional, or merge replication; what I
was trying to get at was that many people want the access database to
publish to sql server, and I was suggesting that you could set up the access
database as a subscriber and if all the changes originate there it could act
as the publisher.
2) All transactions will be merged with the publisher, but they all
originate with the subcriber/access database. the synchronization will be
kicked off each time the push agent runs - I don't believe you can do a
pull.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:%239ZFAV2cFHA.1044@.TK2MSFTNGP10.phx.gbl...
> On page 50, you discuss replicating SQL Server to Access. Two questions:
> 1. While you discuss all 3 replication types, it sounds like you are
> recommending Merge as the solution?
> 2. In the hint, it says in part, "all transactions occuring on the Merge
> Subscriber [Access] will be "published" or merged to the SQL Server
> database." Do you mean the transactions are merged on the SQL Server's
> schedule (both directions?) or via some user interaction on the Access
> side?
>
Monday, February 20, 2012
Replicating Permissions
My reports are currently configured so that only certain users on the
domain can access certain reports. I have installed another server at
a remote location that will need to have the same permissions as the
first one. Is there a way to replicate the security settings without
having to set the permissions manually each time?
Is there a security configuration file somewhere on the first server
that i could move over to the second, since they are pretty much the
same?
Thank you!You may want to check the following tool courtesy of Jasper Smith:
http://www.sqldbatips.com/showarticle.asp?ID=62
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"muris" <rmuris@.hotmail.com> wrote in message
news:1113533808.430998.255460@.f14g2000cwb.googlegroups.com...
> My reports are currently configured so that only certain users on the
> domain can access certain reports. I have installed another server at
> a remote location that will need to have the same permissions as the
> first one. Is there a way to replicate the security settings without
> having to set the permissions manually each time?
> Is there a security configuration file somewhere on the first server
> that i could move over to the second, since they are pretty much the
> same?
> Thank you!
>|||Thanks for your Reply. The app you refered me to helps me replicate
the reports and user roles to multiple servers, but it does not
replicate the security permissions for each folder nor the report. Is
there a script that can accomplish this task?
Thanks!|||Jasper Smith may add this kind of functionality to the tool in a future
release.
On RS 2000 you would have to do this through the SOAP API (ListChildren,
GetProperties, GetPermissions, etc.)
The Management Studio for the upcoming SQL Server 2005 release of Reporting
Services will allow you to generate a script to capture that state and then
apply it to another server.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"muris" <rmuris@.hotmail.com> wrote in message
news:1113572435.510884.55430@.z14g2000cwz.googlegroups.com...
> Thanks for your Reply. The app you refered me to helps me replicate
> the reports and user roles to multiple servers, but it does not
> replicate the security permissions for each folder nor the report. Is
> there a script that can accomplish this task?
> Thanks!
>
domain can access certain reports. I have installed another server at
a remote location that will need to have the same permissions as the
first one. Is there a way to replicate the security settings without
having to set the permissions manually each time?
Is there a security configuration file somewhere on the first server
that i could move over to the second, since they are pretty much the
same?
Thank you!You may want to check the following tool courtesy of Jasper Smith:
http://www.sqldbatips.com/showarticle.asp?ID=62
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"muris" <rmuris@.hotmail.com> wrote in message
news:1113533808.430998.255460@.f14g2000cwb.googlegroups.com...
> My reports are currently configured so that only certain users on the
> domain can access certain reports. I have installed another server at
> a remote location that will need to have the same permissions as the
> first one. Is there a way to replicate the security settings without
> having to set the permissions manually each time?
> Is there a security configuration file somewhere on the first server
> that i could move over to the second, since they are pretty much the
> same?
> Thank you!
>|||Thanks for your Reply. The app you refered me to helps me replicate
the reports and user roles to multiple servers, but it does not
replicate the security permissions for each folder nor the report. Is
there a script that can accomplish this task?
Thanks!|||Jasper Smith may add this kind of functionality to the tool in a future
release.
On RS 2000 you would have to do this through the SOAP API (ListChildren,
GetProperties, GetPermissions, etc.)
The Management Studio for the upcoming SQL Server 2005 release of Reporting
Services will allow you to generate a script to capture that state and then
apply it to another server.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"muris" <rmuris@.hotmail.com> wrote in message
news:1113572435.510884.55430@.z14g2000cwz.googlegroups.com...
> Thanks for your Reply. The app you refered me to helps me replicate
> the reports and user roles to multiple servers, but it does not
> replicate the security permissions for each folder nor the report. Is
> there a script that can accomplish this task?
> Thanks!
>
Subscribe to:
Posts (Atom)