Showing posts with label program. Show all posts
Showing posts with label program. Show all posts

Friday, March 30, 2012

Problems installing RS 2005

-OS: Windows 2000
-RS 2005
-SQL Server 2000
The installation completes successfuly in c:\Program Files\Microsoft SQL
Server\MSSQL.1\Reporting Services\
LogFiles in c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting
Services\LogFiles do not have any errors..
But when i visit http://localhost/ReportServer I get a blank page that looks
like this:
localhost/ReportServer -
----
----
Microsoft SQL Server Reporting Services Version 9.00.1399.00
Any ideas'
I tried re-installing several times...There are two websites. One just shows folders and that website is
ReportServer. If you haven't deployed any reports you won't have any folders
created. The portal (Report Manager) is at the Reports website. Try
http://localhost/Reports
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ash" <Ash@.discussions.microsoft.com> wrote in message
news:2D5F1522-EED5-4A81-B2D2-29BF7F5B873E@.microsoft.com...
> -OS: Windows 2000
> -RS 2005
> -SQL Server 2000
> The installation completes successfuly in c:\Program Files\Microsoft SQL
> Server\MSSQL.1\Reporting Services\
> LogFiles in c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting
> Services\LogFiles do not have any errors..
> But when i visit http://localhost/ReportServer I get a blank page that
> looks
> like this:
>
> localhost/ReportServer - /
> ----
> ----
> Microsoft SQL Server Reporting Services Version 9.00.1399.00
>
> Any ideas'
> I tried re-installing several times...|||Oh wow thats it!! :)
Thanks...
Sorry for posting twice...I thought the my session expired and the first one
didnt make it. Thanks
"Bruce L-C [MVP]" wrote:
> There are two websites. One just shows folders and that website is
> ReportServer. If you haven't deployed any reports you won't have any folders
> created. The portal (Report Manager) is at the Reports website. Try
> http://localhost/Reports
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ash" <Ash@.discussions.microsoft.com> wrote in message
> news:2D5F1522-EED5-4A81-B2D2-29BF7F5B873E@.microsoft.com...
> > -OS: Windows 2000
> > -RS 2005
> > -SQL Server 2000
> > The installation completes successfuly in c:\Program Files\Microsoft SQL
> > Server\MSSQL.1\Reporting Services\
> >
> > LogFiles in c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting
> > Services\LogFiles do not have any errors..
> > But when i visit http://localhost/ReportServer I get a blank page that
> > looks
> > like this:
> >
> >
> > localhost/ReportServer - /
> > ----
> >
> > ----
> > Microsoft SQL Server Reporting Services Version 9.00.1399.00
> >
> >
> > Any ideas'
> > I tried re-installing several times...
>
>

Problems installing MSDE

I was in the process of installing the MSDE program when I came upon an error message. Here are the steps I performed to install the MSDE on my computer.

1. Downloaded the program from the Microsoft website.
2. Extracted the files to the "C" directory.
3. Used command prompt to set password and security mode. Rebooted computer after process was completed.
4. To complete the installation, I opened up the setup.exe. However, I got the error message "The instance named specified is invalid" when I opened the program.

Any solutions? (and yes, I already have the Web Matrix and the .Net platorm and am running on Windows 2000 SP4 .)I just finished dealing with this problem myself.

This is what I did and it FINALLY WORKED.

To install the MSDE:

go to the DOS prompt and navigate to C:\sql2ksp3\MSDE (or wherever you unpacked to).

Type this: setup INSTANCENAME="anyname" SECURITYMODE=SQL SAPWD="somepwd"

If you are like me you were thinking "what is the instance name?!". Well in this setup command you are naming it whatever you want, same with the SAPWD. Previously mine was blank (I know this is bad bad bad).

Anyway, once I ran it this way it installed fine!

Good Luck|||Well this may sound really stupid, but I;m a real newbie...

I've read dozens of setup instruction posts..I've started over and done what was suggested in this post, and everything seems to have gone well. SO FAR

Where do I go from here? Do I have to activate the database somehow? Where is this database anyway, after the I run the command, what was installed and where?

