I read several articles to this topic, and I couldnt understand, why
a SQL-Server-Subscriber need to connect to the distributor.
- I have a Server A in my LAN, publishing a Database, distributor is
the same Server A.
- using Push-Merge-Replikation
- Server B in the internet, behind a firewall
In http://support.microsoft.com/kb/321822 you can read, that you the 2
servers must be able to ping eachother.
Is this definitely true? The Merge-Agent is running on Server A, and
Server A can connect to Server B. Why does the subscriber B need to
connect to Server A?
If you would use Pull-Replication, and der Merge-Agent was running on
Server B, yes, then I could unterstand this.
If this fact is really true, then it is much more difficult to realize
such a default-scenario like I would like to use.
Andreas Lauffer, Germany
You will need connectivity at some point in time. Your subscriber can be
offline for long periods of time, but at some point in time, it must sync
with the publisher.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Now available on Amazon.com
http://www.amazon.com/gp/product/off...?condition=all
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Andreas Lauffer" <al@.lauffers.de> wrote in message
news:u1ie01tic78r09tpmdjl3vuusmk9om6c78@.4ax.com...
> I read several articles to this topic, and I couldnt understand, why
> a SQL-Server-Subscriber need to connect to the distributor.
> - I have a Server A in my LAN, publishing a Database, distributor is
> the same Server A.
> - using Push-Merge-Replikation
> - Server B in the internet, behind a firewall
> In http://support.microsoft.com/kb/321822 you can read, that you the 2
> servers must be able to ping eachother.
> Is this definitely true? The Merge-Agent is running on Server A, and
> Server A can connect to Server B. Why does the subscriber B need to
> connect to Server A?
> If you would use Pull-Replication, and der Merge-Agent was running on
> Server B, yes, then I could unterstand this.
> If this fact is really true, then it is much more difficult to realize
> such a default-scenario like I would like to use.
>
> Andreas Lauffer, Germany
>
>
|||Sure you need a connection at one time. But the question is in which
direction you need to connect.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:<uuQaNsZDFHA.1936@.TK2MSFTNGP14.phx.gbl>...[vbcol=seagreen]
> You will need connectivity at some point in time. Your subscriber can be
> offline for long periods of time, but at some point in time, it must sync
> with the publisher.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Now available on Amazon.com
> http://www.amazon.com/gp/product/off...?condition=all
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Andreas Lauffer" <al@.lauffers.de> wrote in message
> news:u1ie01tic78r09tpmdjl3vuusmk9om6c78@.4ax.com...
Showing posts with label connect. Show all posts
Showing posts with label connect. Show all posts
Monday, March 26, 2012
Wednesday, March 21, 2012
Pulling trans logs from one server to anthother
I know this can be done using a bat file, but am having issues finding any
documentation.
I need to connect to a mapped drive and move trans log backups from on
server to another server so they can be applied.
Any help would be greatly appreciated.
Thanks in advance
SusanI recommend using VBScript and the Windoes Scripting Host.
here is some documentation:
[url]http://www.microsoft.com/technet/scriptcenter/guide/sas_wsh_qlcc.mspx?mfr=true[/ur
l]
It will allow you to create more robust scripts with error handling and
logging capabilities. Here are some examples:
[url]http://www.microsoft.com/technet/archive/ittasks/maintain/script1.mspx?mfr=true[/u
rl]
Search for the Scripting.FileSystemObject to get code samples.
I used it in the past with very good results. In fact, I have production
systems that depend on scripts I wrote and they still perform as intended.
"SBAUER" wrote:
> I know this can be done using a bat file, but am having issues finding any
> documentation.
> I need to connect to a mapped drive and move trans log backups from on
> server to another server so they can be applied.
> Any help would be greatly appreciated.
> Thanks in advance
> Susan
>|||Thanks Edgardo,
However, my knowledge of VB scripting is very limited.
I'm trying to map a drive and just copy the files over using bat.
I'm sure the way you suggested is the best, but I'm under a time crunch and
don't have time for a learning curve.
"Edgardo Valdez, MCSD, MCDBA" wrote:
> I recommend using VBScript and the Windoes Scripting Host.
> here is some documentation:
> [url]http://www.microsoft.com/technet/scriptcenter/guide/sas_wsh_qlcc.mspx?mfr=true[/
url]
> It will allow you to create more robust scripts with error handling and
> logging capabilities. Here are some examples:
> [url]http://www.microsoft.com/technet/archive/ittasks/maintain/script1.mspx?mfr=true[
/url]
> Search for the Scripting.FileSystemObject to get code samples.
> I used it in the past with very good results. In fact, I have production
> systems that depend on scripts I wrote and they still perform as intended.
> "SBAUER" wrote:
>|||In that case, you can use xcopy
>xcopy /?
Copies files and directory trees.
XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W]
[/C] [/I] [/Q] [/F] [/L] [/G] [/H] [/R] [/T] [/U]
[/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z]
[/EXCLUDE:file1[+file2][+file3]...]
source Specifies the file(s) to copy.
destination Specifies the location and/or name of new files.
/A Copies only files with the archive attribute set,
doesn't change the attribute.
/M Copies only files with the archive attribute set,
turns off the archive attribute.
/D:m-d-y Copies files changed on or after the specified date.
If no date is given, copies only those files whose
source time is newer than the destination time.
/EXCLUDE:file1[+file2][+file3]...
Specifies a list of files containing strings. Each string
should be in a separate line in the files. When any of the
strings match any part of the absolute path of the file to be
copied, that file will be excluded from being copied. For
example, specifying a string like \obj\ or .obj will exclude
all files underneath the directory obj or all files with the
.obj extension respectively.
/P Prompts you before creating each destination file.
/S Copies directories and subdirectories except empty ones.
/E Copies directories and subdirectories, including empty ones.
Same as /S /E. May be used to modify /T.
/V Verifies each new file.
/W Prompts you to press a key before copying.
/C Continues copying even if errors occur.
/I If destination does not exist and copying more than one file,
assumes that destination must be a directory.
/Q Does not display file names while copying.
/F Displays full source and destination file names while copying.
/L Displays files that would be copied.
/G Allows the copying of encrypted files to destination that does
not support encryption.
/H Copies hidden and system files also.
/R Overwrites read-only files.
/T Creates directory structure, but does not copy files. Does not
include empty directories or subdirectories. /T /E includes
empty directories and subdirectories.
/U Copies only files that already exist in destination.
/K Copies attributes. Normal Xcopy will reset read-only
attributes.
/N Copies using the generated short names.
/O Copies file ownership and ACL information.
/X Copies file audit settings (implies /O).
/Y Suppresses prompting to confirm you want to overwrite an
existing destination file.
/-Y Causes prompting to confirm you want to overwrite an
existing destination file.
/Z Copies networked files in restartable mode.
The switch /Y may be preset in the COPYCMD environment variable.
This may be overridden with /-Y on the command line.
Example:
C:>xcopy E:\SQLData\*.trn \\remoteserver\C$\SQLBackups
"SBAUER" wrote:
> Thanks Edgardo,
> However, my knowledge of VB scripting is very limited.
> I'm trying to map a drive and just copy the files over using bat.
> I'm sure the way you suggested is the best, but I'm under a time crunch an
d
> don't have time for a learning curve.
>
> "Edgardo Valdez, MCSD, MCDBA" wrote:
>sql
documentation.
I need to connect to a mapped drive and move trans log backups from on
server to another server so they can be applied.
Any help would be greatly appreciated.
Thanks in advance
SusanI recommend using VBScript and the Windoes Scripting Host.
here is some documentation:
[url]http://www.microsoft.com/technet/scriptcenter/guide/sas_wsh_qlcc.mspx?mfr=true[/ur
l]
It will allow you to create more robust scripts with error handling and
logging capabilities. Here are some examples:
[url]http://www.microsoft.com/technet/archive/ittasks/maintain/script1.mspx?mfr=true[/u
rl]
Search for the Scripting.FileSystemObject to get code samples.
I used it in the past with very good results. In fact, I have production
systems that depend on scripts I wrote and they still perform as intended.
"SBAUER" wrote:
> I know this can be done using a bat file, but am having issues finding any
> documentation.
> I need to connect to a mapped drive and move trans log backups from on
> server to another server so they can be applied.
> Any help would be greatly appreciated.
> Thanks in advance
> Susan
>|||Thanks Edgardo,
However, my knowledge of VB scripting is very limited.
I'm trying to map a drive and just copy the files over using bat.
I'm sure the way you suggested is the best, but I'm under a time crunch and
don't have time for a learning curve.
"Edgardo Valdez, MCSD, MCDBA" wrote:
> I recommend using VBScript and the Windoes Scripting Host.
> here is some documentation:
> [url]http://www.microsoft.com/technet/scriptcenter/guide/sas_wsh_qlcc.mspx?mfr=true[/
url]
> It will allow you to create more robust scripts with error handling and
> logging capabilities. Here are some examples:
> [url]http://www.microsoft.com/technet/archive/ittasks/maintain/script1.mspx?mfr=true[
/url]
> Search for the Scripting.FileSystemObject to get code samples.
> I used it in the past with very good results. In fact, I have production
> systems that depend on scripts I wrote and they still perform as intended.
> "SBAUER" wrote:
>|||In that case, you can use xcopy
>xcopy /?
Copies files and directory trees.
XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W]
[/C] [/I] [/Q] [/F] [/L] [/G] [/H] [/R] [/T] [/U]
[/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z]
[/EXCLUDE:file1[+file2][+file3]...]
source Specifies the file(s) to copy.
destination Specifies the location and/or name of new files.
/A Copies only files with the archive attribute set,
doesn't change the attribute.
/M Copies only files with the archive attribute set,
turns off the archive attribute.
/D:m-d-y Copies files changed on or after the specified date.
If no date is given, copies only those files whose
source time is newer than the destination time.
/EXCLUDE:file1[+file2][+file3]...
Specifies a list of files containing strings. Each string
should be in a separate line in the files. When any of the
strings match any part of the absolute path of the file to be
copied, that file will be excluded from being copied. For
example, specifying a string like \obj\ or .obj will exclude
all files underneath the directory obj or all files with the
.obj extension respectively.
/P Prompts you before creating each destination file.
/S Copies directories and subdirectories except empty ones.
/E Copies directories and subdirectories, including empty ones.
Same as /S /E. May be used to modify /T.
/V Verifies each new file.
/W Prompts you to press a key before copying.
/C Continues copying even if errors occur.
/I If destination does not exist and copying more than one file,
assumes that destination must be a directory.
/Q Does not display file names while copying.
/F Displays full source and destination file names while copying.
/L Displays files that would be copied.
/G Allows the copying of encrypted files to destination that does
not support encryption.
/H Copies hidden and system files also.
/R Overwrites read-only files.
/T Creates directory structure, but does not copy files. Does not
include empty directories or subdirectories. /T /E includes
empty directories and subdirectories.
/U Copies only files that already exist in destination.
/K Copies attributes. Normal Xcopy will reset read-only
attributes.
/N Copies using the generated short names.
/O Copies file ownership and ACL information.
/X Copies file audit settings (implies /O).
/Y Suppresses prompting to confirm you want to overwrite an
existing destination file.
/-Y Causes prompting to confirm you want to overwrite an
existing destination file.
/Z Copies networked files in restartable mode.
The switch /Y may be preset in the COPYCMD environment variable.
This may be overridden with /-Y on the command line.
Example:
C:>xcopy E:\SQLData\*.trn \\remoteserver\C$\SQLBackups
"SBAUER" wrote:
> Thanks Edgardo,
> However, my knowledge of VB scripting is very limited.
> I'm trying to map a drive and just copy the files over using bat.
> I'm sure the way you suggested is the best, but I'm under a time crunch an
d
> don't have time for a learning curve.
>
> "Edgardo Valdez, MCSD, MCDBA" wrote:
>sql
Friday, March 9, 2012
Pull Agent: Process Could Not Connect To Subscriber
OK, with a tip from ChrisR I got the first problem fixed (I hope). Now, I have
another problem. I have created a pull subscription on a second server, say
SERVERB, to get the data from the first server, say SERVERA. Every time I try to
run this pull subscription I get the following message:
The process could not connect to Subscriber 'NEWSERVERB'.
Then it fails every time. Funny thing to me is that then name of the subscriber
in this message is my subscriber server with 'NEW' on the front. Questions:
Where does that name come from? Why is it trying to connect to my subscriber?
What the heck is going on?
Thanks!
Hi Darrell,
It looks like '-Subscriber NEWSERVERB' might have been accidentally added to
the command line for starting the replication agent. You can find out the
replication agent command line by doing a select from msdb..sysjobsteps.
Merge agent job steps will have a subsystem value of 'REPL-MERGE' whereas
distribution agent job steps will have a subsystem value of
'REPL-DISTRIBUTION'.
-Raymond
"Darrell" wrote:
> OK, with a tip from ChrisR I got the first problem fixed (I hope). Now, I have
> another problem. I have created a pull subscription on a second server, say
> SERVERB, to get the data from the first server, say SERVERA. Every time I try to
> run this pull subscription I get the following message:
> The process could not connect to Subscriber 'NEWSERVERB'.
> Then it fails every time. Funny thing to me is that then name of the subscriber
> in this message is my subscriber server with 'NEW' on the front. Questions:
> Where does that name come from? Why is it trying to connect to my subscriber?
> What the heck is going on?
> Thanks!
>
|||Dude, thanks! I thought I had changed that in the steps of all jobs. I must have
missed one or more of the steps. Thanks again.
Raymond Mak [MSFT] wrote:[vbcol=seagreen]
> Hi Darrell,
> It looks like '-Subscriber NEWSERVERB' might have been accidentally added to
> the command line for starting the replication agent. You can find out the
> replication agent command line by doing a select from msdb..sysjobsteps.
> Merge agent job steps will have a subsystem value of 'REPL-MERGE' whereas
> distribution agent job steps will have a subsystem value of
> 'REPL-DISTRIBUTION'.
> -Raymond
> "Darrell" wrote:
>
another problem. I have created a pull subscription on a second server, say
SERVERB, to get the data from the first server, say SERVERA. Every time I try to
run this pull subscription I get the following message:
The process could not connect to Subscriber 'NEWSERVERB'.
Then it fails every time. Funny thing to me is that then name of the subscriber
in this message is my subscriber server with 'NEW' on the front. Questions:
Where does that name come from? Why is it trying to connect to my subscriber?
What the heck is going on?
Thanks!
Hi Darrell,
It looks like '-Subscriber NEWSERVERB' might have been accidentally added to
the command line for starting the replication agent. You can find out the
replication agent command line by doing a select from msdb..sysjobsteps.
Merge agent job steps will have a subsystem value of 'REPL-MERGE' whereas
distribution agent job steps will have a subsystem value of
'REPL-DISTRIBUTION'.
-Raymond
"Darrell" wrote:
> OK, with a tip from ChrisR I got the first problem fixed (I hope). Now, I have
> another problem. I have created a pull subscription on a second server, say
> SERVERB, to get the data from the first server, say SERVERA. Every time I try to
> run this pull subscription I get the following message:
> The process could not connect to Subscriber 'NEWSERVERB'.
> Then it fails every time. Funny thing to me is that then name of the subscriber
> in this message is my subscriber server with 'NEW' on the front. Questions:
> Where does that name come from? Why is it trying to connect to my subscriber?
> What the heck is going on?
> Thanks!
>
|||Dude, thanks! I thought I had changed that in the steps of all jobs. I must have
missed one or more of the steps. Thanks again.
Raymond Mak [MSFT] wrote:[vbcol=seagreen]
> Hi Darrell,
> It looks like '-Subscriber NEWSERVERB' might have been accidentally added to
> the command line for starting the replication agent. You can find out the
> replication agent command line by doing a select from msdb..sysjobsteps.
> Merge agent job steps will have a subsystem value of 'REPL-MERGE' whereas
> distribution agent job steps will have a subsystem value of
> 'REPL-DISTRIBUTION'.
> -Raymond
> "Darrell" wrote:
>
Pubs and Northwind
I have MSDE 2000 installed but don't know how to connect to pubs or
northwind. Could anyone help? Running Svr 03
The sample databases do not come with the MSDE distribution. But, you can
download them from:
http://www.microsoft.com/sql/msde/downloads/default.asp
Jim
"glennTK" <glenntk@.gtkcomputer.com> wrote in message
news:%231NmrNSGFHA.3648@.TK2MSFTNGP09.phx.gbl...
>I have MSDE 2000 installed but don't know how to connect to pubs or
> northwind. Could anyone help? Running Svr 03
>
northwind. Could anyone help? Running Svr 03
The sample databases do not come with the MSDE distribution. But, you can
download them from:
http://www.microsoft.com/sql/msde/downloads/default.asp
Jim
"glennTK" <glenntk@.gtkcomputer.com> wrote in message
news:%231NmrNSGFHA.3648@.TK2MSFTNGP09.phx.gbl...
>I have MSDE 2000 installed but don't know how to connect to pubs or
> northwind. Could anyone help? Running Svr 03
>
Wednesday, March 7, 2012
Publisher keeps trying to connect to subscriber
hi,
I manually changed a value in a table that makes part of the Replication and after that the sync failed on the procedure that updates the table on the subscriber.
So I manually re-start the sync. But for some reason it keeps trying to reconnect to the subscriber.
If I try to delete the subscriber to push it again, it locks.
I went to the Agent History, it showed the error "The process could not connect to Subscriber"
ODBC SQL SERVER DRIVER (number 08001)
I checked the SQL on the subscriber and it's running.
Does anybody has an idea of what I could do ?
Thanks !Before somebody try to answer, I got the replication running again.
I STOPPED the Sql Server at the subscriber and Re-started it.
things looks fine now.
Renata
I manually changed a value in a table that makes part of the Replication and after that the sync failed on the procedure that updates the table on the subscriber.
So I manually re-start the sync. But for some reason it keeps trying to reconnect to the subscriber.
If I try to delete the subscriber to push it again, it locks.
I went to the Agent History, it showed the error "The process could not connect to Subscriber"
ODBC SQL SERVER DRIVER (number 08001)
I checked the SQL on the subscriber and it's running.
Does anybody has an idea of what I could do ?
Thanks !Before somebody try to answer, I got the replication running again.
I STOPPED the Sql Server at the subscriber and Re-started it.
things looks fine now.
Renata
Saturday, February 25, 2012
Publish Reports Server to Internet
Hi all,
I have an external IP for my server and I tried to connect it from out side,
I notice that the link address appear on Status bar is my localhost's name
link ... and that's why it can be accessed to view reports. It just work if I
re-config my IP setting following external IP. Who can expalin me or show me
some addresses to study more about this problem ?
--
Thnx lots,
NgocYour local machine has its IP address and the server has its IP address
accessible from the Internet? Assuming you have configured security so that
the server is accessible from outside, you just need to do
http://<serverIPaddress>/Reports or https://<serverIPaddress>/Reports, right?
If you are doing http://<yourmachine>/Reports, then you will see the local
report server, unless you have used rsconfig.exe to point your local server
to the external server URL. Books Online has details on using rsconfig.exe.
Charles Kangai, MCDBA, MCT
"Phi Ngoc" wrote:
> Hi all,
> I have an external IP for my server and I tried to connect it from out side,
> I notice that the link address appear on Status bar is my localhost's name
> link ... and that's why it can be accessed to view reports. It just work if I
> re-config my IP setting following external IP. Who can expalin me or show me
> some addresses to study more about this problem ?
> --
> Thnx lots,
> Ngoc|||I am having the same problem where I go here http://(fqdn.external.name)
/Reports
The reports are viewable externally, but if I try to export them it reverts
to the computer name (Which happens to be MISERY) like this
http://misery/Reports/Pages/Reports.aspx..etc.etc
Does anyone know how to change this?
Thanks.
--
Message posted via http://www.sqlmonster.com|||Open the RSWebApplication.config file and check the URL inside the
<ReportServerURL> element. Do the same with RSReportServer.config file. The
files are located in the folders <SQL Server Installation>\Reporting
Services\ReportManager and <SQL Server Installation>\Reporting
Services\ReportServer, respectively.
Charles Kangai, MCDBA, MCT
"David Benedict via SQLMonster.com" wrote:
> I am having the same problem where I go here http://(fqdn.external.name)
> /Reports
> The reports are viewable externally, but if I try to export them it reverts
> to the computer name (Which happens to be MISERY) like this
> http://misery/Reports/Pages/Reports.aspx..etc.etc
> Does anyone know how to change this?
> Thanks.
> --
> Message posted via http://www.sqlmonster.com
>
I have an external IP for my server and I tried to connect it from out side,
I notice that the link address appear on Status bar is my localhost's name
link ... and that's why it can be accessed to view reports. It just work if I
re-config my IP setting following external IP. Who can expalin me or show me
some addresses to study more about this problem ?
--
Thnx lots,
NgocYour local machine has its IP address and the server has its IP address
accessible from the Internet? Assuming you have configured security so that
the server is accessible from outside, you just need to do
http://<serverIPaddress>/Reports or https://<serverIPaddress>/Reports, right?
If you are doing http://<yourmachine>/Reports, then you will see the local
report server, unless you have used rsconfig.exe to point your local server
to the external server URL. Books Online has details on using rsconfig.exe.
Charles Kangai, MCDBA, MCT
"Phi Ngoc" wrote:
> Hi all,
> I have an external IP for my server and I tried to connect it from out side,
> I notice that the link address appear on Status bar is my localhost's name
> link ... and that's why it can be accessed to view reports. It just work if I
> re-config my IP setting following external IP. Who can expalin me or show me
> some addresses to study more about this problem ?
> --
> Thnx lots,
> Ngoc|||I am having the same problem where I go here http://(fqdn.external.name)
/Reports
The reports are viewable externally, but if I try to export them it reverts
to the computer name (Which happens to be MISERY) like this
http://misery/Reports/Pages/Reports.aspx..etc.etc
Does anyone know how to change this?
Thanks.
--
Message posted via http://www.sqlmonster.com|||Open the RSWebApplication.config file and check the URL inside the
<ReportServerURL> element. Do the same with RSReportServer.config file. The
files are located in the folders <SQL Server Installation>\Reporting
Services\ReportManager and <SQL Server Installation>\Reporting
Services\ReportServer, respectively.
Charles Kangai, MCDBA, MCT
"David Benedict via SQLMonster.com" wrote:
> I am having the same problem where I go here http://(fqdn.external.name)
> /Reports
> The reports are viewable externally, but if I try to export them it reverts
> to the computer name (Which happens to be MISERY) like this
> http://misery/Reports/Pages/Reports.aspx..etc.etc
> Does anyone know how to change this?
> Thanks.
> --
> Message posted via http://www.sqlmonster.com
>
Subscribe to:
Posts (Atom)