SQL 2012 :: SSRS User Does Not Have Required Permissions
May 29, 2015
I've got a Server setup at work on our RD domain
It's Windows 2012, running SQL Server 2012 with reporting Services
I've installed our application and reports to this server.
If I'm on my CORP domain on my development laptop I can enter the following into IE [URL] ...... and the SSRS reports page opens up fine
I then RDP into this server using my same CORP credentials Open IE on this server and enter the same URL within IE and get User 'CORPORATEjoep' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
I'm on the Server itself. Why does my account not work there, but when I access SSRS from outside this SERVER with same login, it works
View 1 Replies
ADVERTISEMENT
Aug 10, 2015
User 'DMNServerBreanch' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account.Control (UAC) restrictions have been addressed.
View 2 Replies
View Related
Nov 6, 2006
I'm making a copy of some tanles between 2 servers.
Server 1 requires a sql login
Server 2 is using Windows Auth.
I have a user on server 1 named "odbc" able to log in.
however my copy task fails, when I drill the error, it's lists the first user in server 1 alphabetically as the failed login???? but in my dts I am specifying the "odbc" user and password.
I think I have a permissions problem on server 1. So my Question, what minimum permissions does user "odbc" need to copy a table?
On server 1 I can copy from northwind to server 2 just fine..but any other db on server 1 causes the weird failure with the wrong username.
Any Ideas? I am not a DBA obviously :)
Thanks,
Carl
View 1 Replies
View Related
Sep 26, 2014
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...
View 1 Replies
View Related
Jul 13, 2015
There's a new SSRS 2012 environment which was setup with My Reports folder to each user enabled. I know I'm supposed to see a Users Folder in the Report Manager root, I'm setup as a system administrator (under Site Settings) and also have content manager rights in the root directory and I still don't see the "Users Folders" ...the only way I can see that is if they give me admin rights in the server SSRS is installed. What am I missing here, is this supposed to be like that?
View 5 Replies
View Related
Mar 12, 2015
Issue #1 I have a report that takes 8 character parameter, A error message needs to popped out if user enters parameter less than 8 character.
Issue #2 I have a report with Tablix. A message needs to display if Tablix returns no Rows.
View 1 Replies
View Related
Feb 27, 2006
This may be the wrong forum for this - if so, please direct me to the appropriate forum.
I've
recently upgraded to MSSQL 2005 and I'm trying to execute the
sp_databases stored procedure, but I'm having what looks like
permissions problems. I can execute the stored procedure, but it
doesn't return any results. As far as I can tell, the problem is that
my userid can't see any rows in sys.master_files (I can select from the view, it just doesn't return any rows).
I've tried any
number of things to get this to work, but the only thing that's been
successful is to change my userid's database role membership to
db_owner. In the long run, this isn't really a viable solution for me,
since my userid should only really have read(select) access to the
database in question.
I'd appreciate any pointers that you can
give me - I figure I'm doing something stupid, but haven't been able to
figure out what, yet.
Thanks,
Jeff
View 5 Replies
View Related
Apr 10, 2008
Good Afternoon All:
We have a SQL2K5 SP2 (x64) in active/passive cluster running an ERP application database.
I have users in remote office who are requesting the ability to run the "standard reports" from SSMS such as Disk Usage, Disk Usage by Table and so on. The user in question has AD account within the instance with db_datareader role.
What other database or server defined role is required to allow this user to launch and view the standard reports from SSMS?
Thanks!
View 12 Replies
View Related
Apr 9, 2007
Hi all,
I was wondering whether there is a way to show the user an error when the user did not select a specific parameter.
In my case, I have two optional parameters. The user has to select either one to view the report. If the user does not select either one, I would like to show some sort of an error page indicating so. However, all i am getting is a complete blank with no report in sight. I as a developer know this is an error as a result of missing parameters, but i was wondering whether I could produce a page or direct it to a page so that the user doesn't go all horrified at an empty page ?
Thanks
Bernard
View 4 Replies
View Related
Jan 9, 2001
I have prepared several DTS packages which must be launched by a custom external application. What is the best way to provide access to this application? What are the minimum security requirements? Currently, they are local packages; I understand that some utility is offered by saving them as .DTS files, but I don't know the pros & cons. Are there advantages to using the Repository? The app should be able to do its work from a different box on the same network as the server. (Ultra-super-secret security isn't an issue, but I don't want to have give our developers sa-level access unless necessary.)
View 2 Replies
View Related
Apr 14, 2008
I'd like to cancel my long running Reports via ReportingService2005.CancelJob(). It seems, while I'm able to start a job I don't have the permission to cancel it. I always get the error message:
The permissions granted to user '<my-account>' are insufficient for performing this operation.
Do I have the be a member of a special group on the server running the Reporting Services?
werner
View 3 Replies
View Related
May 7, 2007
Hi all,
what are the minimum required permissions for being allowed to deploy a report? When I try to deploy a report in BIDS I get the error message that my user has not sufficient rights for doing so.
Some key data for my configuration:
Windows Server 2003 Standard Edition with Service Pack 1
SQL Server 2005 Standard Edition with Service Pack 1
I'm not a local administrator, but I have administration rights for SQL Server and Analysis Services
I'm in the Reporting Services' system administrator and system user groups
I can access http://localhost/Reports, but not http://localhost/ReportServer
I have access to the directory (incl. subdirectories) MSSQL.2, but not to MSSQL.1MSSQL and MSSQL3Reporting Services
I can't run the Reporting Services Configuration Tool (see http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1565766&SiteID=1)
I can't connect to Reporting Services in SQL Server Management Studio
My question is (as I have already mentioned in the beginning): what are the minimum rights the IT administrator has to assign to my user so that I'll be able to deploy reports? Giving me local administrator rights is not possible.
Thanx in advance and kind regards,
Gerald
Update:
In the meantime I have found out, that I'm most probably not a member of the Publisher role. But although I am in the System Administrator role I cannot assign myself to this role. When going to http://localhost/Reports the required links are just not visible. Is this because I'm not a member of the groups SQLServer2005ReportServerUser$... and SQLServer2005ReportingServicesWebServerUser$... ?
View 4 Replies
View Related
Jun 2, 2007
I'm implementing row-level security in a SQL Server database that uses Microsoft Access for the front end. I'm using a UDF (a view behaves the same way) to restrict access to specific rows of a base table based on membership in a role. According to the reading I've done, if the base table has DENY ALL permissions for the role, and the UDF has GRANT ALL, members of the role should be able to update records in the base table via the UDF, without having direct access to the base table. However, I find that unless I grant appropriate permissions on the base table, the user is unable to update the table via the UDF.
Is this expected behavior? Nothing I've read suggests I should have to grant permissions on the columns of the base table.
View 10 Replies
View Related
Feb 15, 2008
Hi all,
What are the minimum permissions required by the SQL Server 2005 Upgrade Advisor (UA)? I could not find it in the documentation.
Obviously being a local Administrators Windows group and a member of sysadmin SQL Server role will do the trick.
But will being a member of only the sysadmin SQL Server role be enough? I know that the UA does want to read the registry.
Running it under just sysadmin generates the following type of errors:
Database Server
PreUpgrade
Requested registry access is not allowed.
WINSOCKPROXY
Database Server
PreUpgrade
Requested registry access is not allowed.
FTUNSIGNEDCOMPONENTS
Database Server
PreUpgrade
Requested registry access is not allowed.
NETPROTOCOL
Database Server
PreUpgrade
Requested registry access is not allowed.
FTMULTIPLEINSTANCES
Database Server
PreUpgrade
Requested registry access is not allowed.
INVALIDNAMEDPIPE
Database Server
PreUpgrade
Requested registry access is not allowed.
FTCOMPONENTREG
Database Server
PreUpgrade
Requested registry access is not allowed.
FTACCTPASS
The issue then is whether these are significant or not. If the UA is only reading the registry to determine if SSAS, DTS, etc is installed then that is not important. But if it is affecting the end result because it cannot read critical information from the registry that is another matter.
TIA
View 1 Replies
View Related
Oct 29, 2015
I have a Windows NT group that is used to delegate certain database responsibilities to other members of staff and I am trying to grant permissions for the members of the group to be be able to establish database mirroring sessions, as in run the following:
ALTER DATABASE <database>
SET PARTNER = 'tcp://principal_server.domain.com:port';
Although the group has db_owner role membership to the user database which grants the ALTER permission on the database, the following is being generated in the error log when they get to this step on the intended Mirror instance after restoring the database correctly in preperation:
SqlDumpExceptionHandler: Process 59 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 10/29/15 11:16:15 spid 59
*
*
* Exception Address = 00007FF9A6AF838C Module(sqlmin+000000000003838C)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000000000D8
* Input Buffer 210 bytes -
* alter database <redacted> set partner = '<redacted>';
As you can see, the statement is denied to the user. There are no issues with the database as I am able to run the same query successfully using my own sysadmin account after the failed attempt. What other minimum permissions the group might need to successfully enable them to setup a mirroring session?
View 9 Replies
View Related
Aug 8, 2007
I'm trying to deploy a project that I deployed yesterday just fine, but today I get the following error:
------ Deploy started: Project: Point Reports, Configuration: Debug ------
Deploying to http://reporting.companyname.com/reportserver
Deploying data source '/Data Sources/Srv24.FieldResponse2_1'.
The permissions granted to user 'DOMAINharley.p.bartman' are insufficient for performing this operation.
Deploy complete -- 1 errors, 0 warnings
This seems like a basic permission issue, except I'm not logged in as the user listed! I've never logged into my computer as the user. I did log in to the reporting services website yesterday as that user, but since have rebooted my machine and logged into bothe my computer and the reporting services website as me. Yesterday this report deployed fine. Today, this error message. I've even tried creating a new project and just creating a simple datasource and deploying just that, but still this message! Where is Visual Studio storing and reusing this user name during my deploy process???
View 4 Replies
View Related
Jun 29, 2007
Hi,
How to import analysis browser in SSRS. I need features similar to SSAS Cube browser and SSAS dimention browser.
Regards
Spandan
View 1 Replies
View Related
Jun 9, 2015
Have a production server, 12 Enterprise, and we are adding a new app to an existing instance. Next app needs SSRS and that was not put in the install request a year ago for the instance.
I do not think a reboot is required but have been wrong before. There are no SPs applied to this server and only last week we were given go ahead from one app vendor to apply SPs. That would have been done in monthly maintenance cycle next weekend. Our test server is doing just fine with all apps on SP1.
View 3 Replies
View Related
Oct 3, 2006
SQL Express is quite sizable for what I want to do but it appears to have many features that could turn out to be highly desirable.
It makes sense that the entire SQL Express must be installed at the developer's location, but what portion of it is required at the application user's location? All, or some?
Thanks
View 1 Replies
View Related
May 18, 2007
Hello! I have the following problem. I developed CLR Stored Procedure "StartNotification" and deploy it on db. This sp calls external web service. Furthermore, this sp is called according with SQL Server Agent Job's schedule. On my PC SQL Server works under Local System account and this web service is called correctly (Executed as user: NT AUTHORITYSYSTEM). But on ther other server the following exception is raised during job running:
Date 17.04.2007 16:42:10
Log Job History (FailureNotificationJob)
Step ID 1
Server MSK-CDBPO-01
Job Name FailureNotificationJob
Step Name MainStep
Duration 00:00:00
Sql Severity 16
Sql Message ID 6522
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: CORPmssqlserver.
A .NET Framework error occurred during execution
of user defined routine or aggregate 'StartNotification':
System.Security.SecurityException: Request for the permission of type
'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089' failed. System.Security.SecurityException:
at System.Security.CodeAccessSecurityEngine.Check(Object demand,
StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.CodeAccessPermission.Demand()
at System.Net. The step failed.
What is the reason of this behaviour? Unfortunately I do not have direct access to this server.
I have the following guesses:
1) CORPmssqlserver may have not enough permissions to call web service
2) Something wrong with SQL Server account's permissions
2) Something wrong with SQL Server Agent account's permissions
I will take the will for the deed. Thanks.
View 1 Replies
View Related
Mar 20, 2008
OK
We have our nice shiny SSRS installation set up, now I want to start creating reports, bear in mind I am not the administrator on this box, but I will need to create content.
What I need to do is create and modify datamodels, create, amend and publish reports, amend folders and content on the reporting services web site.
I have done some reading into this, it seems that there are, what I am assuming are builtin groups for SSRS, these being:
Content Manager
Publisher
Report Builder
Browser
Thanks for your help.
Lee
View 2 Replies
View Related
Feb 1, 2007
Hi,
I've an UDF which inside has two query joined by union and it 's similar to this
select * from Table1 .... (several conditions)
union
select * from Table2 .... (several conditions) (this could takes long time to run)
Since i can't write dynamic sql into UDF , i can't avoid to insert Table2 into the query but to improve permormance I've seen how costant can help me.
For Example if I change my UDF in
select * from Table1 .... (several conditions)
union
select * from Table2 Where 1=2 AND (several conditions)
Optimazer is able to skip completely the second execution, so i need to transform 1=2 into a dynamic condition for example test a field table existence.
select * from Table2 Where Exist (select * from Table3 where Field1=1)
That is why i try to write a single UDF can adapt itself to several situations using second condition only where is necessary and not always.
The problem is the dynamic condition for simple could be, wasn't recognize as costant.
For Example
select top 1 * from MyTable where (select 1)=2
select top 1 * from MyTable where 1=2
If you see the execution plan of these 2 queries you could see that the first takes more than 80% of execution time and in the second less than 20%.
Moreover the second plan use a costant scan unlike the first doesn't it.
Do anyone know a way to tell to optimizer to use a simple condition as constant ? This improve drastically my UDF performance..... :( :(
Thanks.
View 1 Replies
View Related
Sep 3, 2015
Currently we are using Custom Delivery Extension for SSRS 2008R2 We are planning to move it SSRS2012
My Question is: Whether we can use the same Code used for SSRS2008R2 to SSRS2012?
if not what code changes we should do?
View 3 Replies
View Related
Nov 9, 2015
I want to grant CREATE, ALTER, VIEW permission to user but not DML permission?
So user can create Object but can't drop and delete it or user cant insert , update,delete from table.
I have Given db_datareader,db_denydatawriter, and granted create, select, alter permission.
But user is able to drop.
View 3 Replies
View Related
Oct 27, 2015
An automatic failover set exists. This set consists of a primary replica and a secondary replica (the automatic failover target) that are both configured for synchronous-commit mode and set to AUTOMATIC failover.Configured the both AG Group database automatic failover and synchronous-commit mode.But automatic Failover failed also Cluster service not started automatically at Node2. It got connected through AO Listerner after starting Node1. As below SQL Error log during shutdown Node1
Date,Source,Severity,Message
10/27/2015 10:44:20,spid37s,Unknown,AlwaysOn Availability Groups: Waiting for local Windows Server Failover Clustering node to come online. This is an informational message only. No user action is required.
10/27/2015 10:44:20,spid37s,Unknown,AlwaysOn Availability Groups: Local Windows Server Failover Clustering node started.
[code]....
what need to be change existing AO configuration?
View 9 Replies
View Related
Apr 17, 2014
I need to display the output of a table in a specific format, I have attached the sample screenshot and code for reference.
I tried with pivot but does not seems to be working.
View 2 Replies
View Related
Jun 18, 2014
I am unable to update the data using record by record below scenario.
Required output:
patient will able to Admit/Re-admit multiple times in hospital, if a patient readmitted multiple times in hospital after the first visit, first visit record will get Re-admission=0 and Index=1. This visit should cal Index_Admission of that patient. using this index_admission should calculate the 30-day readmission.
Current Output:
Calculation: From index_admission discharge date to next admit_visit date,
1) if the diff is having less than 30 days, readmission=1 and Index=0
else readmission=0 and Index=1 should be update.
For checking this every time should check using the latest index_admission discharge_date.
To get this result i written below logic, but it's updating readmission=0 and Index=1 after 30-day post discharge of using first index admission.
UPDATE Readmission
SET Index_AMI = (CASE WHEN DATEDIFF(DD, (SELECT Sub.Max_Index_Dis FROM
(SELECT Patient_ID, MAX(Discharge_Date_Time) Max_Index_Dis FROM Readmission
WHERE Index_AMI = 1 AND FPR.Patient_ID = Patient_ID GROUP BY Patient_ID) Sub)
, FPR.Admit_Date_Time) between 0 and 31 THEN 0 ELSE 1 END),
[Code] ....
Expected Result:
View 5 Replies
View Related
Apr 24, 2015
Why am I getting message "A valid table name is required for in, out, or format options."
I used the syntax from a tutorial about bcp utility. I am trying to create a format file for flat file import and export.
My server instance is "stat-hpsqlexpress"
The database name is "STATRLO"
Owner is "dbo"
Table name is "PM-allactivity-emaillog_042315"
The bcp comand I am trying to run is:
bcp STATRLO.dbo.PM-allactivity-emaillog_042315 format nul -c -t, -f C:databaseActivity_c.fmt -S stat-hpsqlexpress - T
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
SQL Server Version:
Microsoft SQL Server 2012 (SP1) - 11.0.3153.0 (X64)
Jul 22 2014 15:26:36
Copyright (c) Microsoft Corporation
Business Intelligence Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Yes I know the instance says sqlexpress...it was upgraded.
View 3 Replies
View Related
Aug 14, 2015
let me know apart from the following what else is required
2 for private network
2 for public network ......
1 for virtual server/windows cluster ip which is used to connect application
View 1 Replies
View Related
Nov 4, 2015
I'm after running into something in SSIS 2012 that I fail to grasp.
I have a package that provides a service to other packages. In order to provide that service it needs 4 parameters provided by the caller. So naturally I'm thinking I make those 4 parameters 'required'.
The caller uses Execute package task and provides the 4 parameters on the parameter mapping tab.
Yet the packages fails with the error message that one or more required parameters weren't provided.
View 7 Replies
View Related
Nov 15, 2001
I have 2 users in a database who is having dbo privilages.
I don't want them to modify data in 1 table.
How can I do that?( without removing them from dbo role)
Thanks in advance.
cheryl
View 1 Replies
View Related
Sep 3, 1999
Can someone tell me where user permissions for a table are stored within the
database? One of my programmers would like to access this table for the
security portion of a program he is writing.
Thank you!
Toni Eibner
View 1 Replies
View Related
Apr 28, 2008
Hey all,
Just trying to figure out how to set a users permission in SQL 2005. Ive got one user but I only want them to be able to view data from one or two tables or and views, but can I do this without having to deny access to every other table?
Thanks
Daniel
View 3 Replies
View Related
