Showing posts with label administration. Show all posts
Showing posts with label administration. Show all posts
Tuesday, March 20, 2012
Can not access Report Manager administration options
Recently installed SQL Server 2005 Express with Reporting Services in a W2K3 server.
The installation was performed using Remote Desktop Connection to the server, with a domain account in the Administrators group. Initially, the Reporing Services service failed to start, but I could solve this with references to your forum:
http://www.developmentnow.com/g/115_2004_10_0_0_452194/Report-Services-did-not-install-properly-on-w2k-and-w2k3-Can-anyone-help.htm
After the service could start and completed the Reporting Services Configuration,
I can access the Report Manager Home page, but only with HOME and HELP links,
no options for the administration of the application. Please help !!
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comI forgot to mention that after fixing the service startup problem, I got a 401 error when accessing Resport Manager. I could not fix this, but could get access by allowing anonymous access to the website in IIS properties. This might be important to the analysis of the problem..
From http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=115&threadid=103510
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Very good that you added this. This is the reason that you didn't get
administration options. By default anyone in the local administrators group
is in the proper RS role to administer RS. BUT, when you are anonymous RS
doesn't know who you are (because you are anonymous). And so, no admin
options.
So, the real issue is your 401 Error. Back up and concentrate on that. I
suggest getting back to where you are getting this error
I googled 401 error Reporting Services
This one looks like it could be your issue:
http://msdn2.microsoft.com/en-us/library/ms155921.aspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Elly Aldo" <nospam@.developmentnow.com> wrote in message
news:aa3a00e5-0466-4356-b877-7958970832c0@.developmentnow.com...
>I forgot to mention that after fixing the service startup problem, I got a
>401 error when accessing Resport Manager. I could not fix this, but could
>get access by allowing anonymous access to the website in IIS properties.
>This might be important to the analysis of the problem...
> From
> http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=115&threadid=1035106
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
The installation was performed using Remote Desktop Connection to the server, with a domain account in the Administrators group. Initially, the Reporing Services service failed to start, but I could solve this with references to your forum:
http://www.developmentnow.com/g/115_2004_10_0_0_452194/Report-Services-did-not-install-properly-on-w2k-and-w2k3-Can-anyone-help.htm
After the service could start and completed the Reporting Services Configuration,
I can access the Report Manager Home page, but only with HOME and HELP links,
no options for the administration of the application. Please help !!
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comI forgot to mention that after fixing the service startup problem, I got a 401 error when accessing Resport Manager. I could not fix this, but could get access by allowing anonymous access to the website in IIS properties. This might be important to the analysis of the problem..
From http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=115&threadid=103510
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Very good that you added this. This is the reason that you didn't get
administration options. By default anyone in the local administrators group
is in the proper RS role to administer RS. BUT, when you are anonymous RS
doesn't know who you are (because you are anonymous). And so, no admin
options.
So, the real issue is your 401 Error. Back up and concentrate on that. I
suggest getting back to where you are getting this error
I googled 401 error Reporting Services
This one looks like it could be your issue:
http://msdn2.microsoft.com/en-us/library/ms155921.aspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Elly Aldo" <nospam@.developmentnow.com> wrote in message
news:aa3a00e5-0466-4356-b877-7958970832c0@.developmentnow.com...
>I forgot to mention that after fixing the service startup problem, I got a
>401 error when accessing Resport Manager. I could not fix this, but could
>get access by allowing anonymous access to the website in IIS properties.
>This might be important to the analysis of the problem...
> From
> http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=115&threadid=1035106
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
Friday, February 10, 2012
Can I List the Integration Services Packages on my page?
I want to build an administration consoloe with asp.net
Can I list the packages , can I delete them?Yes, you can do this through the service interface on the Application Object.
Something like this:
Dim app As Application = New Application()
Dim pInfos As PackageInfos = app.GetPackageInfos("\\","yourserver",Nothing,Nothing)
For Each pInfo As PackageInfo In pInfos
Console.WriteLine("Name: {0}", pInfo.Name)
Next
Which will give you all the packages on the SQL Server instance.
For the packages on the IS Server, do something like this:
static void Main(string[] args)
{
Application app = new Application();
PackageInfos pInfos = app.GetDtsServerPackageInfos(@."File System", "yourserver");
foreach (PackageInfo pinfo in pInfos)
Console.WriteLine(pinfo.Folder + " " + pinfo.Description);
}
Subscribe to:
Posts (Atom)