What Permissions Required For SSMS Reports

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


ADVERTISEMENT

Permissions Required For Sp_databases

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

SSMS Express SP2 Reports Issue

Apr 27, 2007

Hi

After remove the previous SP1 installation of Sql Server Express with Advanced and installed the SP2 I've notice the presence of the [Reports] context menu voice.

I can see some report correctly, but for someone, like "Disk usage by table" i receive a NullReferenceException (System.xml) as following:



in System.Xml.XmlReader.CalcBufferSize(Stream input)
in System.Xml.XmlTextReaderImpl.InitStreamInput(Uri baseUri, String baseUriStr, Stream stream, Byte[] bytes, Int32 byteCount, Encoding encoding)
in System.Xml.XmlTextReaderImpl..ctor(String url, Stream input, XmlNameTable nt)
in System.Xml.XmlDocument.Load(Stream inStream)
in Microsoft.SqlServer.Management.Reports.StandardReport.LoadRdlDocument()
in Microsoft.SqlServer.Management.Reports.Report.LoadReportQueriesFromRdl()
in Microsoft.SqlServer.Management.Reports.StandardReportFactory.GetReport(ReportInfo reportInfo, ReportContext context)
in Microsoft.SqlServer.Management.Reports.ReportsManager.GetReport(ReportInfo reportInfo, ReportContext context)
in Microsoft.SqlServer.Management.Reports.ReportsManager.ShowReport(ReportInfo reportInfo)


Can someone help me to solve this issue.



ThanksMatteo

View 2 Replies View Related

DTS & Security: Permissions Required To Launch Package

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

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 View Related

SQL 2012 :: Ssms Reports Library Not Registered

Nov 21, 2012

Windows 7 pro 64.
8gb ram.

Already have SQL2008 installed, and it works fine and great.Needed to install 2012 alongside for another project. Heard it should be fine to have both running. So I did. Installed MDS, DQS, SSIS, Service, and management tools. Launching SSMS 2012, when I click the "new query" button... I get the following error: library not registered. (exception from hresult:0x8002801D (type_e_libnotregistered))

If I connect object explorer to a server (local or otherwise), and try to script an object, it gives me the same error and then crashes the application. If I launch SSMS 2008, I can use it to connect to 2012 instance. So I know the instance and service are running correctly. It looks like its just the SSMS that is a problem.

View 4 Replies View Related

SQL Server Admin 2014 :: Permissions To Debug Stored Procedures Using SSMS?

Jun 25, 2015

What permission is required to run debug feature in SSMS(debug Stored Procedures). This is a development machine and developer requested for this.

EXECUTE permission was denied on the object 'sp_enable_sql_debug', database 'mssqlsystemresource', schema 'sys'.

EXECUTE permission was denied on object 'sp_sql_debug', database 'master'.

Is there any option other than giving sysadmin privilege on SQL?

View 0 Replies View Related

Reporting Services :: User DMNServerBreanch Does Not Have Required Permissions

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

What Permissions Are Required To Call The ReportingService2005.CancelJob Method?

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

Required Permissions (no Local Admin) For Deploying A Report

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

Row-level Security: Permissions Required On Base Table?

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

Minimum Permissions Required By The SQL Server 2005 Upgrade Advisor

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

SQL Server Admin 2014 :: Required Permissions To Enable Mirroring Session

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

DTS Designer Task: Copy Server Objects. What User Permissions Required?

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

Data Warehousing :: How To Decide Whether It Is Required To Develop Operational And Analytical Reports

Jul 15, 2015

I have received some reports and I have been asked to decide whether these reports can be developed as an operational report or Analytical Reports.

Basically I wanted to understand what points needs to be considered while deciding whether I should go for Analytical reporting (Cubes) or Operation Reporting.

View 2 Replies View Related

What Permissions Are Required For SQL Server Service Account To Call Web Service Using CLR Integration?

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

Table Permissions Versus View Permissions

Aug 2, 2006

Using SQL Server 2k5 sp1, Is there a way to deny users access to a specific column in a table and deny that same column to all stored procedures and views that use that column? I have a password field in a database in which I do not want anyone to have select permissions on (except one user). I denied access in the table itself, however the views still allow for the user to select that password. I know I can go through and set this on a view by view basis, but I am looking for something a little more global.

View 5 Replies View Related

Comparison Of SQL Server Reporting Services To Access Reports, Crystal Reports, Cognos Or Other Options

Nov 5, 2007

Hello SQL Server Experts, Data Analysts, and Report Writers et al:

re: Reporting Options with SQL Server

I wanted to propose an offshoot to the pryor thread:

Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?

I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?

Thank you to all, and I hope this is a beneficial discussion to others.

Hal1490



Hal9000

View 4 Replies View Related

Reports Usage Frequency For All The Existing Reports On SSRS 2000

Mar 18, 2008

I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.

Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?

I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.

Any help is appreciated

View 2 Replies View Related

Reports Usage Frequency For All The Existing Reports On SSRS 2000

Mar 18, 2008

I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.

Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?

I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.

Any help is appreciated

View 1 Replies View Related

Remove All Reports ( Not Data Sources) From Reports Server

Jan 23, 2007

Hi does anyone know how to do the above with out going through reportserver url?

Preferably by using a cmd tool ? such rs.exe

or through the backend in the reportserver DB?

Thanks

Dave

View 2 Replies View Related

Migration Of SQL Reports 2000 To SQL Reports 2005

Feb 13, 2008

Hi Friends,

Could I migrate the reports which are developed on SQL 2000 to SQL 2005. If Yes then How ...

Could anyone explain me. How it works.


Thanks
sqlferns

View 2 Replies View Related

Converting Crystal Reports To SSRS Reports

Mar 27, 2008


My issue is with converting multi-value parameters:

In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).

As an example:

I have a database table with a column called ID.
I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".

With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data:
1 - 50
60 - 80
150 - 127

This will only return results within those ranges.


Does anyone know if SSRS provides this kind of functionality?

Thanks,

Patrick Conway

View 9 Replies View Related

Copy Reports From Other Users My Reports Folder

Aug 7, 2007

Is there a way to copy reports from other users "My reports" folder? I am logging onto the management studio reporting services using an administrative account and I am able to view the reports from all users' "My Reports" folder. But I am not able to export them as an rdl file. I am able to export reports from other common folders, but not from the "My Reports" folder.

The reason I need to do this is some of the users have created some reports in one environment and the reports are available in their respective "My Reports" folder. I need to move these reports to their corresponding "My Reports" folder in another environment.


Is there a way to do this?

Thanks for your help.

View 3 Replies View Related

How To Show ChartFX Reports In ReportServer And How To Show Tooltips For Reports Using Chart Properties

Dec 31, 2007



Hi all,

I have two problems.

1. I downloaded ChartFXRSTrial and created one chart, and able to deploy it in ReportServer, but the problem is the reports are not showing there, i checked the configuration of .dll files in the help provided by chartFX, but couldn't get anything, so could help me on this.

2. How to give Tooltip for the X- axis or Y- axis values in the ReportServer , i tried using chartproperties of .rdl file, but didnt understand it. can help me on this, and one more i tried with Dundas too, If im giving tooltip as #valy then, it is showing samething in reportserver instead the values of 'Y-axis'.

Thanks,
Mahesh Manthena

View 1 Replies View Related

SSMS

Apr 2, 2008

OK, I have all of my SS2k sproc scripts saved as

owner.sprocname.prc

Because EM scripted them out that way

Now that we are using MS, it doesn't recognize the script, it doesn't highlight the code, and doesn't connect to a server

Can a change this somewhere?

I've got all of my scripts in pvcs as *.prc and I'd rather not have to change it

Any ideas?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

View 1 Replies View Related

SSMS

Feb 14, 2006

Can I run SQL Server Management Studio (SSMS) from a workstation or do I need to Remote into the server? (SQL Server 2005 Standard Edition)

My workstation already has VS 2005 installed.

Thanks.



View 1 Replies View Related

Where Is SSMS?

Sep 14, 2007

I installed Visual Studio over a year and a half ago when I became a Microsoft ISV. I have done all of my SQL Server work from within the Visual Studio framework and UI. I recently was asked to document how a customer's users would set up the customer's system using SQL Server 2005, but not having Visual Studio. I got the book Beginning SQL Server 2005 for Developers and immediately ran into a wall. Dewson (the author) talks about the SQL Server Management Studio. He says you get to it by Start > Programs > Microsoft SQL Server 2005 > Sql Server Management Studio. When I tried, I went Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools.

I have reinstalled my SQL Server 2005 Developer's edition and installed SQL Server 2005 Standard edition every way I can see, but I still can't get SSMS to come up. What am I doing wrong?

I am running XP Pro 2002 with SP 2. It is on a thinkpad with P4-M 1.8 ghz and 512 mb RAM. My Add/Remove programs says I have SQL Server 2005, SQL Server 2005 Backward Compatibility, SQL Server Native Client, SQL Server Setup Support Files, and SQL Server VSS Writer installed.

Thanks,

Ron

View 8 Replies View Related

SP1 Version Of SSMS

Feb 11, 2007

Hello,
What version of SQL Server Management Studio exists after SP1 is installed?  Can you tell if SP1 has been installed based on that?
Thanks.

View 1 Replies View Related

SSMS Scripting

Jan 29, 2008

Are you kidding me?

I can't create 1 object per file anymore AND I can't have the drop created along with the create

Are they forcing you to use ALTER?

What a piece of junk

View 7 Replies View Related

SSMS Is A Piece Of....

Apr 2, 2008

Junk

OK, I have all of my SS2k sproc scripts saved as

owner.sprocname.prc

Because EM scripted them out that way

Now that we are using MS, it doesn't recognize the script, it doesn't highlight the code, and doesn't connect to a server

Can a change this somewhere?

I've got all of my scripts in pvcs as *.prc and I'd rather not have to change it

Any ideas?

View 5 Replies View Related

SQL 2012 :: How To Add SSC Add-ins To SSMS

May 4, 2014

I installed Red Gate's SQL Search and now I have an Add-ins icon. From the Icon I got to a list of tools, one of which is SSC's script library.

When I downloaded it I got this file "SQLScripts.utmcsr&__utmv=-&__utmk=243779397" which did not trigger an installer when clicking on it. How do I add it.

View 3 Replies View Related

Is There SSMS In Sql Express

Nov 14, 2006

Hello

Can any one of u tell me isthere any SSMS when we install only SQL Express independent of SQL Server

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved