Instances of SQL

Hi,

Is it possible to install more than one instance of SQL on the same server?
I am thinking of the SQL that comes with Windows 2003 SBS (Small business)

--
Thank you
Please post onlyYes. Sql2k supports named instances.

http://msdn.microsoft.com/library/e...nstall_259u.asp

"!!bogus" <hello@.microb.com> wrote in message
news:Dwavc.95442$tb4.3789522@.news20.bellglobal.com ...
> Hi,
> Is it possible to install more than one instance of SQL on the same server?
> I am thinking of the SQL that comes with Windows 2003 SBS (Small business)
> --
> Thank you
> Please post only|||"!!bogus" <hello@.microb.com> wrote in message news:<Dwavc.95442$tb4.3789522@.news20.bellglobal.com>...
> Hi,
> Is it possible to install more than one instance of SQL on the same server?
> I am thinking of the SQL that comes with Windows 2003 SBS (Small business)

SQL2000 supports multiple instances (see Books Online), but you need
to consider the impact on the server resources - you will need to
manage CPU and memory carefully to give each instance enough to work
with, as well as leaving enough for the OS and other applications. I
don't know anything about SBS specifically, but my feeling would be
that since SBS already installs a bunch of different applications on
the same server, you probably don't want to add the complexity of
multiple MSSQL instances.

Depending on what you want to achieve, you might want to look at MSDE,
which is a free version of MSSQL with some limitations:

http://www.microsoft.com/sql/msde/

Simon

instances of MSDE

I can install instances of MSDE without any problem. But
for some reasons the password (or the instance) get
corrupted after I try to upsize a table from MS Access to
an existing database in MSDE (I'll stop doing this).
But now I have multiple instances which I would like to
clean up. Does anybody know how to uninstall them?
Thanks
Perry
Hi ,
You can use the following information to uninstall msde.
A)Remove the following registry:
1) Remove the following ID_Number from your MSDE 2.0 instance
HKEY_CLASSES_ROOT\Installer\Products\ID_Number
-- It has key value name 'ProductName' which displays the instance name.
For example, "ProductName" = Microsoft SQL Server Desktop Engine
(MYINSTANCE)
2)If you had patch applied on this MSDE 2.0 instance, you need to remove
ID_Number
for that MSDE 2.0 instance:
HKEY_CLASSES_ROOT\Installer\Patches\ID_Number
3) For MSDE 2.0 Default instance, remove
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\Your_instance_name
4)If you have the following key points to MSDE 2.0 productGUID, then remove
the
InstanceComponentSet.x
For example, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\Component
SetInstanceComponentSet.x
-- For example, InstanceComponentSet.1 the has value matching the
productGUID of
sqlrun01.msi.
5)Remove :
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Uninstall\Produ
ctGUID
-- the Product GUID which refers to your MSDE 2.0 instance.
6)Remove the Sql server service key:
For MSDE 2.0 default instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQLServer
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQL$Your_Instance_Nam
e
7)Remove the Sql server agent service key:
For MSDE 2.0 default instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\SQLServerAgent
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\SQLAgent$Your_Instance_
Name
B)Remove the MSDE 2.0 instance data and program install directory:
For example, G:\Program Files\Microsoft SQL
Server\MSSQL$Your_instanceName\data
For example, G:\Program Files\Microsoft SQL
Server\MSSQL$Your_instanceName\binn
Now rerun the msde setup from the command prompt
Girish Sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.

Instance specified not valid

Hi,

I'm trying to install MSDE SP3 which I downloaded from MS at http://www.asp.net/msde/.
Following the instructions as best I can I unzipped the file into a Folder now called MSDE located on C: I then went to a command prompt and typed in the command given to start the install:

setup SAPWD=testsite SecurityMode=SQL

Hit enter and the installer started up and ran for a few secs and then came back with

The Instance named specified is invalid

There was no mention of including an instance name or the format for it.

Suggestions please?

Also, if I want to completly uninstall MSDE if I need to how would I do it?

Thanks,
BobWell, I had this message come up if I tried to run setup for the instance that was already on the system.

I used this setup to install msde on my machine.

setup instancename="netsdk" sapwd="your password for sa" securitymode=sql

