Using MSDE 2000 SP3
Sql Server 2000 SP3
Win XP Pro SP1
Microsoft.Jet.OLEDB.4.0
We have recently upgraded field laptops from Windows 2000 to XP Pro. One of our applications which was developed with Visual C++ 6.0 and using MSDE will just drop it's connection to our consolidated Sql Server 2000. This works on Windows 2000 machines.
I have ran the profiler, monitored Sql Processes for locks, checked Event logs and I am unable to find any type of error. Our sync process just drops off. I am uncertain if it is MSDE, Sql Server or XP.
I even set the application's compatiability settings to Windows 2000 but still same result. I am uncertain as to how to do anymore troubleshooting.
Any ideas would be much appreciated.
Thanks,
Vannie Keever
SQL Server (including the MSDE edition) cannot close a connection by itself
except when shutting down. The client, the OS, or the network has to tell
SQL Server to drop the connection. Try a netmon trace to get more details.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
sql
Showing posts with label laptops. Show all posts
Showing posts with label laptops. Show all posts
Friday, March 30, 2012
MSDE Subscriber names
I plan to set up merge replication and have laptops with an MSDE
subscription for replication. I want my application to use the database
name and wondered if I can (and should?) have the same database name on both
the laptop and the main publication. Thanks.
David
It helps to identify the subscriber database, but there is no real
requirement. All the subscribers should have the same database name if you
are publishing to multiple subscribers at once.
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
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:%23KWrAVCpFHA.320@.TK2MSFTNGP09.phx.gbl...
> I plan to set up merge replication and have laptops with an MSDE
> subscription for replication. I want my application to use the database
> name and wondered if I can (and should?) have the same database name on
both
> the laptop and the main publication. Thanks.
> David
>
subscription for replication. I want my application to use the database
name and wondered if I can (and should?) have the same database name on both
the laptop and the main publication. Thanks.
David
It helps to identify the subscriber database, but there is no real
requirement. All the subscribers should have the same database name if you
are publishing to multiple subscribers at once.
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
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:%23KWrAVCpFHA.320@.TK2MSFTNGP09.phx.gbl...
> I plan to set up merge replication and have laptops with an MSDE
> subscription for replication. I want my application to use the database
> name and wondered if I can (and should?) have the same database name on
both
> the laptop and the main publication. Thanks.
> David
>
Wednesday, March 28, 2012
MSDE sp3 install problems
I recently had to install 40 german NT 4 laptops with MSDE sp3.
I prepared a setup.ini file:
[Options]
DATADIR="C:\Programme\Microsoft SQL Server\"
TARGETDIR="C:\Programme\Microsoft SQL Server\"
SAPWD="AStrongPwd"
SECURITYMODE=SQL
and installed most of them sucessfully. Some of them I installed via network, some of them were installed from CD. I tested each installation by copying a prepared database into the data directory and tried to connect to this database using the specified sapwd and found out
When i installed from CD, I could connect to the databases.
Some of the network installs produce a logon failure. it looks like the sapwd was ignored during install - I could not figure out, which password was used, I uninstalled it and reinstalled from CD.
Does anyone know what's the reason for this behaviour?
Thanks,
clothildeGet any information from SQLSTP.LOG on those failed installations for this behaviour.
I prepared a setup.ini file:
[Options]
DATADIR="C:\Programme\Microsoft SQL Server\"
TARGETDIR="C:\Programme\Microsoft SQL Server\"
SAPWD="AStrongPwd"
SECURITYMODE=SQL
and installed most of them sucessfully. Some of them I installed via network, some of them were installed from CD. I tested each installation by copying a prepared database into the data directory and tried to connect to this database using the specified sapwd and found out
When i installed from CD, I could connect to the databases.
Some of the network installs produce a logon failure. it looks like the sapwd was ignored during install - I could not figure out, which password was used, I uninstalled it and reinstalled from CD.
Does anyone know what's the reason for this behaviour?
Thanks,
clothildeGet any information from SQLSTP.LOG on those failed installations for this behaviour.
Monday, March 26, 2012
MSDE refuses to install
I have installed MSDE2000 on several new laptops and wrokstations but for
some reason, I have one new sony vaio that the msde installer gets so far
and then rolls itself back. The event viewer just says that it failed to
install event ID 11708. I am logged in with administrator account and have
shared both hard drives. I am at loss for an answer.
Robert woke up on Fri, 10 Sep 2004 20:39:11 GMT and sat in
microsoft.public.sqlserver.msde writing in message
news:O6NU7Y3lEHA.2680@.TK2MSFTNGP15.phx.gbl
> I have installed MSDE2000 on several new laptops and wrokstations but
> for some reason, I have one new sony vaio that the msde installer gets
> so far and then rolls itself back. The event viewer just says that it
> failed to install event ID 11708. I am logged in with administrator
> account and have shared both hard drives. I am at loss for an answer.
I just downloaded the newer version MSDE2000A and it installed when I
provided the SAPWD.
some reason, I have one new sony vaio that the msde installer gets so far
and then rolls itself back. The event viewer just says that it failed to
install event ID 11708. I am logged in with administrator account and have
shared both hard drives. I am at loss for an answer.
Robert woke up on Fri, 10 Sep 2004 20:39:11 GMT and sat in
microsoft.public.sqlserver.msde writing in message
news:O6NU7Y3lEHA.2680@.TK2MSFTNGP15.phx.gbl
> I have installed MSDE2000 on several new laptops and wrokstations but
> for some reason, I have one new sony vaio that the msde installer gets
> so far and then rolls itself back. The event viewer just says that it
> failed to install event ID 11708. I am logged in with administrator
> account and have shared both hard drives. I am at loss for an answer.
I just downloaded the newer version MSDE2000A and it installed when I
provided the SAPWD.
Monday, February 20, 2012
MSDE for replication on both ends?
We are designing an application that will use merge replication from a
wireless laptop back to a server. Plan on using MSDE on the laptops, can the
central P.C. that will be on the other end use the MSDE also, or does one of
them need to be full blown SQL Server?
Thanks,
Steve
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
"SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
news:CF01E337-7EC0-4879-816C-D572F86A8131@.microsoft.com...
> We are designing an application that will use merge replication from a
> wireless laptop back to a server. Plan on using MSDE on the laptops, can
the
> central P.C. that will be on the other end use the MSDE also, or does one
of
> them need to be full blown SQL Server?
> Thanks,
> Steve
|||It can be used as a publisher or subscriber with merge replication - so it
should work for you.
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
"SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
news:CF01E337-7EC0-4879-816C-D572F86A8131@.microsoft.com...
> We are designing an application that will use merge replication from a
> wireless laptop back to a server. Plan on using MSDE on the laptops, can
the
> central P.C. that will be on the other end use the MSDE also, or does one
of
> them need to be full blown SQL Server?
> Thanks,
> Steve
|||Thanks for your information again Hilary.
We have some current applications with MSDE doing Merge replication back to
our servers running MS SQL. So we do have experience setting up and
maintaining it. We just had not set one up with the MSDE on both ends. You
lose having Enterprise Manager in the mix I guess, but we should be able to
plug the laptops into our network here and use Enterprise Manager from my
workstation to set up the publications and subscriptions on the laptops.
Thanks,
Steve
"Hilary Cotter" wrote:
> It can be used as a publisher or subscriber with merge replication - so it
> should work for you.
> --
> 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
> "SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
> news:CF01E337-7EC0-4879-816C-D572F86A8131@.microsoft.com...
> the
> of
>
>
wireless laptop back to a server. Plan on using MSDE on the laptops, can the
central P.C. that will be on the other end use the MSDE also, or does one of
them need to be full blown SQL Server?
Thanks,
Steve
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
"SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
news:CF01E337-7EC0-4879-816C-D572F86A8131@.microsoft.com...
> We are designing an application that will use merge replication from a
> wireless laptop back to a server. Plan on using MSDE on the laptops, can
the
> central P.C. that will be on the other end use the MSDE also, or does one
of
> them need to be full blown SQL Server?
> Thanks,
> Steve
|||It can be used as a publisher or subscriber with merge replication - so it
should work for you.
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
"SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
news:CF01E337-7EC0-4879-816C-D572F86A8131@.microsoft.com...
> We are designing an application that will use merge replication from a
> wireless laptop back to a server. Plan on using MSDE on the laptops, can
the
> central P.C. that will be on the other end use the MSDE also, or does one
of
> them need to be full blown SQL Server?
> Thanks,
> Steve
|||Thanks for your information again Hilary.
We have some current applications with MSDE doing Merge replication back to
our servers running MS SQL. So we do have experience setting up and
maintaining it. We just had not set one up with the MSDE on both ends. You
lose having Enterprise Manager in the mix I guess, but we should be able to
plug the laptops into our network here and use Enterprise Manager from my
workstation to set up the publications and subscriptions on the laptops.
Thanks,
Steve
"Hilary Cotter" wrote:
> It can be used as a publisher or subscriber with merge replication - so it
> should work for you.
> --
> 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
> "SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
> news:CF01E337-7EC0-4879-816C-D572F86A8131@.microsoft.com...
> the
> of
>
>
Subscribe to:
Posts (Atom)