Saturday, 2024-11-16, 12:20 PM
Welcome Guest | RSS
Site menu
Section categories
My articles [2]
Tag Board
500
Our poll
Rate my site
Total of answers: 148
Statistics

Total online: 5
Guests: 5
Users: 0
Main » Articles » My articles

Installation of SQL SERVER 2008

As many of you are confusing in the process of installing SQL Server, we have brought up with these steps for you people. The below steps will guide in installing SQL server 2008.

  1. Open SQL Server 2008
  2. Double click on "setup" icon. It will open the below window:                                      


  1. Select "Installation” in left side of the windows as shown in below figure.


  1. Now select the first option which is "New SQL Server stand-alone installation or add features to an existing installation" in the right side of the window.
  2. It will open a window aslike below and click on "ok” button.


 

  1. Select "Enter the product key" but dont give any key or values here just select it and press "Next” button as shown in below figure.


  1. Now accept the licence aggreement and press "Next” button and press ”Iinstall” button.
  2. It will open a new window as below.


It is very important to check this.. u hav to get almost all reports as passed.

If u dont hav internet connectivity it wiil show an warrning or error message at "Microsoft .NET Application security" and for people who are having internet connection will not have any problems or issues in this case. This is not a problem you can install it.. press "Next” icon and it will open the below window.


  1. Click on "Select All" button and click on "Next” icon. It will open another window(Instance Configuration) dont change any thing there and just click "Next” icon.
  2. Now, it will open "Disk space Requirements" click on "Next” button.
  3. It will open "Server Configuration” wizard which is most important aspect in installtion.


  1. Be careful in doing this.. because here only many of you face problems in installing SQL Server.

First click on SQL server Agent’s Account name and it is a drop down list control, so select the option as "NT Authority\system" or "XXXXXXX\system” i.e.,(second option in drop down list control box) and password as you wish (eg: abc).

Simillary give all the option as same in remaing four rows: sql server database engine, sql server analysis services, sql server reporting services,sql server integration services 10.0 and enter password.

It will open a new window like below:

 


  1. Select "Mixed Mode”(SQL server authenitcation and windows authentication) and give ur password as u wish.(eg: abc) in both places. click on ADD button at bottom it will open another window as below:


  1. Now give some name at the text box control as shown in above pic.. in my case i hav given NAGI. and click on OK button
  2. It wil open below window and click on "Add” button.


 

  1. It will open another window as below:


Now give some name at the text box control as shown in above pic.. in my case i hav given NAGI. and click on OK button

  1. Now click on "Next” button as shown in below figure.
  1. It opens "Reporting Services Configuration” like below. Now, select the first radio button i.e., "Install the native mode default configuration”. Now click on "Next” button.


  1. In the below window don’t select any options, just click on "Next” button


  1. Again click on "Next” button and then click on "Install” icon. It will open progress bar showing the status of installation like below.


 

  1. Finally click on "Next” button and then on "Finish” button. Then SQL server installion is completed successfully.

    Dafault username for login into SQLServer authentication is "sa” and password is which your are given during the process of installation.

 

Category: My articles | Added by: NAGI (2011-03-02)
Views: 3502 | Comments: 17 | Rating: 3.5/6
Total comments: 171 2 »
17 Budigi  
0
hi sir... this is Raasi..2010 Batcch...

This is my first message to you sir....

i like your way of teaching,... who can understnd everything even though that candiadate who dont have any basics also...

now i got a job in Pradigm Groups. Your classes are helped me in real time......

Thank You So Much Sir

16 nilu  
0
sir i have problem in installing sql server 2008.. previously i have installed bt now it is giving me trouble.. plz help me out

15 Bindu  
0
Hi sir,
Installation of sql server is very helpfull to us but i have a question which one should be loaded directly from online and which suits to out OS example I have a processor 64-bit and in pnline i got 3 links to download which suits and which does not suits to the requirements of PC

Please try to Upload the information so that it is even very help full sir
Thanking You

14 balaji  
0
hi sir...

13 Ramesh Babu.N  
0
Sir, I am Your 11am Batch Student Sir.
I want to Experienced Job Details Sir

12 srinivas.L  
0
thank u...sir

11 Srikanth Raju  
0
hi sir... this is Srikanth.. Eveing 5:30 to 9oclock Batcch...

This is my first message to you sir....

i like your way of teaching,... who can understnd everything even though that candiadate who dont have any basics also...

Please sir... try to maintain the sight for updating all JObs in our form...

10 sreekanth  
0
small request.
somebody people are not understand the how to install the .net framework for sql server .
so please add this step also

9 jagdesh  
0
tan q sir
this is valuable tips for students

8 raj  
0
hi sir,
i have the problem in the instalation of sql server 2008.last to third step in the ready to instalation step it shows the error "prevoius releses of the microsoft visual studio 2008" satus will be "failed" so it shows next button is disabled. we canot move to the next step. whats the solution pls tell me

1-10 11-17
Only registered users can add comments.
[ Registration | Login ]
Search

Time
 

 

Calendar
 

Twitter
 

Entries archive

Copyright R N Reddy © 2024Developed by Nagendra, Venkat, Vijaya and Yaswanth
Get free updates as SMS to your mobile. Just register by clicking here