View Complete Post
I have published an Access 2010 database to Sharepoint 2010. It is pretty basic and essentially it is just used for teachers to enter lesson plans. When viewing the site there is a form that has several dropdown menus. The user should be
able to choose their name, date, etc. from these dropdown menus. The problem is that when I click on a dropdown menu the menu just shows a message that says "This service isn't available right now". I also get a message that pops up which
says "You do not have permission to view the records. To obtain permission contact your site administrator."
The weird thing is that when I was testing this at one point I clicked the dropdown menu and it did work. I clicked off the dropdown menu and went right back to it again and it didn't work.
I have anonymous access enabled for this site. However, I have tried it with an anonymous user as well as with the user account that installed Sharepoint and published the database to Sharepoint and it doesn't work either way.
Is this a permission issue on the site or something else? Any help is greatly appreciated.
I have another tough SharePoint mystery I am trying to solve. Essentially, users with Member permission levels are experiencing issues accessing a sub-site of a Site Collection
intermittently. Users will Full Control, Site or Farm Collection Administrator access do not experience this issue. When the Site Owner with Full Control permission levels opens the site in the morning then the users with Member permission levels are able
to access and navigate the sub-site without issue. Does anyone have any thoughts on what this type of problem may be related to?
I move all the tables to SharePoint site using "Move To SharePoint" button. When it finished, access create additional link table called "User Information List" However, I need a site owner permission list in my access table link(Not User Information
List-it has too many list).
Can anyone help me, please?
I'm trying to determine the minimal amount of access I can give my developers to be able to run create stored procedure scripts with an inclusion of the grant execute to the application user group.
We have been developing some interesting work arounds, but I think there must be an easier way to grant the access.
Grant Create Stored Procedure to user1 on a specific database
Grant Permission to Grant Execute permission for Stored Procedures on a specific Database to user1 for any user.
1 SharePoint server WFE
1SQL 2000 SVR Back End
This SPP server was an in-place upgrade from MOSS 2003.
1 Shared Service Provider
2 Web Applications
About 40 sites
About 30 MySites
Even logs on the SharePoint server include:
Event ID: 1309
I have used the the CspParameters obeject and set the container name. Im then putting it into an RSACryptoServiceProvider object and then calling:
isVerified = signedXml.CheckSignature(rsaKey);
The full code is
public static Boolean VerifyLicenceFile(string xmlLicFilePathArg)
bool isVerified = false;
CspParameters cspParams = new CspParameters();
cspParams.KeyContainerName = containerName;
RSACryptoServiceProvider rsaKey = new RSACryptoServiceProvider(cspParams);
// Create a new XML document.
XmlDocument xmlDoc = new XmlDocument();
// Load an XML file into the XmlDocument object.
xmlDoc.PreserveWhitespace = true;
// Check arguments.
if (xmlDoc == null)
throw new ArgumentException("Doc");
if (rsaKey == null)
throw new ArgumentException("Key");
// Create a new SignedXml object and pass it
// the XML document class.
SignedXml signedXml = new SignedXml(xmlDoc);
// Find the "Signature" node and create a new
// XmlNodeList object.
XmlNodeList nodeList = xmlDoc.GetElementsByTagName("Signature");
// Throw an exception if no signature was
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.
I am trying to run the DMX query
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
predictprobability([bike buyer],1) as dtpredictprobability,
t.numbercarsowned from [predictioncluster]
from [dbo].[prospectivebuyer]') as t
on[gender] = t.[gender] and [number cars owned]
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.