.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Either the xxx user does not have permission to access the yyy object, or the object does not exist.

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

Following examples from Wiley's DM with MS SQL Server 2008 book. Have created a mining model I am not able to train. Up to do point where I use openquery to try to train it, everything goes smoothly. When openquery is run, I get the message: Either the xxx user does not have permission to access the yyy object, or the object does not exist. Obviously, the object exists and I as a db owner should be able to access it. Have double and tripplechecked logins/roles/permissions but have no clue what could be the showstopper.
I am stuck with this issue for some time and would highly appreciate any help to move forward. Have exhausted my ideas and have not been able to find applicable resolution to my problem by querying forums.
Thanks in advance.
Dj.K.




View Complete Post


More Related Resource Links

"'xxxxx\Administrator'user does not have permission to access the 'Local' object, or the object

  

Hi,

I am trying to run the DMX query

select [bikebuyer],
predicthistogram([bikebuyer])
from [TK448 Ch 009 Prediction]
natural prediction join
(select 'm' as [gender],
0 as [number of cars owned]) as t

for my  [TK448 Ch 009 Prediction] model but it's throwing me the error "'xxxxx\Administrator'user does not have permission to access the 'Local' object, or the object does not exist" though it has the Admin permission.

The full query what I am trying to achieve is.

--select * from [predictioncluster].cases
select top 1000
t.[lastname],
t.[firstname],
[bike buyer],
predictprobability([bike buyer],1) as dtpredictprobability,
t.gender,
t.numbercarsowned from [predictioncluster]
prediction join
openquery([Local],
'select [lastname],
[firstname],
[gender],
[numbercarsowned]
from [dbo].[prospectivebuyer]') as t
on[gender] = t.[gender] and [number cars owned]
= t.[numbercarsowned]
where [bike buyer] = 1
order by predictprobability([bike buyer],1)desc

but the same error. Also I am getting the error "The end of the input was reached". If any one could help me out with this issue.

Thanks,

CsKoch


Object Cache set with Portal Super User accounts. Access denied to site.

  
I have the same issue on multiple farms. In this example i'll outline this problem for a three tier farm. SharePoint web server SharePoint Application server (hosts central admin) Sql server After installation and configuration i have created two web applications (claims based auth with NTLM). https://portal.contoso.com https://mysite.contoso.com The client connects on the URLs to the web server (1st tier). All is working correctly and they can access the portal and their mysite. The log file keeps reporting that i need to configure the user accounts for the Object Chache. So, i looked up the required steps and executed these conform mcrosoft guidelines (http://technet.microsoft.com/en-us/library/ff758656.aspx) All the steps run seccesfully. But when i connect to the URL i now get an access denied (even with the administrator who is site collection administrator) In the log file i get the following to lines when i connect to the site. Unknown SPRequest error occurred. More information: 0x80070002 Unknown SPRequest error occurred. More information: 0x80070005 I have exact the same issue on two other farms. Marc

How to access label object in a user control

  

I thought I did something like the following inorder to find the labels in a user object but when I revisited it, it did not work.  Any ideas???

using

 

System;

using System.Collections.Generic;

using

 

System.Linq;

using

 

System.Text;

Can't add item using client object model of sharepoint 2010 with read only permission to user.

  

Hi

I have already developed Silverlight application in SharePoint 2010 using client object model.

But I have one scenario that user can comment on the item, so there is a update operation come in picture for user, but user have read only permission to site.

So please help me resolved this problem.

We can use Run with elevated privileges method in SP object model. I think Silverlight client object model don’t support this method.

Is there any alternative workaround to solve this problem?

Tha


how to get current user permission,all permissions in share point site using object model

  

Hi,

how we will get current user permission using object model to a site/subsite

how can show all permission under a subsite in share point.

Thanks

murali

 


Toolbox: User Interfaces, Podcasts, Object-Relational Mappings and More

  

This column covers common user interface groupings, configuring NHibernate using C#, and a look at interesting books and podcasts.

Scott Mitchell

MSDN Magazine October 2009


A Young Person's Guide to The Simple Object Access Protocol: SOAP Increases Interoperability Across

  

The Simple Object Access Protocol (SOAP) facilitates interoperability among a wide range of programs and platforms, making existing applications accessible to a broader range of users. SOAP combines the proven Web technology of HTTP with the flexibility and extensibility of XML. This article takes you on a comprehensive tour of Object RPC technology to help you understand the foundations of SOAP and the ways it overcomes many of the limitations of existing technologies, including DCOM and CORBA. This is followed by a detailed treatment of the SOAP encoding rules with a focus on how SOAP maps onto existing ORPC concepts.

Don Box

MSDN Magazine March 2000


How to access the refrenced table fields in Ilist object of table MVC asp.net

  

Hello,

I have 2 tables, master, detail. 1.master table have fields (id, username, plan)-->id is primary key (PK) 2. detail table have fields (srNo,id, worksummary, ... )--> srNo is PK.

I have created foreign key relationship from detail to .master table for "id" field.

the code is:

IList<detail> objDetail=new List<detail> (); 
IList<master> objMaster = new List<master> ();
string[] sarray = queryFields.Split('|');//

for (int i = 0; i < sarray.Length; i++)
{
string[] sfields = sarray[i].Split(',');

if (sfields[0] != "")
{

objDetail.Add(new _detail { Id = count , modify = sfields[1].ToString(), verified = sfields[2], I});


}
}

I have problem to add fields in "objDetail" using Add method. But I am unable to access the reference field "Id" , rest of the field of detail table can be accessed using objDetail.

How can I access the "Id" field from objDetail object to add in IList.

I want to solve this problem


Cannot access Label inside Repeater - "Object reference not set..."

  

I have a button on a page with a Repeater and an ObjectDataSource. To give credit where credit is due, the Repeater's paging functionality is courtesy of ScottGu. (However, I'm using ASP.NET 4.0 and SQL Server 2008, as opposed to ASP.NET 2.0 and SQL Server 2005.)

