Showing posts with label directory. Show all posts
Showing posts with label directory. Show all posts

Friday, March 23, 2012

ReportServer virtual directory doubt...

Can a reportserver/reportmanager virtual directory be configured to run inside another virtual directory.

say...http://mymachine/web/reports

Thanks

Samuel

That should not be an issue. I have done this in the past ... Is there a specific reason why you want to do this?|||

i have report server running under my website......do i have to create another virtual directory and point it to what the main reportserver directory is pointing too.

this we need to do as we are publishing a host of application under /web/ virtual directory in ISA. and from my applications the call goes to

from internet http://domainname/web/reportserver

from LAN http://website/reportserver

reportserver2005,IIS6.0,win2003 server.

t

|||

Thats easy,

All you have to do is go to teh actual folder's properties under websharing.

you should see in the top list box, if you have multiple websites on the server. you should all of them listed in a dropdown list box. just select the preferred one.

sql

Reportserver virtual directory

On my web hosting server the inetpub/wwwroot folder is located on D: drive, and the web hosting company configured it that way.

When i have installed the sql server 2005 it created the virtual directory under c:\inetpub\wwwroot which is not a default website location on that server.

could you please tell me how to switch the virtual directory path from c:\inetpub\wwwroot

to

d:\inetpub\wwwroot

Please any help would be greatly appreciated.

Thank you very much.

I'm not quite sure how you mean. When RS installs it doesn't place any files in c:\inetpub\wwwroot. The standard location will be

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer

Note that the drive letter and the number after the MSSQL. part may vary depending on the choices made during setup and the SQL Server components selected.

The using the configuration tool, it creates 2 virtual directories beneath the default website i.e. the one on port 80 called "reportserver" and "reports" and these are just pointers to the physical directories located int he above install path.

Please can you clarify the issue you seem to be having?

reportserver url - get Directory Listing Denied

I have two servers, basically identical on which reporting services is installed.

On one when i go to the /reportserver url i get to a listing of report directories/reports o the server.

On the 2nd, I get the IIS error:

Directory Listing Denied

I've checked and all of the settings i can verify (in report server, Iis etc.) are identical on both.

What might cause this?

thx.

r-

The reportserver virtual root should be configured to map all extensions to aspnet_isapi.dll. It sounds like this is not the case. If you are using Report Server 2005, you might want to recreate the virtual root using the Report Server Config Tool.

ReportServer directory not available outside firewall

We are attempting to expose our reports to the internet without much luck.
The domain name is not set up yet, so we are accessing by IP. There are 2
virtual folders - Reports and ReportServer are set up with Windows
authentication. When I go to http://xxx.xxx.xxx.xxx/ReportServer, I get
prompted, login and then see the list of reports. When I click on a report,
I get prompted again, but login fails and I get 401. Where should I start
looking? Most problems I see from others have to do with the Reports
directory, but their ReportServer directory works.I think 401 is an 'Unauthorised' error. Check your firewall settings, but
pay specific attention to the IIS and .NET authentication as well. Are you
using windows or forms based authentication?
"danb" wrote:
> We are attempting to expose our reports to the internet without much luck.
> The domain name is not set up yet, so we are accessing by IP. There are 2
> virtual folders - Reports and ReportServer are set up with Windows
> authentication. When I go to http://xxx.xxx.xxx.xxx/ReportServer, I get
> prompted, login and then see the list of reports. When I click on a report,
> I get prompted again, but login fails and I get 401. Where should I start
> looking? Most problems I see from others have to do with the Reports
> directory, but their ReportServer directory works.|||Yes, 401 wit h a message about invalid credentials, but as I said, I was able
to log in to the /ReportServer folder successfully and then it prompted me
again for some reason when I clicked on any report.
Check the firewall for what?
Windows authentication is being used on both Reports and ReportServer folders.
Server is Windows 2003 Server.
"CraigyBoop" wrote:
> I think 401 is an 'Unauthorised' error. Check your firewall settings, but
> pay specific attention to the IIS and .NET authentication as well. Are you
> using windows or forms based authentication?
> "danb" wrote:
> > We are attempting to expose our reports to the internet without much luck.
> > The domain name is not set up yet, so we are accessing by IP. There are 2
> > virtual folders - Reports and ReportServer are set up with Windows
> > authentication. When I go to http://xxx.xxx.xxx.xxx/ReportServer, I get
> > prompted, login and then see the list of reports. When I click on a report,
> > I get prompted again, but login fails and I get 401. Where should I start
> > looking? Most problems I see from others have to do with the Reports
> > directory, but their ReportServer directory works.

