Install RS for multiple websites on single computer

My understanding is that RS installs ONLY on the default website. I'm hosting
four websites on a single IIS computer. I want to use Reporting Services
separately on each of the websites. That is, each will have its own database
and its own set of reports. Is this possible? How?
Thanks.
DilipDilip,
I am not sure if you can host multiple instances of RS on single server,
but I have achieved the same requirement by creating a separate directory for
each application. Each corresponding application can have separate directory
with its Reports and required Dataset.
Hope this helps.
Mahesh
"Dilip Kumar" wrote:
> My understanding is that RS installs ONLY on the default website. I'm hosting
> four websites on a single IIS computer. I want to use Reporting Services
> separately on each of the websites. That is, each will have its own database
> and its own set of reports. Is this possible? How?
> Thanks.
> Dilip|||Thanks for your reply, Mahesh.
I want to keep all the domains separate. I want to access each set of
reports as follows:
http://www.companyA.com/Reports
http://www.companyB.com/Reports
http://www.companyC.com/Reports
http://www.companyD.com/Reports
Dilip
"Mahesh Gaware" wrote:
> Dilip,
> I am not sure if you can host multiple instances of RS on single server,
> but I have achieved the same requirement by creating a separate directory for
> each application. Each corresponding application can have separate directory
> with its Reports and required Dataset.
> Hope this helps.
> Mahesh
> "Dilip Kumar" wrote:
> > My understanding is that RS installs ONLY on the default website. I'm hosting
> > four websites on a single IIS computer. I want to use Reporting Services
> > separately on each of the websites. That is, each will have its own database
> > and its own set of reports. Is this possible? How?
> >
> > Thanks.
> > Dilip|||hi Dilip,
hmm.. I am sorry, I have no idea about how this can be acheived using
single IIS server for single RS instance.
Thanks,
Mahesh
"Dilip Kumar" wrote:
> Thanks for your reply, Mahesh.
> I want to keep all the domains separate. I want to access each set of
> reports as follows:
> http://www.companyA.com/Reports
> http://www.companyB.com/Reports
> http://www.companyC.com/Reports
> http://www.companyD.com/Reports
> Dilip
> "Mahesh Gaware" wrote:
> > Dilip,
> > I am not sure if you can host multiple instances of RS on single server,
> > but I have achieved the same requirement by creating a separate directory for
> > each application. Each corresponding application can have separate directory
> > with its Reports and required Dataset.
> >
> > Hope this helps.
> >
> > Mahesh
> >
> > "Dilip Kumar" wrote:
> >
> > > My understanding is that RS installs ONLY on the default website. I'm hosting
> > > four websites on a single IIS computer. I want to use Reporting Services
> > > separately on each of the websites. That is, each will have its own database
> > > and its own set of reports. Is this possible? How?
> > >
> > > Thanks.
> > > Dilip|||Hi Dilip,
I have been thinking about how to do this as I have been thinking of
doing the same...though I am coming to the conclusion it is probably
best to have one server per customer....
However, my thoughts on the subject were as follows...
1. Set up links or domains for each customer.
2. repoint the domains into a single dot net nuke portal (I am
considerign using dot net nuke www.dotnetnuke.com) as the 'BI portal'
for clients....probably a release 2.0 thing for me now.
3. User signs in or can now use integrated security for DNN but if you
have multiple companies on one server you are probably going to host
the server outside their security domains so you need a way to securely
log them into DNN.
4. Present reports inside the DNN environment which will allow you to
have the users looking at the one IIS server and one database without
each customer knowing about the other.....you control where the users
point to for each report or directory so you can just set up different
directories for different customers.
5. You could even set graphics etc from the userid or portal you were
looking at so the clients saw different formats etc inside their BI
portal...
Having played with all this...I thought it was easier just to get the
clients to pay for one machine each...
Peter

Install Reporting Services on another IIS website

I am using IIS6 and installed Reporting Services on http://myWebsite in IIS.
This works fine and I can access http://myWebsite/ReportServer and http://myWebsite/Reports

My problem is that I also need Reporting Services on another website in IIS6.
I have a website http://www.myothersite.com which I also need Reporting Services on. I created two virtual directories (Reports,ReportServer) that point to the same directories as which the original Reporting Services site does, but it doesn't work. I get "You are not authorized to view this page message in IE." when I view http://www.myothersite.com/ReportViewer in my browser

Any suggestions?i dont think you would need to report managers. you would only need one report manager and create your folders in it and use the appropriate paths in various websites on the server.

hthsql

Install Problem Error 29503 & 1067 OR Error 29503 & 2146885628

I'm new with development and just wanted to get the Personal Website Sample to work. So far, I'm have am having a terrible time installing SQL Express Edition. I'm not exactly sure what to do next. I have installed, manually uninstalled, and reinstalled many times. Sometimes I get error 29503 & 1067. Other times when I reinstall I get 29503 & -2146885628 . Here's the info I got so far for my 29503&1067 since that error occurs 95% of time. I believe I got the -2146885628 error when I changed a setting from network to local services.

I feel so confused right now. Any help would be appreciative.

From the Summary Log:

Code Snippet

Machine : DELL1

Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--
Machine : DELL1
Product : Microsoft SQL Server 2005
Product Version : 9.2.3042.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0018_DELL1_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
Error Number : 29503
--

From there, I searched the error logs to find this in the SQL.log

Code Snippet

- Context --

Setting status of unmanaged components and removing unmanaged resources

Do_sqlScript

SqlScriptHlpr

Start service MSSQL$SQLEXPRESS

Error Code: 1067

MSI (s) (84!D4) [01:48:10:750]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly.

.

Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly.

.

Doing Action: Do_sqlScript

PerfTime Start: Do_sqlScript : Tue Aug 28 01:48:10 2007

Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qJapanese_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue Aug 28 01:48:10 2007

Service failed unexpectedly (1067)

Error Code: 0x8007042b (1067)

Windows Error Text: The process terminated unexpectedly.

Source File Name: sqlsetuplib\service.cpp

Compiler Timestamp: Wed Jun 14 16:29:04 2006

Function Name: sqls::Service::Start

Source Line Number: 301

- Context --

Setting status of unmanaged components and removing unmanaged resources

Do_sqlScript

SqlScriptHlpr

Start service MSSQL$SQLEXPRESS

Do_sqlScript

SqlScriptHlpr

Start service MSSQL$SQLEXPRESS

Error Code: 1067

MSI (s) (84!D4) [01:48:13:968]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly.

.

Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly.

.

MSI (s) (84:10) [01:48:14:109]: User policy value 'DisableRollback' is 0

MSI (s) (84:10) [01:48:14:109]: Machine policy value 'DisableRollback' is 0

Action ended 1:48:14: InstallFinalize. Return value 3.

MSI (s) (84:10) [01:48:14:171]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=924585293,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)

MSI (s) (84:10) [01:48:14:171]: Executing op: DialogInfo(Type=0,Argument=1033)

MSI (s) (84:10) [01:48:14:171]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005)

MSI (s) (84:10) [01:48:14:171]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])

MSI (s) (84:10) [01:48:14:171]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1])

MSI (s) (84:10) [01:48:14:171]: Executing op: ProductInfo(ProductKey={B0F9497C-52B4-4686-8E73-74D866BBDF59},ProductName=Microsoft SQL Server 2005,PackageName=sqlrun_sql.msi,Language=1033,Version=151129058,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIcon.ico,PackageMediaPath=\Setup\,PackageCode={08AD0897-0300-4F7D-A3CC-A0CCEDD42E0D},,,InstanceType=1,LUASetting=0,RemoteURTInstalls=0)

MSI (s) (84:10) [01:48:14:171]: Executing op: ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Stopping SQL Service: [1])

MSI (s) (84:10) [01:48:14:171]: Executing op: CustomActionRollback(Action=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlScript,CustomActionData=1
0
0
Configuring Microsoft SQL Server
81062400
lpc:DELL1\SQLEXPRESS
)

MSI (s) (84:B4) [01:48:14:171]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI571.tmp, Entrypoint: Rollback_sqlScript

Function=Rollback_sqlScript

Doing Action: Rollback_sqlScript

This log does get kind of big, so if you need more information, please feel free to ask

The first link is a cleaned up version of the Personal Starter Kit and the second link is where he can answer your questions. The third link is tutorials for many starter kits. Hope this helps.

http://www.jeremywadsworth.com/

http://forums.asp.net/1003.aspx

http://msdn2.microsoft.com/en-us/library/aa530759.aspx

