SQL Server Journey with SQL Authority

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology | 287 Comments

287 Responses

1. on July 28, 2008 at 2:44 pm | Reply Kamran Shahid

   Very Nice.
   Where will be other things like surface area configuration , help e.t.c

   
   
2. on December 2, 2008 at 1:26 am | Reply Dhruval Soni

   Great , it was very useful to me

   
   
   • on October 19, 2011 at 9:49 am | Reply keongracun

     I do not agree with you. u’re liarr #rawrr haha :3

     
     
     • on June 13, 2012 at 8:39 pm | Reply sri

       are you really a dba?

       
       
   • on May 24, 2012 at 6:39 pm | Reply Nrusingha Nath Acharya

     Thank a lot. This doc was really nice to have , and was very useful to me.
     :)

     
     
3. on December 2, 2008 at 7:01 am | Reply SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial Journey to SQL Authority with Pinal Dave

   
   
   • on February 6, 2011 at 12:59 am | Reply srikanth

     Hiii Pinal,im using windows 7 home basic 64 bit os,when im installing sql server 2008,some error r occured.wnen installing .net framework 3.5 sp1 it would not be install,furthur it stops and some times showing error message.please let me know d exact answer.

     Regards
     srikanth.

     
     
     • on June 4, 2011 at 7:25 pm | Reply nep

       just download the .net framework 3.5. sp1 search at google.com then shows directly to microsoft website.only that and you can install your sql server 2008.

       
       
     • on October 19, 2011 at 9:51 am | Reply keongracun

       agreeeeee!!!!! ^_^8

       
       
4. on December 21, 2008 at 11:52 pm | Reply madhan raj

   Hi,

   I think u have missed the image for Analytical services configuration … instead u have placed two copies of Database Services configuration ..

   
   
   • on May 7, 2012 at 9:27 am | Reply Waquar

     mee too noticed the same …..

     
     
5. on January 15, 2009 at 6:17 pm | Reply Jack Waterson

   Cannot install server 2008 evaluation
   installs setup support files and then stops.

   Running xp.

   any help would be appreciated

   
   
6. on February 8, 2009 at 3:02 am | Reply Dmitri.Mironov

   Thanks for such a useful post!
   it really helped me!
   Take care! :)

   
   
7. on March 6, 2009 at 6:26 am | Reply Martin Anderson

   This was God Sent!

   THANK YOU PINAL DAVE THANK YOU AND WELL DONE.

   The screen asking for account and password was misleading as you needed to direct it system folders.

   I want to sent money to Pinal Dave as he saved me lots of time.

   Thankful,
   Marty

   
   
8. on May 4, 2009 at 7:34 pm | Reply Mohan

   Hi its nice Guide but you missed the comments on each step its just a screen shot document needs to be more clear -thanks

   
   
9. on June 15, 2009 at 8:25 pm | Reply VladimirS

   Thanks, it was very useful to me
   when on set accounts (page “Service accounts”)
   were received messages as:
   “The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service.”, …

   (.. and really presented two same images,
   see madhan raj note)

   
   
   • on September 22, 2010 at 1:57 am | Reply BrianG

     @VladimirS – I assume you solved your credentials issue since this post? I’m having the same issue now, and I’m a bit stumped. I tried using my own windows domain account, which the msdn docs seem to suggest should work, but I get the same error. Any ideas?

     
     
10. on June 24, 2009 at 9:34 am | Reply swati

    You had missed an image. But, it was of great help. Also, comments for some of the steps would have been more helpful

    
    
11. on July 3, 2009 at 6:29 pm | Reply Ramesh

    Sir,
    Realy Good Manual

    Thanks Lot

    REgards,
    Ramesh Chandra

    
    
12. on July 13, 2009 at 8:20 am | Reply Sim

    Hi there,

    I facing some problems when try to connect to SSRS 2008.
    When I go to ‘Reporting Services Configuration Manager’, I can see the default server name, the report server instance not auto detects the ‘ReportServer’ database that available in the database.

    When I click ‘Find’, it prompt out ‘Invalid Class’ warning message.

    How can i solve it?
    Thanks.

    regards,
    Sim

    
    
13. on July 24, 2009 at 11:30 am | Reply Naina

    thanks…its really helpful :)

    
    
14. on July 28, 2009 at 5:17 pm | Reply bharathi

    Dear how to install sql server 2008 with Unicode…

    
    
15. on August 11, 2009 at 9:14 am | Reply Steve Williamson

    Thanks for that – very helpful. Especially for the service accounts which are not populated by default. I can never remember what should run as system, local service, network service etc..!

    Now can I have a custom step-by-step guide to setting it up on my network?… :)

    
    
16. on August 14, 2009 at 3:28 pm | Reply Madhav

    Very help full!!!!
    Thanks….!!!

    
    
17. on August 18, 2009 at 9:10 am | Reply JESUS

    GRACIAS POR EL MANUAL ME SIRVIO PARA MI COMO PAR AMIS ALUMNOS OK BYE

    
    
18. on August 18, 2009 at 1:34 pm | Reply Wonderful

    You are the Man!!!.. Simple and neat. Good work.

    
    
19. on September 2, 2009 at 9:45 pm | Reply sam

    Hi

    my sqlserver failed with access denied error :

    unable to connect to ssqlserver now.
    please find below details :

    Log Name: Application
    Source: .NET Runtime Optimization Service
    Date: 9/2/2009 7:45:10 AM
    Event ID: 1101
    Task Category: None
    Level: Error
    Keywords: Classic
    User: N/A
    Computer: xxxx
    Description:
    .NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) – Failed to compile: W:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\Tools\VDT\DataDesigners.dll . Error code = 0x8007000b

    Waiting for your reply

    
    
20. on September 9, 2009 at 1:57 pm | Reply hany

    hi
    thax for ur steps , i have a question,
    i had installed it and then uninstall and after awhile i needed to install it again , the setup file can’t start it show the command prompt screen for less than a second and close it and nothing start ,what shall i do??
    your reply is highly appreciated

    
    
21. on September 12, 2009 at 2:34 am | Reply Jose

    This is a good tutorial, but I have not seen anything special about it, since the author is just placed the screen shots of the installation process. I think that it should be much more helpfull if he have explained the steps, why we should select certain options and why we should not select certain options. The explanation of certain options would have helped much more in this tutorial.

    Thanks

    
    
22. on September 17, 2009 at 8:22 am | Reply max

    [Options]
    USERNAME=ABC => Status Ok
    COMPANYNAME=XYZ => Status Ok
    ADDLOCAL=ALL => Status Ok
    INSTANCENAME=SQLEXPRESS => Status Ok
    SECURITYMODE=SQL => Status Ok
    *****************************************

    SAPWD=sql => Status Ng

    Why Mixed Mode Dialog Password Still Blank ??
    Did i miss some Setting ??

    *****************************************
    SQLBROWSERAUTOSTART=1 => Status Ok
    DISABLENETWORKPROTOCOLS=0 => Status Ok

    
    
23. on September 20, 2009 at 7:50 pm | Reply Swathi

    Thanks! This helped me. Keep up the great work!

    
    
24. on September 25, 2009 at 2:34 pm | Reply Atbt

    Super ……………. you helped me dude, Actually i was stucked on Instance configuration step.

    Thnx

    
    
25. on September 29, 2009 at 2:32 am | Reply Miguel

    Do you have step by step procedures on how to do the upgrade from 2005 to 2008.
    It will be very helpfull to me.

    
    
26. on September 29, 2009 at 9:19 pm | Reply Albert

    Hi,

    I had installed a sql server 2008 on a XP Pro. My problem is when I try to register servers I got this error (Framework .NET warning):

    “Unhandled exception has occurred in a component in your application.

    Key not valid for use in specified state…”

    Then if I try to click on the menu Registered Servers I can’t see any kind of tree as in other installations.

    I tried to repair Framework and it doesn’t work..

    Can you help me? Thank you very much!

    
    
27. on October 29, 2009 at 8:27 pm | Reply prashant jakkani

    Hi Pinal Dave,
    In the insallation rules there i find “previous release of Microsoft Visual Studio 2008 Failed”
    So I cannot go further.
    Please help me

    Thank You,

    
    
28. on October 30, 2009 at 1:23 am | Reply Anil Mahadev

    @Prashanth,

    Check out this KB article for a solution

    http://support.microsoft.com/kb/956139

    
    
29. on October 30, 2009 at 1:46 am | Reply Anil Mahadev

    @Max:

    Are you trying to use SQL Server Express in deploying your application and you need to enter the following settings?

    Please elaborate?

    ========================================
    [Options]
    USERNAME=ABC => Status Ok
    COMPANYNAME=XYZ => Status Ok
    ADDLOCAL=ALL => Status Ok
    INSTANCENAME=SQLEXPRESS => Status Ok
    SECURITYMODE=SQL => Status Ok
    *****************************************

    SAPWD=sql => Status Ng

    Why Mixed Mode Dialog Password Still Blank ??
    Did i miss some Setting ??

    *****************************************
    SQLBROWSERAUTOSTART=1 => Status Ok
    DISABLENETWORKPROTOCOLS=0 => Status Ok

    =========================================

    SAPWD=sql => Status Ng ==> Does not use Strong SA Password

    Thanks

    
    
    • on March 26, 2010 at 11:28 am | Reply max

      yes, i try to deploy my sql server 2005 setting on my application, but the above issue been solve.

      right now i try to do the same setting in sql server 2008, but fail, maybe you can help me.

      
      
