Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 694
  • Last Modified:

How to setup a website on windows 2008 R2 Server?

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
aloknet21
Asked:
aloknet21
  • 12
  • 3
  • 2
  • +1
1 Solution
 
EvilPostItCommented:
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
 
aloknet21Author Commented:
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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
aloknet21Author Commented:
0
 
sabkCommented:
please check DotNet 3.5 and ASPAJAXExt installed???
0
 
aloknet21Author Commented:
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
 
aloknet21Author Commented:
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
 
aloknet21Author Commented:
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
 
aloknet21Author Commented:
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
 
EvilPostItCommented:
Firewall or SQL is not configured to allow incoming connections.
0
 
EvilPostItCommented:
Or even wrong hostname.
0
 
aloknet21Author Commented:
i am using .net framework 2.0. please see IIS settings error in screen shot.
mis.JPG
0
 
aloknet21Author Commented:
0
 
aloknet21Author Commented:
0
 
aloknet21Author Commented:
0
 
aloknet21Author Commented:
0
 
aloknet21Author Commented:
0
 
sabkCommented:
"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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 12
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now