Installing Multiple Instances of ASP.NET Application Services on ONE SQL Server Database

Hi,

I am trying to install multiple application services on 1 sql server database. Is this possible? I do not know how to install anything but the default application services settings for the membership, roles, etc.

Please help if you can.

Thanks,

Ezeibe

Seems not possilble in 1 databases, but should be able in different databases on 1 SQL instance. Just use aspnet_regsql.exe to create schema for membership in serveral database, and then connect to 1 database respectively in your applications.

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

Being new to setting up MSDE, we are currently testing crystal reports
and Microsoft Sharepoint services. We want to install these on a
seperate server and see that they use MSDE. We also have a server
currently installed with MSDE for Altiris deployment images and HP
insite manager. Is it a good practice to link to the existing MSDE
server or house this instance of MSDE on the new test server.
Thanks
John
hi John,
JohnC wrote:
> Being new to setting up MSDE, we are currently testing crystal reports
> and Microsoft Sharepoint services. We want to install these on a
> seperate server and see that they use MSDE. We also have a server
> currently installed with MSDE for Altiris deployment images and HP
> insite manager. Is it a good practice to link to the existing MSDE
> server or house this instance of MSDE on the new test server.
usually it's considered a good practice to separate the database server from
the application server both for security reasons and performance reasons, in
order to have a "dedicated" machine for each task...
just a caveat.. Sharepoint usually requires a lot of database space and
ships with a dedicated MSDE version, known as WMSDE, which has been modified
by Microsoft to remove the 2gb limit for each database.. WMSDE is shipped
only with Sharepoint and can only be (legally) used by it...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.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 for your info, looking at the big picture and future
expansion. Taking on board your info about a dedicated database server,
are we better off having an sql server and all are database accessing
software linking up to it like Altiris, sharepoint, crystal reports,
and our own web site which at the moment is linked to mysql.
Regards
John

Installing MS Reporting Services Probs

Hi NG
We have a problem to install the MS Reporting Services 2000 on a Windows
2003 Server Web Edition.
IIS is propertly installed, runing, and its serves many wepages.
During the installation (System prequestites check) of RS comes the
following message:
"IIS either not installed or not configured for a server component
installation"
We have no idea, how we can configure the IIS for server component
installations.
Thx for help.
Greets TomSeems you can only install Reporting Services Developer Edition on Windows
2003 server Web edition:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8jom.asp
Or maybe you can try setting it up as a web farm, as your database will have
to be running on a different server anyway:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8jom.asp
Kaisa M. Lindahl Lervik
"news.microsoft.com" <thomas.scholtke@.rbc-is.ch> wrote in message
news:ukqWIurPGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi NG
> We have a problem to install the MS Reporting Services 2000 on a Windows
> 2003 Server Web Edition.
> IIS is propertly installed, runing, and its serves many wepages.
> During the installation (System prequestites check) of RS comes the
> following message:
> "IIS either not installed or not configured for a server component
> installation"
> We have no idea, how we can configure the IIS for server component
> installations.
> Thx for help.
> Greets Tom
>

Installing Express2005 SQL

I am trying to setup a new server for a non-profit i donate my services to.

I want to have SQL for an intranet based program that will be converted from a currently used Access database.

I can not get Express (any version to install). Below are the specs of the server and the log from the install.

Any suggestions and thanks in advance,

Lynn

Operating System System Model Windows 2000 Advanced Server Service Pack 4 (build 2195) COMPAQ PROLIANT 800 Processor ^a Main Circuit Board ^b 500 megahertz Intel Pentium III
32 kilobyte primary memory cache
512 kilobyte secondary memory cache BIOS: 12/31/99 Drives Memory Modules ^c,d 27.05 Gigabytes Usable Hard Drive Capacity
23.01 Gigabytes Hard Drive Free Space

COMPAQ CDR-8435 [CD-ROM drive]
3.5" format removeable media [Floppy drive]
Compaq DDS3 12/24 GB DAT Drive [Tape drive]

IBM DCAS-34330W SCSI Disk Device (4.33 GB) -- drive 1
IBM DDRS-34560D SCSI Disk Device (4.57 GB) -- drive 2
IBM DDRS-34560D SCSI Disk Device (4.57 GB) -- drive 3
IBM-PSG ST318404LW !# SCSI Disk Device (18.19 GB) -- drive 0 192 Megabytes Installed Memory Local Drive Volumes