Anyway, in the button's click event, I need to access the Text property of a Label that's inside the Repeater because it's used as an input parameter in a stored procedure. I'm getting a NullReferenceException when trying to access the Label's Text property. I have researched this error and have tried a few different solutions (involving FindControl and the Repeater's ItemDataBound event), but I haven't been able to get it to work. Any suggestions, in VB or C#, would be greatly appreciated. The code is below.

somepage.aspx

<asp:Repeater ID="rptText" runat="server" DataSourceID="tbsDataSource">
<HeaderTemplate>
<table width="100%" cellspacing="1">
</HeaderTemplate>
<ItemTemplate>
<%-- some rows removed for brevity --%>
<tr>
<td><asp:Label

How to check effective permissions for a user or group for a SQL server object or whole server?

  
Guys, How do I see effective permissions for a user or group for a SQL server object or whole server? For example, a user is not listed in security/logins, but he is a member of few groups and some of them have assigned permissions on SQL server (again either directly or through membership in other groups) Even when I select an object (a table), check properties/permission – it doesn’t let me select any principal, except those listed on security/logins… Anyway, what is the right way to see effective permissions for a user or group? Sorry for asking such a simple question, I’ve searched but found nothing relevant.

Insert permission was denied on Object '', database '', schema ''

  
i have a senario where in i am trying to insert data into a Database , i end up getting the above error 'Insert permission was denied on Object '', database '', schema '''.We have a DB which has all Storeprocedures and 90% of the tables . the remaining 10% of the tables are in a different database.I am having trouble inserting data into the second database.The storeprocedure is executed as a user who has permission on the DB and tables.Also the storeprocedure is given permission to a role in which the user is a member . The same role doesnt exists in the 2nd Database.I am able to do all DB operations in one environment . i am unable to do the same in the others.

The SELECT permission was denied on the object 'sysjobs_view', database 'msdb', schema 'dbo'.

  
So, I have an SSIS package that uses a transfer jobs task between Server A and Server B.  When I run the package with my credentials, everything works fine.  However, when I run the package from an SSIS using a different user, I get the following error: Date 9/1/2010 8:00:00 AM Log Job History (xxx) Step ID 1 Server xxx Job Name xxx Step Name Run SSIS Duration 00:00:01 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:00 AM Error: 2010-09-01 08:00:01.39 Code: 0xC002F325 Source: Transfer Jobs Task Transfer Jobs Task Description: Execution failed with the following error: "An exception occurred while executing a Transact-SQL statement or batch.". End Error Error: 2010-09-01 08:00:01.39 Code: 0xC002F325 Source: Transfer Jobs Task Transfer Jobs Task Description: Execution failed with the following error: "The SELECT permission was denied on the object 'sysjobs_view', database 'msdb', schema 'dbo'.". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:00:00 AM Finished: 8:00:01 AM Elapsed: 0.75 seconds The strange thing is, the user running the job ahs sysadmin permissions