Wednesday, March 21, 2012

ReportServer Configuration

We have report server installed for intranet use only. We are using actice directory users for role assignments.

New requirement is to allow access to reports via internet (www.xyz.com) and we are not going to use Microsoft Active Directory Users Account.

What would we need to do to accomplish the above? What additional steps would you recommend?

Thanks

Did you check Tudor's blog article (http://blogs.msdn.com/tudortr/archive/2005/11/03/488731.aspx) and its MSDN links?

-- Robert

|||

Is there any BLOG for SQL Server 2000? If we install Report Manager facing internet then should we must do forms authentication? or is there any alternative to this?

Thanks,

Tuesday, March 20, 2012

reports on AD elements

Is there a way that RS can create reports using the DC
Active Directory as the data source? I need to pull a
report listing two fields: User and e-mail address(from
exchange). Any help is appreciated. Thanks, RonI found the info. it is included in case someone else would like to know how to do it:
Other Data Sources
One exciting aspect of SRS is its ability to query multiple data source types in addition to SQL Server. Any ODBC or OLE-DB provider can be a potential data source for SRS. We will be covering two of these additional providers while covering both developing reports in SRS as well as examining an overall Business Intelligence platform with Analysis Services in a later chapter.
For a simple example of using a data source other than a SQL Server database, let=D5s look at the OLE-DB Provider for Directory Services. By using a direct LDAP query, it is possible to generate field information for use in SRS.
SELECT cn,sn,objectcategory,department
FROM 'LDAP://DirectoryServerName/ OU=3DOuName ,DC=3DCompany,DC=3DCom'
The query uses a standard SQlLdialect that will return the common name, surname, objectcategory (computer or person) and department from the Active Directory. The field names will be automatically created and can be used like any other data field for a report.
There are couple of caveats that must be taken into consideration when querying AD, as well as other data sources that do not support the graphical query designer in SRS.
* Query Parameters are not supported directly in the query, however, Report Parameters can be defined and utilized both in the query, referred to as dynamic query, or used to filter data.
* Because a graphical query designer is not available, the query will need to be developed in the generic query designer by typing the query directly and testing. This requires knowledge of Active Directory objects and names.
Tip: There are several tools available to assist in the development and management of Active Directory, such as ADAM (Active Directory Application Mode) and LDP, an Active Directory tool included in the Windows Support Tools.
>--Original Message--
>Is there a way that RS can create reports using the DC >Active Directory as the data source? I need to pull a >report listing two fields: User and e-mail address(from >exchange). Any help is appreciated. Thanks, Ron
>.
>

Monday, March 12, 2012

Reports (Manager) website errors with 404 and 500

