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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Renaming Windows 2008R2 with SQL2008 and re-IP

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server

Hi all,

I hope I can get an answer here.

I currently have a Win2003 with sql server in production that I need to move everything from there to a new server Win2008R2 with SQL2008 at 64bit.  I named the new server differently with also a different ip address so it would not conflict with the old one after I finish moving everything. So now that I have everything done I have to rename and re ip address the new server to the old server name. So is it safe to do that or do I have to re-do everything from scratch again?

Any help would be greatly appreciated.




View Complete Post

More Related Resource Links

Cannot Connect to SQL server with SQL 2008R2 enterprise On windows server 2008R2

I have 2 identical brand new servers Running Windows Server 2008 R2 not on a domain but simple LAN. I Installed a default instance of SQL server 2008 R2 enterprise on each one with all the default settings. No Problems during the Installaion. I Added the Windows Administrators Group and Users group to the SQL admins role during the SQL Server Installation. Remote connections are enabled on each server. I restored the same database from a copy on each Installation. Configured the user accounts on each maching and made them sysadmins and granted permissions where they were needed. Now from server A when i try to establish a connection to Server B from SQl server Management Studio I get An error stating that the server was not found or accesible. keep in mind i can \\server B\c$ and vice versa, named pipes are enabled. I have never had this problem before in my life. And it's happening on both servers. I really need each installation of SQL to be able to see the other remote installation as i have to create a mirror. -Chris

on windows 2008 Ent SP2 (non R2), install SQL2008 sp1, will be .net framework 4.0 works?

I used the windows update downloaded and install all suggested updates, the .net framework 4 installed too, since sql 2008 sp1 requires .net framework3.5sp1, but .net4 is newer, I assume it is ok? can someone confirm thanks.

Cannot connect to a configuration database after renaming Windows 7 computer


I have just recently installed a standalone instance of SharePoint 2010 on Windows 7 64-bit.  Everything was working fine, however, as part of joining my computer to the domain, my computer was renamed.  Now that the computer has been renamed, I am no longer able to connect to my locally installed SharePoint instance.  I receive an error message stating "Cannot connect to the configuration database."

I found this article on renaming a server for SharePoint Foundation: http://technet.microsoft.com/en-us/library/cc288510.aspx.  However, it seems like the article is assuming that the rename operation occurred while SharePoint was still running.  However, I am running SharePoint Portal Server 2010 and now that I cannot connect to the configuration database, I cannot make any alterations to the SharePoint instance at all.

In addition, my instance of SQL Server as well as the standalone SharePoint instance was installed prior to the computer rename.  What are the steps that are required to address this situation?


Sql 2005sp3 in Windows 2008R2.


I have install Sql 2005sp3 on windows srvr 2008R2 standard, and I did the setup for on surface Area configuration, for TCP/IP, name pipes.

But in and my windows Windows 7 32 bits, when i do browse for the server using sql server I don't see it.

also I have other server winodws 2008 and Sql server 2005, but is working fine.

I have a winodws 200 for DC.

Any help is welcome. thank you.


Ajax.net does not work in windows 2008R2 or windows 7 64bit


Hi ,

I got this error for ajax website

ASP.NET Ajax client-side framework failed to load

. it works well in windows 2003 , 2008 and vista , but in windows 2008r2 and windows 7 , I get this error and ajax does not work.

SQL Server 2008 R2 on Windows 2008R2 Ent - Drives+Raid Configuration + W2008 Disk Initialization


Hi, I just want to make sure that we setup this server the best way possible as we are moving from a previous box where

performance was affected mainly because of partitioning and SQL memory optimizations.


The Hardware:

Dell PowerEdge R710 

  • Intel® Xeon® X5660, 2.8Ghz, 12M Cache,Turbo, HT, 1333MHz
  • 64GB Memory (8x8GB), 1333MHz Dual Ranked RDIMMs
  • PERC H700 Controller
  • 8 x 300GB 10K RPM Serial-Attach SCSI 6Gbps 2.5in Hotplug Hard Drive
  • Virtual Volume 1: 2 Drives = Raid 1 - for the OS
  • Virtual Volume 2: 2 Drives = Raid 1 - for the ldf's
  • Virtual Volume 3: 4 Drives = Raid 10 - for the mdf's

Windows 2008R2 64bits is installed on Volume 1.

- I would like to know what suggestions you might have for the Initialization of the other 2 volumes (MBR or GPT).

- Any other settings like partition align = 64

- Memory Settings at the OS level.

- Memory Settings on SQL.

- Any other recommendations.

Renaming a Page in Windows SharePoint Services 3.0



I created a page in Windows SharePoint Services 3.0.  I want to change the title that displays at the top of the page.  I chose "Edit Toolbar Properties", but it does not let me change the title.  I went into the page's properties and renamed the "file" that contains the page.  But, that did not change the actual title that displays on the page.

Any ideas?


Windows authentication SQL 2005 on Windows 2008R2 problem and SP streaming


