Friday, February 01, 2008 12:38 AM
A colleague of mine has developed a functioning console application that simply performs a little search using an SPQuery object.
I’ve created a web service to be called by BDC to do this.
My web service code fails here:
using (SPSite site = new SPSite("http://sharepointapp01/sandbox"))
When I attempt to execute the method from a web browser, I get this:
System.IO.FileNotFoundException: The Web application at http://sharepointapp01/sandbox could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.
at Microsoft.SharePoint.SPSite..ctor(SPFarm farm, Uri requestUri, Boolean contextSite, SPUserToken userToken)
at Microsoft.SharePoint.SPSite..ctor(String requestUrl)
at Conchango.xyzzyFacade.GetExistingDocument(String minId, String maxId, String titleFilter) in C:\Documents and Settings\Paul\My Documents\Visual Studio 2005\Projects\xyzzy\BDC_DocReview\BDC_DocReview\DocReviewFacade.asmx.cs:line 69
I can access http://sharepointapp01/sandbox fine from a web browser. SharePoint does challenge me for credentials when I log in using a web browser on the server, even though I’m obviously already successfully logged into the server itself. Same credentials work both times, I just have to enter it again. I don’t know if that’s the problem.
I’ve searched and found that a lot of people have this issue, but there are relatively few successful answers or their solutions don’t work for me.
Again, it works fine from a console application running on the server. However, my web service, also running on the server, generates the above error.
Any insights greatly appreciated.
Thursday, February 07, 2008 3:46 PM
Make sure the user account for the app pool has rights to SQL and is a member of the WSS_ADMIN_WPG group.
Lack of permissions in either will give this error from the SPSite() constructor.
- Proposed As Answer by Nate DFW Wednesday, April 24, 2013 4:52 PM
Thursday, February 07, 2008 4:05 PM
Thank you for the feedback.
I solved my problem earlier this week and blogged about it here: http://feeds.feedburner.com/~r/PaulGalvinsSharepointSpace/~3/230017467/cns!1CC1EDB3DAA9B8AA!687.entry
We did go and give the app pool identity permission to SQL and that solved it. Thanks for the concise statement, it's helpful.
Wednesday, October 15, 2008 5:30 AMI had some code running in IIS under a different website than SharePoint (port 8080). I had the same "FileNotFound" exception when my code called various SharePoint API's.In my case:Right click on my site->Properties->Home Directory, change the APPLICATION POOL to the SAME pool as SharePoint solved it.Probably not a best practice, but another possible way to tackle this.
Jeffrey Knight | MCTS .NET 2.0 | RHCT | http://www.rootsilver.com
Thursday, March 26, 2009 1:33 PMHi,
I face the same issue but none of the solution works.
My program only have 1 line of code :
I am always using the same user : dotech.
That user :
- Has rights to access the SQL Database directly
- Is an Administrator on the Sharepoint Server (server001)
- Is part of the WSS_ADMIN_WPG
- Is a Farm Administrator
- The Application Pool (for WSS Site and Central Admin) uses that user.
When I run my program directly on the Sharepoint server (server001) the application works fine and the SPSite is created successfully.
When I run it remotely from any other computer (logged with my dotech user) I get the FileNotFoundException. But I can access the WSS site (with Internet Explorer) from that computer without any problem.
Hope someome can help me!
Thursday, March 26, 2009 1:59 PMThe WSS object model does not work remotely. You'll need to use the Web Services if your code has to run off the farm.
Posting is provided "AS IS" with no warranties, and confers no rights.
Tuesday, October 20, 2009 5:37 PMFor the record and for what is worth, I had a similar problemo. In my case, the Web Service is meant to process some InfoPath forms. At any rate, I solved it by changing the WebService's Application Pool (in the IIS) to match that of the SharePoint site collection.Cheers.
Wednesday, October 13, 2010 7:03 PMI think the user which is run the program must bu a member of WSS_ADMIN_WPG group or WSS_WPG group
Monday, December 06, 2010 5:55 PM
This Issue is more of user permission issue give the following permission
User Permission SharePoint Site --- Minimum Read Permission
Sharepoint Server --- Add to WSS_ADMIN_WPG group
Database --- Sharepoint Content DB (Site collection database) - db_owner permission Sharepoint Config DB (Config DB of sharepoint installation) - - db_owner permission
Read more in my blog