30. on October 30, 2009 at 2:17 am | Reply Anil Mahadev

    @Miguel,

    Check out this MSDN Primer @

    http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx

    On Consideration and steps needed to upgrade from various DB Engine versions to latest releases.

    Thanks

    
    
31. on October 30, 2009 at 2:20 am | Reply Anil Mahadev

    @Jack,

    For installing SQL Server 2008 on Windows XP,

    one would need XP SP3(Recommended) but minimum SP2,
    Windows Installer 4.5 and .NET 3.5 SP1

    Check out this Article for the same

    http://www.packtpub.com/article/microsoft-sql-server-2008-installation-made-easy

    Thanks

    
    
    • on June 5, 2012 at 11:57 am | Reply tabu

      I am encountering the same problem as Jack’s, the setup doesnt proceed further than the support files, any solution to this? & also when i try to install the .NET 3.5 SP1 i get an error

      
      
32. on December 3, 2009 at 1:40 am | Reply vishwa

    Gr8 , it was very grateful to us. Keep up nice works……

    
    
33. on December 8, 2009 at 1:59 pm | Reply bandara

    thanks…its really helpful :)

    
    
34. on December 24, 2009 at 6:48 am | Reply Sundar

    Hi friend,

    Thanks a lot.Really it is very helpful. If i want create new account & password how to proceed?

    Once again thanks for your preparation.

    Regards.

    
    
35. on January 13, 2010 at 4:45 pm | Reply Anna

    Thanks a Ton :)

    It was a great manual :) Cheers !!!

    
    
36. on January 14, 2010 at 8:21 pm | Reply Sorin

    I have the same problem as Albert above:
    I had installed a sql server 2008 Management Studio + SP1 only on a Win7. My problem is when I try to register servers I got this error (Framework .NET warning):

    “Unhandled exception has occurred in a component in your application.

    Key not valid for use in specified state…”

    Then if I try to click on the menu Registered Servers I can’t see any kind of tree as in other installations.

    I tried Repair… didn’t fix it. I tried uninstalling and installing… still can’t register any server.

    Do I have to wipe out Win 7 for this? :-)

    Thanks!

    
    
37. on January 26, 2010 at 12:19 pm | Reply dhiva

    cheers !! finally i installed it now going to start some tips & tricks in sequel server 2008

    
    
38. on February 3, 2010 at 12:13 pm | Reply Smith

    Where are the comments?
    I were refer to this blog post but here there are no commnets on screenshot.
    Kindly add the commnets on the pictures [Like I want's help on Account info for setting as Local system on 14th screenshot] other wise it would looks very childish type.

    
    
39. on February 9, 2010 at 11:25 pm | Reply shifty_1981

    I seem to remember that when you do a SQL install it creates certain groups in Active Directory (in a domain environment). However my account does not have permission to create such groups. I am a local admin on the machine (my domain account is) however. Is this a concern? Exactly what type of permissions are required or recommended for the SQL Server 2008/2005 installer to be run as?

    Thank you

    
    
40. on February 12, 2010 at 2:06 am | Reply Nick

    Hi Can anybody help me. i have been trying to install sql 2008 but its giving me the following error.

    TITLE: Microsoft SQL Server 2008 Setup
    ——————————

    The following error has occurred:

    This access control list is not in canonical form and therefore cannot be modified.

    Click ‘Retry’ to retry the failed action, or click ‘Cancel’ to cancel this action and continue setup.

    For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1442.32&EvtType=System.Security.AccessControl.CommonAcl.ThrowIfNotCanonical%2540System.InvalidOperationException

    ——————————
    BUTTONS:

    &Retry
    Cancel
    ——————————
    plz somebody help me with this.

    
    
41. on March 6, 2010 at 2:00 pm | Reply jo

    well i install a sql 2008 but when i try to create and drop a table i wont let me drop the table. it ask for a persion. How can i make it work?

    and also, i wanna code a VB.net in my sql but i cant see any availbale .net laguage? do i need to install some kinda VB software?? i have Visual Studio im not sure. please help me i really need it in school???

    
    
42. on March 10, 2010 at 12:38 pm | Reply fabkhush

    Hi

    while Installing SQL Server 2008 i noticed that on feature selection page the browse is disabled and im not able to install it on different drive (other than C)

    what is wrong.

    SQL Server 2008 developer edition.
    named instance
    Windows Server 2003 standard edition

    
    
43. on March 10, 2010 at 5:35 pm | Reply Karlapudi

    Hi Pinal

    i have installed as the steps given by the Installation Guide..
    but still i am not able to connect to the Windows Athentication as well as SQL server authentication.
    plz guide me on this.

    regards
    Karlapudi

    
    
44. on June 2, 2010 at 10:05 am | Reply preetam

    good one …
    really helpful …
    thanks a lot …

    
    
45. on June 17, 2010 at 12:58 pm | Reply Divyesh

    Its really helpful

    Thanks a Lot

    
    
46. on June 17, 2010 at 4:05 pm | Reply David-Naija

    You are da bomb!!!!!
    It was very useful, please keep up with the good work.
    Thanks

    
    
47. on June 19, 2010 at 2:49 pm | Reply reetam

    hey i follow the step but i can t log in as server authentication. my pc is windows 7

    help me

    
    
48. on June 28, 2010 at 1:29 pm | Reply Graeme

    Hi,

    The page is no longer loading the images from your source server, has been that way for 2 weeks….hoping you get it up again soon.

    Cheers

    
    
    • on June 28, 2010 at 1:42 pm | Reply pinaldave

      The images are fine. Check your browser or try with different location.

      
      
49. on July 5, 2010 at 2:57 am | Reply Mehul

    Hi,

    I received below error while installing SQL server 2008.
    Pls help…

    TITLE: Microsoft SQL Server 2008 Setup
    ——————————

    The following error has occurred:

    ” is not a valid login or you do not have permission.

    For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=15007&ProdVer=10.00.1600&EvtType=0xBE029E38%25400x12C2466D

    ——————————
    BUTTONS:

    OK
    ——————————

    
    
    • on May 11, 2012 at 9:47 am | Reply Om Rajan

      Hi.. i have getting exactly same problem on windows 7 64 bit home basic edition os…..

      what is the solutions for ths error…

      i hv also installed same setup on windows 7 ultimate edition…
      its installed sucessfully..
      so what is the meaning of this:
      ? it means its not compitable for win 7 64bit home basic edition

      if no
      then please give the solutions

      Regards
      Rajan

      
      
50. on July 7, 2010 at 4:22 pm | Reply ssengu

    hi, during the installation sql server express R2 2008 got error os 2003 ans sp2 and 32 bit

    sql server express R2 version 32 bit 235 mb please replay this isse which i got

    TITLE: Microsoft SQL Server 2008 R2 Setup

    ——————————

    The following error has occurred:

    This access control list is not in canonical form and therefore cannot be modified.

    Click ‘Retry’ to retry the failed action, or click ‘Cancel’ to cancel this action and continue setup.

    pls help me

    ASAP

    ssengu

    
    
51. on July 8, 2010 at 4:47 am | Reply Reddy

    Hi Pinal,

    Thanks for your nice posts on all topics..
    Today i tired SQL 2008 installtion eith 64bit on win2008 server 64 bit.
    I m not able to get the “Feature Section” screen after the “Setup support Rules” screen.

    Any guess on this.

    Please help on the above issue, it helps me a lot.

    
    
52. on July 11, 2010 at 6:37 pm | Reply arunmanikumar

    thank you

    
    
53. on July 13, 2010 at 11:54 pm | Reply Bhaskar

    Hi Pinal,

    thanks for veryfull artical.
    i am trying install Sql Sever 2008 standred edition on windows 7 Ultimate.

    but end i am get error

    rule “operating system supported for edition “.

    MS Sql server 2008 Standred edition is it not Comparablety problem.

    please do needful.

    Thanks,
    Bhaskar

    
    
54. on July 14, 2010 at 12:13 am | Reply Bhaskar

    Hi Pinal,

    Thanks for very useful article.
    i am trying install Sql Server 2008 standard edition on windows 7 Ultimate.

    but end i am get error

    Rule “Operating system support for edition” failed
    This sql server edition is not support on this Operating system. See Sql Server Books online for information about support operating system for SQL small Business edition

    MS Sql server 2008 Standard edition is it not Compatibility problem.
    Please do needful.

    Thanks,
    Bhaskar

    
    
55. on July 18, 2010 at 10:52 am | Reply bikash koirala

    iam so delightful to get this guide of sql installation////

    
    
56. on July 21, 2010 at 7:51 pm | Reply krismlj

    thx was confused about service accounts but ur screen shot fixed up that confusion.

    thanks again helped lots.

    
    
57. on July 24, 2010 at 1:15 pm | Reply Mubin Shaikh

    Hi,

    SSL Server 2008 setup was sucessfully done and all the database created and restored sucessfully, but next time i want to login in sql server specified instance its showing the error that Server conection done sucessfully but specified instance not connected.

    Any guss on this issue

    
    
58. on July 27, 2010 at 7:33 pm | Reply Ashish

    check either sql able to get it in the list of available sql server in same environment.
    To do this, open cmd and run
    sqlcmd -L
    if you want this result in text file then
    sqlcmd -L >c:\serverlist.txt

    you will get the list of all sql server in your environment. Check if this instance exists here

    
    
59. on August 9, 2010 at 1:21 pm | Reply Ashish kumar

    it is little bit difficult to install.so more easy way required or installing information should be attach with the software.

    
    
60. on August 13, 2010 at 10:45 am | Reply Santosh

    ohhhh godd finallllllyyyy sth wrkdd fr me :)
    ihv downld ths softw thrice n ihv deleted cos thr ws sum prob withh user n passwd :(

    ihv downld it againnn n found the same probbb..
    thogg to justtt luk aroundd on the forumsss n ihv foundd thsssssss….
    IT WS AWESUMMMMMMMMMMM !!!!
    no need of writingg sthhh or givings commentsss cos

    U CAN SEEE IN THE SCREENSHOTS WHIC one to SELECT N WHICH ONE SHOULDNT BE !!!!

    so … its not at all a concern of havingg comments under the screens LOL !!!!
    thxxxx so muchh PINAL dave :)
    lov u bro :)
    i needed ths stuff fr progrmnnn thx a lot :)

    
    
