Installing multiple instances of MSDE2000

Hello
I installed 2 instances of msde , installation passed ok but noone can
connect to my machine , i portscanned host machine and port 1443 is not
opened ,can it be becaus i installed it on a VmWare console, any help is
apriciated.
PS I didn't forget to set DISABLENETWORKPROTOCOLS=0.
Thx in advance
__________
TomislavFist you need to find out what the instance names are and whether one is a
default instance (both are probably named instances as no-one is listening
to port 1433).
Use either server network utility, svrnetcn.exe, or check the services in
the machine. After you know the instance names, you connect using:
machinename\instancename
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tomislav Zemljak" <tomislav.zemljak@.*maknime*bj.tel.hr> wrote in message
news:c3rn9s$ksm$1@.sunce.iskon.hr...
> Hello
> I installed 2 instances of msde , installation passed ok but noone can
> connect to my machine , i portscanned host machine and port 1443 is not
> opened ,can it be becaus i installed it on a VmWare console, any help is
> apriciated.
> PS I didn't forget to set DISABLENETWORKPROTOCOLS=0.
> Thx in advance
> __________
> Tomislav
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
> Fist you need to find out what the instance names are and whether one is a
> default instance (both are probably named instances as no-one is listening
> to port 1433).
One is default instance , other is named "second"
> Use either server network utility, svrnetcn.exe, or check the services in
> the machine. After you know the instance names, you connect using:
> machinename\instancename
That didn't solve it ... both instances are started and appear to be
working on host machine , remote users still cant connect and portscann
shows that port 1443 isn't open .Thx for trying thou.|||You don't say whether these instances are both named or one is a default def
ault instance. You cannot have two
default instances. My guess is that you have two names instance. A named ins
tance does NOT listen on 1433.
Please follow my direction closely to find out whether these are default or
named instances and the name of
the instance.
This is what I write in my earlier post:

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tomislav Zemljak" <tomislav.zemljak@.*maknime*bj.tel.hr> wrote in message news:c3s99i$4ge$1
@.sunce.iskon.hr...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
> One is default instance , other is named "second"
> That didn't solve it ... both instances are started and appear to be
> working on host machine , remote users still cant connect and portscann
> shows that port 1443 isn't open .Thx for trying thou.
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
> You don't say whether these instances are both named or one is a default
default instance.
As i already wrote (look below) one is default instance , other is named
"second".
I "fixed" the problem by reinstalling both instances , now they work , thx
for tryng to help !
You cannot have two
> default instances. My guess is that you have two names instance. A named
instance does NOT listen on 1433.
> Please follow my direction closely to find out whether these are default
or named instances and the name of
> the instance.
> This is what I write in my earlier post:
>
in
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Tomislav Zemljak" <tomislav.zemljak@.*maknime*bj.tel.hr> wrote in message
news:c3s99i$4ge$1@.sunce.iskon.hr...
wrote:
is a
listening
in
>

installing MSDE?

Hello!

In the setup of MSDE I need to edit the ini file. Well when I do it looks as if the installation was complete, but there is no MSDE services application and the actual services are on the box(I can start/stop them). Could someone show me what the edited ini file needs to have to be sure the install is complete? Or maybe there's something else that I need to do and just don't know about.

Many thanks.Not sure I understand what the problem is.

Is it MSDE 1.0 or MSDE 2000?

Is the OS NT or Win2k or 9x/ME?

Can you see if the MSSQLSERVER service is running?
You can check this easily by running sqlmangr.exe

Installing MSDE 2000 Rel A

Hi all,
I am unable to install MSDE on Window XP pro, SP2. Setup rolls back every
time without any indication of why. I had an earlier installation of MSDE
which I removed manually following the instructions in the Knowledge Base
article. I installed MSDE on a Windows 2000 Pro machine using the same
procedure without any problems.
The command line syntax I'm using is: setup sapwd="[mypassword]"
SECURITYMODE=SQL
Can anyone help?
Thanks.
When you manually uninstalled MSDE did you also remove the "MSSQLServer" key
under HKEY_LOCAL_MACHINE\Software\Microsoft ? That key and the "Microsoft
SQL Server" key needs to be removed. Also remove the entire directory tree
under c:\program files\Microsoft SQL Server. Also, reboot the machine after
doing the manual uninstall.
Jim
"Stephen Bishop" <Stephen Bishop@.discussions.microsoft.com> wrote in message
news:1E567705-A87F-4B8D-8DF5-202D934D5263@.microsoft.com...
> Hi all,
> I am unable to install MSDE on Window XP pro, SP2. Setup rolls back every
> time without any indication of why. I had an earlier installation of MSDE
> which I removed manually following the instructions in the Knowledge Base
> article. I installed MSDE on a Windows 2000 Pro machine using the same
> procedure without any problems.
> The command line syntax I'm using is: setup sapwd="[mypassword]"
> SECURITYMODE=SQL
> Can anyone help?
> Thanks.
|||Hi Jim,
I did delete those keys from the registry with no luck.
In a separate post, I uploaded part of the install log what appears to point
to the problem . Searching for "return value 3" I found the following:
"Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 11:32:55: InstallFinalize. Return value 3."
According to a Knowledge Base article, the only solution to this involves
some advanced level tinkering with the registry, which I don't feel
comfortable undertaking. Is there any other way?
Thanks for your reply.
sb
"Jim Young" wrote:

> When you manually uninstalled MSDE did you also remove the "MSSQLServer" key
> under HKEY_LOCAL_MACHINE\Software\Microsoft ? That key and the "Microsoft
> SQL Server" key needs to be removed. Also remove the entire directory tree
> under c:\program files\Microsoft SQL Server. Also, reboot the machine after
> doing the manual uninstall.
> Jim
> "Stephen Bishop" <Stephen Bishop@.discussions.microsoft.com> wrote in message
> news:1E567705-A87F-4B8D-8DF5-202D934D5263@.microsoft.com...
>
>
sql

Installing MSDE

I've downloaded sql2ksp3. After I have extracted the file, I found MSDE folder and I ran the setup.exe. Halfway through the installation, it says the instance name specified is invalid.

Does anyone know how to fix this? Thanks.Take a look atKB article 810826 and specify an INSTANCENAME parameters to the command.

Installing Microsoft SQL Server 2005 9.00.1399.06

I'm having problem with installing Microsoft SQL Server 2005 9.00.1399.06. I have (I think removed) all beta and other SQL files but the installation still fails.

Any ideas on where to look for the problem(s)?

summary.txt looks like this:

Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Fri Nov 25 22:42:40 2005
P2 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Machine : P2
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQLSupport_1.log
--
Machine : P2
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQLNCLI_1.log
--
Machine : P2
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SqlWriter_1.log
--
Machine : P2
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_MSXML6_1.log
--
Machine : P2
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQLSupport_2.log
--
Machine : P2
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQLNCLI_2.log
--
Machine : P2
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_MSXML6_2.log
--
Machine : P2
Product : SQL Server Database Services
Error : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
--
Machine : P2
Product : SQL Server Database Services
Error : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
--
Machine : P2
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQL.log
Last Action : DetectInstanceClash
Error String : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
Error Number : 28086
--
Machine : P2
Product : Microsoft SQL Server 2005 Tools Express Edition
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_Tools.log
--

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.

Time : Fri Nov 25 22:47:40 2005

List of log files:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_Core(Local).log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQLSupport_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQLNCLI_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SqlWriter_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_MSXML6_1.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQLSupport_2.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQLNCLI_2.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_MSXML6_2.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SQL.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_Tools.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_Datastore.xml
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_.NET Framework 2.0.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_Support.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_Core.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_SCC.log

This is "SQLSetup0011_P2-Core.log":

Microsoft SQL Server 2005 Setup beginning at Fri Nov 25 22:41:49 2005
Process ID : 3500
f:\22644329947aca3bcc8446\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2005/10/25 22:41:49
Complete: LoadResourcesAction at: 2005/10/25 22:41:49, returned true
...
And then a number of actions that end with "returned true"
...
Running: DetectLocalBootstrapAction at: 2005/10/25 22:42:37
Complete: DetectLocalBootstrapAction at: 2005/10/25 22:42:37, returned true
Running: LaunchLocalBootstrapAction at: 2005/10/25 22:42:37
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 28086
Aborting queue processing as nested installer has completed
Message pump returning: 28086

Something goes wrong, but I'm not able to analyse what.

"SQLSetup0011_P2_Core(Local).log" looks like this:

Microsoft SQL Server 2005 Setup beginning at Fri Nov 25 22:42:40 2005
Process ID : 1424
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2005/10/25 22:42:40
Complete: LoadResourcesAction at: 2005/10/25 22:42:40, returned true
...
Then there is a number of actions that end with various errors.
...
One or more packages failed to install. Refer to logs for error details. : 28086
Error Code: 0x80076db6 (28086)
Windows Error Text: Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Sep 1 22:23:05 2005
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3097

- Context --
sqls::HostSetupPackageInstallerSynch::postCommit
sqls::HighlyAvailablePackage::preInstall
led due to cancel code received from cancel source: 29539

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_P2_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0011.cab" Error Code : 2
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 28086

/anders

It looks like you already have an instance installed with the same name. In the Instance Name dialog enter a unique name for the instance you're installing.|||Hi,
What if I want to remove(clean) all default instances and install SQL Server 2005 RTM as the default instance. I am getting the same error trying to install RTM. I unistalled Sept CTP. How do I remove all the existing instances

