Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







The Permissions Granted To User 'domainusername' Are Insufficient For Performing This Operation. (rsAccessDenied)




Hi,

I wonder if anyone can help me?

I have installed and configured sql server 2005 express edition with advanced services on an xp box, with the aim of using reporting services.

I have set up reporting services successfully using the report manager, with my web services id = netwrokservice.

I can access both the report manager and report url locally, i.e while using localhost anjd on the machine. The problem arises however when i try to access

the reports from another machine, as i get the message:

"The permissions granted to user 'domainusername' are insufficient for performing this operation. (rsAccessDenied)"

when going to for example:

"http://servername/ReportServer/Pages/ReportViewer.aspx?%2fReport1&rs:Command=Render"

I have looked at various sites (including microsoft) in an attempt to find a solution to this and most sites give exmaples of how to configure the full

version of reporting services which i do not have. The things that I have managed to gleam and try are:

- open up security on dir: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServer to everyone and allow all access
- added my own username as a new role assigment in the report manager page
- added my own username to the reportserveruser and reportingserviceswebservicesuser roles, as indicated by microft:

http://msdn2.microsoft.com/en-us/library/ms365166.aspx, who state that "Custom authentication extensions and custom role assignments are not supported. You

must map existing Windows domain user and group accounts to predefined role definitions."

Can anyone suggest where to look next as I cannot believe that this should be this difficult?

Many Thanks in advance


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
The Permissions Granted To User 'DomainUsername' Are Insufficient For Performing This Operation. (rsAccessDenied)
I think setting up SSRS 2005 is quite a nigthmare unlike SSRS 2000 getting errors like :-

The permissions granted to user 'DomainUsername' are insufficient for performing this operation. (rsAccessDenied)

Then later

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database

I have SSRS installation om my Vista Ultimate machine and i have assigned everyone access to the Reporting Services folder where the ReportServer and Report Manager resides..

When i launch the Reporting Services Conf Manager most buttins are GREEN which is alright except the Windows Service Identity.The initialization is greyed out


Sometimes when i get back in the first error dissapears and then the second one comes in..
When i press delete to delete the encription key it just goes foreever and doesn't return anything meaningful error..


------------------------------------------------
I have another installation on my WIN2003 box and i have SSRS 2000 side by side with SSRS 2005..

the SSRS 2000 works well but the SSRS 2005 gives be a blank page with nothing

View Replies !   View Related
The Permissions Granted To User 'Domainuser' Are Insufficient For Performing This Operation. (rsAccessDenied)
Hi, I've scoured the forums and tried just about every answer to this problem without any success. What I have is SQL Server 2005 installed on a single machine, and trying to deploy reports to the same machine for testing purposes. When I try to deploy the report I receive the permissions error. Here's what I've gotten to at this point:


I can get to the reports URL (http://machine/Reports)

I can login to Reporting Services viaSQL Server Management Studio as the administrator. (Windows Authentication)

I have added my login to the Home Folder-->Permissions in SQL Server Management Studio, and all reports are set to inherit the home folder's permissions

In Reporting Service Configuration Manager the Windows Service Identity is set to Local System, and for web service identity - ASP.NET Service Account is set to NT AuthorityNetworkService; Report Server and Report Manager are set to DefaultAppPool.

In IIS I tried enabling Anonymous Authentication

Current Application pools are set to "Classic" for Managed Pipeline mode (I did this to actually be able to login to Reporting Services via SQL Server management studio; having this set to integrated gives me an error)
Whatgets me is that this is entirely self-contained on one machine, that I set up as an administrator. So why do I get a permissions error when I am the admin on this machine deploying to this machine?


View Replies !   View Related
The Permissions Granted To User 'DomainUser' Are Insufficient For Performing This Operation. (rsAccessDenied)
i finally got SSRS(SQL Server Reporting Services) to install properly and and it was working before i had to restart my PC
after restarting my PC i went back to the Domain/Reports$SQLExpress and the menus where Blank it just showed the help link and the border. so i opened the Domain/ReportServer$SQLExpress and it said


The permissions granted to user 'DOMAINOwner' are insufficient for performing this operation.(rsAccessDenied) Get Online Help
and there is no Login Box Popping up How do i get it to Login - Its set to use Windows Authentication what sould i doo please help ive had one problem after another with this SSRS

View Replies !   View Related
Error RsAccessDenied : The Permissions Granted To User '' Are Insufficient For Performing This Operation.
I get an error message when deploying reports to the reportserver from microsoft visual studio.

error message : Error rsAccessDenied : The permissions granted to user '' are insufficient for performing this operation.

TargetServerURL : http://server.com/ReportServer$sql_2005

The Report server is configured to use a custom security extension. i can access the reportserver.

It looks like when i deploy the reports from VS. it does not pass any credentials to the report server. From the error message it looks like there is no username . How do i deploy reports to report server if we are using a custom security extension. How do i grant user rights to deploy report if we are using a custom security extension. Any idea. Thanks!



chi





View Replies !   View Related
The Permissions Granted To User Are Insufficient For Performing This Operation.
I am getting the error "The permissions granted to user 'DOMAINUsername' are insufficient for performing this operation." when I try to deploy a report from Visual Studio 2005 (which is on a different machine than RS is installed on). In the properties of the project, I have the TargetServerURL set to "http://myreportserver/ReportServer" and TargetReportFolder set to "myfolder/My Project Reports". When I try to deploy the report, it correctly creates the My Project Reports, but fails to add the report. DOMAINUsername has been assigned all the roles in the Report Manager, and I am able to manually add the report through Report Manager. Username has also been granted Full Control to the MSSQL.3Reporting ServicesReportManager and MSSQL.3Reporting ServicesReportServer folders. Why would I be unable to deploy via VS?

View Replies !   View Related
The Permissions Granted To User 'mydomainmyuser' Are Insufficient For Performing This Operation.
Hi,

I am trying to deploy a reporting services report to remote reorting services server , i did the following :



in project property : http://192.xxx.xxx.xxx/reportserver

(NB: my pc and server are on the same domain)

and i assigned a permission for my user 'mydomainmyuser' on the virtual folder of the reporting service, but i got this error :

The permissions granted to user 'mydomainmyuser' are insufficient for performing this operation.I

I know it is a permission pb but please any idea to solve that ??

Thanks,

Tarek Ghazali

SQL Server MVP



View Replies !   View Related
The Permissions Granted To User &&<MachineName&&>ASPNET' Are Insufficient For Performing This Operation.
Hi,



I wanted to deploy my Sql 2005 reports to my local machine and want it to get viewed by all the users through Asp.Net application.

User can directly view the reports by clicking on the direct link to report but when they try to view it using application having Report Viewer, running on iis it gives acess denied 401 error and can't view the reports

If I make my application to run on default port then it works fine

If I give rights to <particularMachineNameASPNET> then that user can view the report but if there are 100 users then will i Add 100 such entries???

I think I am making mistake in this case.

Any response will be appriciated.





-Thanks,

Digs



View Replies !   View Related
RsAccess Denied!! The Permissions Granted To User 'PP2000Nataliya' Are Insufficient For Performing This Operation. (rsAcces
Hi,

I am running SQL Server 2005 and Windows Vista Ultimate.

I have a simple report with 2 textboxes on the layout: one for the title and one to display current execution time.

Reports runs ok but when I try and change anything on report properties->execution (for instance to cache the report for 10 mins) or properties->history and save changes I get this error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

The permissions granted to user 'PP2000Nataliya' are insufficient for performing this operation. (rsAccessDenied) (Report Services SOAP Proxy Source)

For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsAccessDenied&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00

------------------------------
ADDITIONAL INFORMATION:

The permissions granted to user 'PP2000Nataliya' are insufficient for performing this operation. (rsAccessDenied) (ReportingServicesLibrary)

For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsAccessDenied&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00

I am logged as Administrator.

Also, if I try and alter permissions for the report on properties->permissions and press OK the new details are saved ok.

Why I cannot apply changes to execution and history?

Many thanks,

Nat

View Replies !   View Related
The Permissions Granted To User 'domainusername'
The permissions granted to user 'domainusername' are insufficient for performing this operation. (rsAccessDenied)


Hi,

I wonder if anyone can help me?

I have installed and configured sql server 2005 express edition with advanced services on an xp box, with the aim of using reporting services.

I have set up reporting services successfully using the report manager, with my web services id = netwrokservice.

I can access both the report manager and report url locally, i.e while using localhost anjd on the machine. The problem arises however when i try to access

the reports from another machine, as i get the message:

"The permissions granted to user 'domainusername' are insufficient for performing this operation. (rsAccessDenied)"

when going to for example:

"http://servername/ReportServer/Pages/ReportViewer.aspx?%2fReport1&rs:Command=Render"

I have looked at various sites (including microsoft) in an attempt to find a solution to this and most sites give exmaples of how to configure the full

version of reporting services which i do not have. The things that I have managed to gleam and try are:

- open up security on dir: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServer to everyone and allow all access
- added my own username as a new role assigment in the report manager page
- added my own username to the reportserveruser and reportingserviceswebservicesuser roles, as indicated by microft:

http://msdn2.microsoft.com/en-us/library/ms365166.aspx, who state that "Custom authentication extensions and custom role assignments are not supported. You

must map existing Windows domain user and group accounts to predefined role definitions."

Can anyone suggest where to look next as I cannot believe that this should be this difficult?

Many Thanks in advance

View Replies !   View Related
Permissions Are Insufficient For Performing ListChildren()
I'm developing an asp.net app that will list the reports available on the report server. The app works OK on my local machine but when I deploy it I run into a permissions problem:

Exception Details: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT AUTHORITYNETWORK SERVICE' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'NT AUTHORITYNETWORK SERVICE' are insufficient for performing this operation. at Microsoft.ReportingServices.Library.ListChildrenAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute() at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems) at Microsoft.ReportingServices.WebServer.ReportingService2005.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems)

My code uses the DefaultCredentials:
ReportingService2005 rService = new ReportingService2005();rService.Credentials = System.Net.CredentialCache.DefaultCredentials;
CatalogItem[] catalogItems;
catalogItems = rService.ListChildren("/", true);
I can avoid the exception if I use the Administrator account:

System.Net.CredentialCache cache = new System.Net.CredentialCache();// Add a NetworkCredential instance to CredentialCache.// Negotiate for NTLM or Kerberos authentication.cache.Add(new Uri(ReportServer), "Negotiate", new System.Net.NetworkCredential("Administrator", "<password>", "<domain>")); //Assign CredentialCache to the Web service Client Proxy(myProxy) Credentials property.rService.Credentials = cache;

I'm pretty sure using the Administrator account here is not the best practice. Any suggestions?

Thanks,
Al

View Replies !   View Related
The Permissions Granted To User 'NT AUTHORITYNETW
I'm getting the following error when I try to view a web page with a report viewer control:

The permissions granted to user 'NT AUTHORITYNETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)


I've tried to add the group on the report server of NT AUTHORITYNETWORK SERVICE and have a 'browser' role.

That didn't work.


I've tried to use:

<identity impersonate="true" />

This just gives me an error of:

The permissions granted to user 'servernameusername' are insufficient for performing this operation. (rsAccessDenied)

...where the username is the Windows user account for anonymous access

I've even given 'servernameusername' a group on the report server and a 'browser' role, but I stil get the same error as in bullet #2

Any suggestions are welcome.

View Replies !   View Related
The Permissions Granted To User AAA/bbb .... RsAccessDenided
I have problem with permissions

here is my error
http://img2.tapuz.co.il/forums/1_91537174.jpg

how can I give all the computers in the network the permission to see the reports.

thanks

View Replies !   View Related
Permissions Granted To An Application Intead Of A User
I have an application that talks to an access db located on a 2000 server. I would like grant permissions to the application instead of a specific user. Any help would be great...

View Replies !   View Related
Issue On SSRS2005 To Grant Permissions To User Are Insufficient

I have a problem to execute report (.rdl) inmy web application. it says that"
The permissions granted to user 'SYSTEMAIUSER_SYSTEMA'are insufficient for performing this operation.". Actually am working on two systems which are SYSTEMA and SYSTEMB, SYSTEMA and SYSTEMB are having reportingservices and my web project. when i try to access web applicationand reporting services (whichmapped withlocalserver)from SYSTEMB to SYSTEMA am getting the above error. Please any one help me to come out from this issue.

View Replies !   View Related
Error (rsAccessDenied) - 'NT AUTHORITYNETWORK SERVICE' Are Insufficient
I have created a report using Microsoft Sql Server 2005 Reporting in my ASP.NET 2.0 Web application. It is succesfully running on the server itself on which I have created. But when I am trying to access it from my client machine by typing URL in the IE6 it gives me following error.

"The permissions granted to user 'NT AUTHORITYNETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied) "

Dont know how to solve this problem.

View Replies !   View Related
Performing String Operation
Hi,

I have got a column with the string "I too Love Sql Server". I am trying an output as shown below:

I want to divide this into 4 columns :

Column1 Column2 Column3 Column4
I too Love Sql Server I.t.L.S.S

The Column 4 contains the first letter of each word. If the string contains only 2 words, Eg: "Sql Server" then Column 2 will be empty and only Column 1,3 and 4 will be filled.

How do I do this?

View Replies !   View Related
Permissions Problem - RsAccessDenied - Urgent
Hi

I'm trying to get the CustomSecurity sample in Reporting Services to work [C:Program FilesMicrosoft SQL Server90SamplesReporting ServicesExtension SamplesFormsAuthentication SamplecsFormsAuthentication] but I keep on getting the following message:

The permissions granted to user 'Admin' are insufficient for performing this operation. (rsAccessDenied)

I have given <servername>ASPNET execute permissions.
I have successfully created a new user "Admin".

However, when I then try to logon to either ReportServer [http://miles/ReportServer/logon.aspx] or ReportManager [http://miles/Reports/pages/uilogon.aspx] I get the above error.

I'm using SQL 2005 Developer edition and XP professional.

Please help!

View Replies !   View Related
Connecting For Entire Session, Or Just When Performing An Operation?
Here's a simple question for you:Is it better to maintain a single open connection to the database for theentire duration of the users session, or to connect, perform an operationand then disconnect each time the user wants to do some work, within thatsession?If so, why?Thanks,Robin

View Replies !   View Related
Could Not Obtain Information About Windows NT Group/user &"Domainusername&" Error Code 0x5.
Here is my problem. Brand new SQL Server 2005 Installation1. Create a database "Test"2. Create a database user "Domainuser" and set user mapping to "Test"with datareader, datawriter permissions3. Look at Test ->Properties->Permissionsactivate "Domainuser" and click effective permissionsand I get this error messageCould not obtain information about Windows NT group/user 'Domainuser',error code 0x5. (.Net SqlClient Data Provider)Does anyone have a clue why this is happening?Additional InformationProgram location:at System.Data.SqlClient.SqlConnection.OnError(SqlExc eptionexception, Boolean breakConnection)at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlExceptionexception, Boolean breakConnection)atSystem.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObjectstateObj)at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,SqlCommand cmdHandler, SqlDataReader dataStream,BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)at System.Data.SqlClient.SqlDataReader.SetMetaData(_S qlMetaDataSetmetaData, Boolean moreInfo)at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,SqlCommand cmdHandler, SqlDataReader dataStream,BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)at System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a()at System.Data.SqlClient.SqlDataReader.get_MetaData() atSystem.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,RunBehavior runBehavior, String resetOptionsString)atSystem.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, Booleanasync)at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, Stringmethod, DbAsyncResult result)at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, Stringmethod)at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehaviorbehavior, String method)atSystem.Data.SqlClient.SqlCommand.ExecuteDbDataRead er(CommandBehaviorbehavior)atSystem.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehaviorbehavior)at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset,DataTable[] datatables, Int32 startRecord, Int32 maxRecords, StringsrcTable, IDbCommand command, CommandBehavior behavior)at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32startRecord, Int32 maxRecords, String srcTable, IDbCommand command,CommandBehavior behavior)at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)atMicrosoft.SqlServer.Management.Common.ServerConnec tion.ExecuteWithResults(StringsqlCommand)