Null Reference Exception was not handled by user Object Reference not set to instance of an object

  
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Security.Principal;using System.Data;using System.Data.SqlClient;using System.Windows;using System.Collections; public partial class Default2 : System.Web.UI.Page{    protected void Page_Load(object sender, EventArgs e)    {     }    private bool tableCopied = false;    private DataTable originalDataTable;     protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)    {         if (e.Row.RowType == DataControlRowType.DataRow)        {            //string sValue = e.Row.Cells[3].Text;             if (!tableCopied)            {                originalDataTable = ((System.Data.DataRowView)e.Row.DataItem).Row.Table.Copy();                ViewState["originalDataTable"] = originalDataTable;      &nbs

Object Cache: The super user account utilized by the cache is not configured. This can increase the

  
Hi im having the following error in the windows event viewer Object Cache: The super user account utilized by the cache is not configured. This can increase the number of cache misses, which causes the page requests to consume unneccesary system resources.  To configure the account use the following command 'stsadm -o setproperty -propertyname portalsuperuseraccount -propertyvalue account -url webappurl'. The account should be any account that has Full Control access to the SharePoint databases but is not an application pool account.  Additional Data:  Current default super user account: SHAREPOINT\system after this the computer starts working slowly and slowly The account that the log shows is the aplication pool account of the first site collection I created   I followed the instrucctions in this link: http://technet.microsoft.com/en-us/library/ff758656.aspx I set new accounts to the superuser and super reader I also tried using the same account that the first error showed has superuser and super reader However  I always get this error when I try to access the Site Collection after performing this The user does not exist or is not unique.<nativehr>0x81020054</nativehr><nativestack></nativestack> In the sharepoint log I get this same error plus this Could not get token super user token, reverting to system account.&

Select Permission Denied on object

  
Hello all, I have just begun to develop a simple web application to maintain phone book / contact details of people. I have been facing problems wrt the connection to the database, while trying to execute the reader it throws this error - Server Error in '/phonebook' Application. SELECT permission denied on object 'PhoneBook', database 'Northwind', owner 'dbo'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: SELECT permission denied on object 'PhoneBook', database 'Northwind', owner 'dbo'. Error occurs at - reader = cmd.ExecuteReader(); The stacktrace looks like this -[SqlException: SELECT permission denied on object 'PhoneBook', database 'Northwind', owner 'dbo'.]   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742   System.Data.SqlClient.SqlCommand.ExecuteReader() +42   Phonebook.ResultPage.CreateDataSource() in c:\inetpub\wwwroot\phonebook\resultpage.aspx.cs:56   Phonebook.ResultPage.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\phonebook\resultpage.aspx.cs:39   System.Web.UI.Control.OnLoad(EventArgs e) +67   System.Web.UI.Control.LoadRecursive() +35    Syste

Cannot find the object % because it does not exist or you do not have permissions. However the SP is

  
hi, I have a procedure with a grant. When i call that procedure the sql server give me the error: Cannot find the object % because it does not exist or you do not have permissions. But the store procedure is executed and i have the right result. Any ideias why this is happening. P.S. - I have other SPs with the same grant that run without the error....

The EXECUTE permission was denied on the object 'proc_UpdateVirusInfo'

  
Hi All,   SharePoint 2007 x64 w/SP1, SQL 2005 x64, ForeFront for SharePoint w/SP1, running on Windows Server 2003 x64 R2 w/SP2.   We originall setup this server using only a couple service accounts. That was a bad idea so a few weeks ago I went over everything and setup or service accounts according to Microsofts recommendations. (http://technet.microsoft.com/en-us/library/cc263445.aspx)   I've gone over the requirements a dozen times and everything is set perfect.   I have two issues.   1. Randomly we have a SQL permission issue popping up, this abouts a couple times a day (some days none), the event log will fill about with anywhere from 15 to 800 of the same event.   Event Type: ErrorEvent Source: Windows SharePoint Services 3Event Category: Database Event ID: 5214Date:  3/11/2008Time:  1:28:30 PMUser:  N/AComputer: TRUMANDescription:Insufficient SQL database permissions for user 'PortalPool' in database 'SharePoint_AdminContent_45f0f48e-c1b1-463c-99e3-ea6648beaf37' on SQL Server instance 'Truman'. Additional error information from SQL Server is included below. The EXECUTE permission was denied on the object 'proc_UpdateVirusInfo', database 'SharePoint_AdminContent_45f0f48e-c1b1-463c-99e3-ea6648beaf37', schema 'dbo'. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.   PortolPool is our service account for the IIS Poo
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend