Solved

How to setup a website on windows 2008 R2 Server?

Posted on 2010-11-11
18
691 Views
Last Modified: 2012-05-10
Hi Experts,

I have a website running on Windows 2003 and Database is based on sql 2000 Server. Recently we have purchase a new Dell Server with Windows 2008 R2 Server and sql 2008 Server.
Now i need to Migrate this website on the New Server.

I am New at Windows 2008 Server. please guide me how can i do this.

Thanks!
0
Comment
Question by:aloknet21
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 12
  • 3
  • 2
  • +1
18 Comments
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34110298
From the SQL Server perspective backup your database on SQL Server 2000 restore it to your new SQL Server 2008. In database properties > options change the compatability level to SQL Server 2008.

Run the below to rebuild all the indexes.

exec sp_msforeachtable "alter index all on [?] rebuild"

Create any windows logins that exist on the old system. For SQL Server logins create them and then run the sp_change_users_login. You will want to look at example B at the bottom of the below link.

http://msdn.microsoft.com/en-us/library/ms174378.aspx
0
 
LVL 1

Author Comment

by:aloknet21
ID: 34118281
thanks for your comment!

i have installed iis 7 now and configured website, but not able to browse login.aspx page.

please see attached screen shot and suggest. webpage
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
LVL 1

Author Comment

by:aloknet21
ID: 34118282
0
 
LVL 5

Expert Comment

by:sabk
ID: 34118401
please check DotNet 3.5 and ASPAJAXExt installed???
0
 
LVL 1

Author Comment

by:aloknet21
ID: 34118430
on my windows 2003 Server .net 2.0 is running and Microsoft ASP.NET 2.0 AJAXEXT 1.0 is installed.

what version will be compatible for windows 2008 R2?
0
 
LVL 1

Author Comment

by:aloknet21
ID: 34118438
Also bydefault on Windows 2008 .net 3.5 was installed but i had removed and installed .net 2.0

should i install AJAXEXT 1.0 too?
0
 
LVL 1

Author Comment

by:aloknet21
ID: 34118569
thanks you so much. i have installed AJAXEXT now and login page is opening. please let me the steps for sql data base.

How can i create database in windows 2008.

i have copied data file from sql 2000 now.

let me the steps to create in sql 2008
0
 
LVL 1

Author Comment

by:aloknet21
ID: 34119065
i have copied .mdf adn log file and attached a database now at sql 2008. but getting this error. please see attached screen shot. error
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34125675
Firewall or SQL is not configured to allow incoming connections.
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34125690
Or even wrong hostname.
0
 
LVL 1

Author Comment

by:aloknet21
ID: 34126979
i am using .net framework 2.0. please see IIS settings error in screen shot.
mis.JPG
0
 
LVL 1

Author Comment

by:aloknet21
ID: 34126982
0
 
LVL 1

Author Comment

by:aloknet21
ID: 34126983
0
 
LVL 1

Author Comment

by:aloknet21
ID: 34126984
0
 
LVL 1

Author Comment

by:aloknet21
ID: 34126988
0
 
LVL 1

Author Comment

by:aloknet21
ID: 34126990
0
 
LVL 5

Accepted Solution

by:
sabk earned 500 total points
ID: 34211648
"localsqlserver" is already defined in "machine.config’ at the server level by default.  So you needs to remove this name first by adding the tag < remove name="LocalSqlServer" / >  in your web.config file before the same name is redinfed in the web.config file
http://forum.winhost.com/archive/index.php/t-3576.html
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question