View Replies !   View Related
User Granted Execute On Schema
I have granted execute on the dbo schema to a sql user so thathe can execute available procedures in the dbo schema. However when he executes a procedure ie..

exec dbo.myproc

The following error is returned:

Msg 229, Level 14, State 5, Line 2

SELECT permission denied on object 'MyType', database 'Mine', schema 'dbo'.

MyType is a table

How can I correct this behavior?

I don't want the user to be able to access the tables except via the procedure calls.



View Replies !   View Related
SPROC Won't Execute - Insufficient Permissions
I'm trying to use the SPROC below (courtesy of Erland!) to capture theerror message but it fails owing to insufficient permissions (I can'treproduce it just now, but I think it's because it can't get access tothe DBCC OUTPUTBUFFER).How do I give the SPROC permission to execute?Many thanksEdwardCREATE PROCEDURE stpShowErrorMessage @errmsg nvarchar(500) OUTPUT ASDECLARE @dbccrow nchar(77),@msglen int,@lenstr nchar(2),@sql nvarchar(2000),@s tinyint-- Catch the output buffer.CREATE TABLE #DBCCOUT (col1 nchar(77) NOT NULL)INSERT INTO #DBCCOUTEXEC ('DBCC OUTPUTBUFFER(@@spid)')-- Set up a cursor over the table. We skip the first-- row, because there is nothing of interest.DECLARE error_cursor CURSOR STATIC FORWARD_ONLY FORSELECT col1FROM #DBCCOUTWHERE left(col1, 8) <> replicate('0', 8)ORDER BY col1-- Init variable, and open cursor.SELECT @errmsg = ''OPEN error_cursorFETCH NEXT FROM error_cursor INTO @dbccrow-- On this first row we find the length.SELECT @lenstr = substring(@dbccrow, 15, 2)-- Convert hexstring to intSELECT @sql = 'SELECT @int = convert(int, 0x00' + @lenstr + ')'EXEC sp_executesql @sql, N'@int int OUTPUT', @msglen OUTPUT-- @s is where the text part of the buffer starts.SELECT @s = 62-- Now assemble rest of string.WHILE @@FETCH_STATUS = 0 AND datalength(@errmsg) - 1 < 2 * @msglenBEGINSELECT @errmsg = @errmsg + substring(@dbccrow, @s + 1, 1) +substring(@dbccrow, @s + 3, 1) +substring(@dbccrow, @s + 5, 1) +substring(@dbccrow, @s + 7, 1) +substring(@dbccrow, @s + 9, 1) +substring(@dbccrow, @s + 11, 1) +substring(@dbccrow, @s + 13, 1) +substring(@dbccrow, @s + 15, 1)FETCH NEXT FROM error_cursor INTO @dbccrowENDCLOSE error_cursorDEALLOCATE error_cursor-- Now chop first character which is the length, and cut after end.SELECT @errmsg = substring(@errmsg, 2, @msglen)GO

