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 on alternate TCP Port

I am trying to create an unattended install of MSDE 2000 sp3a that will set the default tcp port to something other than 1433. I am using a setup.ini file and have tried the following with out any success - any ideas would be great! Thanks
[Options]
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
[SdServerNetwork-0]
TCPPort=1433
hi Kelly
"Kelly" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:D1F4F952-218E-46F9-BF44-ED0F083F0AAD@.microsoft.com...
> I am trying to create an unattended install of MSDE 2000 sp3a that will
set the default tcp port to something other than 1433. I am using a
setup.ini file and have tried the following with out any success - any ideas
would be great! Thanks
> [Options]
> SECURITYMODE=SQL
> DISABLENETWORKPROTOCOLS=0
> [SdServerNetwork-0]
> TCPPort=1433
the MSDE 2000 setup boostrapper does not support TCP/IP port redirecting
the
[SdServerNetwork-0]
TCPPort=1433
parameter you provided is only valid for a full blown SQL Server unattended
installations and not for MSDE...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea!
What is the best method to change the tcp port after MSDE has been installed on the client machine?
Is it acceptable to modify the TcpPort via the registry:
HKLM\Software\Microsoft\MSSQLServer\SuperSocketNet Lib\Tcp
|||hi Kelly,
"Kelly" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:36ACB0E9-2A4E-45A1-A0A3-C430B364D324@.microsoft.com...
> Thanks Andrea!
> What is the best method to change the tcp port after MSDE has been
installed on the client machine?
> Is it acceptable to modify the TcpPort via the registry:
> HKLM\Software\Microsoft\MSSQLServer\SuperSocketNet Lib\Tcp
this can be a viable solution as, in order to install MSDE, admin privileges
are required, so you have access to the full registry, but remember you have
to modify that value using the Client Network Utility on all clients...
as regard the server, please have a look at
http://support.microsoft.com/?kbid=823938
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.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 all of your help

installation (instance name)

I am trying to install SqlServer PE on a WinXP desktop.
But I reach "install name" window where I am asked: "for a default
installation leave default checked..." and "to install a named instance clear
the default checkbox..." etc.
But the Default checkbox is grayed and I can just install a named instance.
What do I miss? I think it is not a user problem because I tryed with 2
different users (one is Administrator).
thanks in advanced for any feedback.
Hi
If Setup detects an already installed default instance, it will not let you
select the check box.
Maybe you have an instance of MSDE installed.
Look in Control Panel > Services to see if you have MSDE or SQL server
already installed.
Regards
Mike
"Francesco" wrote:

> I am trying to install SqlServer PE on a WinXP desktop.
> But I reach "install name" window where I am asked: "for a default
> installation leave default checked..." and "to install a named instance clear
> the default checkbox..." etc.
> But the Default checkbox is grayed and I can just install a named instance.
> What do I miss? I think it is not a user problem because I tryed with 2
> different users (one is Administrator).
> thanks in advanced for any feedback.
|||Correct. After the instance installation I have MSSQLSERVER and
MSSQL$my_instance. I suppose the first service is the engine that somebody
else installed previously... I'll try to remove the engine and start again.
Thanks.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> If Setup detects an already installed default instance, it will not let you
> select the check box.
> Maybe you have an instance of MSDE installed.
> Look in Control Panel > Services to see if you have MSDE or SQL server
> already installed.
> Regards
> Mike
> "Francesco" wrote:

installation (instance name)

I am trying to install SqlServer PE on a WinXP desktop.
But I reach "install name" window where I am asked: "for a default
installation leave default checked..." and "to install a named instance clear
the default checkbox..." etc.
But the Default checkbox is grayed and I can just install a named instance.
What do I miss? I think it is not a user problem because I tryed with 2
different users (one is Administrator).
thanks in advanced for any feedback.Hi
If Setup detects an already installed default instance, it will not let you
select the check box.
Maybe you have an instance of MSDE installed.
Look in Control Panel > Services to see if you have MSDE or SQL server
already installed.
Regards
Mike
"Francesco" wrote:
> I am trying to install SqlServer PE on a WinXP desktop.
> But I reach "install name" window where I am asked: "for a default
> installation leave default checked..." and "to install a named instance clear
> the default checkbox..." etc.
> But the Default checkbox is grayed and I can just install a named instance.
> What do I miss? I think it is not a user problem because I tryed with 2
> different users (one is Administrator).
> thanks in advanced for any feedback.|||Correct. After the instance installation I have MSSQLSERVER and
MSSQL$my_instance. I suppose the first service is the engine that somebody
else installed previously... I'll try to remove the engine and start again.
Thanks.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> If Setup detects an already installed default instance, it will not let you
> select the check box.
> Maybe you have an instance of MSDE installed.
> Look in Control Panel > Services to see if you have MSDE or SQL server
> already installed.
> Regards
> Mike
> "Francesco" wrote:
> > I am trying to install SqlServer PE on a WinXP desktop.
> > But I reach "install name" window where I am asked: "for a default
> > installation leave default checked..." and "to install a named instance clear
> > the default checkbox..." etc.
> >
> > But the Default checkbox is grayed and I can just install a named instance.
> > What do I miss? I think it is not a user problem because I tryed with 2
> > different users (one is Administrator).
> > thanks in advanced for any feedback.