Deploying reports works, Running ReportServer URL yields deployed reports
directory and reports can be run. The Reports Manager website does not run.
The redirect to http://Server/Reports/Pages/Folder.aspx shows and a Red X
Error header followed by The request failed with HTTP status 404: Not Found.
The log shows:
w3wp!ui!7e8!6/3/2005-09:11:46:: e ERROR: The request failed with HTTP status
404: Not Found.
w3wp!ui!7e8!6/3/2005-09:11:46:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The request failed with HTTP status 404: Not Found.
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!7e8!6/3/2005-09:11:48:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)...
--
Keith Powers, MCDBAReport Manager can be run from Inside IIS Manager.
--
Keith Powers, MCDBA
"Keith Powers" wrote:
> Deploying reports works, Running ReportServer URL yields deployed reports
> directory and reports can be run. The Reports Manager website does not run.
> The redirect to http://Server/Reports/Pages/Folder.aspx shows and a Red X
> Error header followed by The request failed with HTTP status 404: Not Found.
> The log shows:
> w3wp!ui!7e8!6/3/2005-09:11:46:: e ERROR: The request failed with HTTP status
> 404: Not Found.
> w3wp!ui!7e8!6/3/2005-09:11:46:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The request failed with HTTP status 404: Not Found.
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname)
> at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!7e8!6/3/2005-09:11:48:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)...
> --
> Keith Powers, MCDBA

Friday, March 9, 2012

Reportmanager failed to load from internet as a webapplication

I works fine when I run from our lan by a IIS virtual directory. But using
reportmanager from a IIS application outside the lan as a true
webapplication, the reportmanager produce wrong paths for controls. E.x.
http://images/48folderopen.jpg There should have been a domain in front of
/images. I haven't been able to find any parameters in config's to meet this
problem.
Regards
Henrik Juel
GBS A/S
DenmarkI have same probleme, anybody have the solution'
"Henrik Juel" <hjh@.gbs.dk> a écrit dans le message de
news:clsmdo$2bti$1@.news.cybercity.dk...
> I works fine when I run from our lan by a IIS virtual directory. But using
> reportmanager from a IIS application outside the lan as a true
> webapplication, the reportmanager produce wrong paths for controls. E.x.
> http://images/48folderopen.jpg There should have been a domain in front of
> /images. I haven't been able to find any parameters in config's to meet
this
> problem.
> Regards
> Henrik Juel
> GBS A/S
> Denmark
>|||Have you added the <ReportServerExternalURL> tag to the
c:\programfiles\microsoft sql server\mssql\reporting services\report anager\
rswebapplication.config file as below?
<Configuration>
<UI>
<ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
<ReportServerExternalURL>http://www.domain.org/ReportServer</ReportServerExt
ernalURL>
</UI>
Ken
"Henrik Juel" <hjh@.gbs.dk> wrote in message
news:clsmdo$2bti$1@.news.cybercity.dk...
> I works fine when I run from our lan by a IIS virtual directory. But using
> reportmanager from a IIS application outside the lan as a true
> webapplication, the reportmanager produce wrong paths for controls. E.x.
> http://images/48folderopen.jpg There should have been a domain in front of
> /images. I haven't been able to find any parameters in config's to meet
this
> problem.
> Regards
> Henrik Juel
> GBS A/S
> Denmark
>|||Hello Ken
After reading others posting about this topic, I have tried the tag
<ReportServerExternalURL>. But it made no difference. I belive in this setup
there is a ok connection from the reportmanager to the reportserver.
"Ken" wrote:
> Have you added the <ReportServerExternalURL> tag to the
> c:\programfiles\microsoft sql server\mssql\reporting services\report anager\
> rswebapplication.config file as below?
> <Configuration>
> <UI>
> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
> <ReportServerExternalURL>http://www.domain.org/ReportServer</ReportServerExt
> ernalURL>
> </UI>
> Ken
> "Henrik Juel" <hjh@.gbs.dk> wrote in message
> news:clsmdo$2bti$1@.news.cybercity.dk...
> > I works fine when I run from our lan by a IIS virtual directory. But using
> > reportmanager from a IIS application outside the lan as a true
> > webapplication, the reportmanager produce wrong paths for controls. E.x.
> > http://images/48folderopen.jpg There should have been a domain in front of
> > /images. I haven't been able to find any parameters in config's to meet
> this
> > problem.
> >
> > Regards
> >
> > Henrik Juel
> > GBS A/S
> > Denmark
> >
> >
>
>