View Replies !   View Related
Distribution Agent Insufficient Permissions
Hi,

I am trying implement replication and having problem when creating push subscription to an existing transactional replication publication.
The distribution agent is failing to run its job with the error:

Agent message code 14260. You do not have sufficient permission to run this command. Contact your system administrator.

I followed the http://msdn2.microsoft.com/en-us/library/ms151868.aspx article instructions when I set the distribution agent properties

What did I miss?

The following is the step error message:
Date        1/12/2007 2:30:01 PM
Log        Job History (105342-DB3PROD-MOMA-ArchivedTransactions-105337-DEV2-15)

Step ID        2
Server        105342-DB3PROD
Job Name        105342-DB3PROD-MOMA-ArchivedTransactions-105337-DEV2-15
Step Name        Run agent.
Duration        00:00:00
Sql Severity        0
Sql Message ID        0
Operator Emailed       
Operator Net sent       
Operator Paged       
Retries Attempted        0

Message
2007-01-12 19:30:01.258 Microsoft SQL Server Replication Agent: distrib
2007-01-12 19:30:01.258
2007-01-12 19:30:01.258 The timestamps prepended to the output lines are expressed in terms of UTC time.
2007-01-12 19:30:01.258 User-specified agent parameter values:
            -Subscriber 105337-DEV2
            -SubscriberDB MOMA
            -Publisher 105342-DB3PROD
            -Distributor 105342-DB3PROD
            -DistributorSecurityMode 1
            -Publication ArchivedTransactions
            -PublisherDB MOMA
            -XJOBID 0x65C41EBC553D96439BAF69E4DC3CC823
            -XJOBNAME 105342-DB3PROD-MOMA-ArchivedTransactions-105337-DEV2-15
            -XSTEPID 2
            -XSUBSYSTEM Distribution
            -XSERVER 105342-DB3PROD
            -XCMDLINE 0
            -XCancelEventHandle 00000000000006E8
