Journey to SQL Authority with Pinal Dave

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

38 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

   
   
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

   
   
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 ..

   
   
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)

   
   
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 = 0×8007000b

    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

    
    
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

    
    
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.