Reportmanager failed to load from internet as a webapplication

I works fine when I run from our lan by a IIS virtual directory. But using
reportmanager from a IIS application outside the lan as a true
webapplication, the reportmanager produce wrong paths for controls. E.x.
http://images/48folderopen.jpg There should have been a domain in front of
/images. I haven't been able to find any parameters in config's to meet this
problem.
Regards
Henrik Juel
GBS A/S
DenmarkHi Henrik,
Thanks for your post.
From your descriptions, I understood that you could not access your Report
Manager via Internet while it's OK for intrannet. Have I understood you?
Correct me if i was wrong.
Based on my scope, it seems you should modify your <ReportServerUrl> Tag
for the remote access. Go look at the Report Manager configuration
file,RSWebApplication.config. There is a UI section
<UI>
<ReportServerUrl>http://intranet-computer-name/ReportServer</ReportServerUrl
>
</UI>
Change it to
<UI>
<ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
</UI>
or you could find another way in charpter "Deploying a Report Server for
Internet Access" under Topic "Enterprise Deployment Model" in Reporting
Services Books Online.
Last but not the least, make sure you follow the security practices before
you opening the Internet Access:)
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!|||Hello Michael
Thanks for your instant answer. And yes you do understand me.
I haved tried the <ReportServerVirtualDirectory> tag in the
RSWebApplication.config file but it didn't made any difference to this
problem. I have read the chapter in the online book as I have read about
this topic in my Wrox book. I was not able to find this issue.
When starting the reportmanager from http://rs.gbs.dk the reportmanager
application do have connection to the reportserver, as it is able to show
folders, but fail to work with fully urls. E.x. the image problem stated
earlier.
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> Thanks for your post.
> From your descriptions, I understood that you could not access your Report
> Manager via Internet while it's OK for intrannet. Have I understood you?
> Correct me if i was wrong.
> Based on my scope, it seems you should modify your <ReportServerUrl> Tag
> for the remote access. Go look at the Report Manager configuration
> file,RSWebApplication.config. There is a UI section
> <UI>
> <ReportServerUrl>http://intranet-computer-name/ReportServer</ReportServerUrl
> >
> </UI>
> Change it to
> <UI>
> <ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
> </UI>
> or you could find another way in charpter "Deploying a Report Server for
> Internet Access" under Topic "Enterprise Deployment Model" in Reporting
> Services Books Online.
> Last but not the least, make sure you follow the security practices before
> you opening the Internet Access:)
> 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!
>
>
>|||Hi Henrik,
If the Report Manager and Report Server are on the same machine then remove
the <ReportServerExternalUrl> and the <ReportServerUrl> from the <UI> node
in the config file - and replace with <ReportServerVirtualDirectory>
Let me know whether this works
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!|||Hello Michael
Both applications are on the same machine.
And I have only the <ReportServerVirtualDirectory> tag in the
rswebapplication.config.
<UI>
<ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
</UI>
I have created a virtual directory in the reportmanager root, which point to
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer
where the server originally is installed.
So I belive It doesn't work.
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> If the Report Manager and Report Server are on the same machine then remove
> the <ReportServerExternalUrl> and the <ReportServerUrl> from the <UI> node
> in the config file - and replace with <ReportServerVirtualDirectory>
> Let me know whether this works
> 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 Henrik,
First of all, I need to confirm that how do get the following link. Is it
in report manager when he right click a image->Properties to see the link
of the image? http://images/48folderopen.jpg
Secondly, please make sure that 'images' are in the IIS manager the image
folder:
1). Expand IIS server->Web sites->Default Website->Reports->Images
2). Right click Images->Properties->Directory and check if "The designated
directory" is used and "reports\images" is listed.
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!|||Hello Michael
1. Yes I have the http://images/48folderopen.jpg from right clicking a image
in reportmanager.
2. The IIS settings are as you describe
You are welcome to contact me on +45 20282851 or on email : hjh@.gbs.dk for a
login to http://rs.gbs.dk
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> First of all, I need to confirm that how do get the following link. Is it
> in report manager when he right click a image->Properties to see the link
> of the image? http://images/48folderopen.jpg
> Secondly, please make sure that 'images' are in the IIS manager the image
> folder:
> 1). Expand IIS server->Web sites->Default Website->Reports->Images
> 2). Right click Images->Properties->Directory and check if "The designated
> directory" is used and "reports\images" is listed.
> 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 Henrik,
Looking at the nature of this issue, I am afraid we need more time
researching on this issue and this issue was critical to your business, I
would like to suggest you open an incidnet call with Microsoft Support
Professional through Microsoft Product Support Services. You can contact
Microsoft Product Support directly to discuss additional support options
you may have available, by contacting us at 1-(800)936-5800 or by choosing
one of the options listed at
http://support.microsoft.com/directory/overview.asp
If you'd still like to continue working via the newsgroup, I want to set
your expectations that the issue might take a long time to narrow down.
During the course of troubleshooting, we may redirect you to PSS if
required.
For now, I doubt it might be a IIS issue instead of Reporting Services one
and please let me know the answers for the following questions
1. If you are browsing the Report Manager *Locally* via domain name
(http://rs.gbs.dk), will it shows as expected?
If you are browsing via domain name within the intrannet, will it shows as
expected?
2. Open the Web site property,
Click Advanced Button in Web site identification of Web Site Tab
Select Default in Multiple identities for the Web site, Click Edit...
Let me know whether there is anything in the Host Header value
3. Is it possible for you to post IIS logs here? You could also send it to
me if you think it was critical for your business. My email address was
v-mingqc@.online.microsoft.com (please remove "online", it's only for SPAM,
thanks:-)
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 Henrik,
I am currently standing by for an update from you and would like to know
how things are going there. Should you have any questions or concerns on
the recent questions/ information I've posted, please don't hesitate to let
me know directly. It's my pleasure 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!|||I have sent my reponse on your emailaddres v-mingqc@.online.microsoft.com
"removed online" for some weeks ago. Looking forward to your answer.
regards Henrik
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> I am currently standing by for an update from you and would like to know
> how things are going there. Should you have any questions or concerns on
> the recent questions/ information I've posted, please don't hesitate to let
> me know directly. It's my pleasure 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 Henrik,
I am sorry that I have never received email from you :-(
May I ask your favor to resend the email?
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!

Monday, February 20, 2012

Reporting Services won't start (SQL Server 2005 Express)

Hi,
I have IIS and SQL Server 2005 Express + Reporting Services.
When you try to configure the virtual directory for RS the manager crashes,
but the directory is created anyway.
However I can't start the reporting service, I get the following exception:
System.ServiceProcess.TimeoutException: Time out has expired and the
operation has not been completed.
at
System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus
desiredStatus, TimeSpan timeout)
at
ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)
I've seen this on the net a few times, but never a solution.Ok I found the problem and solution.
First of all, make sure IIS is running.
Then make sure ASP.NET 2.0 is enabled and set as the default .NET Runtime
(right click on your website --> properties)
Check the users on your system and see if you can find the ASPNET user,
if not, reinstall the .NET 2.0 redist (after you make sure IIS is running),
because
if finds IIS this time, it'll create the ASPNET user and RS will be able to
start.
"TimothyP" wrote:
> Hi,
> I have IIS and SQL Server 2005 Express + Reporting Services.
> When you try to configure the virtual directory for RS the manager crashes,
> but the directory is created anyway.
> However I can't start the reporting service, I get the following exception:
> System.ServiceProcess.TimeoutException: Time out has expired and the
> operation has not been completed.
> at
> System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus
> desiredStatus, TimeSpan timeout)
> at
> ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)
> I've seen this on the net a few times, but never a solution.
>