2007-01-12 19:30:01.258 Startup Delay: 214 (msecs)
2007-01-12 19:30:01.477 Connecting to Distributor '105342-DB3PROD'
2007-01-12 19:30:01.618 Agent message code 14260. You do not have sufficient permission to run this command. Contact your system administrator.

View Replies !   View Related
An Error 1069 - )The Service Did Not Start Due To Logon Failure) Occurred While Performing This Service Operation ...
Hi All,

We seem to be being plagued by the error below by our SQL Server agent. This happens almost everytime we restart the server that has been running for a day or two.

Our SQL Server Agent uses a none expiring domain credential. I understand that this problem only happens when the profile being used by the SQL Servr Agent has changed (password change). What puzzles me is that the login is A ok and no changes has been made to it's password.

Wealways resolve this problem by changing the login used in the SQL Server Agent to local and after that, returning it back to it's original domain login. Unfortunately, we cant always do this everytime something goes wrong.

Can anyone please help us shed a light on this? We're using SQL2k with SP3a. Thanks!

Error:

An error 1069 - )The service did not start due to logon failure) occurred while performing this service operation on the SQLServerAgent service.


Regards,
Joseph

View Replies !   View Related
Can A User Be Granted Read Only Privileges For Stored Procedures
Can a user be granted the ability to create stored procedures with read only capabilities? I wouldn't mind be able to UPDATE but simply need to read only.

