Replacing a cluster node: SQL silent install setup installshield error

Can anyone tell me how to get around this? Installing SQL- no issues, just when applying the sp

I have tried numerous things, including rebuilding the 2nd node again

Trying to install a service pack on SQL 2000 node, and Install shield keeps returning this error, .

[InstallShield Silent]
Version=v5.00.000
File=Log File
[ResponseResult]
ResultCode=-8

I have reset temp directories on both nodes,

I have made user permissions and profiles exist

I have copied install files to both local and remote locations

I know the response – Installshield cannot find the silent response file, but SQL setup creates this on its own.

Short of bringing this production system down and re-installing on both nodes ( I did test this on a non-prod box by the way, no issues), I am at a loss

Well

After 2 weeks of searching, finally!

It turns out, a couple of old log files and a registry key were the culprits..

I found this article this am, and it was the saviour

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=66737

Specific to my case were:

all mif and logs EVERYWHERE on the replaced node and:

\SOFTWARE\Microsoft\Microsoft SQL Server\80\Need_SP_Key - delete this key (backup 1st of course) on the new node

SP3a went on like a dream, and I can now finally move onto SP4 testing.

Repl works on VPN, not via internet

I am trying to setup a process in a VB.Net app that allows the user to manually invoke a transactional replication process. This works fine on my development machine within our network/VPN. However, when I disconnect my machine from the VPN, the process
keeps failing with a "Process could not connect to Distributor" error. Unfortunately, our customers/users will not be in our domain...they need to be able to connect & replicate over the internet.
Here is the current setup:
Server
Windows 2003 Server
Sql Server 2000 (sp3)
Client
Windows 2000 Pro or Windows XP Pro
MSDE
Also...from within the network I have to use only the server's name "MyServer" to get this to work. If I use a fully qualified name, like "MyServer.Domain.Com" it fails with the same error.
The server acts as both the publisher and the distributor. The publication is set up to allow anonymous pull subscriptions via FTP. I have a sql login that I have setup and made sure that it is in the Publications PAL.
I have used this example: http://support.microsoft.com/default...;en-us;Q319648 to create the .net process.
From a client machine...I can access the ftp site on the server via:
ftp Server.Domain.Com.
I cannot get to the server with Ping or Tracert. I was told by our network admin that the ability to Ping our server has been disabled.
I think that this must be a server configuration problem...since I can get the whole thing to work when I am on the network. I checked the log files (based on a suggestion from another post) on the server...and it doesn't even appear that a login is attem
pted.
Does anyone have any other suggestions?
thanks
when you are using a vpn you are able to authenticate using NT
authentication. This won't work over the internet. You will have to change
how you are authenticating for this to work.
If you can ftp you have connectivity.
Make the following changes
oSnap.PublisherSecurityMode = SQLINITXLib.SECURITY_TYPE.NT_AUTHENTICATION
to
oSnap.PublisherSecurityMode = SQLINITXLib.SECURITY_TYPE.DB_AUTHENTICATION
oSnap.PublisherPassword="password"
oSnap.PublisherLogin="account"
change
oSnap.DistributorSecurityMode =
SQLINITXLib.SECURITY_TYPE.NT_AUTHENTICATION
to
oSnap.DistributorSecurityMode =
SQLINITXLib.SECURITY_TYPE.DB_AUTHENTICATION
oSnap.DistributorPassword="password"
oSnap.DistributorLogin="account"
Repeat these changes everywhere you see NT_AUTHENTICATION.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"dd" <dd@.discussions.microsoft.com> wrote in message
news:BBA7CF14-42B4-417C-8C4D-A422D520EA0B@.microsoft.com...
> I am trying to setup a process in a VB.Net app that allows the user to
manually invoke a transactional replication process. This works fine on my
development machine within our network/VPN. However, when I disconnect my
machine from the VPN, the process keeps failing with a "Process could not
connect to Distributor" error. Unfortunately, our customers/users will not
be in our domain...they need to be able to connect & replicate over the
internet.
> Here is the current setup:
> Server
> Windows 2003 Server
> Sql Server 2000 (sp3)
> Client
> Windows 2000 Pro or Windows XP Pro
> MSDE
> Also...from within the network I have to use only the server's name
"MyServer" to get this to work. If I use a fully qualified name, like
"MyServer.Domain.Com" it fails with the same error.
> The server acts as both the publisher and the distributor. The
publication is set up to allow anonymous pull subscriptions via FTP. I have
a sql login that I have setup and made sure that it is in the Publications
PAL.
> I have used this example:
http://support.microsoft.com/default...;en-us;Q319648 to create
the .net process.
> From a client machine...I can access the ftp site on the server via:
> ftp Server.Domain.Com.
> I cannot get to the server with Ping or Tracert. I was told by our
network admin that the ability to Ping our server has been disabled.
> I think that this must be a server configuration problem...since I can get
the whole thing to work when I am on the network. I checked the log files
(based on a suggestion from another post) on the server...and it doesn't
even appear that a login is attempted.
> Does anyone have any other suggestions?
> thanks
|||Hilary...
Thanks for the reply. It is good to know that if I can connect via ftp I am doing something right.
Actually, I already made those changes to the example code...changing from NT to DB authentication in each place it was occuring. Though...even on our VPN, I had to change the login and password to the "sa" account so it would work.
We do have a firewall...not sure if that is the problem. And...another note...I have another application running on a PocketPC (with the .Net Compact Framework) that is successful in a merge replication over the internet without using "sa" account...and
it is on the same database I am using for my transactional one that is failing.
"Hilary Cotter" wrote:

> when you are using a vpn you are able to authenticate using NT
> authentication. This won't work over the internet. You will have to change
> how you are authenticating for this to work.
> If you can ftp you have connectivity.
> Make the following changes
> oSnap.PublisherSecurityMode = SQLINITXLib.SECURITY_TYPE.NT_AUTHENTICATION
> to
> oSnap.PublisherSecurityMode = SQLINITXLib.SECURITY_TYPE.DB_AUTHENTICATION
> oSnap.PublisherPassword="password"
> oSnap.PublisherLogin="account"
> change
> oSnap.DistributorSecurityMode =
> SQLINITXLib.SECURITY_TYPE.NT_AUTHENTICATION
> to
> oSnap.DistributorSecurityMode =
> SQLINITXLib.SECURITY_TYPE.DB_AUTHENTICATION
> oSnap.DistributorPassword="password"
> oSnap.DistributorLogin="account"
> Repeat these changes everywhere you see NT_AUTHENTICATION.
>
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "dd" <dd@.discussions.microsoft.com> wrote in message
> news:BBA7CF14-42B4-417C-8C4D-A422D520EA0B@.microsoft.com...
> manually invoke a transactional replication process. This works fine on my
> development machine within our network/VPN. However, when I disconnect my
> machine from the VPN, the process keeps failing with a "Process could not
> connect to Distributor" error. Unfortunately, our customers/users will not
> be in our domain...they need to be able to connect & replicate over the
> internet.
> "MyServer" to get this to work. If I use a fully qualified name, like
> "MyServer.Domain.Com" it fails with the same error.
> publication is set up to allow anonymous pull subscriptions via FTP. I have
> a sql login that I have setup and made sure that it is in the Publications
> PAL.
> http://support.microsoft.com/default...;en-us;Q319648 to create
> the .net process.
> network admin that the ability to Ping our server has been disabled.
> the whole thing to work when I am on the network. I checked the log files
> (based on a suggestion from another post) on the server...and it doesn't
> even appear that a login is attempted.
>
>

rep monitor setup scripts

how to you measure Latency in pull or push sub/publist architecture?
Do you have a set of scripts which use to monitor and setup the
replication environment?
If you are using SQL Server 2005 and transactional replication, please take a
look at the tracer token functionality:
http://www.replicationanswers.com/TracerTokens.asp
If not, please post back with SQL Server version and type of replication.
Rgds,
Paul Ibison
|||On Apr 30, 10:26 am, Paul Ibison <Paul.Ibi...@.Pygmalion.Com> wrote:
> If you are using SQL Server 2005 and transactional replication, please take a
> look at the tracer token functionality:http://www.replicationanswers.com/TracerTokens.asp
> If not, please post back with SQL Server version and type of replication.
> Rgds,
> Paul Ibison
We using sql 2000. please tell me for that
|||Have a look at the counters for these two processes namely the SQL Server
Replication LogReader: Delivery Latency counter and the SQL Server
Replication Dist.: Delivery Latency counter. Also the treplication monitor
reveals similar info
(http://www.informit.com/articles/article.asp?p=170748&rl=1).
Rgds,
Paul Ibison

Rendering to Excel, multiple sheets

I am rendering a report from RS that has multiple tables. After each table I
have it setup to have a page break. This causes each table to be written to
a different sheet within the excel workbook. This is fine. What I would
like to know is if there is a way to write the table name to the excel
workbook tab when the report is rendered instead of having the tabs show
sheet1, sheet2, etc. DOes anyone know how or if this can be done?
Thanks for your help,
sOn Oct 11, 10:24 am, Susan R <Sus...@.discussions.microsoft.com> wrote:
> I am rendering a report from RS that has multiple tables. After each table I
> have it setup to have a page break. This causes each table to be written to
> a different sheet within the excel workbook. This is fine. What I would
> like to know is if there is a way to write the table name to the excel
> workbook tab when the report is rendered instead of having the tabs show
> sheet1, sheet2, etc. DOes anyone know how or if this can be done?
> Thanks for your help,
> s
Several people have asked this same question on these forums w/pretty
much the same response: this is not currently possible in SSRS. Sorry
that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi,
I never tried it my myself, but facing the same problem I found
http://www.spacefold.com/lisa/post/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx
Seems to do the job, but is a little tricky to setup and works only for
excel 2003 and newer.
Simon
"Susan R" wrote:
> I am rendering a report from RS that has multiple tables. After each table I
> have it setup to have a page break. This causes each table to be written to
> a different sheet within the excel workbook. This is fine. What I would
> like to know is if there is a way to write the table name to the excel
> workbook tab when the report is rendered instead of having the tabs show
> sheet1, sheet2, etc. DOes anyone know how or if this can be done?
> Thanks for your help,
> s