61. on August 22, 2010 at 11:11 am | Reply yaseen

    THANKS A LOT FOR PROVIDING SUCH A GOOD INFORMATION FOR LEARNER.

    THANK AGAIN.

    REGARDS

    YASEEN

    
    
62. on August 25, 2010 at 10:35 am | Reply Sunit yadav

    Very-very healpfull….
    Thanking you.

    
    
63. on August 26, 2010 at 6:31 pm | Reply S.Kapadia

    Hello, I want to install SQL Server 2008 on Server 2008 Enterprise but it failed to install saying that

    “sql server 2008 edition not supported on this operating system”

    O/S Server 2008 Enterprise Edition.

    
    
64. on September 4, 2010 at 3:26 pm | Reply Snehal

    It is really nice.

    But what I think is, it will be better utilised if provided some add info. such as how to saperate .mdf,.ldf,tempdb e.t.c.
    during setup or after setup. In particular if we use raid 10.

    I will be obliged if provided something neccessary.

    Any way many many thanks to Pinal Sir.

    
    
65. on October 21, 2010 at 8:55 pm | Reply santanu

    Hi Pinal,

    I am working with SQL Server 2008 on Win 7 Pro. Installed successfully, but can’t connect to server instance from SQL Server Mgmt Studio.

    I named db as “PHCG” and I see a service running as SQL Server (PHCG).

    What should be my Server Name when connecting?

    Thanks much in advance,
    Santanu Bera

    
    
66. on October 21, 2010 at 9:50 pm | Reply sampath

    HI
    please use as below

    \

    if your server name is server01 then

    use as below

    server01\PHCG

    and use windows or SA authentication for connecting

    
    
67. on October 25, 2010 at 3:19 pm | Reply Kumaresan

    ALL THE STEPS WORKED FINE. FANTASTIC JOB.THANKS A LOT.

    
    
68. on November 11, 2010 at 7:00 am | Reply Hugo

    TNX very much.!

    
    
69. on November 19, 2010 at 2:49 pm | Reply dhaval

    Thanks very much.!

    
    
70. on November 22, 2010 at 11:19 am | Reply Syed Wajahat

    If you are getting error “the credential you provided for the sql server agent is invalid”

    One of the best way of handling this is to install it with a local account first.

    Once SQL Server installed, now you can change the service account by changing the user at services.msc

    Change the service account, stop & start it. Its now working with your service account.

    Thanks.
    Syed Wajahat
    Principal Consultant
    Techerz.

    SharePointGulf

    
    
71. on November 24, 2010 at 5:18 pm | Reply Charles

    Hi,

    I want to do a silent install of SQL 2008 under W7entreprise, But when i install it whith this command “Setup.exe /q /ACTION=Install /FEATURES=SQL /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT=”" /SQLSVCPASSWORD=”" /SQLSYSADMINACCOUNTS=”" /AGTSVCACCOUNT=”NT AUTHORITY\Network Service”, i receive “the specified credentials for the sql server service are not valid. to continue, provide a valid account and password for the SQL server services”

    What is the exact command line for to do an automatic silernt install ??

    thanx

    
    
72. on December 2, 2010 at 2:07 pm | Reply Onkes

    Hey dude

    you have just saved my butt with this guid, thanks for everything that you are doing in helping when we are having problems.

    take care

    
    
73. on December 5, 2010 at 11:17 pm | Reply Sandeep

    Thankx a million Mr. Pinaldave
    It really helped me.

    
    
74. on December 6, 2010 at 3:43 pm | Reply Akshay

    hi, man thanks for putting all this stuff
    that was really helpful coz reading all docs and then install takes much time. you saved my time from that.
    thanks a lot.

    
    
75. on December 15, 2010 at 9:26 am | Reply mahabub

    It is really nice.

    But what I think is, it will be better utilised if provided some add info. such as how to saperate .mdf,.ldf,tempdb e.t.c.
    during setup or after setup. In particular if we use raid 10.

    I will be obliged if provided something neccessary.

    Any way many many thanks to Pinal Sir.

    
    
76. on December 22, 2010 at 12:16 pm | Reply Ankit Moradiya

    Thank u So much dear

    Really its very very Helpful …

    Thanks

    
    
77. on January 4, 2011 at 1:37 pm | Reply arianna

    Thank you very much for the article, it was soo easy to install it with your screenshots.

    
    
78. on January 5, 2011 at 2:08 pm | Reply seobridging

    There is a benefit in agreeing to a recommended set of features and corresponding tags in order to create, interpret and display a common . Thanks for sharing info.

    
    
79. on January 6, 2011 at 11:45 am | Reply Jahfar

    I am installing as given above. In “Installation Progress ” step after a few seconds in “validating feature setting” i get the error:
    “The folder path specified is invalid. Please enter a valid folder path.. Folder Path=C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data”. If anyone know the solution , please help

    
    
    • on May 9, 2013 at 1:09 pm | Reply siva

      i am also getting same error.can u pls tell me the solution if u know

      
      
80. on January 6, 2011 at 12:12 pm | Reply Andrew

    Hi Pinal Dave,

    Thank you very much for UR fantastic information about SQL SERVER 2008 Installation. It helped me a lot. Keep posting always…God Be with U…

    regards
    Andrew

    
    
81. on January 6, 2011 at 2:03 pm | Reply sai

    i installed sqlserver2008 in mixedmode.but it is connect only windowsmode.it is not connect sql mode.while connecting to the sql mode it displays error login failed.why? it is not connect.
    pls reply

    
    
82. on January 22, 2011 at 9:56 am | Reply Mengkong

    Hi,
    I installed sqlserver2008 and it continued to “Installation Rules” it failed with ‘Previous release of Microsoft Visual Studio 2008′ and the Next button is disable too.
    So, how can i install it.

    
    
83. on January 25, 2011 at 3:48 pm | Reply Waleed Mustafa

    Thanks alot for the great help
    Installation SQL 2008 is one of my duties at work

    
    
84. on January 27, 2011 at 11:22 pm | Reply ron

    absolutely fantastic!!!

    
    
85. on January 29, 2011 at 10:12 pm | Reply anjan

    Great .It is very help ful

    
    
86. on February 6, 2011 at 1:15 am | Reply ajay

    Hiii Pinal Im ajay. i installed sql server 2008 express edition on my win 7,64 bit operating system home basic.after installing successfully then im open to sql server it wont be open becose im unable to get the SSMS in option.please give me a suitable ans,im awaiting for your reply.

    regards
    Ajay.

    
    
87. on February 10, 2011 at 2:33 am | Reply Shiva

    Hey, Thanks for the explanation.

    
    