Hello all,

At our customers site we are building a POC (Prove Of Concept) setup and ran into problems. First of all we install SQL 2005 Standard without ServicePack. After this we apply Service pack 3 for SQL. Now we have the problem that the domain admins are not able to connect to the instance in any way. Error is 18456 with state 11. After searching the web I found out that due to UAC, local admins are no longer sysadmins on SQL by default. So I did these two commands:

EXEC sp_grantlogin 'domain\Domain Admins'

EXEC sp_addsrvrolemember 'domain\Domain Admins', 'sysadmin'

Where I of course replaced domain with the appropriate domain name. For Domain Admins this does not seem to work! Also applied it to BUILTIN\Administrators. The local administrator can connect. I then created a new domain group named 'DBadmins'. I applied the exact same commands as stated before to this group, members of this new group can login. When I add the group Domain Admins to the group DBadmins, they do can login. This is of course not a desirable construction. I want all Domain Admins to have access. So I have 2 questions:

1> How can I make sure the Domain Admins group

Problem connecting using ODBC from Windows Server 2008R2 x64




I have strange problem: when I'm trying to create new “System DSN” (ODBC Data Source Administrator) using either SQL Native Client or “integrated” SQL Serve source I’m getting next:

Connection failed:

SQLState: '08001'

SQL Server Error: 1326

[Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [1326].

Connection failed:

SQLState: 'HYT00'

SQL Server Error: 0

[Microsoft][SQL Server Native Client 10.0]Login timeout expired

what strange for me – is that I can create this Data Source either on the other machine (Windows XP there) or on the server host (Server 2008 x64)…

Windows Firewall turned off on that host and I have no idea what to check next…

Any help appreciated.


Best regards...

Windows 2008R2 + MS SQL 2005 Express + "Synchronize" tool ? Where it is ...


Hello Everyone,

I just installed in a test setup a replication from SQL Server 2005 to SQL 2005 Express. Everything work fine. However, I like to schedule it to run ever hour. On the express machine, a Windows 2008R2, I cannot find the "Synchronize" tool (Normally in accessory folder). After looking online I ended up copying it from another machine. However, it does not work well.


Where is that tool in Windows 2008R2 ? I am doing something wrong ?



Forgot SA password and the windows login in SQL2008


Hello all,

I have forgot the SA password as well as the windows domain id  and password which was used by me, during the install. The SQL service runs under the local sytem account and is a default instance,

Is there any way to get into the server , or a way to find out what was the windows id which was provided by me , when i was installing the SQL (by default we will use an SQLwindows id) during install.




Windows Service Applications Tutorials

You can easily create services by creating an application that is installed as a service. For example, suppose you want to monitor performance counter data and react to threshold values. You could write a Windows Service application that listens to the performance counter data, deploy the application, and begin collecting and analyzing data.

Serving Silverlight Apps from Windows Mobile

Even if mobile dev is not my every day work, thanks to the .Net Compact Framework, it's still .Net programming.

Here is the scenario:

You come back home, you have a windows mobile phone wifi capable and you want to quickly get access to your phone pictures from your home network.
You just activate the Wifi, run my app and then browse to the provided link from any computer on the network.

Getting Started with Windows SharePoint Services

Of all of the capabilities of SharePoint, I thought I would start with the most basic installation - as a corporate intranet. It is likely that we will need to discuss some of the elements of SharePoint as we go along, so this also gives us the opportunity to review these elements for future reference.

Before going into too much detail, I would like to point out that you can try the core SharePoint framework (known as Windows SharePoint Services or WSS) for free. On Microsoft's Web site you can download a trial version of Virtual PC 2004 (VPC). Using VPC, you can install the Windows 2003 Evaluation Kit and the WSS add-on. This combination will give you 45 days to evaluate the setup.

Building a Searchable Phone Directory with Windows SharePoint Services

I want to continue to build out the intranet site we've started in our previous articles. A standard item in every intranet is a staff/employee list. Most companies implementing Windows SharePoint Services (WSS) are large enough to have a database that contains all employees. We will use the aggregation features of SharePoint to include data from this database into our intranet.

Getting Started with Windows Communication Foundation

Windows Communication Foundation (WCF) provides a unified framework for rapidly building service-oriented applications that makes it easy to build and consume secure, reliable, and transacted Web services. It unifies the capabilities in ASMX, WSE, Remoting, COM+, and MSMQ; therefore developers need to learn only one programming model.

Application Architecture in Windows Forms 2.0

Applications have special support in Windows Forms. For starters, you can manage and tailor your application's lifetime, and, when the work flow is disrupted by an unhandled exception, you can choose from several methods of response. Then, there are several application models that you can employ, including Single Document Interface (SDI) and Multiple Document Interface (MDI) applications, each of which can support either multiple-instance or single-instance mode, the former the VS05 default and the latter requiring special consideration. All applications, however, can discover and use a wide variety of information about the system and environment they execute in.
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