Reason for using instance name netsdk was that it seems that SDK kit needs this instance to install pubs and nwind database.

After executing this i did not get any error messages but when I started service manager I could not see any servers listed. It took me solid two hours to come up with idea to look into error log and there it was.

2004-03-09 11:57:44.50 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2004-03-09 11:57:44.50 server Copyright (C) 1988-2002 Microsoft Corporation.
2004-03-09 11:57:44.50 server All rights reserved.
2004-03-09 11:57:44.50 server Server Process ID is 3456.
2004-03-09 11:57:44.50 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$NETSDK\LOG\ERRORLOG'.
2004-03-09 11:57:44.52 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2004-03-09 11:57:44.63 server SQL Server configured for thread mode processing.
2004-03-09 11:57:44.63 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2004-03-09 11:57:44.63 spid2 Warning ******************
2004-03-09 11:57:44.63 spid2 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-03-09 11:57:44.63 spid2 Starting up database 'master'.
2004-03-09 11:57:44.98 spid5 Starting up database 'model'.
2004-03-09 11:57:44.98 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-03-09 11:57:45.03 spid2 Server name is 'PC0491-EPITKA\NETSDK'.
2004-03-09 11:57:45.03 spid2 Skipping startup of clean database id 5
2004-03-09 11:57:45.03 spid2 Skipping startup of clean database id 6
2004-03-09 11:57:45.03 spid2 Starting up database 'msdb'.
2004-03-09 11:57:45.17 server SQL server listening on Shared Memory.
2004-03-09 11:57:45.17 server SQL Server is ready for client connections
2004-03-09 11:57:45.38 spid5 Clearing tempdb database.
2004-03-09 11:57:46.12 spid5 Starting up database 'tempdb'.
2004-03-09 11:57:46.20 spid2 Recovery complete.
2004-03-09 11:57:46.20 spid2 SQL global counter collection task is created.
2004-03-09 11:57:46.22 spid2 Warning: override, autoexec procedures skipped.
2004-03-09 11:57:56.94 spid51 Error: 15457, Severity: 0, State: 1
2004-03-09 11:57:56.94 spid51 Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install..
2004-03-09 11:57:57.08 spid51 Error: 15457, Severity: 0, State: 1
2004-03-09 11:57:57.08 spid51 Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install..
2004-03-09 11:57:57.34 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.

There is a line that says servername, I typed it in and I was able to start service. Log should be under c:\program files\microsoft sql server\mssql${your instance name}\log.

I am very new to windows world since I worked on Unix platform for past six years, so for you gurus out there this migth be something that does not need to be explained. Anyway I hope this helps.sql

instance of sql server

I am learning SQL Server 2005 and I was told to install a second instance of
SQL Server 2005 on my machine. How can I install a second instance of SQL
Server 2005 on my machine

I already installed SQL Server 2005, I guess this is my first instance. To
install a second instance, do I just run setup again?Yes, just run setup again to create a 'named' instance. Setup will ask you
for an instance name.

A computer can have up to 1 default instance (probably what you installed
initially) but many named instances. To connect to the default instance
after installation, specify only the computer name. For the named instance,
specify computer name and instance name separated by a backslash
('ComputerName\InstanceName').

--
Hope this helps.

Dan Guzman
SQL Server MVP

"David" <david_vcp@.hotmail.com> wrote in message
news:bMKdnc_BtsngZ9fZRVn-rg@.comcast.com...
>I am learning SQL Server 2005 and I was told to install a second instance
>of SQL Server 2005 on my machine. How can I install a second instance of
>SQL Server 2005 on my machine
> I already installed SQL Server 2005, I guess this is my first instance.
> To install a second instance, do I just run setup again?

Instance NetSDK

Dear
I have a question about SQL Server / MSDE. Iâ'm trying install and to configure the documentation of the .NET Framework 1.1 but I have a problem because is necessary contain a instance: â'Local\NetSDKâ' (Local is the same the principal instance) second information about details of the configuration
Iâ'm working with Microsoft SQL Server 2000 â' Personal Edition and I have listed in SQL Server Service Manager only: â'Localâ'
How I make to create the instance: â'NetSDKâ'
Your
ThankI'm not sure why that SDK needs an instance of SQL Server with that
particular name, but I'd have thought it would create the instance during
it's installation...
Anyway, to create a named instance of SQL Server, you have to install it
again & you get the chance to provide the instance name during the
installation process.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Rogério Toledo" <anonymous@.discussions.microsoft.com> wrote in message
news:B75B10E3-3740-45BC-93D5-39158618C2D1@.microsoft.com...
> Dear,
> I have a question about SQL Server / MSDE. I'm trying install and to
configure the documentation of the .NET Framework 1.1 but I have a problem
because is necessary contain a instance: "Local\NetSDK" (Local is the same
the principal instance) second information about details of the
configuration.
> I'm working with Microsoft SQL Server 2000 - Personal Edition and I have
listed in SQL Server Service Manager only: "Local".
> How I make to create the instance: "NetSDK"?
> Yours
> Thanks
>

Instance name

I have two machines install SQL Server 2000.
One has the same name as my machine name, eg. alan.
Another machine has the name as 'Local'.
Why is that the case ?Alan
> Another machine has the name as 'Local'.
> Why is that the case ?
A person, who installed SQL Server specified LOCAL as name of the SQL Server
If you want to change the name ,just delete the registration from EM and
create a new one with name of the machine
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>I have two machines install SQL Server 2000.
> One has the same name as my machine name, eg. alan.
> Another machine has the name as 'Local'.
> Why is that the case ?
>|||How do I create a new one with name of the machine when setup ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
> Alan
> A person, who installed SQL Server specified LOCAL as name of the SQL
> Server
> If you want to change the name ,just delete the registration from EM and
> create a new one with name of the machine
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>|||Hi,
I really don't understand why I installed SQL Server 2000 on 2 machines, one
in my office, one at home, why one has the machine name, eg. "alan", at my
office. But on my home machine, the server instance is called "LOCAL"?
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eixndxxoGHA.1600@.TK2MSFTNGP04.phx.gbl...
> How do I create a new one with name of the machine when setup ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
>

instance name

Hi,

I just install msde SQL2kdesksp3.exe and also WebMatrix.To use WebMatrix and manage database, i need something like: myservername\instancename to connect but how do i know my instance name ?i found, i needed to reboot. actually i can connect with my SERVERNAME but can i use my IP address instead SERVERNAME cause i would like to connect remotly. MSDE and Webmatrix are installed in my Windows 2003 Server and i would like to connect that database remotly.

Is it possible ?|||fixed

Instance name

I have two machines install SQL Server 2000.
One has the same name as my machine name, eg. alan.
Another machine has the name as 'Local'.
Why is that the case ?Alan
> Another machine has the name as 'Local'.
> Why is that the case ?
A person, who installed SQL Server specified LOCAL as name of the SQL Server
If you want to change the name ,just delete the registration from EM and
create a new one with name of the machine
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>I have two machines install SQL Server 2000.
> One has the same name as my machine name, eg. alan.
> Another machine has the name as 'Local'.
> Why is that the case ?
>|||How do I create a new one with name of the machine when setup ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
> Alan
>> Another machine has the name as 'Local'.
>> Why is that the case ?
> A person, who installed SQL Server specified LOCAL as name of the SQL
> Server
> If you want to change the name ,just delete the registration from EM and
> create a new one with name of the machine
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>>I have two machines install SQL Server 2000.
>> One has the same name as my machine name, eg. alan.
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>|||Hi,
I really don't understand why I installed SQL Server 2000 on 2 machines, one
in my office, one at home, why one has the machine name, eg. "alan", at my
office. But on my home machine, the server instance is called "LOCAL"?
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eixndxxoGHA.1600@.TK2MSFTNGP04.phx.gbl...
> How do I create a new one with name of the machine when setup ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
>> Alan
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>> A person, who installed SQL Server specified LOCAL as name of the SQL
>> Server
>> If you want to change the name ,just delete the registration from EM and
>> create a new one with name of the machine
>>
>> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>>I have two machines install SQL Server 2000.
>> One has the same name as my machine name, eg. alan.
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>>
>

installtion program dies when installing Native Client

it's my laptop, i try to install sql server 2005. the installation program dies at the first stage.
the program seem cant finish the Native Client installation and stops for ever. theres no error msg.
the installation program works well on my desktop. does anyone knows what goes wrong?
Did you install any SQL Beta on the machine ? Then you will first have to deinstall and run the cleanup utility on your laptop. If not, try to install the SNAC client from a standalone installer.

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

Can you check C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log\Summary.txt

and post the error message

Also go inside the subfolder files and look for _snac.log

Thanks

Vishal

|||i reboot the system for a few times, and for the last time, the system did a hard disk error check. then the installation program goes on well.||| next time if you have this kind of a issue please refer setup bootstrap|||

thanks a lot of all ur helpssql

installtion file for SQL CE 2.0 to install in Real PocketPC

HI,

i have one instalation file of SQL CE 2.0 named setup.exe ,i installed that in my desktop it works well.i could not install the same file inside the pocketPC.Can any one give me some information about how to get the installation file of SQL CE 2.0 and how to install that in real pocketPC.Thanks in advance.

Best Regards

Ihsan

Not having worked with SQL CE 2.0 (available here) for a while I would assume that it follows the same pattern as the current verion which is that the installer is to be run on the desktop NOT the device. After running the installer either the runtime dlls or a mobile installer will be available - you should also read the ReadMe and consider installing the books online (available locally after installing the main SQL CE 2.0 installer)

Hope this helps.

Installtion failed

Hi,
I failed to install SQL Server 2005 to my Win2003 server which has AVG antivirus/firewall installed. It still not work even I disable the firewall. Please advice

Here is the error log

2006-11-17 13:45:12.25 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2006-11-17 13:45:12.25 Server (c) 2005 Microsoft Corporation.
2006-11-17 13:45:12.25 Server All rights reserved.
2006-11-17 13:45:12.25 Server Server process ID is 3300.
2006-11-17 13:45:12.25 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2006-11-17 13:45:12.26 Server This instance of SQL Server last reported using a process ID of 2768 at 11/17/2006 1:45:00 PM (local) 11/17/2006 9:45:00 PM (UTC). This is an informational message only; no user action is required.
2006-11-17 13:45:12.26 Server Registry startup parameters:
2006-11-17 13:45:12.26 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2006-11-17 13:45:12.26 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2006-11-17 13:45:12.26 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2006-11-17 13:45:12.28 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-11-17 13:45:12.28 Server Detected 2 CPUs. This is an informational message; no user action is required.
2006-11-17 13:45:12.43 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2006-11-17 13:45:12.45 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2006-11-17 13:45:13.48 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2006-11-17 13:45:13.48 Server Database Mirroring Transport is disabled in the endpoint configuration.
2006-11-17 13:45:13.48 spid5s Starting up database 'master'.
2006-11-17 13:45:13.51 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2006-11-17 13:45:13.59 spid5s SQL Trace ID 1 was started by login "sa".
2006-11-17 13:45:13.60 spid5s Starting up database 'mssqlsystemresource'.
2006-11-17 13:45:13.78 spid5s Server name is 'VSMRND'. This is an informational message only. No user action is required.
2006-11-17 13:45:13.78 spid9s Starting up database 'model'.
2006-11-17 13:45:13.85 Server The certificate was successfully loaded for encryption.
2006-11-17 13:45:13.85 spid9s Clearing tempdb database.
2006-11-17 13:45:13.85 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2006-11-17 13:45:13.85 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2006-11-17 13:45:13.87 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2006-11-17 13:45:13.87 Server Dedicated admin connection support was established for listening locally on port 1434.
2006-11-17 13:45:13.87 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2006-11-17 13:45:13.90 spid5s Starting up database 'msdb'.
2006-11-17 13:45:14.09 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2006-11-17 13:45:14.25 spid9s Starting up database 'tempdb'.
2006-11-17 13:45:14.31 spid5s Recovery is complete. This is an informational message only. No user action is required.
2006-11-17 13:45:14.32 spid12s The Service Broker protocol transport is disabled or not configured.
2006-11-17 13:45:14.32 spid12s The Database Mirroring protocol transport is disabled or not configured.
2006-11-17 13:45:14.39 spid12s Service Broker manager has started.
2006-11-17 13:57:11.79 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2006-11-17 13:57:12.34 Server The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. This is an informational message only. No user action is required.
2006-11-17 13:57:12.34 Server Error: 17054, Severity: 16, State: 1.
2006-11-17 13:57:12.34 Server The current event was not reported to the Windows Events log. Operating system error = 31(A device attached to the system is not functioning.). You may need to clear the Windows Events log if it is full.
2006-11-17 13:57:12.49 spid12s Service Broker manager has shut down.
2006-11-17 13:57:13.15 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