installation (instance name)

I am trying to install SqlServer PE on a WinXP desktop.
But I reach "install name" window where I am asked: "for a default
installation leave default checked..." and "to install a named instance clea
r
the default checkbox..." etc.
But the Default checkbox is grayed and I can just install a named instance.
What do I miss? I think it is not a user problem because I tryed with 2
different users (one is Administrator).
thanks in advanced for any feedback.Hi
If Setup detects an already installed default instance, it will not let you
select the check box.
Maybe you have an instance of MSDE installed.
Look in Control Panel > Services to see if you have MSDE or SQL server
already installed.
Regards
Mike
"Francesco" wrote:

> I am trying to install SqlServer PE on a WinXP desktop.
> But I reach "install name" window where I am asked: "for a default
> installation leave default checked..." and "to install a named instance cl
ear
> the default checkbox..." etc.
> But the Default checkbox is grayed and I can just install a named instance
.
> What do I miss? I think it is not a user problem because I tryed with 2
> different users (one is Administrator).
> thanks in advanced for any feedback.|||Correct. After the instance installation I have MSSQLSERVER and
MSSQL$my_instance. I suppose the first service is the engine that somebody
else installed previously... I'll try to remove the engine and start again.
Thanks.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> If Setup detects an already installed default instance, it will not let yo
u
> select the check box.
> Maybe you have an instance of MSDE installed.
> Look in Control Panel > Services to see if you have MSDE or SQL server
> already installed.
> Regards
> Mike
> "Francesco" wrote:
>

Inserting the date as defaultvalue in a sqldatasource Parameter

Hi Guys.

I am trying to insert the date as the default value into the DatePosted parameter in the sqldatasource object. I have put have the following below but it doesn't work. I have also tried <asp:Parameter Name="DatePosted" Type="DateTime" DefaultValue="<%= Date.Now %>" />

<asp:Parameter Name="DatePosted" Type="DateTime" DefaultValue="<%= now() %>" />

I know the solution is probably simple and I look like an idiot, but excuse me because I am very knew and fragile at this lol...

any help would be great :).

Mike.

Change your code to this,and it is OK.

<asp:Parameter Name="DatePosted" Type="DateTime" DefaultValue='<%# DateTime.Now %>' />

|||

Hi Jason,This does not work either. It says you can't use databind in a parameter I tried it with <%= %> as well but still nothing?

Any other ideas?

|||

If you can't override the parameter, it would be easiest to change the sql statement to reference getdate or getutcdate instead like:

INSERT INTO MyTable(col1,DatePosted) VALUES (@.col1,getutcdate())

If you have to allow for the parameter to be overridden, try putting this code into page_init:

SqlDatasource1.InsertParameters("DatePosted").DefaultValue=now

|||just do it at the database level via enterprise manager by modifying the table in question and set the default for the column by specifying the getdate() function so when a recorded is inserted via code with dateposted not supplied the sql server will insert that column with the current date.|||I have the same problem and this solution doesnt work. The column in the table has a default of getdate(), but I still get an error that NULL cannot be insert into the column. The problem is there is no way to tell it to not supply a value--if a value is not set it will supply NULL. Is there another way to default a DateTime parameter to DateTime.Now or getdate()? TIA|||

The solution I posted should work. The solution posted after mine should also work.

Please post your code.

|||

Doing it at the database level only works if you can remove it as a parameter entirely. In my case I needed to allow the user to enter datetime and only default it to getdate()/DateTime.Now when they choose not to enter specific date.

I knew of the page init method you suggested, but I was trying to avoid this as I was experimenting with how much you can do with only declarative code--I guess I just hit one of the limits of declarative coding.

(For the record, I much prefer DDD with NHibernate, NUnit, etc., but in some cases, especially for small/trivial/non-critical projects, being able to do things quickly outweighs other concerns.)