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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

SPWebApplication, This operation can be performed only on a computer that is joined to a server farm

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :SharePoint
 

Hi,

We are trying to migrate a console program (C#) from Moss 2007 to SP 2010.

One of the functions in the program has to loop thru several web apps/site colls/sites/lists to trim permissions and uses this sentence to get a reference to the web app:

- SPWebApplication webApplication = SPWebApplication.Lookup(serverUri);

In MOSS 2007 it works but in SP 2010 we see this error message:

"This operation can be performed only on a computer that is joined to a server farm by users who have permissions in SQL Server to read from the


View Complete Post


More Related Resource Links

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is no

  

Hi,

 I keep getting the following error. I also added time out parameter in the connection stirng and it still did not help. Has any one faced similar issues.

Thanks in adavance.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

 

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: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
   System.Data.SqlCl

Sharepoint farm lost a server... How to proceed?

  

Had a Sharepoint farm I inherited that was running on ____ hardware in a ____ setup- raid controller failed, and the rack was setup so that I have to down 15 servers that might not come back up, just to get at the server... Complete, unrecoverable failure. This server was a member of our Sharepoint 2007 farm, and had Reporting Services on it. There are a lot of little pieces that are still referenced in the Central Configuration. I removed the server forcibly, and need to know next steps, specifically:

1. I tried to move Reporting Services to another server, but I get an error in the Grant Database privileges that I cannot connect to the Report Server's WMI Provider. I created a SPN on a DC, forced a replication a few hours ago, and still no luck. Any Advice?

2. How do I fix all the little things that reference that server? Anytime Sharepoint initiates a web page to Central Administration, it tries to use that server address.

I think the failed server was running SQL 2008 or SQL 2008 R2, and the server I am moving this to is SQL 2005 SP2. I have installed the correct Reporting Services for Sharepoint. Have I missed something?

Time is of the essence because management relies on Reporting Services and I am under a great deal of pressure to fix this. I appreciate any help I can get.

 

Thanks!


Video: Coding a Long-Running Operation Page in SharePoint Server 2007 or Windows SharePoint Services

  
Watch this visual how-to video as you learn to write code to mimic the default long-running operations page (the "spinning wheel") in SharePoint Server 2007 or Windows SharePoint Services 3.0. (Length: 7:56)

Coding a Long-Running Operation Page in SharePoint Server 2007 or Windows SharePoint Services 3.0 (V

  
Watch the video and explore code as you learn how to write code to mimic the default long-running operations page (the "spinning wheel") in SharePoint Server 2007 or Windows SharePoint Services 3.0.

SQL Server Express 2008 Setup fails. Support Rule "Restart Computer" Failed

  
Hi, I have been trying to install SQL Server Express for most of the day now without any luck.  Whatever I do setup fails at the stage of Setup Support Rules, Rule "Restart Computer" - Failed.  Needles to say I have restarted (several times!) and I have tried downloading  and installing the "Advanced", "Tools" and "Basic" versions, all give the same error.  Trying a repair does the same.  I have been searching the net for an answer without success, any help would be MUCH appreciated. Further info: I am trying to install a stand-alone installation on to a single PC running under XP SP 3 with .NET 3.5 SP1 installed.  The PC did have some earler versions of SQL server installed but I (?hopefully?) removed all of these through Control Panel.  Before trying the first SQL install I installed Windows installer 4.5 and PowerShell 1.0 as per the Microsoft Instructions. Running SQL Server Configuration Manager results in an error (MMC could not create the snap-in. The snap in might not have been installed correctly).  A directory structure for SQL server exists in "Program Files".  Services MSC shows SQL Server (SQLEXPRESS) as Automatic Statup (not running).  Trying to start this manually gives error 14001: "application configuration incorrect - re-install to fix" .......... Which is precisely what I'm trying to do.........:(

Detect other versions of SQL Server, or SQL server instances on a computer

  
Hi All, I want to detect other versions of SQL Server, or SQL server instances on a computer. I used the recommended Microsoft C# example by using the SQL Server Windows® Management Instrumentation (WMI) provider. http://msdn.microsoft.com/he-il/library/dd981032(en-us,SQL.100).aspx SQL server 2005 has been correctly identified on my PC with Windows 7 64 bit OS. Then I uninstalled the SQLserver and all its tools/components. But even after uninstall the utility detects the SQL server 2005 as if it was not removed. What is an alternative for the correct detection of the SQL server installed on PC? Thanks in advance Dmitry

The URL 'ao/AO Document/Admin Guideline/xxxxx.jpg' error on 2nd SharePoint server in farm

  
We just added a 2nd SP2007 server to mirror our site.  The original site is in China, the new site in the US.  They are connected via a permanent  site to site VPN.  We are hitting the errors when attempting to upload files to the US mirror.    Environment: US server site: OS: Windows Server 2008 R2 Enterprise (64 bit) APP: Windows Sharepoint Server 2007 Enterprise SP2 (64 bit) DB: Windows SQL Server 2008 Enterprise R2 (64 bit) China site: OS: Windows Server 2003 Enterprise SP2 (32 bit) APP: Windows Sharepoint Server 2007 Enterprise SP2 (32 bit) DB: Windows SQL Server 2008 Enterprise R2 (32 bit) Background: We setup two test Sharepoint farm to be syncronized with only its content database. The upload works good on SZ site. But we got the following 2 error messages randomly when uploading file to document library of SF side. Error message: 1. The URL 'ao/AO Document/Admin Guideline/xxxxx.jpg' is invalid.  It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web. 2. Cannot open file "ao/AO Document/Admin Guideline/xxxxx.jpg". -- We've tried the official hotfix, altering the schema, changing the IIS memory limit settings, and restarting the application pool. Could the issue be related to the different OSes 2008 vs 2003, or 32 vs 64bit?  

Failed to change Farm Account in Sharepoint 2010 server, now Central Administration is not accessibl

  
Hello, I have a problem, that I no longer can access Central Administration Website, only the Sharepoint itself. I was running installation of Sharepoint 2010 Server with administrative account ImTheAdmin, who is a Domain Admin in the domain on one of the Windows 2008 R2 member servers. Besides that, I made ImTheAdmin the primary administrator of the Sharepoint. ImTheAdmin became the only user of this Sharepoint 2010 server after installation.  I installed everything on one box with default installation settings. I used builtin SQL server, not Standard or Enterprise. What then happened is: Using ImTheAdmin account, I opened Central Administration Website, and it said, that I need to change the Farm Account, for the account for Farm was the default one (I think it was network service). So I created a regular domain user MYDOMAIN\SharepointFarmAccount. The account name was too long to be as a Windows 2000 name, so it showed there without last 't', e.g. MYDOMAIN\SharepointFarmAccoun. I thought, Windows 2000 is long gone, so I didn't pay much attention, I think everywhere the account SID is important. I don't know if that is the real problem with my failure later, but it might be one of the reasons. I put MYDOMAIN\SharepointFarmAccount down in to the form of Central Administration Website, added the check mark, that it would react to password changes, and pre

Connect SQL Server 2005 to Ms Access on another computer

  
I'm trying to create a "Linked Server" on my SQL Server 2005.  This linked server is a reference to an Access File on a remote computer.  I've set up all the permissions and shared resources.  I've created an ODBC DSN to connect to the database.  If i open the DSN in excel, i can retrieve data.  If I open a linked server connected to the DB I get the following error when i try to run a query against it.   ------------------ OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'.  It is already opened exclusively by another user, or you need permission to view its data.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LS_Specialty". ---------------------   Why does this DSN work in Excel and Access, but not in SQL

Cannot Add Second FE Server to SharePoint 2010 Farm

  
Hi folks Well I thought I would add my problem to the others that are also experiencing this issue. I actually reported somthing similar to this forum in Feb 2010 when I was trying the beta version out. I upgraded our WSS farm to SPFS 2010, the upgrade worked, well kinda. Basically our second WFE server would not join the farm after installing the 2010 binaries and runnng the configuration tool and it was complaining with the following error: 07/31/2010 14:35:59  11  INF                              Calling SPFarm.Local and SPServer.Local to get the local farm objects 07/31/2010 14:35:59  11  INF                              SPFarm.Local returned null.  This usually means that the server is not joined.  But, you can delete a server from the configdb without unjoining, which would mean that this machine still thinks it is joined. 07/31/2010 14:35:59  11  INF                              Trying to access th

Linked Server to DB2 from SQL 2005 IA64BIT computer

  
Has anyone created a linked server to DB2 on AS/400 from SQL Server 2005 IA64 BIT? We were hoping to use the new Microsoft OLEDB Provider for DB2...The problem is the driver looks like it will only work on x64 computers."The single setup program will install the provider and tools on both x86 and x64 computers" We were able to install the driver on the IA64 computer and were able to successfully create a data source from the Data Access Tool. Oddly enough when we attempted to create a linked server in SSMS we received an error, we also noticed that the DB2OLEDB provider is not listed in SSMS. This is becoming a real problem so any ideas on how we can get this driver to work or suggestions on an alternative would be greatly appreciated.   thx.art.  

Same server farm administrator domain account for both Intranet and Internet Sharepoint site?

  
Hello,   We are planning to setup 2 streams of architecture for both Intranet and Internet web sites. Just wondering whether there is any best practices/security concerns if we are using the same domain account as the Server Farm Administrator for both Intranet and Internet platform?   Thanks,

An Excel Services Application setting does not allow the requested operation to be performed.

  
I'm facing a problem with Excel services and JSOM. On the page load, I'm registering a JSOM with a Visio webaccess webpart. On the shape selection changed event I'm trying to show a range of cells accordingly in the Excel web access webpart. Initially when the page is loaded and a shape selection event is fired, range.setValuesAsync(values); throws An Excel Services Application setting does not allow the requested operation to be performed. After pressing f5 on the page, it works fine. I came across a similar post in this link - http://social.technet.microsoft.com/forums/en-us/sharepoint2010programming/thread/B4739DB6-DDC1-42FB-BA6A-FFC41CBEFF1E but it was for Sharepoint 2010 beta 2 version. I'm having 14.0.4763.1000 - RTM build version. I have logged in as farm administrator. Log details Session=36.aceef71f-eb5b-4aab-9ce9-9db4728b45e5163.1.V22.91tY3PgMaeCbJtomFAb9Ab90.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.918121dd-d18e-4afe-b148-4cba08a0899b1.N b07378be-7293-4770-89cc-f136e1a8d7df WebServiceHelperMethods.ExecuteWebServiceRequestHandler: started processing 'SetRange' web method call b07378be-7293-4770-89cc-f136e1a8d7df WebServiceHelperMethods.ValidateContext: Operation requiring permissions 'SessionIdPresent, AllowEdits' not allowed according to the current permi

Accessing the command prompt of the server computer in c#

  
Hi ,I'm developing a web application in asp.net using  C# and need to access the command prompt of the server computer.After accessing it I need to run a "ABC.bat" file in the server computer which is in folder "E:\Test".The absolute path of the server is "\\MyServer"Any help to achieve this ( or any other alternative suggestions) would be greatly appreciated....ThanksPS: I need to run the ABC.bat file on the server machine as the bat file runs couple of more applications which are licensed to that server machine.

SSAS: An operation on a socket could not be performed...

  
Here is the scenario:  SSRS report in DEV, issues query that spins up Memory big time on SSAS.  MsmDSrv showing 1+ GBs Memory usage in Task Manager. After the connection is terminated, SSAS Service gets cycled.  At that point, can connect via SSMS from another server to this SSAS server. However when connecting from local SSMS, receive this error:  A connection cannot be made.  Eusure that the servier is running (admodClient).  An operation on a socket could not be performed because the system lacked sufficient buffer space or becasue a queue was full 127.0.0.1:2383 I really tried to find root cause - network trace, tcpview, vmmap, cycle SSAS, cycle SQL (shouldn't be related, but hey..) - but to no avail.  I'd love to be able to fix this without bouncing the server. SQL version 10.0.2531 SP1 x64, Windows 2008 R2 Enterprise.  Ideas?  Booting server now, but would looooove to have a non-boot solution to this

Farm, SPWebApplication.Lookup, System.InvalidOperationException

  
Dear all,   I have a piece of code that works well on a standalone SharePoint installation:   public void SetPeoplePickerProperty(string webAppUrl) { // elevate permissions to allow setting of property. SPSecurity.RunWithElevatedPrivileges(delegate() { System.Uri srvrUri = new System.Uri(webAppUrl); SPWebApplication webApp = SPWebApplication.Lookup(srvrUri); if (!webApp.PeoplePickerSettings.OnlySearchWithinSiteCollection) { webApp.PeoplePickerSettings.OnlySearchWithinSiteCollection = true; webApp.Update(); } }); }   When I deploy it to a server farm, I get the following error: System.InvalidOperationException: This operation can be performed only on a computer that is joined to a server farm by users who have permissions in SQL Server to read from the configuration database. To connect this server to the server farm, use the SharePoint Products and Technologies Configuration Wizard, located on the Start menu in Administrative Tools.   at Microsoft.SharePoint.Administration.SPWebApplication.Lookup(Uri requestUri) The user running the query is farm administrator. It has the necessary access to the configuration database. The server running the code is joined to the farm.   Ideas anyone?   Thanks,   Tore.

Getting Sql Server Management Studio 2008 installed on local computer

  
Hello, I have been trying to figure out this problem for a while now so hopefully someone can help me out - I would really appreciate it! Right now I have SQl Server Management Studio2005 installed on my computer for a SQL sever that we have. We recently got a 2008 sql server and if I remotely access the server, I can see that SQL Management Studio 2008 has been isntalled on the new server. I need to build new databases but need SQL Management Studio 2008 on my computer and I have no idea how to get it. I have a "Microsoft SQl Server 2008 R2" folder on my computer, and I have already tried clicking on "Configuration Tools" and then "SQL Server Installation center" and it isntalls a bunch of things, but none of them are "SQL Server Management Studio 2008."  I also found a link on a Microsoft website that says it's SQL Server Management studio 2008 R2 but it was just the same bunch of programs I already downloaded. How do I install Sql Server Managment Studio 2008 on my computer?! Thanks in advance for any help you can provide.
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