88. on February 21, 2011 at 2:20 pm | Reply Gopal

    Hi Pinal,
    i am using windows 7 home basic 64 bit os. I’m having a shocking time trying to install SQL Server 2008 on 64-bit Windows 7. When I run setup.exe, I get the following error message:

    Microsoft .NET Framework 3.5 installation has failed.

    SQL Server 2008 Setup requires .NET Framework 3.5 to be installed

    Things I’ve tried:

    I’ve checked and double checked. I do have .NET Framework 3.5 installed, with SP1
    I’ve read about a missing Windows Installer 4.5 installation producing the same error. Win7 comes with Windows Installer 5, which hopefully satisfies this requirement, as I’ve tried to install 4.5 and it won’t let me
    Burning the ISO to DVD and installing from there.
    Installing on an XP machine using the same ISO. This works, so the ISO must be fine.
    Considering SQL Server 2005, but it really needs to be 2008 for the project.

    Update I could install SQL Server Express, and then SP1, but couldn’t upgrade to Enterprise.
    If you’ve come across this issue, or know how to fix it, I’d love to know.

    Please note i purchased a new system for learning SQL Server but disappointed with Microsoft for making me to struggle with its compatablity issues and with out any solutions.

    Please let me know if you can assist me on this.

    
    
    • on March 28, 2011 at 1:35 pm | Reply Gopal

      After doing lot of research i managed to resolve this issue. I now have installed Enterprise Edition SQL Server 2008 in my system.

      
      
      • on December 27, 2011 at 11:22 pm | Reply walaasaadh

        Can you please explain how have you solved the problem as I have the same

        
        
89. on February 21, 2011 at 10:12 pm | Reply Nirmal Kumar.G

    Hi Pinal Dave…i Need your help
    My Laptop OS win-7 Home Premium 64 bit,I have only one Login Account(Having Administrator Rights)
    If i try to Install the SQL Server 2008 R2,Iam Getting this Error msg [" is not a Valid Login or you dont have a permission"]

    Note:My System Requirement Result-No Warning and No Faild.
    I Already Install Service Pack 1 for VS 2008,While i start Install the SQL Server 2008 R2,iam not getting any error msg..but before Complete the finall Installation Progress iam Receiving that above Error…Plz Tell me

    
    
90. on February 23, 2011 at 4:25 pm | Reply Vaibhav Saran

    you are such a great man :)

    
    
91. on February 23, 2011 at 9:25 pm | Reply JIKEN

    @Anil Mahadev

    When I installed as per these steps, I got below error between installation and then continue installation process.

    TITLE: Microsoft SQL Server 2008 Setup
    ——————————

    The following error has occurred:

    A later version of Microsoft SQL Server Compact is already installed.

    ———————————————–
    After installation complete I shown some features not installed. Then go to all programs–> sql server 2008 –> ssms is not display to launch.
    =======================================
    I read this below link article

    http://support.microsoft.com/kb/956139
    =======================================

    I already installed visual studio 2008 and vs2008 sp1 also before sql server 2008 installation

    So please give solution in steps. ASAP.

    
    
92. on February 27, 2011 at 8:21 pm | Reply Anne Lagang

    First, let me thank you for this great tutorial. It helped me a lot during my feeble attempts to install SQL Server 2008.

    I have a quick question. I followed all your instructions and installed all the components (i.e SSAS, SSRS, SSIS, BIS etc) because I need to study them. When I tried to view my Report Server/Reports in my browser, it prompts me for username and password. I don’t remember setting one up and I tried all possible username – password combinations I could think of but to no avail. Could you please tell me which username – password I need to enter so that I could view my Report Server/Reports?

    Thank you for your time and more power! ^_^

    - Anne

    
    
93. on February 28, 2011 at 9:17 pm | Reply sandy

    it will be good to create a step by step of this same product but using windows 7 OS

    
    
94. on March 3, 2011 at 12:08 pm | Reply Ananth

    I learned so many things from this site

    It is very useful for very DBA

    
    
95. on March 10, 2011 at 2:31 pm | Reply Nirav

    Hi Pinal
    I am installing share point office server 2007 and so i need to install sql server 2008
    in meanwhile of installing i go through the “reporting service configuration” step and there is 3 option
    just like you have in this “http://www.pinaldave.com/blogfolder/2008/200817.jpg”
    so if i want to install share point office server 2007 then which option i need to select
    pls provide info regarding this step
    so i can go further in sharepoint installation.

    
    
96. on March 21, 2011 at 12:23 am | Reply abhi

    at end of set setup showing error
    Event type: sql 100msi P1: 10.50.1600.1 P2:10.1.2731.0
    P3:sqlsupport.msi P4:0xced4a450 P5:1308
    P6: install_sqlsupport_katmairtm

    Plz suggest me

    
    
97. on March 21, 2011 at 12:27 am | Reply abhi

    at end of set setup showing error
    Event type: sql 100msi P1: 10.50.1600.1 P2:10.1.2731.0
    P3:sqlsupport.msi P4:0xced4a450 P5:1308
    P6: install_sqlsupport_katmairtm

    and after all above set shows

    Feature Name Status
    Database Engine Services Failed
    SQL server replication Failed
    SQL Client Connectivity SDK Success

    Plz suggest

    
    
98. on April 5, 2011 at 1:43 pm | Reply Anil

    Really Helpful document..I have faced many problem to resolve this problem…Thanks again…

    
    
99. on April 5, 2011 at 8:33 pm | Reply reyad yosef

    Very Nice.
    Thank you

    
    
100. on April 7, 2011 at 3:32 pm | Reply Vishvaroop

     Excellent Job Pinal… You are saviour….. !!!

     
     
101. on April 14, 2011 at 11:36 am | Reply essays

     The performance of SQL Server is primarily decided by the disk I/O efficiency. Improving I/O definitely improves the performance. SQL Server 2008 introduced Data and Backup compression features to improve the disk I/O. Here, I will explain Data compression.

     
     
102. on May 13, 2011 at 6:23 pm | Reply remko

     Hi,

     When we install SQL Server on vista or windows 7 (Deutch) the problem we face is that instance can not be started.
     We gat an error code 1814.
     Annyone experiencing the same problem??

     
     
103. on May 13, 2011 at 6:28 pm | Reply remko

     This only happens when we install it under a local account that is added to the administartors account. With the build in account ‘Administrator’ it works fine…

     
     
104. on May 17, 2011 at 2:11 am | Reply mrizwan_shahid@yahoo.com

     Thank you so much it helps me a lot thanks again

     
     
105. on May 17, 2011 at 9:43 am | Reply Kevin

     please can anyone help me installing SQL to my computer windows 7 home premium

     i need help “(

     
     
106. on May 17, 2011 at 7:44 pm | Reply laxman

     i got this error in ssas deployment , am using windows 7 36bit,pls give me a solution .
     Errors related to feature availability and configuration: The ‘Measure expressions’ feature is not included in the ‘Standard Edition’ SKU.

     
     
107. on May 21, 2011 at 7:48 pm | Reply RAHUL KUMAR

     HI ALL,
     I AM GETTING THIS ERROR WHEN TRY TO INSTALL SQL SERVER 2008 IN WINDOWS 7.

     TITLE: SQL Server Setup failure.
     ——————————

     SQL Server Setup has encountered the following error:

     The collation was not found.

     Error code 0x84B40000.

     ——————————
     PLEASE SUGGEST ME WHAT TO DO.
     THANKS ALL,
     RAHUL KUMAR
     ——————————

     
     
108. on June 1, 2011 at 6:22 pm | Reply shailesh

     TITLE: Message Details
     ——————————

     The specified credentials that were provided for the SQL Server service are not valid. To continue, provide a valid account and password for the SQL Server service.

     ——————————
     BUTTONS:

     OK
     ——————————

     
     
     • on June 2, 2011 at 6:39 am | Reply Imran Mohammed

       @Shailesh,

       Please post complete question ?

       SQL Server Service Account Needs Permissions to specific Folders. So the Account you mentioned when Installing SQl Server, might not have proper permissions, that is why you are getting this message.

       You can find here, permissions required for SQl Server Account.

       Look for the Topic :

       Reviewing Access Control Lists Created for SQL Server Service Accounts

       Web Link: http://msdn.microsoft.com/en-us/library/ms143504.aspx

       Another, easy way which I don;t recommend, is to give run SQL Server Service under an Account that have Administrator privileges.

       ~ IM.

       
       
109. on June 2, 2011 at 2:09 pm | Reply Laxman

     When I am running inmort and export wizard i am getting the following error in sql 2008 on XP can any1 give me solution,
     i did instalation using the above steps
     ===================================

     This wizard will close because it encountered the following error: (Microsoft SQL Server)

     ——————————
     For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

     ===================================

     No description found

     ——————————
     Program Location:

     at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_DBProviderInfos()
     at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetDtsDbProviderInfos(WizardInputs wizardInputs)
     at Microsoft.SqlServer.Dts.DtsWizard.DataSourceCombo.PopulateProviders(Boolean fSources, WizardInputs wizardInputs)
     at Microsoft.SqlServer.Dts.DtsWizard.Step1.OnInitializePage(EventArgs e)
     at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
     at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage nextPage)
     at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender, EventArgs e)

     
     
110. on June 4, 2011 at 2:58 am | Reply xavier

     Hi,

     You forgot to mention the most important part of SQL Server installation :)…the data directories part (data and log files location).

     but still nice work…

     Regards,

     Xavier

     
     
111. on June 4, 2011 at 5:27 pm | Reply Md.Nuruzzaman Mithun

     Hi,
     Wishes u all the best. I surf this web site for first time. This site seems to me much more helpful.

     
     
112. on June 6, 2011 at 6:11 am | Reply Laurie

     I am trying to install SQL Server 2008 on XP. I previously had it installed then had to do a system restore and am trying to install again. When I doubleclick on the setup file it show the command prompt screen for less than a second and close it and nothing start. Any suggestions??

     
     
113. on June 6, 2011 at 10:21 pm | Reply amns

     Thanks Pinal for the great article.

     I’m getting an error during sql server enterprise R2 installation (on a Windows Server 2008 R2)
     “Error reading from file E:\1033_ENU_LP\x64\setup\sql2008support\PFiles\SqlServr\100\Setup\Release\x64\Help\1033gi5cdu2.chm. Verify that the file exists and that you can access it.”
     ” Error: Action “Install_SqlSupport_KatmaiRTM_Cpu64_Action” failed during execution.”

     Anyone knows how to solve this?
     Abhi, have you solved your problem?
     Thanks

     
     
114. on June 7, 2011 at 4:52 am | Reply praveen

     Hi,

     Cannot install Sql server express R2 on windows 7 home premium ( brand new system)

     I selected all the options given, but could not install Managment Tools-Basic

     I get error below :

     “Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1.
     Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft Update”

     Then I installed only Database engine, Successful Completed.
     I would like to have Management studio as well, how can i install this.

     Please help …!

     
     
115. on June 7, 2011 at 4:35 pm | Reply Narendra

     I am trying to install Sql Server 2008 R2 window2008 server.

     I Successufly Completed Installed but after 10 or 15 days
     Sql server not login password..

     cannot connect to SCIL-SINGACH
     Additional Information
     A network -related or instance-specific error occurred while established a connection to SQL Server.The server was not accessible……….

     Please help me to come out this problem……

     Thank you

     
     
116. on June 8, 2011 at 2:15 pm | Reply Prajeesh

     Very excellent

     
     
117. on June 14, 2011 at 2:03 pm | Reply UCHE

     i want to learn more about the lastest in SQL 2008
     THANKS

     
     
     • on June 14, 2011 at 6:42 pm | Reply madhivanan

       Search for “What is new in SQL Server 2008″? in google/bing

       
       
118. on June 18, 2011 at 9:35 am | Reply sk gupta

     hallo sir,
     i have just installed sql server 2005. after installation when i conncect database to server. it reflect a massage “can not connect to server Error Code 4″

     
     
119. on June 24, 2011 at 10:49 pm | Reply Prakash N B

     In installation rules at last .i’m getting error ‘ visual studio error’

     
     
120. on June 26, 2011 at 8:25 am | Reply Varun

     Gud Work. Little bit Confusing, but it works. Really Thanks. Its d proper guide.

     
     
121. on June 26, 2011 at 1:05 pm | Reply Anusha

     Hiii All

     When i tried to instal SQl server 2008 with windows xp sp-3 i got an error saying “Read error in G:/sql/SQLserver 2008.rar

     
     
122. on June 30, 2011 at 11:25 am | Reply Anand

     This installation steps for SQL 2008 has helped me a lot …… Thanks a lot

     
     
123. on July 2, 2011 at 12:58 am | Reply Matthias Fleschütz

     Sorry, to say that, but:
     The way you described setting the users is definitely the way you should NOT do it…it is hardly recommended to use a different user for each service!

     
     
124. on July 6, 2011 at 7:08 pm | Reply IGV Systems

     The images are not coming up, only getting the red X icons on this page.

     
     
     • on July 7, 2011 at 2:42 pm | Reply madhivanan

       They are displayed correctly. Check your internet policy and see if they are blocked

       
       
125. on July 16, 2011 at 3:00 am | Reply balaji

     Dear sir/madam

     Sql installation am getting this below error

     error 03 how can i solve ,

     
     
126. on July 19, 2011 at 8:27 pm | Reply Adil

     Hi
     I am installing SQL Server 2008 R2 on Server but When I try to map a Datafile to Shared location it gives an error message that Shared location or in this case Y drive is not a valid drive? I dont want to install Datafiles on C since its not large enough so I want to store all datafile in Shared location but getting error that it is not a valid drive? does it have to do with read write access?

     Appreciate your input.

     
     
127. on July 20, 2011 at 11:17 am | Reply Piyush Bajaj

     Hey Pinal,
     Its a very nice blog and quite useful.
     Well i have also posted an article based on the same topic.
     So the link is:
     www. sqlservergeeks .com/articles/ sql-server-bi/32/installation-guide-for-sql-server-2008

     
     
128. on July 21, 2011 at 2:22 pm | Reply lark77

     Thank you so much finally i am able to install SQL Server in my system.
     Wish u had a live video demonstration it would be much more helpful as we would be able to understand what exactly is goin on

     
     
129. on July 22, 2011 at 6:56 pm | Reply David Davis

     If you are trying to install SQL-2008 and you also have visual studio 2008 installed with service pack one (SP1) and get the error

     “A previous release of Microsoft Visual Studio 2008 is installed on this computer. Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008”

     Then welcome to the Microsoft beta testing program even if you purchased the faulty software.

     With XP the most common solution seem to be renaming the registry key
     HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VS\Servicing\9.0
     And replacing ‘9.0’ with ‘9.0Old’ however this does not solve the problem if you are using windows 7 and the only solution I managed to find that worked was to uninstall VS2008 and all the components and to then install SQL-2008 and finally reinstall VS2008.

     
     
130. on July 28, 2011 at 4:06 pm | Reply srichandar

     This really has made a gr8 help to me..
     thanks dude..

     
     
131. on July 29, 2011 at 7:21 pm | Reply Pramit

     Nice Blog..
     Thanks

     
     
132. on August 1, 2011 at 2:20 pm | Reply nitin

     Really Helpful
     Thanks

     
     
133. on August 4, 2011 at 11:45 am | Reply uday

     Hi,

     Myself uday,I want to install on SQL server 2005 on windows 7 of 64 bit.Can u help me.when i try to install in get the error message i.e “The program you want to run is not compatible”.

     Kindly provide your suggestion on this.

     Thanks
     Uday

     
     
134. on August 5, 2011 at 7:33 am | Reply Web Developer

     Make sure you meet all of the requirements first, operating system, memory, ect.

     
     
135. on August 9, 2011 at 2:06 pm | Reply Ganesan K

     very good article. it was helped me to install sql server 2008.

     Thank you

     Ganesan K

     
     
136. on August 11, 2011 at 1:16 am | Reply steve

     thank you friend; i was stuck at the server configuration screen trying to avoid account/password setup for my standalone pc and you saved me!

     
     
137. on August 19, 2011 at 11:31 am | Reply Achea

     good but You have to explain what to do at each diagram

     
     
138. on August 31, 2011 at 3:23 am | Reply Santana

     After the installation of MS SQL Express 2008, how do I do the settings below?
     SAPWD=
     SECURITYMODE=SQL
     DISABLENETWORKPROTOCOLS=0

     Thanks

     
     
139. on August 31, 2011 at 10:55 am | Reply Thusitha

     This is a superb guide. Thanks

     
     
140. on September 7, 2011 at 9:02 pm | Reply khurram

     Its easy and workable………… thanks

     
     
141. on September 10, 2011 at 2:30 pm | Reply dinesh

     i am not applicable for Sa user

     
     
142. on September 11, 2011 at 2:31 pm | Reply Vic

     Database Engine – Failed
     Full Text – Success
     Replication – Failed
     Analysis Service – Success
     Reporting Services – Failed
     Integration Services – Skipped
     Client Tools – Skipped
     SQL Server Books Online – Skipped
     BIDS – Skipped

     Please help… What did i do wrong and how can i correct this?

     
     
143. on September 19, 2011 at 4:06 pm | Reply pavan

     i am install .net frame for 64 bit win7 but there is error that the set up will say it is all ready install and after installing sql 2008 it say install .net framework ,so what can i do

     
     
144. on September 28, 2011 at 7:32 am | Reply sumanth

     Hi Pinal,

     After installing sql server 2008 in windows 7,I cant able to access the database using windows authentication and sql server authentication .This is the error coming,so help me plz

     TITLE: Connect to Server
     ——————————

     Cannot connect to PRAVEEN-PC\PRAVEEN.

     ——————————
     ADDITIONAL INFORMATION:

     A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

     For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

     ——————————
     BUTTONS:

     OK
     ——————————

     
     
145. on September 28, 2011 at 9:28 am | Reply jubpas

     I have installed the SQL Server 2008 on Windows XP successfully in just one go. I am lucky to access the database from my VB6 application running on the same machine. But I am unable to connect to this SQL Server from a remote Window XP machine. Any one help me how to connect to

     
     
     • on September 28, 2011 at 5:10 pm | Reply madhivanan

       Make sure that the system where the application is deployed has enough permission to access the server. Also did you get any error?

       
       
       • on October 9, 2011 at 2:52 pm | Reply jubpas

         Thank you very much

         
         
146. on September 30, 2011 at 1:51 am | Reply bala

     very goooooooooooooodddd

     
     
147. on October 11, 2011 at 7:29 pm | Reply sareshwathi2011

     Hi…
     I have installed sql server 2008 R2 (sql management studio _X86 ENU) in windows 7 Home premium.
     I mentioned server name as (local).
     While connecting i am getting the following error.

     cannot connect to (local)
     Additional information
     network related or instance specific error has occurred while establishing connection to sql server.server was not found or not accessible.Verify that the instance name is correct and that SQL server is configured to allow remote connection.(Provider:Named Pipes Provider,error-40-could not open a connection to Sql server)(Microsoft sql server,error:2)

     Then i changed server name as (local)\sqlexpress.
     Now i am getting getting error message as follows.

     cannot connect to (local)
     Additional information
     network related or instance specific error has occurred while establishing connection to sql server.server was not found or not accessible.Verify that the instance name is correct and that SQL server is configured to allow remote connection.(Provider:Sql Network interfaces,error-26-Error locating server/instance specified)(Microsoft sql server)

     Kindly assist me to resolve this issue.
     Thank You.

     
     
148. on October 12, 2011 at 3:15 am | Reply Gopal Ghelani

     hi friends,

     i m trying to install the sql server 2008 in microsoft vista but it gives me a error
     “Wait on the database Engine recovery handled fail” so please give me a suggestion what i have done wrong and how can i solve this problem.

     Thank you!

     
     
149. on October 18, 2011 at 6:19 pm | Reply STR

     hi

     i unable to install sql server 2008 on windows xp sp3.

     the following system configuration i have:

     1.Internet Explorer 8.0
     2.windows installer 4.5
     3.Microsoft .NET Framework 3.5 SP1
     4.MSXML 4.0 SP2 Parser SDK

     Problem:
     When i clicked on Setup file (native SQL install bootstrapper) nothing was opened and it just shown anything.

     I tried to install as administrator and Firewall also OFF.

     Please help me out.

     
     
150. on October 19, 2011 at 9:45 am | Reply doy

     less any explanation on each image. euh -______-

     
     
151. on October 31, 2011 at 4:30 pm | Reply harsh jhaveri

     Is it possible to install sql server 2008 when already 2005 and vs 2008 installed ?

     
     
     • on November 1, 2011 at 7:41 pm | Reply madhivanan

       Yes you can install it as a new instance

       
       
152. on November 4, 2011 at 2:30 pm | Reply rinku

     thanks

     
     
153. on November 7, 2011 at 4:27 pm | Reply manpreet

     On my machine SQL server was working fine when I installed it first time later on I uninstalled .net and sql and reinstalled sql i was not able to restore the datbases. So again I have uninstalled and also after uninstalltion deleted folder created in program files.While trying to install it again I am not able to use default instance it gives me error that instances are already in use.Could you please tell me what I should do to get use of default instance of SQL sever 2008.

     
     
154. on November 9, 2011 at 10:43 am | Reply Nitesh Kanal

     Working Fine!! Thanks a lot buddy… :)

     
     
155. on November 9, 2011 at 2:05 pm | Reply rajasekar

     excellent work

     
     
156. on November 14, 2011 at 11:32 am | Reply rajesh

     Hi Pinal,

     Need your quick suggest, does Mssql 2008 R2 inplace upgrade requires SSL reconfigure?

     
     
157. on November 15, 2011 at 2:57 am | Reply punith

     thanx dave……

     
     
158. on November 16, 2011 at 6:29 pm | Reply vaibhav

     it was very helpful.

     Killing one of the msi.exe service helped

     
     
159. on November 21, 2011 at 6:47 pm | Reply Sudarshan S

     Sir ,

     Can you also please tell me how to install a sql server 2005 on a machine which has got sql server 2008 already installed.

     
     
160. on November 22, 2011 at 12:16 pm | Reply SVK

     i have installed & uninstalled sql server 2008 7 times but same thing repeats
     if i select Management tools i get the error message Previous version of vsiual studio 2008 failed
     if i dont select the Management tools option Sql get installed sucesfully but without ssms.exe
     i even tried regedit with SPINDEX & SP values but still same
     i tried everything available online but the issue persists

     my system has visual studio 2008 already installed

     
     
161. on November 23, 2011 at 11:49 pm | Reply Arun

     Dear All

     i have installed sql server 2008 r2 on 64 bit windows 7. i connect on local computer with no network means Ncomputing network with RDP. sql is running fine on local server but not work on remote desktop ncomputing. please suggest what can i do in this case.

     Regards
     Arun

     
     
162. on November 24, 2011 at 5:51 pm | Reply Paritosh

     HI ALL:
     Can any body can tell me how to find the edition of SQL Server 2008r2 from Setup files. means is it STD or ENT edition.without installing the software

     
     
163. on November 25, 2011 at 1:33 pm | Reply bayisa

     how to install 2008 server

     
     
164. on November 25, 2011 at 8:43 pm | Reply sqllover

     TITLE: Microsoft SQL Server 2008 Setup
     ——————————

     The following error has occurred:

     Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

     For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22&EvtType=0xD15B4EB2%25400x4BDAF9BA%25401306%254024

     ——————————
     BUTTONS:

     OK
     ——————————

     
     
165. on November 28, 2011 at 3:15 pm | Reply Sk

     Thank you

     I trying to install SQL Server 2008 on Windows 7 ultimate 32bit but it doesn’t want to when it surpose to install Setup Support Files. Also doesn’t want to install MS Visual Studio 2008.

     What could be the problem

     Please help

     
     
166. on December 1, 2011 at 4:26 pm | Reply Akshay

     hi
     I’m trying to install sql server 2008 on vista and at the time of final installation it is showing “is not a valid login or you don’t have permission” hey dude please help me…
     Akshay

     
     
167. on December 15, 2011 at 1:44 am | Reply irshad kanwal

     very very thanx sir penal dave ,,,you solved my problem ,,so nice of you…
     this is very useful …

     
     
168. on December 17, 2011 at 2:31 pm | Reply soma

     its worked out thanks…
     good document for fresher

     
     
169. on December 21, 2011 at 4:32 pm | Reply aqeel

     very nice……….thank u alot!

     
     
170. on December 28, 2011 at 9:42 am | Reply pradeep naidu

     thanks its very help u so nice

     
     
171. on January 15, 2012 at 6:57 pm | Reply baber

     i have server 2008 server ent. now my SQL is not opening, cannot connect to database. what to do

     
     
172. on January 20, 2012 at 11:04 am | Reply Tilli

     Hii,
     Very nice post, and nicely explained with the help of images.

     
     
173. on January 21, 2012 at 11:17 pm | Reply aqeel

     thank you allot

     
     
174. on January 24, 2012 at 12:46 am | Reply riya

     sqqlserver instance name is allready exist for this m getting problem..so give solution 4 dis…plz

     
     
175. on February 7, 2012 at 12:50 am | Reply Hammad

     Plz Sir ! I need your help, I tried this procedure but failed to Install.. Got several errors during Installation…
     Help Plz…

     
     
176. on February 10, 2012 at 8:26 pm | Reply Alex Costa

     I need help, please! I have installed the program, but I am stuck at the screen where it’s asking for server name. I downloaded to my laptop, I don’t know what name to put, and the installation will not be completed until I do so. Thank you.

     
     
177. on February 12, 2012 at 6:20 pm | Reply Subhash

     Thanks a lot Pinal.

     
     
     • on February 13, 2012 at 12:15 am | Reply Alex Costa

       My question is: the installation process asks me to put down a server name. I have downloaded the program into my laptop, what name should I put when it asks for the server name? Where should I go to to find that name? Thank you.

       
       
178. on February 18, 2012 at 1:49 pm | Reply Sripathy Iyemgar

     Hi Dave,
     I am still having problems installing SQL Server 2008 R2. No matter what I do i keep getting the following message:
     “Specified Credentials that were provided for the SQL Server Service are not valid.
     Provide a valid Account & PW
     Error 0x84B40000

     Am installing on Server 2003 SP2. Part of a Domain. No internet access.
     Appreciate any help

     Sripathy

     
     
179. on February 27, 2012 at 9:29 pm | Reply praveen

     Thanks Pinal,
     It really helped me a lot….

     
     
180. on March 1, 2012 at 8:22 pm | Reply Bereket

     Hi…
     I have installed sql server 2008 R2 (sql management studio _X64 ENU) in windows 7 ultimate.
     I mentioned server name as (local).
     While connecting i am getting the following error.

     cannot connect to (local)
     Additional information
     network related or instance specific error has occurred while establishing connection to sql server.server was not found or not accessible.Verify that the instance name is correct and that SQL server is configured to allow remote connection.(Provider:Named Pipes Provider,error-40-could not open a connection to Sql server)(Microsoft sql server,error:2)

     Kindly assist me to resolve this issue.
     Thank You.

     
     
181. on March 7, 2012 at 11:53 am | Reply M.R

     Hi,
     This post was very useful, but images not load now… :(

     
     
182. on March 10, 2012 at 1:42 am | Reply raja

     I installed SQL server 2008 R2 Evaluation version on my Windows 7 home OS .The installation went successfull..when i go to Start > All programs > Microsoft SQL Server 2008 R2 folder is is empty..i dont know why..but when i go ro Run command and type ssms.exe the management studio opens up.
     Can anybody help me out why i am not able to see anything under SQL Server 2008 folder in programs?

     
     
183. on March 14, 2012 at 7:59 pm | Reply Bhushan

     Thanks Pinal,
     Your post helped us a lot in installing sql 2008 on windows server 2008 R2.

     
     
184. on March 16, 2012 at 8:01 am | Reply Emping

     Dear All need your advises as I can not connect to my SQL Server 2008R2 here is the situation:

     SQL Server 2008 R2 64 Bit installed in Windows 2008 Server (64 Bit)

     Installed SQL client 2008 R2 in Win XP SP3 (32 BIt)

     I can not connect to server SQL 2008 Server with this XP work station, although the server browser services was started, but can connect to other SQL server with 32 Bit environment.

     Kindly advice for solving this problem

     
     
185. on March 17, 2012 at 10:11 pm | Reply JoseLuis

     Thanks Pinal

     
     
186. on March 18, 2012 at 12:20 pm | Reply Akshay

     Thanks Mr. Pinal Dave for guidance.
     Keep posting good articles like this one !!

     
     
187. on March 19, 2012 at 7:19 pm | Reply kartheek

     Hi All,
     I am unable to install SQL server 2008 r2 on windows server 2003 64 bit os(Vitual machine)
     I have installed
     .net framework 3.5 sp1
     MSXML 6.0
     windows installer 4.5

     I got the following error
     TITLE: SQL Server Setup failure.
     ——————————

     SQL Server Setup has encountered the following error:

     Failed to retrieve data for this request..

     
     
188. on March 24, 2012 at 2:03 am | Reply Bill Iaquinto

     Hi, I am trying to install SQL server 2008 R2 full eval and everytime I get the error at the end of the install saying can not connect to server, uninstall and reinstall software. Please help thanks.

     
     
189. on March 25, 2012 at 4:40 pm | Reply niyifasha Robert

     Hi, how to connect web base application(made in php and html) with sql server 2008 r2
     thx Robert

     
     
190. on March 29, 2012 at 3:53 pm | Reply kiran k

     when i instaling sql server 2008 it gives collation related error message.
     what do i need to do to instal sql 2008 in my system. my system have
     win7 os

     
     
191. on April 2, 2012 at 2:01 pm | Reply Darshit Pandya

     Hi Pinal,

     I am unable to install ms sql server 2008 in my system. As I am using Windows vista home basic x64 . I have also installed .net framework 3.5 sp1 So is there any specific installation guide?. Please let me know ASAP.

     
     
192. on April 3, 2012 at 2:44 pm | Reply jatin

     thanks bro

     
     
193. on April 6, 2012 at 12:41 pm | Reply sindhu

     hi…
     i have created a database…no one is able to submit data there apart from me…they get a error ” a network related/instance specific error…” i am using vb 2010 ans sql 2008 r2..plese help me

     
     
194. on April 16, 2012 at 12:45 pm | Reply ashok kumar

     UR SQL DB is not responding,is it local or server.

     
     
195. on April 28, 2012 at 9:11 pm | Reply Tia

     hi,
     i have installed sql server 2005 but it is not connecting to database engine giving server name error. please help me to resolve it

     
     
196. on May 1, 2012 at 11:59 pm | Reply Gourav

     Really Helpful Pinal, Thanks a lot

     From Gourav

     
     
197. on May 4, 2012 at 6:33 pm | Reply vyas

     i have faced an error which gives like this:
     windows could not start the sql server on local computer(MSSQLSERVER),review the system event log
     service specific error code 3414.

     what should i do? i could not find my local server.i need help.please give me
     the steps in order to connect to my local server

     
     
198. on May 7, 2012 at 9:28 am | Reply Waquar

     Hii pinal ….the all I can say is you are awesome created!!!

     
     
199. on May 7, 2012 at 11:26 am | Reply Swapnil Gujar

     thanks a lot for this superb presentation!!! it was indeed of help
     Thanks a lot again.

     
     
200. on May 10, 2012 at 7:45 pm | Reply sriram

     thanx…………. for information………but some screenshots are missed……….

     
     
201. on May 15, 2012 at 4:07 pm | Reply Bhavesh Hariyani

     Thanks Pinal ….

     
     
202. on May 16, 2012 at 8:54 pm | Reply alex.lopex

     Hi I have such a problem with the error “Invalid user name or password or need. To continue, provide valid credentials for the SQL Server Agent service.
     I agree I have tried many solutions
     put on a NT Authority / System or NT Authority Network Service?
     please help thanks

     
     
203. on May 19, 2012 at 1:24 pm | Reply ABDUL SAMAD KHAN

     Very Helpful. Thanks

     
     
204. on May 21, 2012 at 3:07 pm | Reply surya

     i installed sql server 2008 for connecting sql server database with java jdbc program. But it displays login fail error…
     any one can answer this…..?

     
     
205. on May 27, 2012 at 7:16 pm | Reply Alexis Leno

     I’ve installed Microsoft SQL Server 2008 R2 and rebooted. Upon reboot, I only have the Installation Center in my Program Files. When trying to upgrade my installation, it asks me to Browse for the Installation Media. Do you have any idea on where the Installation Media might be?

     
     
206. on June 6, 2012 at 4:35 pm | Reply Divya

     Thanks alot,it was very helpful ..is that same case with windows 2007 ?

     
     
207. on June 17, 2012 at 11:53 am | Reply amol Mehare

     HI,
     I am amol Mehare
     it is nice one

     
     
208. on June 18, 2012 at 5:05 pm | Reply Balpreet Kaur

     but if there is an error at the end of the installation that your system is in single user mode . you cant logged in …. then wat shuld i do … ????
     please resolve this problem

     
     
209. on June 20, 2012 at 3:02 pm | Reply madia1902

     i have installed the sql server 2008 r2, i had only one default instance. how can i get more instance? where can jeg install more instance? please show me step by step.. thankxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

     
     
210. on June 22, 2012 at 11:46 am | Reply rohit

     hey, my installation has failed on installation rules step.
     error is previous release of microsoft visual studio 2008.
     plz help me

     
     
211. on June 25, 2012 at 9:01 pm | Reply Pierre

     An array of screen shots without explanation served no purpose at all. I dumped this and winged it successfully myself. This blog, I conclude is just internet noise.

     
     
212. on August 2, 2012 at 6:00 am | Reply Amiya

     Thanks …..
     Finally i can start preparing for 70-448.
     God Bless u :)

     
     
213. on August 5, 2012 at 11:10 am | Reply wojohullah

     hello sir thanks from you outstanding information about SQL server.
     we use open sources SQL server and i have some difficulties regarding restoring the date and i have problem to create users if you guide me thanks

     
     
214. on August 8, 2012 at 11:36 am | Reply Murugan

     Hi Pinal,

     very helpfull. Thank you

     
     
215. on August 8, 2012 at 7:37 pm | Reply maclaure

     Hi Pinal,

     thanks a lot for the info.

     
     
216. on August 15, 2012 at 12:36 pm | Reply sunil bhavsar

     thanx………..
     its vary usefull post

     
     
217. on August 17, 2012 at 12:31 pm | Reply Matt B B

     It was really helpful.
     Thanks :-)

     
     
218. on August 17, 2012 at 3:42 pm | Reply Gajendran

     I am installing as given above. In “Installation Progress ” step after a few seconds in “validating feature setting” i get the error:
     “The folder path specified is invalid. Please enter a valid folder path.. Folder Path=C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data”. If anyone know the solution , please help

     
     
     • on August 17, 2012 at 3:43 pm | Reply Gajendran

       I am installing SQL Server 2008 R2… The same I have installed in another server and it works without any error.

       
       
219. on August 18, 2012 at 12:19 pm | Reply Kandhavel

     Thanks a lot for ur work
     During installation progress,it shows few error regarding this package
     i have tried this with SQL 2008 R2 developer version

     
     
220. on August 21, 2012 at 3:29 pm | Reply mukesh

     TITLE: Connect to Server
     ——————————

     Cannot connect to MUKESH-PC\SqlExpress.

     ——————————
     ADDITIONAL INFORMATION:

     A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

     For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

     ——————————
     BUTTONS:

     OK
     ——————————

     
     
221. on August 26, 2012 at 11:39 am | Reply Ajitkumar

     Hi Pinal,

     thanks a lot for the info….

     
     