Moved thread to SQL Server Setup & Upgrade. This is a better forum for your post.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||Hi,
To whom may concern, I found the mistake.
The error happens is because I extracted SQL Server 2005 CD 1 and CD2 into two different folder (as I can't extract them into same folder, this will overwritten each other). When I run setup from CD1 folder, I tick SQL Server database engine and workstation component. As Workstation component is in CD2 cause setup unable to locate it.

Install workstation component only using setup.exe under CD2 folder will solve the problem.

HTH

Installtion

I was trying to install SQLSERVER 2000 on WINOWS 2000 Advanced server,i am
getting an error "A previous program installation created pending file
operations on the installation machine.you must restart the computer before
running setup".I did restart the computer again i am getting same error.
I am wondering how to resolve this issue.Pls help me ..
Advance Thanks,
Sriram.
See if this helps:
http://support.microsoft.com/default...95&Product=sql
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Ram" <Ram@.discussions.microsoft.com> wrote in message
news:3DF5F779-AAB6-484B-9F22-AA44CBD23F70@.microsoft.com...
> I was trying to install SQLSERVER 2000 on WINOWS 2000 Advanced server,i am
> getting an error "A previous program installation created pending file
> operations on the installation machine.you must restart the computer
before
> running setup".I did restart the computer again i am getting same error.
> I am wondering how to resolve this issue.Pls help me ..
> Advance Thanks,
> Sriram.

Installting SQL Server 2k5

I have SQL Server 2000 on Windows XP professional OS.
I want to install SQLServer 2K5?
Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
What steps should be taken before and after SQL Server 2K5 installation?
Thanks,Hi,
You should be able to install SQL Server 2005 and SQL Server 2000 side
by side.
I think you may need SP2 of XP Pro.
One important thing to watch out for is any old components left behind
by past builds of SQL Server 2005 or Visual Studio 2005. If they are
present you need to uninstall CAREFULLY and in the right order or you
can expect to hit problems.
Andrew Watt
MVP - InfoPath
On Wed, 12 Oct 2005 12:01:02 -0700, "UA" <usha.anumolu@.eds.com> wrote:

>I have SQL Server 2000 on Windows XP professional OS.
>I want to install SQLServer 2K5?
>Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
>What steps should be taken before and after SQL Server 2K5 installation?
>
>Thanks,

Installting SQL Server 2k5

I have SQL Server 2000 on Windows XP professional OS.
I want to install SQLServer 2K5?
Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
What steps should be taken before and after SQL Server 2K5 installation?
Thanks,
Hi,
You should be able to install SQL Server 2005 and SQL Server 2000 side
by side.
I think you may need SP2 of XP Pro.
One important thing to watch out for is any old components left behind
by past builds of SQL Server 2005 or Visual Studio 2005. If they are
present you need to uninstall CAREFULLY and in the right order or you
can expect to hit problems.
Andrew Watt
MVP - InfoPath
On Wed, 12 Oct 2005 12:01:02 -0700, "UA" <usha.anumolu@.eds.com> wrote:

>I have SQL Server 2000 on Windows XP professional OS.
>I want to install SQLServer 2K5?
>Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
>What steps should be taken before and after SQL Server 2K5 installation?
>
>Thanks,

Installting SQL Server 2k5

I have SQL Server 2000 on Windows XP professional OS.
I want to install SQLServer 2K5?
Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
What steps should be taken before and after SQL Server 2K5 installation?
Thanks,Hi,
You should be able to install SQL Server 2005 and SQL Server 2000 side
by side.
I think you may need SP2 of XP Pro.
One important thing to watch out for is any old components left behind
by past builds of SQL Server 2005 or Visual Studio 2005. If they are
present you need to uninstall CAREFULLY and in the right order or you
can expect to hit problems.
Andrew Watt
MVP - InfoPath
On Wed, 12 Oct 2005 12:01:02 -0700, "UA" <usha.anumolu@.eds.com> wrote:
>I have SQL Server 2000 on Windows XP professional OS.
>I want to install SQLServer 2K5?
>Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
>What steps should be taken before and after SQL Server 2K5 installation?
>
>Thanks,

InstallSQLAgentSecurity failed (XXXXX,LocalSystem,87)

hi all,
i'd like to install MSDE that comes bundled with ms livecomm server.
but during the installation i get (using cmd params: /l*v ):
...
Starting custom action CallSQLAdHlp
C:\Programme\Microsoft SQL Server\80\Tools\Binn\sqladhlp.exe : 0
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}
TempFolder is
C:\DOKUME~1\ADMINI~1.ABS\LOKALE~1\Temp\{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}\
Loading extended custom action library
C:\DOKUME~1\ADMINI~1.ABS\LOKALE~1\Temp\{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (EXMAIL,LocalSystem,87).
Action ended 13:17:10: InstallFinalize. Return value 3.
...
i read about this behavior in ms's knowledgebase, but i dont
know how to update to sp3 of this msde cause its bundles with
the server...
any ideas how i get this msde installed on my win2003 server ?
tia !
cheers
joerg
hi Joerg,
"Joerg Mauz" <Joerg_MauzREMOVETHIS@.abs.org> ha scritto nel messaggio
news:uMTHNkBlEHA.2680@.TK2MSFTNGP15.phx.gbl...
> hi all,
> i'd like to install MSDE that comes bundled with ms livecomm server.
> but during the installation i get (using cmd params: /l*v ):
> ----
> ...
> Starting custom action CallSQLAdHlp
> C:\Programme\Microsoft SQL Server\80\Tools\Binn\sqladhlp.exe : 0
> SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}
> TempFolder is
>
C:\DOKUME~1\ADMINI~1.ABS\LOKALE~1\Temp\{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE
}\
> Loading extended custom action library
>
C:\DOKUME~1\ADMINI~1.ABS\LOKALE~1\Temp\{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE
}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}
> Starting custom action InstallSQLAgentSecurity
> InstallSQLAgentSecurity failed (EXMAIL,LocalSystem,87).
> Action ended 13:17:10: InstallFinalize. Return value 3.
> ...
> ----
> i read about this behavior in ms's knowledgebase, but i dont
> know how to update to sp3 of this msde cause its bundles with
> the server...
> any ideas how i get this msde installed on my win2003 server ?
>
if the bundle is not updated to service pack 3a, you can get it for free at
http://www.microsoft.com/sql/msde/do...s/download.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

InstallSQLAgentSecurity failed

I (actually one of our clients) is receiving an InstallSQLAgentSecurity
failed error in the msde install log.
*************************************
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (LORIH,LocalSystem,87).
Action ended 14:11:24: InstallFinalize. Return value 3.
*************************************
I've seen the following article
http://support.microsoft.com/default...en-us%3B829386
However, the Server service is running and it still won't start up. The
user is logged in as the Administrator, so is there anything else this can
be. We have this come up every now and then and we really don't have many
options to solve this.
Lance Johnson
Your solution is here:
http://seer.support.veritas.com/docs/265613.htm
I had the same problem and solution #2 fixed it. Tell me how it goes.
"Lance Johnson" <ljohnson@.docs.com> wrote in message news:<OM2SSmgXEHA.3292@.TK2MSFTNGP09.phx.gbl>...
> I (actually one of our clients) is receiving an InstallSQLAgentSecurity
> failed error in the msde install log.
> *************************************
> Starting custom action InstallSQLAgentSecurity
> InstallSQLAgentSecurity failed (LORIH,LocalSystem,87).
> Action ended 14:11:24: InstallFinalize. Return value 3.
> *************************************
> I've seen the following article
> http://support.microsoft.com/default...en-us%3B829386
> However, the Server service is running and it still won't start up. The
> user is logged in as the Administrator, so is there anything else this can
> be. We have this come up every now and then and we really don't have many
> options to solve this.
> Lance Johnson
|||"Lance Johnson" <ljohnson@.docs.com> wrote in message
http://seer.support.veritas.com/docs/265613.htm
Is where the solution is.
news:<OM2SSmgXEHA.3292@.TK2MSFTNGP09.phx.gbl>...
> I (actually one of our clients) is receiving an InstallSQLAgentSecurity
> failed error in the msde install log.
> *************************************
> Starting custom action InstallSQLAgentSecurity
> InstallSQLAgentSecurity failed (LORIH,LocalSystem,87).
> Action ended 14:11:24: InstallFinalize. Return value 3.
> *************************************
> I've seen the following article
> http://support.microsoft.com/default...en-us%3B829386
> However, the Server service is running and it still won't start up. The
> user is logged in as the Administrator, so is there anything else this can
> be. We have this come up every now and then and we really don't have many
> options to solve this.
> Lance Johnson
|||Check solution #2 @. the veritas page. I changed the roles and all
worked fine. Changed them back after and all continued to work.
[vbcol=seagreen]
> "Lance Johnson" <ljohnson@.docs.com> wrote in message
> http://seer.support.veritas.com/docs/265613.htm
> Is where the solution is.
> news:<OM2SSmgXEHA.3292@.TK2MSFTNGP09.phx.gbl>...
sql

InstallSQLAgentSecurity

Trying to install MSDE2000 on a clean Win2000Pro laptop. Installing from the SqlRun01.Msi file. According to the log it fails at.....
>>
Loading extended custom action library sqlcax.dll
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (TEST_0001,LocalSystem,87). <<

I can find where MS says there is an error, and it is Error# 60005, but nothing else.

I need to know what the problem is and how to fix it...

HELP! Deadline approaches.Applies to Windows 2000 OS.
MSDE 2000

Error: MSDE2000 fails to install correctly.

To Verify: Press Start|Run. Type "msiexec /i" <the fully qualified name and location of the sqlrun01.msi file> "/L* c:\msi.log" Press OK. This will run the install and place a log file called msi.log on the c:\. Check the log file for the word "Fail". Log should indicate that InstallSQLAgentSecurity failed.

Problem: File and Print Sharing are not enabled.* You will know this is not enabled if you are missing the "Service" service in the Services applet in Administrative Tools or
Control Panel.

Solution: Install File and printer sharing.|||AIkerd - THANK YOU for posting the solution to this. I spent 3 frustrating hours today fighting with this. Whoda thunk? Turing on File and Print sharing solved it immediately.

Mike G|||I have already done the logging but I have print and file sharing enabled anything else that might cause this problem?

your help is much appreciated

...already over my deadline

shiloh|||An MSDE Installation requires the Server service to be started.

Originally posted by shiloh69
I have already done the logging but I have print and file sharing enabled anything else that might cause this problem?

your help is much appreciated

...already over my deadline

shiloh

INSTALLl sql server without reboot

Hello,
I am trying install MS SQL 2000 client on the server.
and it telling me that I have to reboot server , because some other program
was install.
Q: How can I install client without reboot server?
ThanksYou can not... If there is a pending re-boot necessary due to the
installation of something else, you must re-boot first to finish the prior
install. Then do your sql stuff.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Serverdba" <Serverdba@.discussions.microsoft.com> wrote in message
news:4B6F0229-0652-445C-8DBE-C1D2C15E146F@.microsoft.com...
> Hello,
> I am trying install MS SQL 2000 client on the server.
> and it telling me that I have to reboot server , because some other
program was install.
> Q: How can I install client without reboot server?
>
> Thanks

INSTALLl sql server without reboot

Hello,
I am trying install MS SQL 2000 client on the server.
and it telling me that I have to reboot server , because some other program was install.
Q: How can I install client without reboot server?
Thanks
You can not... If there is a pending re-boot necessary due to the
installation of something else, you must re-boot first to finish the prior
install. Then do your sql stuff.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Serverdba" <Serverdba@.discussions.microsoft.com> wrote in message
news:4B6F0229-0652-445C-8DBE-C1D2C15E146F@.microsoft.com...
> Hello,
> I am trying install MS SQL 2000 client on the server.
> and it telling me that I have to reboot server , because some other
program was install.
> Q: How can I install client without reboot server?
>
> Thanks