Thanks,
-Suri

installing management studio on a cluster

Hi,
I am installing sql 2005 on a two node cluster. I have managed to complete
the installation and then wanted to add the sql management studio on to the
cluster. I installed disk two and chose the support tools but have way
through the installation it failed with the following error:
Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from
HRESULT: 0x8004D01B)
I was installing this on the first node which had ownership of the shared
disks
Any ideas
Looks like you need to install a clustered instance of MSDTC.
http://www.microsoft.com/technet/prodtechnol/biztalk/2006/library/bts06clustering/55b0c81f-44a5-4069-b065-57df1cce19ac.mspx?mfr=true
Ignore the incoming caller stuff. That is for Biztalk.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:D07341A6-EDDA-4448-9C8A-23A1727E565B@.microsoft.com...
> Hi,
> I am installing sql 2005 on a two node cluster. I have managed to complete
> the installation and then wanted to add the sql management studio on to
> the
> cluster. I installed disk two and chose the support tools but have way
> through the installation it failed with the following error:
> Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from
> HRESULT: 0x8004D01B)
> I was installing this on the first node which had ownership of the shared
> disks
>
> Any ideas

Installing IIS and SRS at a later date

How difficult would it be to install IIS and SRS in a SQL Server 2005 x64 installation at a later date? What steps would I take?

Thanks!

Run the installer should be all that is involved.|||

I was thinking it might be that simple but preferred some confirmation.

Thanks!

Installing Database

Hi,
My client is US based. Now I want to send them the database script for the package installation. Client does'nt have any technical people. So all I have to do it remotely from India. So could any one guide me on this?
thnxDuplicate post. Has been answered in other thread.|||you can send me a check and your worries would all be gonesql

Installing Database

Hi,
My client is US based. Now I want to send them the database script for the package installation. Client does'nt have any technical people. So all I have to do it remotely from India. So could any one guide me on this?
thnxWhat exactly is the problem. Either you can ask them to install by sending the database scripts, or ask them to install a remote server and connect from India remotely. In case of remote connection, they have to open up their server ports to skip the firewall. Then you can connect from India and do everything yourself.|||Could you please come up with a more clear picture, on remote connection and opening the port................?

thnx|||You can install MS Remote Desktop Connection software in your computer and connect to the sql server remotely. For that, you have to ask your client to open you the sql server, http and ftp ports to you.|||They would be crazy to open up ports on their SQL Servers though for you to work on it remotely from India. Just make a backup of a database with only the data needed. They can just restore the database on their SQL Server as part of the installation process. The alternative is to give them a script that creates the database, users, tables, stored procs, etc. and inserts the data needed. That's more prone to error though and harder to troubleshoot.

This is pretty standard practice and you should probably know this if you are going to be distributing commercial applications that utilize SQL Server. You might want to hire a DBA or look at consulting services for your company.|||yup, hire me!

Installing and Uninstalling Express Edition

Hi guys,

I'm trying to create a all-in-one installation package for my application which make use of the SQL 2005 Express edition. It seems that there's no way to roll my application MSI installation with the database engine, the only ways around this problem is to use a bootstrap exe to launch the sql setup before or after my main application's MSI. This works fine during installation and I have modified the original .NET framework bootstrapper to do just that.

The problem comes when uninstalling my application. Since the uninstall process is all done through the MSI engine, how would I take the sql instance with me during my application's uninstall? Since the sql engine is also based on MSI technology, I won't be able to do that during the removal step of my application's MSI, right? Any one know any "clean" ways around that? Besides not letting users uninstall my application directly from Add/Remove program and force them to call another exe simular to my installation bootstrap?

I'm considering to use 3rd party tools like InstallShields, but even them are recommending people to stay with the MSI technology which is where the problem is. I'm running out of ideas really fast...

Thanks in advance!

William

Hi,

Since my initial posting, I've been working on the command to uninstall a named instance of SQL Server 2005. I though it would help once I get my problem above solved, as it seems to be the next logical step.

It seems that from MSDN (http://support.microsoft.com/default.aspx/kb/909967), there isn't a way to automate this process neither. The command ARPWrapper.exe don't have (or I couldn't fine) parameter to specify the named instance I'm trying to remove. The switch "/REMOVE" just brings up a window letting user choose their instance to remove. Anyone knows if such a way exists?

As I've said before, I'm trying to package my .NET application with SQL Server 2005 Express Edition into one. So that users can install and uninstall from one place with minimal user intervention. It seems to be such a common task, but it's certainly not too intuitive.

William

|||I too want to have the ability to uninstall a named instance of SQL Server 2005 Express SP2 from the command prompt in silent mode? You were you able to find a solution?sql

Installing all components on XP

At one time there was a Reporting Services installation that worked on XP. I
know this because I was training & testing myself on my XP machine which also
has vs.net, SQL 2000 & IIS installed. In my default website, I had
directories called reportserver & reports.
After not using this for a while, I tried to browse (unsuccessfully) to this
website & I could not get to it. even after rsconfig.
I uninstalled Reporting services to give myself the practice, but using the
install I have now, It complains that all the components cannot be installed
with XP. I really shot myself in the foot. Any suggestions, besides shooting
myself in the head?If the SQL Server2000 is developer version, yes, you can installed all
components on your XP. Otherwise, you ca only install client components. The
SQL Server itself, along with Reporting Services, needs Windows Server (2K
or 2K3).
"JDArsenault" <JDArsenault@.discussions.microsoft.com> wrote in message
news:A1B9C2F6-5D07-4470-A5A1-93BE3EE570B4@.microsoft.com...
> At one time there was a Reporting Services installation that worked on XP.
> I
> know this because I was training & testing myself on my XP machine which
> also
> has vs.net, SQL 2000 & IIS installed. In my default website, I had
> directories called reportserver & reports.
> After not using this for a while, I tried to browse (unsuccessfully) to
> this
> website & I could not get to it. even after rsconfig.
> I uninstalled Reporting services to give myself the practice, but using
> the
> install I have now, It complains that all the components cannot be
> installed
> with XP. I really shot myself in the foot. Any suggestions, besides
> shooting
> myself in the head?|||Thank you sir...I located a copy of the developer version & all's well.
JD
"Norman Yuan" wrote:
> If the SQL Server2000 is developer version, yes, you can installed all
> components on your XP. Otherwise, you ca only install client components. The
> SQL Server itself, along with Reporting Services, needs Windows Server (2K
> or 2K3).
> "JDArsenault" <JDArsenault@.discussions.microsoft.com> wrote in message
> news:A1B9C2F6-5D07-4470-A5A1-93BE3EE570B4@.microsoft.com...
> > At one time there was a Reporting Services installation that worked on XP.
> > I
> > know this because I was training & testing myself on my XP machine which
> > also
> > has vs.net, SQL 2000 & IIS installed. In my default website, I had
> > directories called reportserver & reports.
> >
> > After not using this for a while, I tried to browse (unsuccessfully) to
> > this
> > website & I could not get to it. even after rsconfig.
> >
> > I uninstalled Reporting services to give myself the practice, but using
> > the
> > install I have now, It complains that all the components cannot be
> > installed
> > with XP. I really shot myself in the foot. Any suggestions, besides
> > shooting
> > myself in the head?
>
>sql

Installing 2nd instance of MSDE

I am trying to install WSUS on a Windows 2000 server that already has MSDE
installed for Backup Exec.
Unfortunately the WSUS installation returns the following error: "- a
database server could not be detected"
I believe WSUS is looking for an instance called "WSUS".
How do I install a 2nd instance of MSDE on a Windows 2000 server (Child
Instance?) without impacting
my default instance for Backup Exec? Thanks!!!!!!
hi Ken,
Ken wrote:
> I am trying to install WSUS on a Windows 2000 server that already has
> MSDE installed for Backup Exec.
> Unfortunately the WSUS installation returns the following error: "- a
> database server could not be detected"
> I believe WSUS is looking for an instance called "WSUS".
> How do I install a 2nd instance of MSDE on a Windows 2000 server
> (Child Instance?) without impacting
> my default instance for Backup Exec? Thanks!!!!!!
you can install up to 16 (theorical) SQL Server/MSDE instance per machine...
only one of them can be the default instance, where all the others have to
be named instance..
to install a named instance you have to provide the
INSTANCENAME=WSUS
parameter to the setup.exe boostrap installer
(http://msdn.microsoft.com/library/de...stsql_84xl.asp)
, that's to say something like
c:\...\>setup.exe INSTANCENAME=WSUS SECURITYMODE=SQL SAPWD=some_pwd
DISABLENETWORKPROTOCOLS=0 /L*v "c:\msdelog.txt"
please see the referenced page for all parameter synopsis..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
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
|||Thanks for your help Andrea!!!! WSUS was installed!!!
Ken
"Andrea Montanari" wrote:

> hi Ken,
> Ken wrote:
> you can install up to 16 (theorical) SQL Server/MSDE instance per machine...
> only one of them can be the default instance, where all the others have to
> be named instance..
> to install a named instance you have to provide the
> INSTANCENAME=WSUS
> parameter to the setup.exe boostrap installer
> (http://msdn.microsoft.com/library/de...stsql_84xl.asp)
> , that's to say something like
> c:\...\>setup.exe INSTANCENAME=WSUS SECURITYMODE=SQL SAPWD=some_pwd
> DISABLENETWORKPROTOCOLS=0 /L*v "c:\msdelog.txt"
> please see the referenced page for all parameter synopsis..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> 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

Installing

Hi Group
Absolute newbie in reporting services...
Have a server with a SQL 2005 Standard Installation (version 9.00.1399.06) -
and now I've been asked to check if reporting services are installed - How
can I see this - and if its not there how do I install it ?Go to Control Panel, open "Services" applet, if there is "ReportServer"
service running, then, most likely, RS is installed on this vbox. Or go to
IIS manager, underneath Website, if you can see virtual folder "Reports" and
"ReportServer" (or Reports$ServerInstanceName and
ReportServer$ServerInstanceName), then, RS is installed.
RS can be installed on a computer where no SQL Server itself is installed.
However, it requires IIS. To installed it, simply place CD/DVD into drive
and in the installation wizard, make sure you select Reporting Services. You
may need to plann ahead for the user accounts used by RS: RS uses different
accounts for the service and data source access. You'd better plan ahead
according to your needs. RS is also an ASP.NET application, which has its
own security configuration that you need to plan well before hand.
"Wiper" <taenkeren@.gmail.com> wrote in message
news:1FCBD552-F4AE-49F6-B5A3-43DB73649D68@.microsoft.com...
> Hi Group
> Absolute newbie in reporting services...
> Have a server with a SQL 2005 Standard Installation (version
> 9.00.1399.06) - and now I've been asked to check if reporting services are
> installed - How can I see this - and if its not there how do I install it
> ?
>
>

Installed SQL 2005, but where is the management tools?

I installed the SQL2005, but cannot find the management tools like
Enterprise Manager in 2000
During Installation, i selected advanced
and select to install
all in Database Service,
all in Client Components and
the SQL BOL in Documentation, Sample, and Sample Database.
But after the installation complete, I cannot locate the SQL Management
Studio
In my program list, it only has
SQL Server 2005\Configuration Tools
SQL Server 2005\Documentation and Tutorials
I checked the Add/Remove Program in Control Panel, it show followings are
installed
MS SQL Server 2005
MS SQL Server 2005 Backward compatibility
MS SQL Server 2005 BOL (English)
MS SQL Server Natvie Client
MS SQL Server Setup Support Files
MS SQL Server VSS Writer
but no any manager tools.
I tried to insert to dvd again and select to install the Client Component
but the wizard said the component i choose is already installed.
So what is the problem?
P.S. OS WinXP SP2
already have SQL 2000 Dev Ed installed with Enterprise Manager.
Any Help?
Thanks in Advanced
Jason
What edition did you install?
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||You need to install the workstation tools if you installed the standard or
enterprise edition.
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||This [1] is the only current option for SQL Express.
<%= Clinton Gallagher
[1]
http://www.microsoft.com/downloads/d...displaylang=en
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||Do you have Internet Explorer 6 SP1 or higher on the machine?
"Jason Chan" wrote:

> I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
>

Installed SQL 2005, but where is the management tools?

I installed the SQL2005, but cannot find the management tools like
Enterprise Manager in 2000
During Installation, i selected advanced
and select to install
all in Database Service,
all in Client Components and
the SQL BOL in Documentation, Sample, and Sample Database.
But after the installation complete, I cannot locate the SQL Management
Studio
In my program list, it only has
SQL Server 2005\Configuration Tools
SQL Server 2005\Documentation and Tutorials
I checked the Add/Remove Program in Control Panel, it show followings are
installed
MS SQL Server 2005
MS SQL Server 2005 Backward compatibility
MS SQL Server 2005 BOL (English)
MS SQL Server Natvie Client
MS SQL Server Setup Support Files
MS SQL Server VSS Writer
but no any manager tools.
I tried to insert to dvd again and select to install the Client Component
but the wizard said the component i choose is already installed.
So what is the problem?
P.S. OS WinXP SP2
already have SQL 2000 Dev Ed installed with Enterprise Manager.
Any Help?
Thanks in Advanced
JasonWhat edition did you install?
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||You need to install the workstation tools if you installed the standard or
enterprise edition.
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||This [1] is the only current option for SQL Express.
<%= Clinton Gallagher
[1]
http://www.microsoft.com/downloads/...&displaylang=en
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||Do you have Internet Explorer 6 SP1 or higher on the machine?
"Jason Chan" wrote:

> I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
>

Installed SQL 2005, but where is the management tools?

I installed the SQL2005, but cannot find the management tools like
Enterprise Manager in 2000
During Installation, i selected advanced
and select to install
all in Database Service,
all in Client Components and
the SQL BOL in Documentation, Sample, and Sample Database.
But after the installation complete, I cannot locate the SQL Management
Studio
In my program list, it only has
SQL Server 2005\Configuration Tools
SQL Server 2005\Documentation and Tutorials
I checked the Add/Remove Program in Control Panel, it show followings are
installed
MS SQL Server 2005
MS SQL Server 2005 Backward compatibility
MS SQL Server 2005 BOL (English)
MS SQL Server Natvie Client
MS SQL Server Setup Support Files
MS SQL Server VSS Writer
but no any manager tools.
I tried to insert to dvd again and select to install the Client Component
but the wizard said the component i choose is already installed.
So what is the problem?
P.S. OS WinXP SP2
already have SQL 2000 Dev Ed installed with Enterprise Manager.
Any Help?
Thanks in Advanced
JasonWhat edition did you install?
--
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||You need to install the workstation tools if you installed the standard or
enterprise edition.
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||This [1] is the only current option for SQL Express.
<%= Clinton Gallagher
[1]
http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||Do you have Internet Explorer 6 SP1 or higher on the machine?
"Jason Chan" wrote:
> I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
>sql

installed sp3a but @@version still says sp2

Ran the sp3a (setup.bat) on server from G:\ then MSSQL is
installed on F:\ (NOT C:). I choose default on the
installation because that is all it gave me, could not
type in. The installation went through and restarted
machine. MDAC got updated, but @.@.version in sql still
gives me 8.00.534.
Looks like databases have a updated modified date on them
bu they all say old version. Where did my update go? Any
files I can check for? Did it install it on C:'
Please help!Look for *.out files. If there are none, run the installation again with
the verbose logging option on (see the readme file for running setup from a
command line to change switches.)
"Kada" <kadahoffman@.hotmail.com> wrote in message
news:01a901c37faa$e952c730$a301280a@.phx.gbl...
> Ran the sp3a (setup.bat) on server from G:\ then MSSQL is
> installed on F:\ (NOT C:). I choose default on the
> installation because that is all it gave me, could not
> type in. The installation went through and restarted
> machine. MDAC got updated, but @.@.version in sql still
> gives me 8.00.534.
> Looks like databases have a updated modified date on them
> bu they all say old version. Where did my update go? Any
> files I can check for? Did it install it on C:'
> Please help!|||Do you mean if I do not see something called sp3_repl.out
and sp3_serv_uni.out? Or what Out files should I see?
Thanks!
>--Original Message--
>Look for *.out files. If there are none, run the
installation again with
>the verbose logging option on (see the readme file for
running setup from a
>command line to change switches.)
>
>
>"Kada" <kadahoffman@.hotmail.com> wrote in message
>news:01a901c37faa$e952c730$a301280a@.phx.gbl...
>> Ran the sp3a (setup.bat) on server from G:\ then MSSQL
is
>> installed on F:\ (NOT C:). I choose default on the
>> installation because that is all it gave me, could not
>> type in. The installation went through and restarted
>> machine. MDAC got updated, but @.@.version in sql still
>> gives me 8.00.534.
>> Looks like databases have a updated modified date on
them
>> bu they all say old version. Where did my update go?
Any
>> files I can check for? Did it install it on C:'
>> Please help!
>
>.
>

Installed MSDE Rel A does not appear to work.

I just installed MSDE 2000 Rel A on a Win 2000 machine, after removing the old MSDE 2000 that came with MS Office. The new installation does not appear to work. I have a log file (with verbose dialog), but it says the installation completed successfully
at its end.
A custom ini file was used with a strong sa password and the DisableNetworkProtocols=0 to enable network access from a peer computer. Since I want to use Windows Authentication I omitted the SECURITYMODE=SQL.
As per the MSDE Readme file , I set the security policy for "Unsigned non-driver installation behavior" to "Silently succeed".
I disabled Norton Internet security (the firewall) and Antivirus before installing. After reboot, I set firewall rules to pass everything on ports that the MSDE wanted to communicate on. Disabling the firewall (after booting) does not allow it to work.
The Service Manager is active, but lists only the old server name "H" which is the name of the computer. The new instance is not shown. The services list is empty.
Q1) Why is the old server name "H" still there?
Q2) Any idea why this installation does work? Can anyone look at the log file (its about 2 MB in size) and tell what's wrong?
Mark Ferguson
hi Mark,
"Mark Ferguson" <MarkFerguson@.discussions.microsoft.com> ha scritto nel
messaggio news:3E995A24-7B1B-4CA7-9472-90056074438F@.microsoft.com...
> I just installed MSDE 2000 Rel A on a Win 2000 machine, after removing the
old
>MSDE 2000 that came with MS Office. The new installation does not appear to
work. I
> have a log file (with verbose dialog), but it says the installation
completed successfully
>at its end.
>...........
just a question... you say
>The services list is empty
does it means you investigated the available services in the services
control panel and the installed MSDE instance is not present? or you mean
the instance is not present in the Service Manager combobox?
if the service is available in the services management panel, try typing the
instance name in the Service Manager combobox...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I understand your question, and it was helpful but did not solve the problem:
1) Control Panel>Administrative Tools>Services shows a list of services, some started, some not. In this case the MSSQL$<instance> is shown as *started*, so we know that the server is active.
2) The SQL Server Manager (SSM) that I was referring to, is started from the Startup subfolder during system boot. It appears as an icon at the right of the task bar: a CPU box with a green arrow in white circle. (In my case, the green arrow is missing).
The SSM is used to start and stop services associated with an instance of SQL Server. It contains two combo boxes, one for picking the instance, the second for picking the service to start and stop.
In the SSM instance combo box, the only instance name is "H" - the name of the old uninstalled MDSE 2000 from the MSOffice 2000 CDROM. I tried entering the new instance name in the combo box. It generated the error message "The network path was not found.
" The service combo box remained empty.
Mark Ferguson
"Andrea Montanari" wrote:

> hi Mark,
--snip--
> just a question... you say
> The services list is empty"
> does it means you investigated the available services in the services
> control panel and the installed MSDE instance is not present? or you mean
> the instance is not present in the Service Manager combobox?
> if the service is available in the services management panel, try typing the
> instance name in the Service Manager combobox...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
|||Mark,
In the Server Manager, did you type in the instance name as
<MACHINE_NAME>\<INSTANCE_NAME>? For example, if my machine is DANDELL and
the instance is MYINSTANCE, I would enter DANDELL\MYINSTANCE and press the
"Refresh Services" button. This name is difference than MSSQL$MYINSTANCE.
Dan
"Mark Ferguson" <MarkFerguson@.discussions.microsoft.com> wrote in message
news:7D67CBC5-10EF-453D-8E77-9B2545BE6092@.microsoft.com...
>I understand your question, and it was helpful but did not solve the
>problem:
> 1) Control Panel>Administrative Tools>Services shows a list of services,
> some started, some not. In this case the MSSQL$<instance> is shown as
> *started*, so we know that the server is active.
> 2) The SQL Server Manager (SSM) that I was referring to, is started from
> the Startup subfolder during system boot. It appears as an icon at the
> right of the task bar: a CPU box with a green arrow in white circle. (In
> my case, the green arrow is missing). The SSM is used to start and stop
> services associated with an instance of SQL Server. It contains two combo
> boxes, one for picking the instance, the second for picking the service to
> start and stop.
> In the SSM instance combo box, the only instance name is "H" - the name of
> the old uninstalled MDSE 2000 from the MSOffice 2000 CDROM. I tried
> entering the new instance name in the combo box. It generated the error
> message "The network path was not found." The service combo box remained
> empty.
> --
> Mark Ferguson
>
> "Andrea Montanari" wrote:
> --snip--
>
|||Thanks Dan. Didn't work however. The instance name is ABC. I tried
- H\ABC - result was an eror mesage saying that the computer name format was invalid.
-\H\ABC - result was "The RPC server is unavailable". The RPC server was started, I started the RPC locator service and tried again with the same error.
-\\H\ABC - result was no error message but at the bottom of the Service Manager dialog, a field showed the message "Unknown - \\\\H\ABC - MSSQLServer". Note the 4 backslashes?
I should mention that the first try (H\ABC) created more firewall rules for the SQL server and the Service Manager.
What is the proper format for the computer name and instance? According to my reading, in the "Books Online", the proper format is "H\<instance>".
Why doesn't the Service Manager find this new instance in the same way that it found the original instance? (I assume the original instance-name was blank.)
Mark Ferguson
"PPC" wrote:

> Mark,
> In the Server Manager, did you type in the instance name as
> <MACHINE_NAME>\<INSTANCE_NAME>? For example, if my machine is DANDELL and
> the instance is MYINSTANCE, I would enter DANDELL\MYINSTANCE and press the
> "Refresh Services" button. This name is difference than MSSQL$MYINSTANCE.
> Dan
> "Mark Ferguson" <MarkFerguson@.discussions.microsoft.com> wrote in message
> news:7D67CBC5-10EF-453D-8E77-9B2545BE6092@.microsoft.com...
>
>

Installation: SQL Server 2005 surface area configuration, error WI

Hello,
I'm trying to install RS 2005 on my server.
First the installation is ok, to validate it I checked (as explained in the
installation guide) with "SQL Server 2005 surface area configuration", but I
have always an error when I want to validate the "windows intergated
security".
The error is: "Argument value wa not passed for the argument reporting
service URL. (Microsoft.sqlsac.public)".
Details are: "--
Program Location:
at
Microsoft.SqlSac.Public.ReportingServices.GetReportingServiceProxy(String
reportingUrl)
at Microsoft.SqlSac.Public.ReportingServices.GetSettings(String
givenInstanceName, ReportingFeature feature, String serverName)
at
Microsoft.SqlSac.MainPanel.WindowsIntegratedSecurity.GetCurrentSettings(String machineName)
at Microsoft.SqlSac.MainPanel.FormFeatures.DisplayLeaf(TreeView tree,
ETreeNode selected)
at Microsoft.SqlSac.MainPanel.FormFeatures.OnTimer(Object source,
ElapsedEventArgs eArgs)".
I don't want to continue the installation (use reporting service
configuration tool) before resolve this issue.
Thanks for your help.
PascalHi,
I am also trying to install RS 2005 on my server
and getting the same problem, can any one pl. help us to resolve this
issue.
Thanks
plkumar
pbrel wrote:
> Hello,
> I'm trying to install RS 2005 on my server.
> First the installation is ok, to validate it I checked (as explained in the
> installation guide) with "SQL Server 2005 surface area configuration", but I
> have always an error when I want to validate the "windows intergated
> security".
> The error is: "Argument value wa not passed for the argument reporting
> service URL. (Microsoft.sqlsac.public)".
> Details are: "--
> Program Location:
> at
> Microsoft.SqlSac.Public.ReportingServices.GetReportingServiceProxy(String
> reportingUrl)
> at Microsoft.SqlSac.Public.ReportingServices.GetSettings(String
> givenInstanceName, ReportingFeature feature, String serverName)
> at
> Microsoft.SqlSac.MainPanel.WindowsIntegratedSecurity.GetCurrentSettings(String machineName)
> at Microsoft.SqlSac.MainPanel.FormFeatures.DisplayLeaf(TreeView tree,
> ETreeNode selected)
> at Microsoft.SqlSac.MainPanel.FormFeatures.OnTimer(Object source,
> ElapsedEventArgs eArgs)".
> I don't want to continue the installation (use reporting service
> configuration tool) before resolve this issue.
> Thanks for your help.
> Pascal

Installation/Connection problems with MS Desktop Engine

Actually, it appears to install fine. I used the command line parameters
setup SAPWD="strongpassword" SECURITYMODE=SQL as the instructions described.
I've tried with the double quotes and without. I've tried on a machine
running Windows 2000 and XP (home addition). I tried updating the XP
machine with XP service pack.
No matter what I try, it apperas to install fine. When I attenpt to connect
to the engine (through the ASP.Net Web Matrix), I select SQL Server
Authentication. I then enter "SA" (No quotes, I've tried both upper and
lower case) as the user and the strongpassword that I used as the parameter
when installing. Everytime I get the same message.
Unable to connect to the database server. SQL Server does not exist or
access denied. ConnectionOpen (Connect()).
I can tell the engine is running because its icon in the tray is running.
What am I missing?
Steve,
You may have installed with SA and strong password (Sql authentication) but I believe the install defaults to Windows authentication.
Follow the below to make sure ... (excerpt from KB-322336)
******
If you are not sure how to verify the authentication mode of your MSDE installation, you can check the corresponding registry entry. By default, the value of the Windows LoginMode registry subkey is set to 1 for Windows Authentication. When Mixed Mode authentication is enabled, this value is a 2.
a.. The location of the LoginMode subkey depends on whether you installed MSDE as the default MSDE instance or as a named instance. If you installed MSDE as the default instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
b.. If you installed MSDE as a named instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\Microsoft SQL Server\%InstanceName%\MSSQLServer\LoginMode
NOTE: Before you switch authentication modes, you must set a sa password to avoid exposing a potential security hole
******
Hope this helps,
Tunji
"Steve Wash" <swash1@.home.com> wrote in message news:79GdnaCfS4T2AtbcRVn-tQ@.comcast.com...
Actually, it appears to install fine. I used the command line parameters
setup SAPWD="strongpassword" SECURITYMODE=SQL as the instructions described.
I've tried with the double quotes and without. I've tried on a machine
running Windows 2000 and XP (home addition). I tried updating the XP
machine with XP service pack.
No matter what I try, it apperas to install fine. When I attenpt to connect
to the engine (through the ASP.Net Web Matrix), I select SQL Server
Authentication. I then enter "SA" (No quotes, I've tried both upper and
lower case) as the user and the strongpassword that I used as the parameter
when installing. Everytime I get the same message.
Unable to connect to the database server. SQL Server does not exist or
access denied. ConnectionOpen (Connect()).
I can tell the engine is running because its icon in the tray is running.
What am I missing?