Installing and Configuring Reporting Services using the Command Prompt

Hello, I have a question regarding installing SQL Express with Advanced Services from the command prompt. I am executing a .cmd file which has the following syntax:

start /wait setup.exe /qb INSTANCENAME=Tim ADDLOCAL=SQL_Engine,Connectivity,RS_Server,RS_Web_Interface SAPWD=1StrongPassword_2 SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0

Yet, after the installation when I run the Reporting Services configuration tool, none of the settings for Reporting Services are set. I would like to be able to install Reporting Services from the command prompt and have it use the default settings for creating a default website just like you can through the User Interface using the Setup.exe but cannot seem to figure out what I am missing in my .cmd file?

I would appreciate any help anyone can provide.

Tim

I suspect that you are wanting to deploy Reporting Services with your application.

If so, these resources may be helpful:

SQL Server 2005 UnAttended Installations
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://msdn2.microsoft.com/en-us/library/bb264562.aspx
http://www.devx.com/dbzone/Article/31648

|||

Thanks Arnie, this is great!

Tim

Installing A Failover Cluster

I have two matched servers, one will be Active and one will be Passive.
The servers have Windows 2000 Advanced Server and I have SQL Server 2000
Enterprise Edition.
My question is, do I also need a box called a Shared Disk Array, or can I
use another server I currently have that has lots of disk space on it?
Correction: I have Windows 2000 Advanced Server
"Vincel2k2" wrote:

> I have two matched servers, one will be Active and one will be Passive.
> The servers have Windows 2000 Advanced Server and I have SQL Server 2000
> Enterprise Edition.
> My question is, do I also need a box called a Shared Disk Array, or can I
> use another server I currently have that has lots of disk space on it?
>
|||You will indeed need shared storage.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...[vbcol=seagreen]
> Correction: I have Windows 2000 Advanced Server
> "Vincel2k2" wrote:
|||Hi
You need to get your self a Storage Area Network (SAN) to store your data
on.
For clustering, make sure that your hardware is on the Windows Hardware
Compatibility List (HCL)
Read the documentation on
http://www.microsoft.com/windowsserv...g/default.mspx
to get an understanding.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...[vbcol=seagreen]
> Correction: I have Windows 2000 Advanced Server
> "Vincel2k2" wrote:
I[vbcol=seagreen]
|||I also have two matched servers with Win2003EntSrv that I would like to
install an active/passive failover cluster of Yukon on. Since this is a lab
environment and I don't have the $$ for a SAN, will it work with a Network
Storage HD? I realize the performance won't be great, but I'm looking for
the experience in how to build/configure the environment.
Any tips?
An alternative question for the lab environment is ... how would you do this
in two VPC? Or would you steer clear?
Thanks
Al
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> You need to get your self a Storage Area Network (SAN) to store your data
> on.
> For clustering, make sure that your hardware is on the Windows Hardware
> Compatibility List (HCL)
> Read the documentation on
> http://www.microsoft.com/windowsserv...g/default.mspx
> to get an understanding.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
> news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...
> I
>
>
|||Virtual Server 2005 will work nicely for this test. See
http://www.hands-on-labs.com/microsoft.asp?ID=4477 for the steps
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"al_stark_born" <al_stark_born@.discussions.microsoft.com> wrote in message
news:E579B181-45E6-4DF2-8BCA-E7F1D2DD44C7@.microsoft.com...[vbcol=seagreen]
>I also have two matched servers with Win2003EntSrv that I would like to
> install an active/passive failover cluster of Yukon on. Since this is a
> lab
> environment and I don't have the $$ for a SAN, will it work with a Network
> Storage HD? I realize the performance won't be great, but I'm looking for
> the experience in how to build/configure the environment.
> Any tips?
> An alternative question for the lab environment is ... how would you do
> this
> in two VPC? Or would you steer clear?
> Thanks
> Al
> "Mike Epprecht (SQL MVP)" wrote:
sql

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

Installation problems with Reportin Services

I'm having problem installing SQL Server 2005 Express Edition with Advanced Services SP1. Everything installs fine until I reach the installation of Reporting Services, there I get the following message --> "IID_IIMSAdminBase object error. The error code is -2147221164."

Any ideas as to how to solve this..?

Thanks in advance.

Could you post the information from the setup logs?

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

Mike

|||

Any answer to this post?....I am having the same problem.

Patrick (pdill@.clovor.com)

|||Same for you, can you post the log files of the installer ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Jens,

I uninstalled SQL Server(all parts of it), Uninstalled IIS, and the reinstalled worked fine.

Patrick.

Installation problems with Reportin Services

I'm having problem installing SQL Server 2005 Express Edition with Advanced Services SP1. Everything installs fine until I reach the installation of Reporting Services, there I get the following message --> "IID_IIMSAdminBase object error. The error code is -2147221164."

Any ideas as to how to solve this..?

Thanks in advance.

Could you post the information from the setup logs?

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

Mike

Installation on Vista