ddave

View Replies !   View Related
Message When Performing End User Sort
Hi,
I have added interactive sort to report. When i perform the sort in the preview of the report, i see a message 'Report is being generated'. But when i do the sorting from Report viewer control, the screen goes blank before the sorted data comes up.
Is there any way I can display a message telling sorting is in progress?
Any help in this regard is appreciated.

Thanks.

View Replies !   View Related
Operation Cancelled By User
Hello Guys,

I am currently experiencing a Sql error: operation cancelled by user.

I don't know where this error come from. Is it from ADO.NET or SQL Server 2000.

This error doesn't always occur. It only occurs when many users access the web site. I want to know who issue the error. Why issue the error.



Let me know if you have any ideas



Thanks in advanced



View Replies !   View Related
User Permissions Vs. Role Permissions
Which takes precedence?

User Tom has Exec permissions on MyStoredProc. He is also a member of the Public role which does not specifically state that he has Exec permission on MyStoredProc. However it also does not implicitly 'deny' that permission. Is there a "cumulative permission" effect here? Or is the Public role being 'more' restrictive and therefore not allowing Tom to Exec MyStoredProc?


From BOL.
"A user account can be a member of any number of roles within the same database. For example, a SQL Server user can be a member of the admin role and the users role for the same database, with each role granting different permissions. The effective permissions on an object granted to a member of more than one role are the cumulative permissions of the roles, although a denied permission in one role has precedence over the same permission granted in another role. For example, the admin role may grant access to a table, whereas the users role denies access to the same table. A member of both roles is denied access to the table because denied access is the most restrictive."


If I grant Exec permission on the MyStoredProc to the Public role, then Tom can execute the procedure.

I am all confused.

Help,
Troy

View Replies !   View Related
Deploy Fails Telling Me The User Don't Have Permissions, But The User Listed Isn't Me!
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 Replies !   View Related
User Permissions
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 Replies !   View Related
USER PERMISSIONS
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 Replies !   View Related
User Permissions
New to SQL server, but not DBs in General, much more used to MySQL.

Anyways, trying to do a select and getting user problems.
Is there some easy way to grant a user all privilages in MSSQL 2005? With MySQL this is easy, but not sure about MSSQL.

View Replies !   View Related
User Permissions
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 Replies !   View Related
User Permissions
Question from a beginner:

I am having difficulty connecting to a SQL database from C#. There are no user signons set up on my PC and I am using windows authentication with C#. Whenever I try to connect to the data base I get a message "You do not have permission to open this database.........".

Any assistance greatly appreciated.

Steve

View Replies !   View Related
How To Run SSE Under User Permissions?
Hello,
Our application works this way: attaches database, modifies data and dettaches database. This works fine when user has administrative permissions, but does not work for users with standard permissions. The reason is that SSE ovewrites MDF file permissions (after MDF is attached) and then it is accessible only for Administrators, Network Service and SQLServer2005MSSQLUserxxxxx. How to avoid this behaviour? We want to keep permissions of MDF file as they are, i.e. inherited from parent folder. This becomes serious problem because some users are migrating to Vista where standard permissions are default (but the problem exists also on XP). Has SSE been designed to work in such environment?

Thank you in advance
Roman

P.S. We work with SSE SP2, BUILTIN/Users have sysadmin priviliges, problem is with file permissions of MDF. This behaviour can be easily reproduced with Management Studio - just attach MDF file and look how permissions were changed.

View Replies !   View Related
User Permissions Help
I have created a vb app that connects with ansql database on server express 2005.

When i install the app on my machine, i can connect and edit records no problem, but when the app is installed on other machines on the network (using windows authentication) i get this error:
SELECT permission denied on object 'tbltest', database 'test', schema 'dbo'

