Using System Role Assignment I grant a domain user account "System Administrator" & "System User" within Reporting Services.
Then I connect via IE7 to Report Server with the domain account that has been granted the above rights. The page comes up but the "Contents" and "Properties" tabs are missing. This user can use "Site Settings" and perform admin though.
If I assign the users domain account to the local Administrator group on the Win 2003 Server, then when they reconnect to Reporting Services the missing tabs appear.
We are a development shop, need some of our qa testers and developers to have admin rights within Reporting Services but don't want to grant them local Administrator rights on the server. This could also be an issue upon deployment at customer sites.
So how to get round this. I have been trying ACL's on the Reporting Services directorys, ASP.Net security etc but with no success.
When I am trying http://localhost/Reports/Pages/Folder.aspx
I am not seeing the all too familier "Contents" and "Properties" tabs along with deployed reports. Once in a while, I see that, but most of the time it is missing. Reporting Services got installed correctly though.
I've received a couple of complains about a website I've been working on the past year or so: http://www.ipcamerademos.com/
I can open and browse the website fine, in both MS Internet Explorer and Firefox. But some people are getting some error opening up the website (home page):
I have Reporting Services 2005 installed on my Windows XP machine. I can access the Report Manager home page with the built-in Administrator account. However, my own account, which is a member of the Computer Admin group, is denied access with a 401.3 error. The 401.3 seems to be access denied due to not being on the ACL. I am using simple file sharing. What should I do to give access to my own account?
First off, forgive the ignorance that I'm sure to display in this post. I'm a total newbie with SRSS and have been using it to follow along with the tutorials offered via the SQL Express website. I'm using it strictly for learning on my local machine for the time being.
All had been working well with Reporting Services until I upgraded Vista Ultimate 64-bit (which was running in free 30-day trial unactivated Evaluation mode) sideways to Vista Ultimate Upgrade Edition 64-bit Edition. (Sounds confusing, I know.) I also subsequently installed a SQL Server 2k5 critical update which was recommended by Windows Update.
Now when I attempt to access Report Manager via localhost the "Home page" is incomplete, showing only the SSRS "Home" page header. There are no properites, data sources, config options, etc. outside of links for "Home|Help". I am running IE as an Admin and all the Reporting Services Configuration settings are green.
Also, when I attempt to deploy from VS 2005 I now receive the error: "Permissions granted to user 'NT AuthorityNetwork Service' are insufficient ..."
Some of the settings inside the Report Sever Config are as follows:
Windows Service Identity:
Service Acct: NT AuthorityNetwork Service; Built-in Account: Network Service
Web Service Identity:
Asp.net Service Account; NT AuthorityNetwork Service; Report Server and Manager are both using Classic.Net AppPool
I've attempted for hours to weed through Google and this forum but have repeatedly wound up back where I started and more confused than when I started. I would deeply appreciate any help in resolving this matter.
I have a simple WSS 2.0 SharePoint site for my SSRS deployment which I would like to link my users to from the SSRS home page. Is it possible to add a link or shortcut to my SSRS home page without embedding it inside of a document or report?
I have installed MDS while installing SQL Server 2014 on my local machine ( windows 10). However when I try accessing the home page of Master Data Manager, it is giving access denied error. I am unable to access the Master Data Manager itself. MDS Database and Web Application are using same user account which is Administrator on the system.
I installed Reporting Services 2014 on Windows 7. When i am trying to start home page i can see only HTML page and the text: "localhost/reports - /",then double lines (<hr><hr>) and text "Microsoft SQL Server Reporting Services Version 12.0.4100.1"Maybe the windows user (SERVER_NAMEADMINISTRATOR) has not sufficient permissions ?
I want to give the permission to a user to view only one folder among 10 folders on Home page of report server. I don't want that user to view other folder than his/Her Own folder on report server home page.
Our Information Assurance (IA) office wants us to add a warning message popup box to our SQL 2012 SSRS server.The purpose is to force users to acknowledge the warning box popup before they get into to the SSRS main page.The message box would contain text stating Privacy Act information and or DoD monitoring consent...
I added a new windows user "ReportUser" which is a local user (not in administrator group). When I connect to the report manage's web page, I use reportuser to log in (when the anonymous access is disabled it will ask a log in). Report builder icon is not showing up on the report manager home page.
If I log in as a user in administrator group, the reportr builder icon shows up so I can download it and build report.
I have assigned reportuser "Content manager" and "repoter builder" access to the home folder. Is there anything else I have to do to make the report build icon show up on the home page?
Is it possible to add hyperlinks to the Report Manager Home Page that link to other aspx pages? I have created some associated data entry aspx pages that I want to enable access to from the Report Manager Home Page (if possible).
I have created one reports but all the records are displaying on one page.find a solution to display the records page by page. I created the same report without group so the records are displaying in page by page.
Hi, how can I remove newline characters and tabs from a char field in sql. We are directing the results from a query to an excel and having the newlines in one of the columns is messing up the whole output. thanks Zoey
I'm in Management Studio right now and I have two tabs called : "Table -dbo.contact".
As is the case, one tab is actually for the Schema of the table while the other shows the data in the table. (I'd also guess that if I was looking at a "contact" table from another database or server it would also be listed as "Table -dbo.contact").
Is there an option in Studio to provide more detailed tab descriptions?
I want to rename the worksheet tabs when I export the report to excel. The answer is NO with SQL Server 2005 but any luck with SQL Server 2005 Service Pack 2? Please help.
I want a query which is used in sql server like access query
TRANSFORM Sum(Q_DayBook.Debit) AS SumOfDebit SELECT Q_DayBook.Purticular, Sum(Q_DayBook.Debit) AS [Total Of Debit] FROM Q_DayBook GROUP BY Q_DayBook.Purticular PIVOT Q_DayBook.CDate;
SQL query windows saves all the tabs in numerical sequence after you close each window. SO for example if you are typing query in window 1 and close it and open a new query windows it labels the new windows as SQL Query2 and so on.
What is the purpose of saving the SQLQuery windows like this? And how to retrieve all the windows.
I know this is an easy one. I have some how made the message and results tabs disapear. Now when i run somethinbg in the query window i don't see my results or errors.
I know from experience that the Excel connection mechanisms are somewhat limited. I was wondering if anyone has come across a solution to this problem.
We receive an excel file from a business line. Basically a list of account mods for a given month. Due to the tabular nature of Excel, sometimes the amount of mods exceeds the limits of one tab and has to roll over into a second tab. The names of the tabs reflect the file creation date, which often is the last day of the month, but not always. Here is a question related to this-
Is there a way to "query" a the list of tabs in an Excel file, so that I could store that record set in an SSIS variable, use it to loop through all the tabs? If no, can you think of a way to somehow get the value of the tab name or names so that I can use it to dynamically set the OpenRowset value of the Excel Data Source?
Hello All, I am viewing the report in Reporting Manager. It has four tabs at the top viz. View, Properties History and Subscription. When I click any one of Properties, History or Subscription and click the View tab again, I loose my dataset that was there before I started clicking the tabs. It prompts for the parameters again. Is that by design? I find this a nuisance to enter the parameter again and run the report just because I navigated to a different tabs. Any suggestions to alter this behavior to make the data sticky in the report?
SSMS 2012: when you open up many sql files in the IDE, it starts hiding some tabs and you have to click on the drop down at the right to navigate to the tab you want. Is there a way to make it display more than one row of tabs, so that tabs are not hidden and always displayed?
I liked the default appearance of SSMS in 2005 and 2008. 2012 is lousy by default.
My quesion is whether it can be made to approximate the way it behaved in 2008.
What I liked: Registered Servers and Object Explorer resided on nested vertical tabs on the left-hand side of the screen. Queries stacked up on the right-hand side of the screen.
I managed to get the Registered Servers and Object explorer to display with nested vertical tabs (tabs at the top, rather than the bottom - that's ok). But if there aren't any other vertical tabbed displays, then the tab on top fills the screen. There's no point to that. Both Registered Servers and Object explorer are narrow trees. The rest of the screen is white nothingness.
If a query is opened, it then fills the screen - empty. If I want that in a vertical tab I have to manually make it one (right click, choose New Vertical Tab Group).
s there a way to make the doggone thing behave?
The way I got the Registered Servers and Object explorer to behave this way was to right click on a tab and play with the vertical tabbing options.
Ever since I installed Internet Explorer 7 I have recieved an error message when closing the browser tabs. It doesn't matter if I am closing one or all of the open tabs. Here is the message I recieve,
"Access violation at address 02050200 in module iesdsg.dll Read of address 25202E67"
This message didn't occur until I installed IE7. When I uninstall IE7 the message does not show up. Any insight would be appreciated.
is there a way to avoid closing and reopening tabs in mgt studio when one task conflicts with another? For instance, I sometime look at a stored proc by scripting it as a create to a new query window. If I need to alter the db it is on, in a way that conflicts with a separate connection that is looking at a stored proc, I have to close the tab in which I was viewing the sp, run the alter, close that tab and then rescript the sp as a create in a new window.
I had to re-image my computer and reinstall SQL 2014. Now, when I open a table (edit top 200 rows) a tab opens (of course). But if I do not hit something like Show Criteria Pane and try to open another tab the first tab is replaced by the second table's tab.
How do I keep both open before hitting Show Criteria Pane?
My company is trying to convert existing reports to Reporting Services 2005... we need to have reports that export to excel with multiple sheets have the group name as the tab label. I can't find anywhere how this can be done. Can someone please tell me when this will be available? We have the latest service pack and still can't get this done... Our large customers are used to getting their reports this way, and the document map with sheet1,sheet2..etc.. will not be a suitable option. Any help with this is greatly appreciated.... seems I am not the only one waiting on this one...
In my SSIS package I have a loop container that I am running the same code against 4 servers. I have the package export the SQL data to an Excel spreadsheet that has multiple tabs.
Is there a way I can change the tab on the fly or do I need to create a Connection for the same spreadsheet 4 times Each Connection pointing to a different tab?
I tried to set up a expression for the Excel Connection Manager to use the InitialCatalog for the tab and change it based on the script in the loop however this causes the following error:
An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft Native Client" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Cannot create an OLE DB accessor. Verify that the column metadata is valid.
