[Tutorial]INSTALLING/USING MSSQL 2008 R2 (images)

[tanomist]

This is step by step guide, for those who want to install and use MSSQL 2008 R2, this guide also contain information about restoring the QQXY Database :

Step by step ...

TO DOWNLOAD MSSQL 2008 R2 USE GOOGLE,

Installing process

Run the setup

Choose [Installation] -> And then click on [New SQL Server ... installation]

Note: Do not pm me for product key :

Tick "I accept ..."

^^

Wait till the Setup will copy Support Files

Note: If you got any warnings, fix them first to continue the installation

Feature Selection: Push Select all if you don't know what are you doing ..

Next ...

Next ...

Server Configuration: Use standart options do not change them ( Do not push "Use the same account on all SQL services" )

Check Mixed mode, Enter the password, and push the [Add Current User]

Next ...

The Setup will run the system checking ... if you got any errors, cancel your installation

Install

Next .. then Close..

Credits going to pinaldave

If you got any errors during installation, you can freely contact with me .

 

[tanomist]

Re: [Tutorial]MSSQL 2008 R2 (images)

Using MSSQL 2008

You must restore 2 databases :
QQXYTWDBCenter.bak
QQXYTWLogin.bak

Run the SQL Server Management Studio

...

The connection window will appear:
insert your id : sa (default)
password : yourpassword

Connect

Restoring the database, Right click on Database -> Restore Database

To Database : QQXYTWDBCenter
Tick, From Device

Click on [..] near From Device -> Add, Find the database on your drive

Put TICK on Restore then [OK]

Do the same with :

QQXYTWLogin.bak