c: (NTFS on drive 0) 18.19 GB 14.45 GB free f: (NTFS on drive 3) 4.54 GB 4.26 GB free g: (NTFS on drive 1) 4.33 GB 4.30 GB free

Network Drives None detected

Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Time : Mon Nov 06 15:22:52 2006
MAPSERV : The current system does not meet minimum hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
MAPSERV : The system does not have the required version of Microsoft Data Access Components (MDAC) for this SQL Server release. For details, see Hardware and Software Requirements for Installing SQL Server 2005 in Microsoft SQL Server Books Online.

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 Nov 06 15:23:26 2006

Your hardware fails by just a few Mhz of CPU speed. From BOL for SQL Express:

Pentium III-compatible processor or higher required

Minimum: 600 MHz

Recommended: 1 GHz or higher

Minimum: 192 MB

Recommended: 512 MB or more

Maximum: OS maximum

--
SvenC

|||

The failure is that your OS does not have the proper version of MDAC installed. I believe the minimum required is MDAC 2.6 SP1, but there shouldn't be an issue with installing a more recent version.

Once you take care of that, you should be able to attempt another Express install again.

|||

Thanks for all your help.

You were correct about needing the updated MDAC. I searched the MDAC 2.6 SP1 and found a 2.8 SP1. I installed the latest version and re-started the install with success.

Thanks for your keen eye R. Green

|||

hi

if i want install Express2005 SQL on windows vista (ultimate) , what is the requriments that must be avaliable ?

Installing Express2005 SQL

I am trying to setup a new server for a non-profit i donate my services to.

I want to have SQL for an intranet based program that will be converted from a currently used Access database.

I can not get Express (any version to install). Below are the specs of the server and the log from the install.

Any suggestions and thanks in advance,

Lynn

Operating System

System Model

Windows 2000 Advanced Server Service Pack 4 (build 2195)

COMPAQ PROLIANT 800

Processor ^a

Main Circuit Board ^b

500 megahertz Intel Pentium III
32 kilobyte primary memory cache
512 kilobyte secondary memory cache

BIOS: 12/31/99

Drives

Memory Modules ^c,d

27.05 Gigabytes Usable Hard Drive Capacity
23.01 Gigabytes Hard Drive Free Space

COMPAQ CDR-8435 [CD-ROM drive]
3.5" format removeable media [Floppy drive]
Compaq DDS3 12/24 GB DAT Drive [Tape drive]

IBM DCAS-34330W SCSI Disk Device (4.33 GB) -- drive 1
IBM DDRS-34560D SCSI Disk Device (4.57 GB) -- drive 2
IBM DDRS-34560D SCSI Disk Device (4.57 GB) -- drive 3
IBM-PSG ST318404LW !# SCSI Disk Device (18.19 GB) -- drive 0

192 Megabytes Installed Memory

Local Drive Volumes

c: (NTFS on drive 0)

18.19 GB

14.45 GB free

f: (NTFS on drive 3)

4.54 GB

4.26 GB free

g: (NTFS on drive 1)

4.33 GB

4.30 GB free

Network Drives

None detected

Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Time : Mon Nov 06 15:22:52 2006
MAPSERV : The current system does not meet minimum hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
MAPSERV : The system does not have the required version of Microsoft Data Access Components (MDAC) for this SQL Server release. For details, see Hardware and Software Requirements for Installing SQL Server 2005 in Microsoft SQL Server Books Online.

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 Nov 06 15:23:26 2006

Your hardware fails by just a few Mhz of CPU speed. From BOL for SQL Express:

Pentium III-compatible processor or higher required

Minimum: 600 MHz

Recommended: 1 GHz or higher

Minimum: 192 MB

Recommended: 512 MB or more

Maximum: OS maximum

--
SvenC

|||

The failure is that your OS does not have the proper version of MDAC installed. I believe the minimum required is MDAC 2.6 SP1, but there shouldn't be an issue with installing a more recent version.

Once you take care of that, you should be able to attempt another Express install again.

|||

Thanks for all your help.

You were correct about needing the updated MDAC. I searched the MDAC 2.6 SP1 and found a 2.8 SP1. I installed the latest version and re-started the install with success.

Thanks for your keen eye R. Green

|||

hi

if i want install Express2005 SQL on windows vista (ultimate) , what is the requriments that must be avaliable ?

Installing Exchange Pack for Reporting Services

Has anyone successfully installed the Exchange Pack for Reporting Services?
I've attempted a couple of times and continue to get "Object Reference not
set to an instance of object", which causes the install to rollback.
Does anyone know how to correct this problem?
This question was originally posted in 10\04, but there was never an answer
posted.Do you have a default instance of SQL Server? What OS are you running? We
have never been able to repro this here.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"winkle60" <winkle60@.discussions.microsoft.com> wrote in message
news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> Has anyone successfully installed the Exchange Pack for Reporting
> Services?
> I've attempted a couple of times and continue to get "Object Reference not
> set to an instance of object", which causes the install to rollback.
> Does anyone know how to correct this problem?
> This question was originally posted in 10\04, but there was never an
> answer
> posted.
>|||Yes, I have the default instance running on SQL Server. The Reporting Service
installed fine. We are running Server 2003 STD (ver. 5.2.3790). .NET
Framework 1.1 (ver 1.1.4322.573). No Visual Studio installed.
"Brian Welcker [MSFT]" wrote:
> Do you have a default instance of SQL Server? What OS are you running? We
> have never been able to repro this here.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "winkle60" <winkle60@.discussions.microsoft.com> wrote in message
> news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> > Has anyone successfully installed the Exchange Pack for Reporting
> > Services?
> >
> > I've attempted a couple of times and continue to get "Object Reference not
> > set to an instance of object", which causes the install to rollback.
> >
> > Does anyone know how to correct this problem?
> >
> > This question was originally posted in 10\04, but there was never an
> > answer
> > posted.
> >
>
>|||I had this error, and it went away once I installed Visual Studio.NET Pro on
the PC, so there must be some object missing without it.
Michael
"winkle60" <winkle60@.discussions.microsoft.com> wrote in message
news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> Has anyone successfully installed the Exchange Pack for Reporting
Services?
> I've attempted a couple of times and continue to get "Object Reference not
> set to an instance of object", which causes the install to rollback.
> Does anyone know how to correct this problem?
> This question was originally posted in 10\04, but there was never an
answer
> posted.
>|||I have not tried installing Visual Studio, but I had a feeling that it might
be the issue even though it is supposed to be optional. I will try it when I
get the chance and see what happens.
"michael@.civis.com" wrote:
> I had this error, and it went away once I installed Visual Studio.NET Pro on
> the PC, so there must be some object missing without it.
> Michael
> "winkle60" <winkle60@.discussions.microsoft.com> wrote in message
> news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> > Has anyone successfully installed the Exchange Pack for Reporting
> Services?
> >
> > I've attempted a couple of times and continue to get "Object Reference not
> > set to an instance of object", which causes the install to rollback.
> >
> > Does anyone know how to correct this problem?
> >
> > This question was originally posted in 10\04, but there was never an
> answer
> > posted.
> >
>
>|||I installed Visual Studio .NET 2003 and was able to complete the install.
Another question, is there anyway to actually pull data from the Exchange
system without installing the SSW softeware extraction piece on the Exchange
server?
"michael@.civis.com" wrote:
> I had this error, and it went away once I installed Visual Studio.NET Pro on
> the PC, so there must be some object missing without it.
> Michael
> "winkle60" <winkle60@.discussions.microsoft.com> wrote in message
> news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> > Has anyone successfully installed the Exchange Pack for Reporting
> Services?
> >
> > I've attempted a couple of times and continue to get "Object Reference not
> > set to an instance of object", which causes the install to rollback.
> >
> > Does anyone know how to correct this problem?
> >
> > This question was originally posted in 10\04, but there was never an
> answer
> > posted.
> >
>
>|||I'm wondering the same thing. Is the SSQ software piece required? If so, is
that a seperate product you have to buy? I'd be curious to hear from anyone
who made this work. Thanks.
"winkle60" wrote:
> I installed Visual Studio .NET 2003 and was able to complete the install.
> Another question, is there anyway to actually pull data from the Exchange
> system without installing the SSW softeware extraction piece on the Exchange
> server?
> "michael@.civis.com" wrote:
> > I had this error, and it went away once I installed Visual Studio.NET Pro on
> > the PC, so there must be some object missing without it.
> >
> > Michael
> >
> > "winkle60" <winkle60@.discussions.microsoft.com> wrote in message
> > news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> > > Has anyone successfully installed the Exchange Pack for Reporting
> > Services?
> > >
> > > I've attempted a couple of times and continue to get "Object Reference not
> > > set to an instance of object", which causes the install to rollback.
> > >
> > > Does anyone know how to correct this problem?
> > >
> > > This question was originally posted in 10\04, but there was never an
> > answer
> > > posted.
> > >
> >
> >
> >

Installing Delphi 2005 Gives Security Exception..

After installing delphi 2005 I am getting a security exception when trying
to access the reports/report manager/web service of Reporting Services.
I think it is Borland related - the stack trace shows borland in there
now...How do I fix?
======================================================== Description: The application attempted to perform an operation not allowed
by the security policy. To grant this application the required permission
please contact your system administrator or change the application's trust
level in the configuration file.
Exception Details: System.Security.SecurityException: Request for the
permission of type System.Security.Permissions.EnvironmentPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 failed.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[SecurityException: Request for the permission of type
System.Security.Permissions.EnvironmentPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed.]
System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet
grantedSet, PermissionSet deniedSet, CodeAccessPermission demand,
PermissionToken permToken) +675
System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken,
CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames,
Int32 unrestrictedOverride) +0
System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap,
StackCrawlMark& stackMark) +88
System.Security.CodeAccessPermission.Demand() +62
System.Environment.GetEnvironmentVariable(String variable) +53
Borland.DbkAsp.DbkConnModule.getInstallRoot() +27
Borland.DbkAsp.DbkConnModule.OnBeginRequest(Object sender, EventArgs e)
+191
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87Hi Wayne,
Thanks for your posting!
It seems that the security module internal reports the error message, I
will make research to see whether others meet this issue before. You are
encouraged to see whether Borland guys have solutions to this issue.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Search for 'Security Exception - Article ID : 887787'.
I uninstalled Delphi 2005 and the problem went away immediately.....
I look forward to your solution. (I imagine I just have to give rights to
some borland assembly or something for Rptsvs..)
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:JFbg9w11EHA.1512@.cpmsftngxa10.phx.gbl...
> Hi Wayne,
> Thanks for your posting!
> It seems that the security module internal reports the error message, I
> will make research to see whether others meet this issue before. You are
> encouraged to see whether Borland guys have solutions to this issue.
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Wayne,
Unfortunately, I found the only workaround available now is uninstall
Delphi 2005.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Michael,
Exactly what did you find. What are we 'working around'? The problem
is what exactly? Isn't this an assembly rights issue, like when you install
that URL monitor DLL (security fix) from microsoft (forgot its name). You
would get these same sort of errors, until you put some magic entries into a
config file...
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:g$%23vysC2EHA.3152@.cpmsftngxa10.phx.gbl...
> Hi Wayne,
> Unfortunately, I found the only workaround available now is uninstall
> Delphi 2005.
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Wayne,
Yes, you probably have to change the policy files to include some CAS (Code
Access Security) permissions for the Borland assemblies. See the following
information for more detailed information about how to set the Code Access
Security correctly
Code Access Security
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconCodeAccessSecurity.asp
Code Access Security in SQL Server 2000 Reporting Services
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
/dngrfCodeAccessSecurityInSQLServer2000ReportingServices.asp
Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Reinstall Delphi 2005 and press "No" when asked:
An entry needs to be added to the machine.config file to enable ASP
debugging for Delphi.
Would you like setup to add this entry for you now?
"Wayne Brantley" wrote:
> Michael,
> Exactly what did you find. What are we 'working around'? The problem
> is what exactly? Isn't this an assembly rights issue, like when you install
> that URL monitor DLL (security fix) from microsoft (forgot its name). You
> would get these same sort of errors, until you put some magic entries into a
> config file...
>
> "Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
> news:g$%23vysC2EHA.3152@.cpmsftngxa10.phx.gbl...
> > Hi Wayne,
> >
> > Unfortunately, I found the only workaround available now is uninstall
> > Delphi 2005.
> >
> > Thank you for your patience and corporation. If you have any questions or
> > concerns, don't hesitate to let me know. We are always here to be of
> > assistance!
> >
> >
> > Sincerely yours,
> >
> > Michael Cheng
> >
> > Online Partner Support Specialist
> > Partner Support Group
> > Microsoft Global Technical Support Center
> > ---
> > Get Secure! - http://www.microsoft.com/security
> >
> > This posting is provided "as is" with no warranties and confers no rights.
> > Please reply to newsgroups only, many thanks!
> >
>
>

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 Analysis services on vista 64

Which install do I use to install Analysis Services on a 64 bit version of vista ?

Thanks

I would try the 64 bit Developer Edition

Installing Analysis Services

I installed anaylsis services 6 months after I installed
SQL 2000. Do I need to reinstall the SQL Service Packs?I probably would, also make sure to install the service packs for analysis
services
Ray Higdon MCSE, MCDBA, CCNA
--
"Greg" <anonymous@.discussions.microsoft.com> wrote in message
news:1b7601c3fbfe$5e44d4a0$a101280a@.phx.gbl...
> I installed anaylsis services 6 months after I installed
> SQL 2000. Do I need to reinstall the SQL Service Packs?

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 a report

I urgently need to install a report that I developed (in Reporting Services
for SQL Server 2003) in a different computer, that doesn't has VS.NET (that
is, a can't build the reports there).
What files do I need to install, and where do I install them? And what about
the connection string of the report, how can I change it so that it will
work in the new computer ?I am unclear as to why you wish to put a report on a different computer...
however
1. if the reason is for someone else to develop the report, you must install
the developement environment on that computer
2. If you wish someone else to run the report, you should deploy it to a
reporting server...
Both items are documented in books on line... Search for Deploy
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Nuno Machado" wrote:
> I urgently need to install a report that I developed (in Reporting Services
> for SQL Server 2003) in a different computer, that doesn't has VS.NET (that
> is, a can't build the reports there).
> What files do I need to install, and where do I install them? And what about
> the connection string of the report, how can I change it so that it will
> work in the new computer ?
>
>|||hi u shoul take only the ReportName.rdl.
then u should use Report Manger->Upload File.
to change Connection styring : Report
Manger->ReportName->Properties->DataSource.
"Nuno Machado" wrote:
> I urgently need to install a report that I developed (in Reporting Services
> for SQL Server 2003) in a different computer, that doesn't has VS.NET (that
> is, a can't build the reports there).
> What files do I need to install, and where do I install them? And what about
> the connection string of the report, how can I change it so that it will
> work in the new computer ?
>
>

installing 64bit

would there be any issues if i where to install reporting services 2005 64 ed
on 64 bit machine with the report database on another server running 32 bitOn Aug 13, 12:30 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
> would there be any issues if i where to install reporting services 2005 64 ed
> on 64 bit machine with the report database on another server running 32 bit
As far as I know, this should be possible; however, you may want to
check out this link to determine if your version of SQL Server
supports different bit versions, etc.
http://msdn2.microsoft.com/en-us/library/ms143761.aspx
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||thanks
"EMartinez" wrote:
> On Aug 13, 12:30 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
> > would there be any issues if i where to install reporting services 2005 64 ed
> > on 64 bit machine with the report database on another server running 32 bit
>
> As far as I know, this should be possible; however, you may want to
> check out this link to determine if your version of SQL Server
> supports different bit versions, etc.
> http://msdn2.microsoft.com/en-us/library/ms143761.aspx
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Aug 14, 1:02 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
> thanks
> "EMartinez" wrote:
> > On Aug 13, 12:30 pm, Marvin <Mar...@.discussions.microsoft.com> wrote:
> > > would there be any issues if i where to install reporting services 2005 64 ed
> > > on 64 bit machine with the report database on another server running 32 bit
> > As far as I know, this should be possible; however, you may want to
> > check out this link to determine if your version of SQL Server
> > supports different bit versions, etc.
> >http://msdn2.microsoft.com/en-us/library/ms143761.aspx
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Installing 2nd (Named) Instance of SQL Server 2005 EE

When installing a 2nd instance of SQL Server 2005 EE on a server, is it
necessary to install Reporting Services, SSIS, and Analysis Services again?
Does anyone know of any good documentation that discusses this subject?
Thanks.
No, if you need just an OLTP and / or olap named instance, you don't have to
reinstall RS or AS; you cannot install a second instance of SSIS because SSIS
is a stand alone service and you cannot have two SSIS on the same server.
The first documentation you have to read is the setup documentation;
Gilberto
"MACason" wrote:

> When installing a 2nd instance of SQL Server 2005 EE on a server, is it
> necessary to install Reporting Services, SSIS, and Analysis Services again?
> Does anyone know of any good documentation that discusses this subject?
> Thanks.

Installing 2nd (Named) Instance of SQL Server 2005 EE

When installing a 2nd instance of SQL Server 2005 EE on a server, is it
necessary to install Reporting Services, SSIS, and Analysis Services again?
Does anyone know of any good documentation that discusses this subject?
Thanks.Thanks. Appreciate the prompt reply.
"Gilberto Zampatti" wrote:
> No, if you need just an OLTP and / or olap named instance, you don't have to
> reinstall RS or AS; you cannot install a second instance of SSIS because SSIS
> is a stand alone service and you cannot have two SSIS on the same server.
> The first documentation you have to read is the setup documentation;
> Gilberto
> "MACason" wrote:
> > When installing a 2nd instance of SQL Server 2005 EE on a server, is it
> > necessary to install Reporting Services, SSIS, and Analysis Services again?
> > Does anyone know of any good documentation that discusses this subject?
> >
> > Thanks.|||No, if you need just an OLTP and / or olap named instance, you don't have to
reinstall RS or AS; you cannot install a second instance of SSIS because SSIS
is a stand alone service and you cannot have two SSIS on the same server.
The first documentation you have to read is the setup documentation;
Gilberto
"MACason" wrote:
> When installing a 2nd instance of SQL Server 2005 EE on a server, is it
> necessary to install Reporting Services, SSIS, and Analysis Services again?
> Does anyone know of any good documentation that discusses this subject?
> Thanks.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
> ?
>
>

installation verification issue

Hello

I Just installed Reporting Services 2005 and I have a problem to make work

After installing it and setting different properties in the Reporting Services Configuration Manager, When it comes to verifying the installation, http://localhost/ReportServer or http://localhost/Reports pops up a Login Window, Where I enter Windows Account Username/Password, but this windows pops up again 3 times then I get Error page with the message:

HTTP 401.1 - Unauthorized: Logon Failed
Internet Information Services

SQL Server 2005 with SP2 is installed on WinXP SP2

What could be the reason?

http://support.microsoft.com/kb/247593|||I already tried the solution in this article, and I had the same result|||pending on how your Web site is configured, you might encounter one or more HTTP 401 errors when verifying the URL: "HTTP 401.1 - Unauthorized: Logon failed" can occur if you are running Windows XP Service Pack 2 or Windows Server 2003 Service Pack, and the fully qualified domain name of the Web site is different from the local computer name. There are several workarounds for resolving this error. For more information about the error and possible workarounds, go to http://support.microsoft.com/kb/896861.
"HTTP 401.1 - Unauthorized: Access is denied due to invalid credentials" can occur if the application pool is a local account or domain user account, and the Web site is configured to use integrated security. Because the report server virtual directories use integrated security by default, you can expect to encounter this error when you access the report server. For more information about the error and possible workarounds, go to http://support.microsoft.com/kb/871179.

Installation Reporting services on SQL fail-over cluster

Hi,
Perhaps a simple question, but I could not find a clear answer in the
deployment guide. I want to install SQL Reporting Services on a SQL fail over
cluster to be used for MOM Reporting. I was wondering where to run the set up
for SRS. Do I run it on the Virtual server or on one (or both) of the nodes?
Does anyone know?
Regards, MartijnIt is best practice to run SQL Server or RS on the CLuster node. In Any case
once you go to the virtual server, you will be directed to the "Physical
Node" that owns the cluster resources. Always use the Virtual Server name to
do anything for RS or SQL Server.
"Martijn" wrote:
> Hi,
> Perhaps a simple question, but I could not find a clear answer in the
> deployment guide. I want to install SQL Reporting Services on a SQL fail over
> cluster to be used for MOM Reporting. I was wondering where to run the set up
> for SRS. Do I run it on the Virtual server or on one (or both) of the nodes?
> Does anyone know?
> Regards, Martijn

Installation questions

Hi,
We are running SQL 2000 still and I would like to implement reporting
services. When I install reporting services on the server will it require a
reboot to complete the installation? This is a production machine and I'd
like to install it during normal working hours but obviously can't if it
requires a reboot.
Generally speaking, does it take a lot of resources to run reporting
services? We have a rather small organization where only half a dozen folks
will need to run reports occasionally. Should I expect to see this using a
lot of system resources? Obviously, I know that some reports may take more
resources than others, but generally speaking...
We have SQL Server 2000 Standard, my understanding is that I am also
licensed for a single installation of reporting services. Can this
installation be on a different server than the actual SQL database or does
that take an additional license?
Thanks in advance,
LinnYes, if you install the Reporting Services on different computer, you need
another SQL Server 2000 license. You also need IIS runing and .NET1.1
installed. As far as I know, it does not need to restart computer (not 100%
sure, though).
We run SQL Server, reporting services and our major ASP.ENT app on a single
box (fairly powerful, though), to avoid to buy seperate SQL Server license,
just because of using RS. It is pretty smoother, so far, although our
ASP.NET apps and reporting services are used by more then 50 people daily
intensively.
"Linn Kubler" <lkubler@.chartwellwisc2.com> wrote in message
news:egupPo6%23HHA.4592@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We are running SQL 2000 still and I would like to implement reporting
> services. When I install reporting services on the server will it require
> a reboot to complete the installation? This is a production machine and
> I'd like to install it during normal working hours but obviously can't if
> it requires a reboot.
> Generally speaking, does it take a lot of resources to run reporting
> services? We have a rather small organization where only half a dozen
> folks will need to run reports occasionally. Should I expect to see this
> using a lot of system resources? Obviously, I know that some reports may
> take more resources than others, but generally speaking...
> We have SQL Server 2000 Standard, my understanding is that I am also
> licensed for a single installation of reporting services. Can this
> installation be on a different server than the actual SQL database or does
> that take an additional license?
> Thanks in advance,
> Linn
>|||Just a heads up, be sure to install the RS 2000 service packs. Also, people
exporting to PDF or Excel can really hammer the server. If there is any way
to upgrade the license (note I say license, not database) to SQL 2005 so you
can install RS 2005 it would be a good idea. There are a lot of improvements
with RS 2005. Multi-select parameters, end user sorting, faster pdf and
excel rendering, calendar control, etc.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Linn Kubler" <lkubler@.chartwellwisc2.com> wrote in message
news:egupPo6%23HHA.4592@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We are running SQL 2000 still and I would like to implement reporting
> services. When I install reporting services on the server will it require
> a reboot to complete the installation? This is a production machine and
> I'd like to install it during normal working hours but obviously can't if
> it requires a reboot.
> Generally speaking, does it take a lot of resources to run reporting
> services? We have a rather small organization where only half a dozen
> folks will need to run reports occasionally. Should I expect to see this
> using a lot of system resources? Obviously, I know that some reports may
> take more resources than others, but generally speaking...
> We have SQL Server 2000 Standard, my understanding is that I am also
> licensed for a single installation of reporting services. Can this
> installation be on a different server than the actual SQL database or does
> that take an additional license?
> Thanks in advance,
> Linn
>|||I hadn't thought of that, I was thinking that since it's SQL 2000 it should
be RS 2000 as well. We are subscribed to the assurance licensing with MS so
I'm assuming I can get 2005. My main concern is that I don't disrupt my SQL
server. Our main database application is not designed for use with SQL
2005. They are working on an upgrade and expect it sometime next year.
But that is a good thought, using RS 2005 with our existing DB. But can
they co-exist on the same hardware?
Thanks,
Linn
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OYJ1x56%23HHA.5948@.TK2MSFTNGP04.phx.gbl...
> Just a heads up, be sure to install the RS 2000 service packs. Also,
> people exporting to PDF or Excel can really hammer the server. If there is
> any way to upgrade the license (note I say license, not database) to SQL
> 2005 so you can install RS 2005 it would be a good idea. There are a lot
> of improvements with RS 2005. Multi-select parameters, end user sorting,
> faster pdf and excel rendering, calendar control, etc.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Linn Kubler" <lkubler@.chartwellwisc2.com> wrote in message
> news:egupPo6%23HHA.4592@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> We are running SQL 2000 still and I would like to implement reporting
>> services. When I install reporting services on the server will it
>> require a reboot to complete the installation? This is a production
>> machine and I'd like to install it during normal working hours but
>> obviously can't if it requires a reboot.
>> Generally speaking, does it take a lot of resources to run reporting
>> services? We have a rather small organization where only half a dozen
>> folks will need to run reports occasionally. Should I expect to see this
>> using a lot of system resources? Obviously, I know that some reports may
>> take more resources than others, but generally speaking...
>> We have SQL Server 2000 Standard, my understanding is that I am also
>> licensed for a single installation of reporting services. Can this
>> installation be on a different server than the actual SQL database or
>> does that take an additional license?
>> Thanks in advance,
>> Linn
>>
>|||Yes. This is fully supported. I ran that way for 6 months. It is absolutely
no problem to have the metadata/object cache databases on SQL 2000.
I would hesitate to run RS 2000 on a production database server. I would
periodically have my server get totally frozen if a user exports a large
report to Excel or PDF. This problem for me went totally away when I went to
RS 2005. RS 2005 is on service pack 2, be sure to install that.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Linn Kubler" <lkubler@.chartwellwisc2.com> wrote in message
news:%23rKXon7%23HHA.4732@.TK2MSFTNGP04.phx.gbl...
>I hadn't thought of that, I was thinking that since it's SQL 2000 it should
>be RS 2000 as well. We are subscribed to the assurance licensing with MS
>so I'm assuming I can get 2005. My main concern is that I don't disrupt my
>SQL server. Our main database application is not designed for use with SQL
>2005. They are working on an upgrade and expect it sometime next year.
> But that is a good thought, using RS 2005 with our existing DB. But can
> they co-exist on the same hardware?
> Thanks,
> Linn
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OYJ1x56%23HHA.5948@.TK2MSFTNGP04.phx.gbl...
>> Just a heads up, be sure to install the RS 2000 service packs. Also,
>> people exporting to PDF or Excel can really hammer the server. If there
>> is any way to upgrade the license (note I say license, not database) to
>> SQL 2005 so you can install RS 2005 it would be a good idea. There are a
>> lot of improvements with RS 2005. Multi-select parameters, end user
>> sorting, faster pdf and excel rendering, calendar control, etc.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Linn Kubler" <lkubler@.chartwellwisc2.com> wrote in message
>> news:egupPo6%23HHA.4592@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> We are running SQL 2000 still and I would like to implement reporting
>> services. When I install reporting services on the server will it
>> require a reboot to complete the installation? This is a production
>> machine and I'd like to install it during normal working hours but
>> obviously can't if it requires a reboot.
>> Generally speaking, does it take a lot of resources to run reporting
>> services? We have a rather small organization where only half a dozen
>> folks will need to run reports occasionally. Should I expect to see
>> this using a lot of system resources? Obviously, I know that some
>> reports may take more resources than others, but generally speaking...
>> We have SQL Server 2000 Standard, my understanding is that I am also
>> licensed for a single installation of reporting services. Can this
>> installation be on a different server than the actual SQL database or
>> does that take an additional license?
>> Thanks in advance,
>> Linn
>>
>>
>|||Thanks for the information Bruce. I just received my SQL 2005 disks and
will give it a try on the test system once I have Windows installed
successfully.
Linn
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eukF477%23HHA.5160@.TK2MSFTNGP05.phx.gbl...
> Yes. This is fully supported. I ran that way for 6 months. It is
> absolutely no problem to have the metadata/object cache databases on SQL
> 2000.
> I would hesitate to run RS 2000 on a production database server. I would
> periodically have my server get totally frozen if a user exports a large
> report to Excel or PDF. This problem for me went totally away when I went
> to RS 2005. RS 2005 is on service pack 2, be sure to install that.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Linn Kubler" <lkubler@.chartwellwisc2.com> wrote in message
> news:%23rKXon7%23HHA.4732@.TK2MSFTNGP04.phx.gbl...
>>I hadn't thought of that, I was thinking that since it's SQL 2000 it
>>should be RS 2000 as well. We are subscribed to the assurance licensing
>>with MS so I'm assuming I can get 2005. My main concern is that I don't
>>disrupt my SQL server. Our main database application is not designed for
>>use with SQL 2005. They are working on an upgrade and expect it sometime
>>next year.
>> But that is a good thought, using RS 2005 with our existing DB. But can
>> they co-exist on the same hardware?
>> Thanks,
>> Linn
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OYJ1x56%23HHA.5948@.TK2MSFTNGP04.phx.gbl...
>> Just a heads up, be sure to install the RS 2000 service packs. Also,
>> people exporting to PDF or Excel can really hammer the server. If there
>> is any way to upgrade the license (note I say license, not database) to
>> SQL 2005 so you can install RS 2005 it would be a good idea. There are a
>> lot of improvements with RS 2005. Multi-select parameters, end user
>> sorting, faster pdf and excel rendering, calendar control, etc.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Linn Kubler" <lkubler@.chartwellwisc2.com> wrote in message
>> news:egupPo6%23HHA.4592@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> We are running SQL 2000 still and I would like to implement reporting
>> services. When I install reporting services on the server will it
>> require a reboot to complete the installation? This is a production
>> machine and I'd like to install it during normal working hours but
>> obviously can't if it requires a reboot.
>> Generally speaking, does it take a lot of resources to run reporting
>> services? We have a rather small organization where only half a dozen
>> folks will need to run reports occasionally. Should I expect to see
>> this using a lot of system resources? Obviously, I know that some
>> reports may take more resources than others, but generally speaking...
>> We have SQL Server 2000 Standard, my understanding is that I am also
>> licensed for a single installation of reporting services. Can this
>> installation be on a different server than the actual SQL database or
>> does that take an additional license?
>> Thanks in advance,
>> Linn
>>
>>
>>
>