The startkit 'congifuration' still fails everytime. Says I don't have either .NET, MSDE, or IIS. I KNOW I have all of this installed..the only weak link could be the MSDE, because I have no idea what is going on with it.

I've installed SQL Server2000 in the past and got to a point where it configured and coulnd fidn the database..

Anyway, are there STEP BY STEP instructions ANYWHERE on this crap. I'm getting sick of reading random posts, web documentation, program documentation, and trying to compile this in to a process to follow..|||As Cheyjey mentioned, use this parameters:
INSTANCENAME="anyname" SECURITYMODE=SQL SAPWD="somepwd"

But you said installed it once, i have to mention that one the major reasons for getting the error you said, is that you have already installed MSDE on your system...|||i mean MSDE SP3a|||And Dear Mickey,

it's not as hard as you say, MSDE is a kind of a server, you can use it either as a server and an interface between applications and SQL Server 2000|||Amins2s,

I've read many post regarding the installation of MSDE, and i'm having the same problems.

I'm new at this and have followed instructions, and am using MSDE for school project.

I have installed VS 2002 Enterprise Architect, then uninstalled it to upgrade to VS 2003
I download the MSDE SP3a service pack from MS, and try to install it.

I'm suppose to use SAPWD=itm and SECURITYMODE=SQL, but upon typing this, i get the speciefed instance is invalid.

How am i suppose to recitfy this. How do i know what the instance i have on it is?

Also you said that you might be getting this error because you have already installed it once before. But i don't remember installing it, since the only thing i have installed is the VS2002 and VS2003, plus the Framework.

If you've installed it once before, how can you correct it so that you can properly install it now?

Even when i go to the MS .net/Frameworksdk/samples/setup/ there is no msde file to execute, which i read from other post should be there.

Thank You.

Nick|||Hello dear Nick,

ok... give this solution a try: do not indicate the SECURITYMODE parameter. Just run it from the Start>Run and use the SAPWD=itm parameter only!
And from the point that my FrameworkSDK doesn't work (the CD is corrupted), unfotunately I can't answer the question.
Please try it and tell me if it worked or not.
If it didn't, then send a feedback (Reply) and this time with more details about your system info...

Monday, March 26, 2012

Problems getting SQL Server 2005 Express to run on my XP Pro PC

Hello
I have installed SQL Server 2005 on my XP Pro PC but I can't get it to run.
If I go into the SQL Server Management Studio Express program in the Server
name dropdown there is nothing displayed - even if I browse. But database
should be local.
If I look in Services I don't see any SQL Server entry? The only thing
vaguely related I see in Services is SQL Server VSS Writer. And this has
started OK.
How can I troubleshoot this?
AngusHi Angus
"Angus" wrote:
> Hello
> I have installed SQL Server 2005 on my XP Pro PC but I can't get it to run.
> If I go into the SQL Server Management Studio Express program in the Server
> name dropdown there is nothing displayed - even if I browse. But database
> should be local.
> If I look in Services I don't see any SQL Server entry? The only thing
> vaguely related I see in Services is SQL Server VSS Writer. And this has
> started OK.
> How can I troubleshoot this?
> Angus
>
What does it say as installed programs?
Do you have the installation log files see
http://msdn2.microsoft.com/en-us/library/ms143702.aspx ?
John

Problems getting SQL Server 2005 Express to run on my XP Pro PC

Hello
I have installed SQL Server 2005 on my XP Pro PC but I can't get it to run.
If I go into the SQL Server Management Studio Express program in the Server
name dropdown there is nothing displayed - even if I browse. But database
should be local.
If I look in Services I don't see any SQL Server entry? The only thing
vaguely related I see in Services is SQL Server VSS Writer. And this has
started OK.
How can I troubleshoot this?
AngusHi Angus
"Angus" wrote:

> Hello
> I have installed SQL Server 2005 on my XP Pro PC but I can't get it to run
.
> If I go into the SQL Server Management Studio Express program in the Serve
r
> name dropdown there is nothing displayed - even if I browse. But database
> should be local.
> If I look in Services I don't see any SQL Server entry? The only thing
> vaguely related I see in Services is SQL Server VSS Writer. And this has
> started OK.
> How can I troubleshoot this?
> Angus
>
What does it say as installed programs?
Do you have the installation log files see
http://msdn2.microsoft.com/en-us/library/ms143702.aspx ?
John

Tuesday, March 20, 2012

Problems activating a second Report server using rsactivate (Web f

1. I cannot get rsactivate to activate a second RS node on a web farm.
rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config"
Failure starting the web service:
The local NT Service is not activated
2. rskeymgmt on the Original RS node 1 does not work either.
rskeymgmt -e -fc:\rsdbkey.txt -pxxxxx
Are you sure you want to extract the key from the report server (Y/N)? y
The local NT Service is disabled 0x80090005
Environment -
The two RS Servers are both Windows 2003 Servers.
SQL Server is on a third computer: SQL 2000 Server Enterprise Edition.
RS Node1: Works fine.
RS Node 2: Activation fails.
ReportServer service login account for both nodes: "NT
Authority\NetworkService"
SQL Server access - using a "sql admin" account.
IIS (W3Svc) on both RS nodes - "LocalSystemAccount".
Web Servers on both RS nodes are working fine and the ReportServer service
starts as well.To activate a web farm, you will need to run rsactivate -m <name of node 2>
from node 1.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"VChandy" <VChandy@.discussions.microsoft.com> wrote in message
news:539D88F5-35FE-44E7-B2A5-79AC74E363D9@.microsoft.com...
> 1. I cannot get rsactivate to activate a second RS node on a web farm.
> rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config"
> Failure starting the web service:
> The local NT Service is not activated
> 2. rskeymgmt on the Original RS node 1 does not work either.
> rskeymgmt -e -fc:\rsdbkey.txt -pxxxxx
> Are you sure you want to extract the key from the report server (Y/N)? y
> The local NT Service is disabled 0x80090005
> Environment -
> The two RS Servers are both Windows 2003 Servers.
> SQL Server is on a third computer: SQL 2000 Server Enterprise Edition.
> RS Node1: Works fine.
> RS Node 2: Activation fails.
> ReportServer service login account for both nodes: "NT
> Authority\NetworkService"
> SQL Server access - using a "sql admin" account.
> IIS (W3Svc) on both RS nodes - "LocalSystemAccount".
> Web Servers on both RS nodes are working fine and the ReportServer service
> starts as well.
>|||Figured it out from an earlier post on 8/17 from Brian Hartman [MSFT]
Did the following -
1. rskeymgmt -d on the orignal RS Node 1.
2. Stopped W3Svs and RS Service on Node 2. (** important)
3. From Node1 ran: rsactivate -mNode2 -c "C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"
4. Re-started W3Svc and RS Service on Node 2.
5. Deleted and re-deployed all my RDLs to RS Node 1 as the security
information for the Data sources & other stuff got clobbered by rskeymgmt -d
6. Both RS nodes 1 & 2 can access all reports.
7. SSL works fine as well - next need to upgrade both nodes to RS Service
pack 1 and work on an NLB cluster solution ...
"VChandy" wrote:
> 1. I cannot get rsactivate to activate a second RS node on a web farm.
> rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config"
> Failure starting the web service:
> The local NT Service is not activated
> 2. rskeymgmt on the Original RS node 1 does not work either.
> rskeymgmt -e -fc:\rsdbkey.txt -pxxxxx
> Are you sure you want to extract the key from the report server (Y/N)? y
> The local NT Service is disabled 0x80090005
> Environment -
> The two RS Servers are both Windows 2003 Servers.
> SQL Server is on a third computer: SQL 2000 Server Enterprise Edition.
> RS Node1: Works fine.
> RS Node 2: Activation fails.
> ReportServer service login account for both nodes: "NT
> Authority\NetworkService"
> SQL Server access - using a "sql admin" account.
> IIS (W3Svc) on both RS nodes - "LocalSystemAccount".
> Web Servers on both RS nodes are working fine and the ReportServer service
> starts as well.
>