View Complete Post
I have installed a new instance of Sharepoint 2007 and am in the process of configuring all the farm services. At the moment the farm consists of a sharepoint box and a separate sql server. Here is the catch. There are already some non-sharepoint
databases on the sharepoint server. The account under which Central Administration runs has dbcreator and securityadmin privileges in the database. The Sharepoint_Config and SharePoint_AdminContent databases were created without any issues.
When I try to start the Windows Services Search, I get an "Unknown Error." Looking in the event viewer gives the following error "The server principal "MyServerPrincipal" is not able to access the database "MyDatabase" under the current security context."
This is true, MyServerPrincipal does not have privileges to access MyDatabase, but why should it. MyDatabase has nothing to do with sharepoint.
In an attempt to get past this issue, I gave MyServerPrincipal public access to MyDatabase, but that resulted in an additional error saying that it lacked INSERT privileges. This is really worriesome. Does anyone know why Sharepoint Search configuration
would try to access the non-Sharepoint database?
Thanks a lot.
"An error occured while initializing the access database."
I was trying to publish a access 2010 web database to SharePoint 2010 Enterprise.
I have a view in Microsoft Access 2010 that I would like to display in a SharePoint 2010 Standard web page. It does not need to be updated in realtime - only when the page is refreshed.
The data is updated from within Access - SharePoint would only be used to display a single view.
I would appreciate if someone can recommend a practical solution.
Hi to all,
I've an environment that includes 3 machines: the sp2010 frontend (W2K8 R2), the sp2010 backend (SQL2008 R2), the analysis services backend (SQL2008 R2).
I've successfully setup my environment with Kerberos constrained delegation and the entire thing works fine with both performancepoint and excel services (the requirement was to pass the user's domain identity to the analysis backend): thanks to the
excellent SP2010 Kerberos Guide.
Now I've extended this portal to the Extranet zone, assigned it a new host header and upgraded my SPNs to include the new fqdn and also added it to the necessary accounts in Active Directory.
In the intranet environment everything is fine. I've published the Sharepoint site to the external network onto the ISA 2006 and setup the Kerberos constrained delegation from the isa computer account to the Sharepoint SPN.
So here is the point: I can correctly access the Sharepoint site from external with Kerberos authentication, performancepoint is fine but I cannot open excel workbooks from this zone, I already trusted both the file and the data connection locations with
the external fqdn but still no luck. Even the sample workbook does not open. The error is "error while trying to execute the requested action. Retry".
Anyone has any hint on the possible causes?
I followed all the steps in the help article to create a new form from an existing Microsoft Access database. I publish this form using the "publish to network folder option" but i use a local folder on my computer
The form opens and i can add data, but when i submit it, i get this error mesage: Accessing data across domains is not supported for forms opened from the Internet
The database is located in the same folder as the published form so i am not sure what i am doing wrong here.Any help would be appreciated
I hope this is posted in the correct section of the forum, if not please accept my apologies and point me in the direction of the right forum.
I am using Visual Studio (VS) 2010 and an Access DB, I am trying to get specific data from the DB into a gridview on a web page in VS.
Visual Studio can see the DB and it is on view in the Server Explorer and I have tested connection when setting up the two together.
In my DB I have three tables, Bookings