Not a valid Win32 application

New to SQL Server installations. I downloaded the SQL Server Express with Advanced; when I double click the Setup.exe, I get a pop-up "document path/file is not a valid Win32 application". I upgraded from XP Home to XP Pro SP2.0. Any suggestions?Seems like the downloaded exe is corrupt. Download it again.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Non-standard port through router

Here's my setup. I have an SQL server machine with a local LAN ip. I have
a router with an internet IP. I configured the router to pass external port
5000 through to the sql machine's ip on port 1433. When I try to connect to
the sql server using the router's IP and port 5000 I get a timeout. I can
telnet to the router's IP and port 5000 (get a blank screen, but connection
succeeds).
Does anyone know why I would be getting a timeout? If I (internaly) connect
to the sql machine's local LAN IP port 1433 I can access the SQL server with
no problems.
Hi Lee,
If you get a blank black screen from telnet <MachineName>_or_<IP> <Port
Number>, then you have succeeded in connecting over TCP/IP to the ROUTER
port. We are not able to say it connects to SQL Server's TCP/IP port
successfully. I still think your mapping in router is not configured
correctly.
Secondly, what client tools you used to connect SQL Server? Query Analyzer?
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
sql

Non sharing data cluster

Hi:

I'm trying to setup a MS Cluster but I don't know if it is feasible to
configure it in the way I think.

I have two machines with win2k server and MSSQL-2000 one of them is
currently performing as the production database and the other one is
the backup. The secondary one is keeping updated via the "Log
Shipping" technic.

We almost covered all the other possible failures of the other
components (ie: network, power, application servers, etc), the data is
maintaned in a raid which is ok but we want to cover also the
possibility of that failure too (yes, you can call us paranoids!! ).

The thing is we want to create a cluster that do not share the data,
but each machine of the cluster have thei own set of the same data.

My intention is to configure the cluster to detect a failure of one
machine and initiate the failover to the remaing one using the
appropiate scripts related to the promotion of a secondary server
keeped updateusing "log shipping".

Have anyone some experience with that kind of solution ??

Thanks in advance

Leonardo"Leonardo C" <lcomunia@.hotmail.com> wrote in message
news:fcc135d.0406150953.6fecf39a@.posting.google.co m...
> Hi:
> I'm trying to setup a MS Cluster but I don't know if it is feasible to
> configure it in the way I think.
> I have two machines with win2k server and MSSQL-2000 one of them is
> currently performing as the production database and the other one is
> the backup. The secondary one is keeping updated via the "Log
> Shipping" technic.
> We almost covered all the other possible failures of the other
> components (ie: network, power, application servers, etc), the data is
> maintaned in a raid which is ok but we want to cover also the
> possibility of that failure too (yes, you can call us paranoids!! ).
> The thing is we want to create a cluster that do not share the data,
> but each machine of the cluster have thei own set of the same data.
> My intention is to configure the cluster to detect a failure of one
> machine and initiate the failover to the remaing one using the
> appropiate scripts related to the promotion of a secondary server
> keeped updateusing "log shipping".
> Have anyone some experience with that kind of solution ??
> Thanks in advance
> Leonardo

I don't believe that's possible with a true cluster - in a cluster, if one
node goes down, its resources are immediately taken over by another node. A
cluster is intended for when you need absolute minimum downtime, but if you
can take the time to apply log shipping scripts, then I guess for you some
downtime is acceptable. In that case, why not just continue to use log
shipping?

But I must admit that I've never used clustering myself, so you might want
to post in microsoft.public.sqlserver.clustering to see if you can get some
more specific comments.

Simon|||Hi Simon:

Thanks for your response. Yes a minimum downtime is acceptable but as Log
Shipping needs a manual intervention a cluster can be the piece to automate
that part.
I'm forwarding this post to the Microsoft groups too, I'm not getting the
other one mentioned by you.

Maybe somebody knows how to automate this, without needing a Cluster.

"Simon Hayes" <sql@.hayes.ch> wrote in message
news:40cf3cc6$1_3@.news.bluewin.ch...
> "Leonardo C" <lcomunia@.hotmail.com> wrote in message
> news:fcc135d.0406150953.6fecf39a@.posting.google.co m...
> > Hi:
> > I'm trying to setup a MS Cluster but I don't know if it is feasible to
> > configure it in the way I think.
> > I have two machines with win2k server and MSSQL-2000 one of them is
> > currently performing as the production database and the other one is
> > the backup. The secondary one is keeping updated via the "Log
> > Shipping" technic.
> > We almost covered all the other possible failures of the other
> > components (ie: network, power, application servers, etc), the data is
> > maintaned in a raid which is ok but we want to cover also the
> > possibility of that failure too (yes, you can call us paranoids!! ).
> > The thing is we want to create a cluster that do not share the data,
> > but each machine of the cluster have thei own set of the same data.
> > My intention is to configure the cluster to detect a failure of one
> > machine and initiate the failover to the remaing one using the
> > appropiate scripts related to the promotion of a secondary server
> > keeped updateusing "log shipping".
> > Have anyone some experience with that kind of solution ??
> > Thanks in advance
> > Leonardo
> I don't believe that's possible with a true cluster - in a cluster, if one
> node goes down, its resources are immediately taken over by another node.
A
> cluster is intended for when you need absolute minimum downtime, but if
you
> can take the time to apply log shipping scripts, then I guess for you some
> downtime is acceptable. In that case, why not just continue to use log
> shipping?
> But I must admit that I've never used clustering myself, so you might want
> to post in microsoft.public.sqlserver.clustering to see if you can get
some
> more specific comments.
> Simon

No tables in merge replication

Hi, I have setup a publication that my program on my CE device will
synchronize to. It connects and downloads the database fine, and the database
file shows that data has been downloaded. But when I try to run SQL
statements against the database, it says that the tables are not there. I
also used the Query Analyzer that is installed on the machine when using
vs.net, and it does not show any tables, either. I was wondering if there was
something that I was doing wrong when setting up the publication.
Thanks
Daniel Robinson
This is highly abnormal. Can you possibly post your code here?
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
"Daniel Robinson" <DanielRobinson@.discussions.microsoft.com> wrote in
message news:72C63D6C-6F68-416E-AC16-8BE0A8B94CD9@.microsoft.com...
> Hi, I have setup a publication that my program on my CE device will
> synchronize to. It connects and downloads the database fine, and the
database
> file shows that data has been downloaded. But when I try to run SQL
> statements against the database, it says that the tables are not there. I
> also used the Query Analyzer that is installed on the machine when using
> vs.net, and it does not show any tables, either. I was wondering if there
was
> something that I was doing wrong when setting up the publication.
> Thanks
> Daniel Robinson
|||I don't think it's a problem with my code. We had a publication setup for
another database, and that was working. All I did in the code was change the
publication name.
Daniel
"Hilary Cotter" wrote:

> This is highly abnormal. Can you possibly post your code here?
> --
> 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
> "Daniel Robinson" <DanielRobinson@.discussions.microsoft.com> wrote in
> message news:72C63D6C-6F68-416E-AC16-8BE0A8B94CD9@.microsoft.com...
> database
> was
>
>
|||Here is the SQL that I used to create the publication:
EXEC sp_replicationdboption @.dbname='daniel', @.optname='merge publish',
@.value='true'
EXEC sp_addmergepublication @.publication='uadd_AMSSchool_Daniel',
@.allow_pull='true', @.allow_push='false',
@.allow_anonymous='true', @.enabled_for_internet='true',
@.snapshot_in_defaultfolder='false', @.alt_snapshot_folder='C:\SqlPublication',
@.compress_snapshot='false', @.sync_mode='character', @.retention=60,
@.conflict_retention=60, @.allow_synctoalternate='true',
@.keep_partition_changes='true'
EXEC sp_addpublication_snapshot @.publication='uadd_AMSSchool_Daniel',
@.frequency_type=8, @.frequency_interval=1,
@.frequency_subday=1, @.frequency_subday_interval=1,
@.frequency_recurrence_factor=1
EXEC sp_grant_publication_access @.publication='uadd_AMSSchool_Daniel',
@.login='sa'
EXEC sp_addmergearticle @.publication='uadd_AMSSchool_Daniel',
@.article='mytable', @.source_object='mytable', @.source_owner='dbo',
@.type='table', @.destination_owner='dbo', @.column_tracking='true',
@.force_invalidate_snapshot=1, @.vertical_partition='true'
EXEC sp_mergearticlecolumn @.publication='uadd_AMSSchool_Daniel',
@.article='mytable', @.column='myname', @.operation='add',
@.schema_replication='true', @.force_invalidate_snapshot=1,
@.force_reinit_subscription=1
EXEC sp_mergearticlecolumn @.publication='uadd_AMSSchool_Daniel',
@.article='mytable', @.column='myint', @.operation='add',
@.schema_replication='true', @.force_invalidate_snapshot=1,
@.force_reinit_subscription=1
I do get a warning that only Subscribers running SQL Server 2000 can
synchronize with the publication...and I am running sqlCE. You think this
might be causing a problem?
Thanks
Daniel
"Hilary Cotter" wrote:

> This is highly abnormal. Can you possibly post your code here?
> --
> 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
> "Daniel Robinson" <DanielRobinson@.discussions.microsoft.com> wrote in
> message news:72C63D6C-6F68-416E-AC16-8BE0A8B94CD9@.microsoft.com...
> database
> was
>
>

No sync - No Initialize & scripts

If you restore the db you plan to replicate to another server, and then setup Trans. Repl. with immediate update, without doing a Snapshot Initialization (Taking the option that says data & schema are already there)
how do the scripts get created?
The scripts that will do the insert/update/delete (sp_msdel_tbl1, sp_msdel_tbl2, etc.)?
Thanx!
JLS
In SQL2000, you need to call sp_scriptpublicationcustomprocs to generate a script for creating the sp_MSins|del|upd procedures at the subscriber and then call sp_MSaddsynctrigger for each article at the subscriber to create the immediate updating triggers. The following kb has more details on this:
http://support.microsoft.com/default...b;en-us;320499
In SQL2005 (publisher), we create the replication system objects for you automatically if you use 'replication support only' or 'initialize with backup' as the @.sync_method in sp_addsubscription (SQL2005 Management Studio will use "replication support only" if you choose not to initialize data\schema)
-Raymond
"JLS" <jlshoop@.hotmail.com> wrote in message news:eTe%23PyJ5FHA.3276@.TK2MSFTNGP10.phx.gbl...
If you restore the db you plan to replicate to another server, and then setup Trans. Repl. with immediate update, without doing a Snapshot Initialization (Taking the option that says data & schema are already there)
how do the scripts get created?
The scripts that will do the insert/update/delete (sp_msdel_tbl1, sp_msdel_tbl2, etc.)?
Thanx!
JLS
|||It is Sql 2000, Thanx for the link to the kb! You're a great help!!!
"Raymond Mak [MSFT]" <rmak@.online.microsoft.com> wrote in message news:uSamV6J5FHA.2524@.TK2MSFTNGP10.phx.gbl...
In SQL2000, you need to call sp_scriptpublicationcustomprocs to generate a script for creating the sp_MSins|del|upd procedures at the subscriber and then call sp_MSaddsynctrigger for each article at the subscriber to create the immediate updating triggers. The following kb has more details on this:
http://support.microsoft.com/default...b;en-us;320499
In SQL2005 (publisher), we create the replication system objects for you automatically if you use 'replication support only' or 'initialize with backup' as the @.sync_method in sp_addsubscription (SQL2005 Management Studio will use "replication support only" if you choose not to initialize data\schema)
-Raymond
"JLS" <jlshoop@.hotmail.com> wrote in message news:eTe%23PyJ5FHA.3276@.TK2MSFTNGP10.phx.gbl...
If you restore the db you plan to replicate to another server, and then setup Trans. Repl. with immediate update, without doing a Snapshot Initialization (Taking the option that says data & schema are already there)
how do the scripts get created?
The scripts that will do the insert/update/delete (sp_msdel_tbl1, sp_msdel_tbl2, etc.)?
Thanx!
JLS