SQL SERVER – 2008 R2 – Step By Step Installation Guide With Images

installed  SQL SERVER – 2008 R2 on Window / Window Server 2008.

Step 1  Install IIS 7 see previous blog.

 you Download   SQL SERVER 2008 R2.

Step 2 Go to SQL Server and right click on Setup.

Step 2  Select Planning and check security.

Step 3  View Details and click ok.

Step 4 Select Installation and click new Installation.

Click Next.

Select Check Box and click Next.

Click Install.

Click Next.

Click Next.

Click Next.

Select check Box and click Next.

Click Next.

Enter Instance Id and click Next.

Click Next.

Enter account name and password  click ok then click Next.

Click use the same account for all SQL Server services and click Next.

Click Next.

Click Next.

Click Next.

Click Install.

Click close.

Go to window Firewall with advanced and select inbound Rules.

Port 1433

Select Domain  and Public.

Enter User         sa 

                             Enter Password               Welcome1  

click connect.

if you want to connect ip then local ip 127.0.0.1

your SQl server is connect. 

If you used SQL Server other Machine the 

Go to  SQL server configuration manager

 and click Protocols and Enter IP Address your System

click Apply and ok .

THANKS.