|||Will I ever need to install SQL EE (right now I'm SQL less)? This error looks really big and I'm not sure exactly how to solve it.
|||

EDIT

I don't see how you plan to run an application that needs SQL Server database without running Express. Express Advanced that is almost like the full edition is free. If you plan to develop you can download the Advanced below.

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

|||Still waiting around for an answer to my install errors. I did install mySQL in about 15mins vs 3 full days and counting for SQL Server EE. It's pretty nice...but besides that, still wondering if anyone knows about these SQL EE Errors?
|||

You cannot install MySQL and expect to run software created to use SQL Server Here is the thing I have installed the kit without problem a whileback and you are having problem so read those tutorials in my recent post the two for this kit and post in the forum I gave to you.

|||I am very very confused now.

I can't install SQL Server Express Edition because I get errors 29503 & -2146885628 during the install process. Thus, SQL Server Express is not installed in my computer.

The links you gave me are troubleshooting tips for the Personal WebKit. Since you gave it too me, I thought I could run it without SQL Server Express Edition but your reply to that makes it sound like I need SQL Server Express Edition which I cannot install due to the errors above. I already install, manually uninstall, etc etc etc. As far as I can tell, during my install process, SQL Server Express Edition just installs maybe 80% of what it should be installing because my summary log says this:

I am assumming because my summary log says "Failed" in the install section, that SQL Server failed to install. I may be wrong and this may be a bug in the summary log.

I am very very confused now. Do I or do I not need to install SQL Server Express Edition first?
|||SQL Server 2005 is the easiest SQL Server to install I have installed 7.0, 2000 and now 2005 on all exist operating systems except Vista, that means server included. Now if you are running XP it comes with System Restore roll your Operating System back by one month if you have restore point that far back. You cannot install this starter kit without SQL Server because I have not seen MySQL versions of it. The link I gave you is where errors for this kit are resolved and you are right your current problem is SQL Server installation so now go roll back the Operating System and try the install again. Now go do some work and post again.|||

I did a search and found a number of possible causes of this error, but the log segment you provided does not provide enough information to really tell what the issue is. For starters, check out the KB article at http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B920114 and see if this applies to your situation.

If that doesn't work, search the log for "ue 3" to find any lines that contain 'Return Value 3' indicating a failure. The several lines above the return value should give you a more specific message about what actually failed to cause the error you're seeing. If that information doesn't point you in an obvious direction, post that snippet to the forum and we can take a look at it.

Mike

sql

Install Problem Error 29503 & 1067 OR Error 29503 & 2146885628

I'm new with development and just wanted to get the Personal Website Sample to work. So far, I'm have am having a terrible time installing SQL Express Edition. I'm not exactly sure what to do next. I have installed, manually uninstalled, and reinstalled many times. Sometimes I get error 29503 & 1067. Other times when I reinstall I get 29503 & -2146885628 . Here's the info I got so far for my 29503&1067 since that error occurs 95% of time. I believe I got the -2146885628 error when I changed a setting from network to local services.

I feel so confused right now. Any help would be appreciative.

From the Summary Log:

Code Snippet

Machine : DELL1

Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--
Machine : DELL1
Product : Microsoft SQL Server 2005
Product Version : 9.2.3042.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0018_DELL1_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
Error Number : 29503
--

From there, I searched the error logs to find this in the SQL.log

Code Snippet

- Context --

Setting status of unmanaged components and removing unmanaged resources

Do_sqlScript

SqlScriptHlpr

Start service MSSQL$SQLEXPRESS

Error Code: 1067

MSI (s) (84!D4) [01:48:10:750]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly.

.

Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly.

.

Doing Action: Do_sqlScript

PerfTime Start: Do_sqlScript : Tue Aug 28 01:48:10 2007

Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qJapanese_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue Aug 28 01:48:10 2007

Service failed unexpectedly (1067)

Error Code: 0x8007042b (1067)

Windows Error Text: The process terminated unexpectedly.

Source File Name: sqlsetuplib\service.cpp

Compiler Timestamp: Wed Jun 14 16:29:04 2006

Function Name: sqls::Service::Start

Source Line Number: 301

- Context --

Setting status of unmanaged components and removing unmanaged resources

Do_sqlScript

SqlScriptHlpr

Start service MSSQL$SQLEXPRESS

Do_sqlScript

SqlScriptHlpr

Start service MSSQL$SQLEXPRESS

Error Code: 1067

MSI (s) (84!D4) [01:48:13:968]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly.

.

Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly.

.

MSI (s) (84:10) [01:48:14:109]: User policy value 'DisableRollback' is 0

MSI (s) (84:10) [01:48:14:109]: Machine policy value 'DisableRollback' is 0

Action ended 1:48:14: InstallFinalize. Return value 3.

MSI (s) (84:10) [01:48:14:171]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=924585293,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)

MSI (s) (84:10) [01:48:14:171]: Executing op: DialogInfo(Type=0,Argument=1033)

MSI (s) (84:10) [01:48:14:171]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005)

MSI (s) (84:10) [01:48:14:171]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])