222. on August 28, 2012 at 7:46 am | Reply myseoinnovation

     Hi Pinal,

     I have installed SQL Server 2008 r2 as per your instruction and all process have done successfully but when i tried to connect showing “Login failed for user HOME-B076483C3F (Microsoft SQL Server, Error: 18456). So please suggest me what should i do now…

     
     
223. on August 28, 2012 at 7:29 pm | Reply Matt B B

     Hi,
     Nice document. it really helped me. can you tell me if there is any link for the
     installation of VS_2008_SP1.

     
     
224. on September 10, 2012 at 12:47 pm | Reply sivakishore

     hi

     i installed sql server 2008 in my system.
     i worked on ssrs reports for some days.
     in those days i used windows credencials to login to report server

     now those windows credencials are not accepting

     can u ply help me in this issue.

     at the same i install that one in sever system also
     in server system it is working fine.

     can u ply help me how to resolve it

     
     
225. on September 11, 2012 at 12:32 pm | Reply nandana

     i am trying to install sql server 2008 in my windows xp operating system but always i fail due to the error upgrade to .net 2008 sp1 but already i installed sp1 for .net still the same error is coming what to do?????????

     
     
226. on September 18, 2012 at 12:26 pm | Reply Anton

     Thanks, big help for me :)

     
     
227. on September 20, 2012 at 6:12 pm | Reply jigar

     Ever green post.. works even in 2012 (Year)… Thanks

     
     
228. on September 21, 2012 at 2:01 pm | Reply kris

     thnx its nice

     
     
229. on September 23, 2012 at 11:02 am | Reply anamika

     can some one help me out in letting me know about the process of downloading sql server 2008 to winodws xp, what are all the s/w i require and and how to proceed further

     
     
230. on September 25, 2012 at 6:43 pm | Reply kousik Acharjee

     Thanks, it is a very helpfull manual

     
     
231. on October 1, 2012 at 10:37 pm | Reply LordDart

     Hi,

     When I try to install sql server 2008 in Win 7, I get this error:

     The folder path specified is invalid. Please enter a valid folder parth Folder Path=C:\Program files\microsotsql server\msas10.mssqlserver\olap\data
     Error code 0x84b4000

     Thanks for your help.

     
     
232. on October 6, 2012 at 11:41 am | Reply Sana Shahzadi

     thank you very much this tutorial helps me very much .. and it releases most of my tension. :)

     
     
233. on October 7, 2012 at 12:47 pm | Reply ajay

     hey ! whenever I follow the installation process by clicking on new Sql Server Standalone installation i get up a pop-up window “browse for sql server installation media” instead of “setup support rules window” as shown above..
     Can anyone tell me what i am doing???

     
     
234. on October 8, 2012 at 2:01 pm | Reply Jatinder Singh

     THANKS SIR
     VERY NICE STEPS TO INSTALL SQL SERVER 2008

     
     
235. on October 13, 2012 at 9:57 pm | Reply Ravinder

     Thanks thats wonderfull …. so helpfull..

     
     
236. on December 2, 2012 at 1:33 am | Reply Amit

     I am getting error “sql server 2008 setup requires microsoft .net framework 3.5 sp1 to be installed” when i tried to run Setup.exe.
     I already have .Net framework 4.0 installed.
     I have downloaded .Net framework 3.5 from Microsoft site but it is not opening on my machine when i double click it for installation.
     I read some blogs for this error, it says open the Server Manager and add .Net Framework 3.5 feature from there, but Server Manager is not listed in my Administration Tools.
     Can someone please help me here.

     
     
237. on December 5, 2012 at 2:25 pm | Reply kiran murthy

     very nice….
     it is very use full for installation of sql server

     
     
238. on December 7, 2012 at 4:40 pm | Reply syed

     when we configure the Authentication of the sql Server from Windows Authentication to Mixed Mode Authentication whether it reflect to the Exist database running of the Sql Server

     Kindly reply me back on this

     
     
239. on December 18, 2012 at 11:31 am | Reply sarada

     It was very useful to me.Thank u.

     
     
240. on December 18, 2012 at 11:48 pm | Reply malu

     thank u……….. sir it was very useful

     
     
241. on December 19, 2012 at 4:59 pm | Reply sampatty

     It is also working for SQL server 2008 R2 ?

     
     
242. on December 24, 2012 at 1:20 pm | Reply teg singh bisht

     hi pinal..i have a questtion..
     earlier i was using sql server 2005..when i right click on database i can see properties windows ..there i was getting features “mirroring and transactional log shipping” ..now i have installed sql server 2008 enterprise edition..now when i right click a database and i look at properties i cant find same two features….. in enterprise edition of sql 2008…help me which sql 2008 version i should install to get that feature………………

     
     
243. on December 27, 2012 at 1:55 pm | Reply roshanth

     thanks dude….

     
     
244. on December 27, 2012 at 3:46 pm | Reply chandu

     How to resolve the fallowing error in sql server 2005 “this message cannot be copied to the clipboard. (Microsoft SQL Server Management Studio)

     ===================================

     Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it. (System.Windows.Forms)

     ——————————
     Program Location:

     at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy, Int32 retryTimes, Int32 retryDelay)
     at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy)
     at Microsoft.NetEnterpriseServers.ExceptionMessageBoxForm.CopyToClipboard()
     “

     
     
245. on December 28, 2012 at 5:05 pm | Reply Krishna Kumar

     Thanks you for your great work

     
     
246. on December 29, 2012 at 5:12 pm | Reply Shams Surani..

     M very thankful for your help for sqlserver 2008r2 installation… thanks for making easy step-by-step instructions.. :)

     
     
247. on December 31, 2012 at 10:50 pm | Reply kevin

     Hi, on the server configuration does not accept any account name.
     what should I do? I am a beginner :)

     
     
248. on January 9, 2013 at 2:43 pm | Reply Aimama

     i have installed SQL server 2008 but my server name is not valid as u giver (PINAL) please help me what i do..

     
     
249. on January 15, 2013 at 7:21 pm | Reply Mari

     My server is blocked. Error message is License invalid. How to recover the sql. please help me

     
     
250. on February 5, 2013 at 3:07 pm | Reply miran

     Very Usefully..thanks a lot…

     
     
251. on February 7, 2013 at 1:26 pm | Reply saravanan.msk10@gmail.com

     Thank u for ur installation step for sql server…. insatalled successfully in my laptop….

     
     
252. on February 7, 2013 at 8:38 pm | Reply Lava

     This is nice for someone who just wants to do simple installation, it would have been helpful if there were some extra comments and screenshots about some options such as placing data, log and other files on seperate drives. I can’t complain though as Pinal Dave does a GREAT job documenting and sharing his knowledge. THANK YOU.

     
     
253. on February 8, 2013 at 9:57 pm | Reply prasad

     Can any one tell me i have windows 7 OS which version of server server i need to install for complete reporting service every thing please provide me link of software sql server 2008 download

     
     
254. on February 9, 2013 at 10:36 am | Reply aroop

     thnx ….finally i installed sql on my acer. Great work …thnx again

     
     
255. on February 22, 2013 at 10:03 pm | Reply Sudharsanan

     thnx ….finally i installed sql
     thnx again

     
     
256. on February 26, 2013 at 1:30 pm | Reply Nikhil

     Thanks a lot

     
     
257. on February 27, 2013 at 9:46 pm | Reply mrbronz

     How useless is this… just a bunch of jpg’s??? where is the step by step guide?

     
     
258. on March 5, 2013 at 9:42 pm | Reply imroz

     thanks dear …….without your this image i cant install .

     
     
     • on March 15, 2013 at 2:34 pm | Reply Binay

       Hi, while I am trying to install SQL Server 2008 R2, getting the following error.
       Please suggest me to resolve this issue.

       The following error has occured:

       Error 1935.An error occured during the installation of assembly

       ‘Microsoft.VisualStudio.Tools.Applications.Contract.v9.0,version=”9.0.0.0″,publicKeyToken=”b03f5f7f11d50a3a”,processorArchitecture=”MSIL”,fileVersion=”9.0.30

       729.4462″,culture=”neutral”‘. Please refer to Help and Support for more information. HRESULT:0×80070005

       Thanks in advance.

       
       
259. on March 21, 2013 at 10:47 pm | Reply Sruthi

     Thanks a lot!!! This really helped me a lot! :)

     
     
260. on March 22, 2013 at 4:31 am | Reply Hoa Ngo

     Your installation guide just worked great for me
     Thank you
     Hoa Ngo

     
     
261. on March 26, 2013 at 4:10 pm | Reply Ram

     Thanks a lot!

     
     
262. on April 9, 2013 at 1:39 pm | Reply Leebico

     Thank you very much.. Very easy to follow ;)

     
     
263. on May 10, 2013 at 8:00 am | Reply S Sudharsanan

     Thanks sir
     And 1 more request is dat i want step by step process for upgrading SQL 2008 to 2008 R2

     
     

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

Notify me of follow-up comments via email.

Notify me of new posts via email.