************** Exception Text **************
System.Data.SqlClient.SqlException: SELECT permission denied on object 'tblTest', database 'Test', schema 'dbo'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Test.TestDataSetTableAdapters.tblTestTableAdapter.Fill(tblTestDataTable dataTable)
at Test.Form1.Form1_Load(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Test
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Default%20Company%20Name/Setup/Test.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------


I think it may have something to do with user permissions for the database on sql server, but no amount of editing permissions will allow access.
Help !!!!!!



View Replies !   View Related
How To View All User Permissions?
I've seriously looked, but this simple concept eludes me. How do I go about viewing all the permissions granted to a database user? Like whether or not they can execute a stored procedure.

View Replies !   View Related
Help ! Dangerous User With SA Permissions
Hi guys,I have been told that only users with SA priviledges could check thestatus of a job. For this reason, I had to give SA priviledges to thisuser so he could check the results of a job (succesful or not) and dohis work. Now, he makes changes on the database without telling me andlast time we nearly lost one day of work as he changed the db optionto truncate on checkpoint. I don't want to be the one to log on andverify the results of the job everyday so is there any way that I cangive him limited permissions so he could only check the job and leavethe database alone ? I am pregnant so I am afraid that next time hedoes something like that I may hit him on the head with the keyboard(hormones... :-)Any suggestions would help,Thanks !!!

View Replies !   View Related
Create User With Certain Permissions ???
I wonder how I could use a stored procedure or similar for setting up a user account on an MSDE server.

***********************************

The user should be able to access the database something like:

username: carl
password: carl1

the user should have Read and Write access to the three databases called house, fish and cars.

***********************************

The end-user must have have these permissions so he can use a certain software that has to access the 3 databases.

So faar I only know how to create an account like:
EXEC sp_grantdbaccess 'Carre', 'Georgie'

but that's not really useful as I don't know how to set the read and write permissions to certain databases.

Any help is really appreciated!

regards, Carl Hupt (db developer)

View Replies !   View Related
Info About User Permissions
Hi All,

Can someone tell me where the information about the permissions granted to a user are stored? For eg, user xyz in db1 has SELECT permissions on Col1, Col2, Col3 of Tab1 and UPDATE permissions on COL2 of the same table. Which system table(s) will hold this data?

I appreciate help in this regard.

Thanks !

View Replies !   View Related
TempDB And User Permissions
I have a user account that needs CREATE TABLE permission in tempdb. I know how to do this using the GUI
(Enterprise Manager).

The problem is that this reverts whenever the DB server is restarted. I need to figure out
how to keep it from reverting, or it needs to be set in some sort of startup script.

Any help would be greatly appreciated.

View Replies !   View Related
User Permissions Time Log
Hi Gurus,

Is there any to get time as when DBA's grated permissions on particular database...

Please advice..
This will be very helpfull to me..


Thanks,
ServerTeam

View Replies !   View Related
How To See User Permissions In 2005...
In SQL/2000 EM I can go to a user Database, expand the Users, double click a user and click Permissions to see everything a user has permisson to in the database. How can I get the same information in Management Studio in SQL/2005? Is there an overview of this process in BOL 2005?

Thanks in advance!!!

DeWayne

View Replies !   View Related
User Permissions To Database
hi,



I created an application using VB.NET, which performs accessto SQL database. the server is MS SQL 2000.

I got a few questions:

a. The application performs access to tables, performs SELECT transactions, and calls stored procedures. I want to define a userlogin that is only permitted to commit UPDATE and INSERT only by the stored procedures, and not by direct commands. Is that possible ? Do I have to deny access to READWRITE in the tables? If I do deny - will the user be permitted to call stored procedures that performs the INSERTUPDATE those tables ?

b. Do I have to create a LOGIN or a USER for the specified requirements ?

c. Where can I find REALLY detailed information about what I need to create (login, user, role ect.) ? I find only general stuff...

d. The user-defined role I need to create - is it considered as an application role (because it grants an application access to the database) or is it called SERVER ROLE ?

Thanks,

Dror.

View Replies !   View Related
Newbie - User Permissions
I have added a new user to a database without any explicit permissions, but when I view their effective permissions inside the Microsoft SQL Server Management Studio, they have awhole host of permissions. How can this be? Is it a bug in SQL Server? Or could it be that the public role has all these permissions?

If new users are inheriting these permissions from the public role, how do I view the public role permissions?

Thanks.

View Replies !   View Related
SQL Express User Permissions?
I'm trying to build a web application using SQL2005 Express and Visual Studio Express.  It all works OK on the local machine, but gives an error "Login failed for user xxxxASPNET" when used remotely.  I can't find where I can set login permissions for SQLServer 2005 Expresss - can anyone help, please?
Thanks
John

View Replies !   View Related
Dbo User / Permissions Error.


I had found one or two other questions about this, but neither of them seemed to be the same as my instance, and there solutions were not valid for me.



I purchased the Build a Program Now MS Visual C# 2005 Express Edition book with CD.

This was installed by the auto installer on the disk. which included the SQL Express 2005 version.



I have used the Visual Express C# interface, build a small program, created the database, created tables. all went well. I can even add data, and so forth.

My problem came when I went to click on database Diagrams in the Database Explorer.

I get a Dialog box stating

" This Database does not have a valid dbo user or you do not have permissions to impersonate the dbo user, so database diagramming is not available. Do you want to make yourself the dbo of this database in order to use the database diagramming?"

two options are Yes and No.

If I choose yes, I get the following dialog box stating,

" This databse does not have a valid dbo user or you do not have permissions to impresonate the dbo user, so database diagramming is not available. Ensure the dbo account is valid and ensure you have imprersonate permission on the dbo account."

One button, OK.



I have searched every where I can think of to try to figure out how to set / alter the dbo user info / permissions.

Can someone guide me on this?



Thanks in advance.



Tom

View Replies !   View Related
Permissions For Non Sa User To Execute Xp_cmdShell
Hi,    I want to execute BCP in Query Analyser in SQL Server 2005 Express for that i surf on net and find that i should execute BCP under xp_cmdShell, That works good for addministritative account on SQL. But i want the working will be done by a non administrative account or non 'sa' user.How can i assign a non sa User permissions to execute xp_cmdShell? or just tell me any other alternative way to run BCP in Query Analyser or code behined. thanx 

View Replies !   View Related
User/Login Permissions Problem
I use 1&1 to host my site, with SQL Server.
I've used their db management tool to create stored procs and tables.
I backed up the db stored at 1&1 and restored it on my home machine.
On my home machine, I can't access most of the db objects in the restored db via ASP.net, even if I login as sa. I get messages such as "Could not find stored procedure 'proc_name'".
1&1 provided me with a username and password to login into their SQL Server database, and all my objects now have that username as the owner.
The only way I can get the stored procs or tables to work is to prefix them all with the username from 1&1, e.g.:

exec <1&1username>.<proc_name>
Any advice would be most welcome.
Thanks,
B

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved