Issues with MSDE after installing WMSDE, WSUS

I have a stable 3rd party application which has been running on MSDE Sp3 (ver
2000.80.760.0) as the default instance. I installed WSUS, which apparently
uses WMSDE (version 2000.80.884.0), as a named instance. After this
installation I noticed that the original SQL server has a memory leak,
consuming the resources of the server over a few hours.
I upgraded (replaced) the Sp3 default instance with Sp4 (version
2000.80.2039.0). Howeveer the problem seems to be continuing. Is it wise to
have these 2 different database versions running on the same machine or
should I separate/amalgamate them?
TIA
hi,
Lance wrote:
> I have a stable 3rd party application which has been running on MSDE
> Sp3 (ver 2000.80.760.0) as the default instance. I installed WSUS,
> which apparently uses WMSDE (version 2000.80.884.0), as a named
> instance. After this installation I noticed that the original SQL
> server has a memory leak, consuming the resources of the server over
> a few hours.
> I upgraded (replaced) the Sp3 default instance with Sp4 (version
> 2000.80.2039.0). Howeveer the problem seems to be continuing. Is it
> wise to have these 2 different database versions running on the same
> machine or should I separate/amalgamate them?
> TIA
WMSDE is a modified version of MSDE that enables db size larger then 2gb per
database, that is one of the constraints/limitations of "standard" MSDE, and
is provided for SharePoint, AFAIK..
unfortunately no sp4 for this edition has still been provided, even if it
has been promised...
Andrea Montanari
http://www.asql.biz/DbaMgr.shtm
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Issues with moving existing single production server setup to a New Cluster installation

According to the documentation the chosen Cluster name and IP address need
to be unused before installing the cluster. The IP address is not a problem,
but it will be a difficult task with the Cluster Name as the business
processes have many scripts, DTS packages, stored procedures and views that
have the production server name hard coded. There are many other servers
involved for updating and transferring data, so there was no way around it
and I would like to keep it that way if possible.
Therefore, my question is how can I reuse the production server name for the
cluster without jeopardising the Cluster installation ?
Hello,
You may need to rename the current production server name "ServerA" to
another name before installing virtual server. After that, you could reuse
the name "ServerA" as the virtual server name.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
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.
|||You can't, however there are a lot of workarounds. If you are in an AD/DNS
envorinment, you can create an alias record that points the old name to the
new server. You can also set up a SQL alias on each client, but that is
generally harder.
Geoff N. Hiten
Microsoft SQL Server MVP
"GMG" <nospam@.nospam.com> wrote in message
news:uNQ4jV6dFHA.4060@.TK2MSFTNGP10.phx.gbl...
> According to the documentation the chosen Cluster name and IP address need
> to be unused before installing the cluster. The IP address is not a
> problem,
> but it will be a difficult task with the Cluster Name as the business
> processes have many scripts, DTS packages, stored procedures and views
> that
> have the production server name hard coded. There are many other servers
> involved for updating and transferring data, so there was no way around it
> and I would like to keep it that way if possible.
> Therefore, my question is how can I reuse the production server name for
> the
> cluster without jeopardising the Cluster installation ?
>

issues w/SQL clustering in NT4 domain

does anybody aware of any issues when installing SQL2K in NT4 domain? Help is greatly appreciated.
sorry, forgat to add: using MSCS on W2k3 servers
-- igor_gonik@.dell.com wrote: --
does anybody aware of any issues when installing SQL2K in NT4 domain? Help is greatly appreciated.
|||Nope.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||It should work
Rand
This posting is provided "as is" with no warranties and confers no rights.

Issue installing SQL Server Express on Visual Studio Beta 2

Hi,

I have installed VS 2005 Beta 2 (Team System) using a DVD available from MS TEch Ed. This also installs SQL Server 2005 Express edition along with other tools. This installation is done on a vpc.

However when I try to install SQL Server Express Manager over this installation, I get "The installer package could not be opened. Contact the vendor to make sure to verify that the Windows installer package is valid".

Is there a solution to get this resolved ?

Thanks in advance !
It likely that you need to download the file again. Also not that you may need to uninstall the .Net Framework and re-install the version that SQL Server shipped in its June CTP as the NetFx version between Vs Beta 2 and SQL CTP June is different.

-Euan

Issue installing SQL 2000 Enterprise

I need some help, I am attempting to install SQL 2k Enterprise and nothing is happening. When I attempt to start the installation again, I get a message of "Another instance is already running."

Can anyone help me with this? I need to have this installed tonight for work I need to do tomorrow.

Thanks

the error message says that Setp/Autorun is already running. What is the OS on this box. You need to have server version to install Enterprise Edition of SQL Server. If the os is not Server version(windows 2000 server/2003/NT) you can only install Client tool

Madhu

|||

I faced this type of issue before because the installation was aborted in the middle abnormally. And when i started it again it said another instance is already running. But after restarting the server it was thru.

Not sure if that is the same case with you...

Issue installing SQL 2000 Enterprise

I need some help, I am attempting to install SQL 2k Enterprise and nothing is happening. When I attempt to start the installation again, I get a message of "Another instance is already running."

Can anyone help me with this? I need to have this installed tonight for work I need to do tomorrow.

Thanks

the error message says that Setp/Autorun is already running. What is the OS on this box. You need to have server version to install Enterprise Edition of SQL Server. If the os is not Server version(windows 2000 server/2003/NT) you can only install Client tool

Madhu

|||

I faced this type of issue before because the installation was aborted in the middle abnormally. And when i started it again it said another instance is already running. But after restarting the server it was thru.

Not sure if that is the same case with you...