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

SQL SERVER 2008 Release Candidate 0 has been released for some time and I have got numorous request about how to install SQL Server 2008. I have created this step by step guide Installation Guide. Images are used to explain the process easier.

[Click On Images to See Larger Image]

[Click On Images to See Larger Image]

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

342 thoughts on “SQL SERVER – 2008 – Step By Step Installation Guide With Images

  1. Pingback: SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial Journey to SQL Authority with Pinal Dave

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

  2. Hi,

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

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

    Running xp.

    any help would be appreciated

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

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

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

    • @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?

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

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

  9. 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?… :)

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

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

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

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

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

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

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

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

    • 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

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

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

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

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

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

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

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

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

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

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

    • 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

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

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

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

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

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

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

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

  34. 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 :)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  67. 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 …!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  105. 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…..?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  124. 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()

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

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

    • 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:0x80070005

      Thanks in advance.

  127. Hi, I am tired to search sql server 2008r2 right installation link and try many link unfortunately all failed.Can u pls. provide the right link where i can download the .exe of sql 2008r2. pls. help me
    Thanks in advance

  128. Pingback: SQL SERVER – Weekly Series – Memory Lane – #033 | Journey to SQL Authority with Pinal Dave

  129. I have an older PC which I used on some of my projects. The Windows instance got heavily corrupted on it to the point that I cannot use SQL Server 2008 R2, cannot uninstall it or re-installed. It became so bad, that at this point I am planning to completely recreate this PC.
    However, there are SQL Server databases (in fact the whole server instance), which I would like to preserve. I cannot not extract these databases using SQL Server tools, because SQL Server installation is corrupted and tools do not work. I have all the files (mdf, ldf), registry entries (though these may be somewhat corrupted), etc.

    Is there a way to move and use (open, attach, or whatever) these databases on another computer with the valid SQL Server 2008 R2 installation?

  130. I tried installing SQL Server 2008 R2 on Windows XP 32 bit SP3 32 bit pc which already has DotNet Framework 3.5 SP1 in it. But I am getting an error saying ‘Microsoft .Net Framework 3.5 SP1 installation has failed. SQL Server 2008 R2 requires .Net Framework 3.5 SP1 to be installed’

    Can anyone help me ?

  131. Sir,
    I have a problem in installation. In the feature selection step I am not getting all the features. Only a few of them are visible.
    What should I do?

  132. Good job. Just one comment, I think you missed the “Analysis Services Configuration” step. Instead of that you repeated twice the “Database Engine Configuration” step.

    I have taken a print screen of the missed step while I was installing SQL Server, so if you need the image just email me.

    Thanks

  133. I am getting error as :User or group doen’t exists.and not going to next step while selecting Windows authentication mode and Add current user.

  134. Dear Pinal,
    I want to install sql server 2008 on windows server 2008 operation systems. please can u provide me clear steps how to install and connect to with application server.
    please help i am handling a project of 9 clients among which one site is a central site

  135. WHEN I M INSTALLING IT ..IT SHOWS .NER FRAMEWORK 3.5 HAS FAILED THE COONECTION AND IN WINDOWS 8 .NET FRAMEWRORK 3.5 IS NOT WORKING WHAT SHOULD I DO NOW

  136. Hey !
    When I type my Username as server name, it denies an gives error. Though i installed by selecting current user in the mixed mode? Should i reinstall or what ?

  137. I want to install Windows Installer for Sql server2008 OS Windows Server 2008 R2 X64. But when I installed Windows Installer 4.5 will display the following warning:

    the update is not application to your computer

  138. When I drag drop the shortcut file of “SQL Server Management Studio” from the Start Menu,it completely remove from the sql server 2008 file..But unknowingly I deleted the shortcut file of “SQL Server Management Studio” by press shift+delete..Plz help me for backup

  139. when i run my project of .net

    this is error what i get all the time …

    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)

    what to do guys??

  140. i installed SQLserver 2008 with instance name SQLEXPRESS. But after connecting to a small db named DB20032013, it is showing error when i execute below query.
    select * from mas_user.

    but when i changed that to
    select * from DB20032013.mas_user i got result

    can you tell me why?

  141. Very nice document, suggestion : should have little explanation at the bottom of each if there are option if any one can consider

  142. thanks .this really helped me.yes it has installed

    i just renamed the file in regedit and that worked.
    olny problem was showing for windows powershell installation.
    nice page.thanks

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s