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

Post New Web Links

Switching web servers

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

So I have a Content DB on the DB server which will not be moving.  All I want to do is take the portal off of one front-end web server and put it on a new front-end web server (the existing web server is having a lot of issues and needs to be rebuilt).  What is the best way to accomplish this when there is no access to Central Admin on the existing server (due to numerous server issues, Central Admin no longer works and the Configuration Wizard cannot be run).


View Complete Post

More Related Resource Links

Data Points: Updating Data in Linked Servers, Information Schema Views, and More


Every day a developer somewhere needs to write code to iterate through SQL ServerT system objects, query and update tables in linked servers, handle optimistic concurrency, and retrieve column and stored procedure metadata.

John Papa

MSDN Magazine November 2004

Taming the Stateless Beast: Managing Session State Across Servers on a Web Farm


Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here. The article begins with a description of the SQL Server database used to store state information, the stored procedures used to update it, and the retrieval of session data. ASP code drives the session manager tool and the COM and COM+ components that run the stored procedures.

John Papa

MSDN Magazine October 2000

Windows 2000: Asynchronous Method Calls Eliminate the Wait for COM Clients and Servers


Windows 2000 is the first version of COM to support asynchronous method calls, which permit clients to make nonblocking calls to COM objects and objects to process incoming calls without blocking the calling threads. COM clients benefit from asynchronous method calls because they can continue working while waiting for outbound calls to return. Objects benefit because they can queue incoming calls and service them from a thread pool. Our SieveClient and SieveServer sample apps demonstrate how to create and use asynchronous clients and servers in COM-based distributed applications.

Jeff Prosise

MSDN Magazine April 2000

"This server is not supported. Only servers up to Microsoft SQL Server 2005 are supported"



I am getting the following error when i want to add a remote connection in the Server explorer:

'This server is not supported. Only servers up to Microsoft SQL Server 2005 are supported'

what can be the problem. On Microsoft site i saw, you need to install following update: 'Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support'

But i have a Microsft SQL Express Server 2005 SP3...

SQL 2008 servers and MOSS 2007 with SSRS


I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS.  Here is the run down:

  • I currently have MOSS 2007 server with backend on SQL 2005, which also acts as the SSRS server.  In addition I have another SQL 2005 server where business data resides and against which most of the SSRS reports run.
  • Future plan (over which I don't really have a say) is MOSS 2007 with backend on SQL 2008, which will remain to be the SSRS server.  The second SQL server with business data will be migrated to SQL 2008 R2.

Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)?  Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?

VS2010: Switching tabs in wpf designer

Hi, I have a problem with the WPF designer in VS 2010. I have a WPF UserControl which contains a TabControl with several Tabs (TabItems).  It was always possible to switch the tabs in the designer to see the content of the individual tabs. However, suddenly this stops working. I can not switch the tabs anymore. [EDIT] Seems to be a known issues? https://connect.microsoft.com/VisualStudio/feedback/details/531868/wpf-editor-tabcontrol-issues Workaround does not work for me (or I do not understand it correctly)... [/EDIT] Any ideas? Thanks in advance. Jus  

how to move SSAS applications between windows servers

Hi All, We have separate windows servers hosting production and development environments.  Each environment consists of MS SQL Server and SSAS, studios, etc.  What would be the best way to move MS SQL Server databases and SSAS objects from one server to another?  I have been looking for some import/export applications but have not been able to find anything. Thanks for any help, Thanks, Roscoe

Enumerate SQL servers

Anyone have any information about enumerating SQL servers on a network without DMO or .NET?

Enumerate SQL servers

Anyone know a WinAPI(not .Net) call to enumerate SQL servers in C++ if the system does not have any SQL libraries installed?

Current thought by MS on virtualizing SQL Servers

I am looking for documentation from MS on it's current thought on virtualizing SQL servers (Hyper-V or ESX).  Years ago I know it wasnt supported for production by MS but I belive things have changed and want to provide some data to our dev dept on the practice of virtualizing a SQL server.    Lossless Audio Addict

How to upload a file to two different servers?

Here is Code behind:Protected Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpload.Click         Dim fileExt As String         fileExt = System.IO.Path.GetExtension(FileUpload1.FileName)           If (fileExt <> ".exe") Then               Try                 Dim hfc As HttpFileCollection = Request.Files                 Label1.Text = String.Empty                 'lblNames.Text = String.Empty                 For i As Integer = 0 To hfc.Count - 1                     Dim hpf As HttpPostedFile = hfc(i)                     If hpf.ContentLength > 0 Then                         hpf.SaveAs(Server.MapPath("/Storage/Uploaded") & "\" & System.IO.Path.GetFileName(hpf.FileName))                         Label1.Text += "<b>File: </b>" & hpf.FileName & "     " & "    U

Interconnectivity Between SQL Servers 1033 and 1027

Writer Daniel S. Abrahamian discusses interconnectivity between SQL servers 1033 and 1027 when (cid=1033). There appears to be significant overlap between the two SQL servers, with many users lamenting over a noticeable drag period when utilizing the 1033 server. Users accessing their emails on the 1027 server while utilizing the 1033 server share a distinct level of interconnectivity, although there is not necessarily a signicant distinction between the two. Service switching has become an unavoidable adjustment and must therefore be handled as such. I have heard many users of Yahoo email services lament that the shift from MG4 to MG5 included a noticeable drag period and decreased speed when accessing email services.

Collecting data from multiple servers

I have a list of about 500 servers that I am trying to connect to and collect various amounts of information from these servers through one query. I'd like to have something that doesn't involve OS batch scripting or using SQLCMD as the SQL Instances range from SQL 2000 through SQL 2008 R2. Does anyone have any suggestions or ideas on what to do to accomplish this?Big Ern

Accessing two SQL servers simultaniously in C#

Hi all, we want to connect two different SQL servers in our application (in C#). With Linked server, unless we manually run some query (like SELECT * ....) in T-SQL query browser the linked server will not get initiated and can't be used in application. And with OPENDATASOURCE method, it works fine only if we use system IP address (TCP/IP). With system name (Named pipe if am not wrong) this method some time fails as follows: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [5]. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Login timeout expired". ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider "SQLNCLI" for linked server "(null)" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". what may be wrong here? Any suggestions/guidence please. RVandakar

Switching texbox when pressing Enter key

Dear all, I have a ssimple mask which is based on 4 text box to be fills. What is teh simple way that when my user is pressing the ENTER key after editing first text box, cursor moves to the next text box in edit bomde ? thnaks regards SergeYour knowledge is enhanced by that of others.

Different SQL Servers

Please provide me with a single script which will help me in restoring the FTS DB in all the versions of SQL Server. And please don't tell me to write different codes for different sql servers coz I need to implement it in a single Tool or executable made in VB6!! 
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