Hi, I have a serious issue installing sql server express (advanced edition) on Windows Vista Home Premium. I'm doing the install with elevated priviledges but setup of the sql server always fails at the same point with the following error:

{Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'

I've tried many different combinations, including advanced installation options selecting sql server instance to run as local system or local server but nothing came out of that. I always select add current user to the sql server administrators group.
Any help on this issue is appreciated. Below follows the setup summary log:

Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Home Edition (Build 6000)
Time : Mon Feb 26 22:02:41 2007
Machine : JUPITER
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SQLSupport_1.log
--
Machine : JUPITER
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SQLNCLI_1.log
--
Machine : JUPITER
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SqlWriter_1.log
--
Machine : JUPITER
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--
Machine : JUPITER
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error Number : 29515
--

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

Time : Mon Feb 26 22:30:02 2007

I'm really new to the whole SQL thing too.

Also had trouble with installation as well.

It's weird how they don't tell you to setup the app correctly.

There are two ways I believe to set up the app as an administrator.

The easiest for me was to goto "All Programs" in the start bar and right-click on the SQL Management application and they click "Run as Administrator"

Maybe it might launch correctly. It did for me.

Or I remember with Win XP days that you could boot and hit one of the function keys (I think F2) that would normally take you to Safe Mode but gives you the option to log onto as a system administrator as well.

Maybe that may work for Vista as well. Once you log in as system administrator you can open SQL Management and add your user windows account as a sysadmin through the app to give you correct permissions.

Hope any of that was readable and somewhat understandable.
|||

Hi, Amie.

Thank you for the tip, but the trouble is that this error occurs during the installation fase of the sql engine, so installation fails and it rolls back, which essentially means that the sql instance fails to run, so there is no server to manage. :-(

|||

Hi Zzermont,

Are you installing a new instance of SQL or upgrading an existing installation? If you are upgrading an existing installation I would guess that you are trying to select SQL Authentication during the upgrade process, which is not supported. If this is a new installation, I'm not sure what's going on. I've installed SQL Express successfully on Vista a number of times.

Either way, I'm pushing this message over to the Setup forum for more directed help.

Mike

|||

Hi, Mike.

It is a new installation on vista. The only thing to note is that I have Visual Studio 2005 SP1 installed (with sql server deselected at installation time).

Alek

Installation on Vista

Hi, I have a serious issue installing sql server express (advanced edition) on Windows Vista Home Premium. I'm doing the install with elevated priviledges but setup of the sql server always fails at the same point with the following error:

{Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'

I've tried many different combinations, including advanced installation options selecting sql server instance to run as local system or local server but nothing came out of that. I always select add current user to the sql server administrators group.
Any help on this issue is appreciated. Below follows the setup summary log:

Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Home Edition (Build 6000)
Time : Mon Feb 26 22:02:41 2007
Machine : JUPITER
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SQLSupport_1.log
--
Machine : JUPITER
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SQLNCLI_1.log
--
Machine : JUPITER
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SqlWriter_1.log
--
Machine : JUPITER
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--
Machine : JUPITER
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error Number : 29515
--

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

Time : Mon Feb 26 22:30:02 2007

I'm really new to the whole SQL thing too.

Also had trouble with installation as well.

It's weird how they don't tell you to setup the app correctly.

There are two ways I believe to set up the app as an administrator.

The easiest for me was to goto "All Programs" in the start bar and right-click on the SQL Management application and they click "Run as Administrator"

Maybe it might launch correctly. It did for me.

Or I remember with Win XP days that you could boot and hit one of the function keys (I think F2) that would normally take you to Safe Mode but gives you the option to log onto as a system administrator as well.

Maybe that may work for Vista as well. Once you log in as system administrator you can open SQL Management and add your user windows account as a sysadmin through the app to give you correct permissions.

Hope any of that was readable and somewhat understandable.|||

Hi, Amie.

Thank you for the tip, but the trouble is that this error occurs during the installation fase of the sql engine, so installation fails and it rolls back, which essentially means that the sql instance fails to run, so there is no server to manage. :-(

|||

Hi Zzermont,

Are you installing a new instance of SQL or upgrading an existing installation? If you are upgrading an existing installation I would guess that you are trying to select SQL Authentication during the upgrade process, which is not supported. If this is a new installation, I'm not sure what's going on. I've installed SQL Express successfully on Vista a number of times.

Either way, I'm pushing this message over to the Setup forum for more directed help.

Mike

|||

Hi, Mike.

It is a new installation on vista. The only thing to note is that I have Visual Studio 2005 SP1 installed (with sql server deselected at installation time).

Alek

installation of sql express edition with advanced features

hi friends
where i can find the installation guide for sql express 2005. mine is windows xp os.

regards

sekar.r

check these links and there are many KBs available.

http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQLEXP2005Advanced.htm

http://www.microsoft.com/downloads/details.aspx?FamilyID=B0167129-5AC8-49C4-90BD-0493F3773081&displaylang=en

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

Madhu