MSI (s) (84:10) [01:48:14:171]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1])

MSI (s) (84:10) [01:48:14:171]: Executing op: ProductInfo(ProductKey={B0F9497C-52B4-4686-8E73-74D866BBDF59},ProductName=Microsoft SQL Server 2005,PackageName=sqlrun_sql.msi,Language=1033,Version=151129058,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIcon.ico,PackageMediaPath=\Setup\,PackageCode={08AD0897-0300-4F7D-A3CC-A0CCEDD42E0D},,,InstanceType=1,LUASetting=0,RemoteURTInstalls=0)

MSI (s) (84:10) [01:48:14:171]: Executing op: ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Stopping SQL Service: [1])

MSI (s) (84:10) [01:48:14:171]: Executing op: CustomActionRollback(Action=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlScript,CustomActionData=1
0
0
Configuring Microsoft SQL Server
81062400
lpc:DELL1\SQLEXPRESS
)

MSI (s) (84:B4) [01:48:14:171]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI571.tmp, Entrypoint: Rollback_sqlScript

Function=Rollback_sqlScript

Doing Action: Rollback_sqlScript

This log does get kind of big, so if you need more information, please feel free to ask

The first link is a cleaned up version of the Personal Starter Kit and the second link is where he can answer your questions. The third link is tutorials for many starter kits. Hope this helps.

http://www.jeremywadsworth.com/

http://forums.asp.net/1003.aspx

http://msdn2.microsoft.com/en-us/library/aa530759.aspx

|||Will I ever need to install SQL EE (right now I'm SQL less)? This error looks really big and I'm not sure exactly how to solve it.
|||

EDIT

I don't see how you plan to run an application that needs SQL Server database without running Express. Express Advanced that is almost like the full edition is free. If you plan to develop you can download the Advanced below.

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

|||Still waiting around for an answer to my install errors. I did install mySQL in about 15mins vs 3 full days and counting for SQL Server EE. It's pretty nice...but besides that, still wondering if anyone knows about these SQL EE Errors?
|||

You cannot install MySQL and expect to run software created to use SQL Server Here is the thing I have installed the kit without problem a whileback and you are having problem so read those tutorials in my recent post the two for this kit and post in the forum I gave to you.

|||I am very very confused now.

I can't install SQL Server Express Edition because I get errors 29503 & -2146885628 during the install process. Thus, SQL Server Express is not installed in my computer.

The links you gave me are troubleshooting tips for the Personal WebKit. Since you gave it too me, I thought I could run it without SQL Server Express Edition but your reply to that makes it sound like I need SQL Server Express Edition which I cannot install due to the errors above. I already install, manually uninstall, etc etc etc. As far as I can tell, during my install process, SQL Server Express Edition just installs maybe 80% of what it should be installing because my summary log says this:

I am assumming because my summary log says "Failed" in the install section, that SQL Server failed to install. I may be wrong and this may be a bug in the summary log.

I am very very confused now. Do I or do I not need to install SQL Server Express Edition first?
|||SQL Server 2005 is the easiest SQL Server to install I have installed 7.0, 2000 and now 2005 on all exist operating systems except Vista, that means server included. Now if you are running XP it comes with System Restore roll your Operating System back by one month if you have restore point that far back. You cannot install this starter kit without SQL Server because I have not seen MySQL versions of it. The link I gave you is where errors for this kit are resolved and you are right your current problem is SQL Server installation so now go roll back the Operating System and try the install again. Now go do some work and post again.|||

I did a search and found a number of possible causes of this error, but the log segment you provided does not provide enough information to really tell what the issue is. For starters, check out the KB article at http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B920114 and see if this applies to your situation.

If that doesn't work, search the log for "ue 3" to find any lines that contain 'Return Value 3' indicating a failure. The several lines above the return value should give you a more specific message about what actually failed to cause the error you're seeing. If that information doesn't point you in an obvious direction, post that snippet to the forum and we can take a look at it.

Mike

Install on non-default website

I would like to install RS on my intranet box on a non-default website and
use host-headers to hit the site.
Is this possible even though RS books online says to set the IP address for
the site to "all unassigned"?
TIA,
Berry"Berry Morgan" wrote:
> I would like to install RS on my intranet box on a non-default website and
> use host-headers to hit the site.
> Is this possible even though RS books online says to set the IP address for
> the site to "all unassigned"?
It's not possible to install it to a non-default website, but you can move
it afterwards. Follow this link for more details:
http://www.henriksen.no/Blog/PermaLink,guid,5235a943-d55a-482c-ba1f-e599fb75e960.aspx