You must Sign In to post a response.
  • Category: SQL Server

    Getting following errors while installing the sql server 2008

    Hi

    Am facing errors while installing the sql server 2008 32 bit in 32 bit windows 7 mixed mode.

    I uninstalled and reinstalled twice but facing the same issue.

    The following error has occurred:
    "is not a valid login or you do not have permission // this occurred while installation is in progress

    After completion of installation it displayed as
    Your sql server 2008 installation is completed with failures.

    When I tried to login by opening management studio its not taking the id and password.
    Even it is not getting accessed with windows authentication also.

    Regards

    Sridhar Thota.
  • #762336
    Hi

    I have attached the snapshot of the final error message which i got after the installation has completed.

    Regards

    Sridhar Thota.

    Sridhar Thota.
    Editor: DNS Forum.

    Delete Attachment

  • #762339
    Hi
    Sridhar

    Did you install Sqlserver 2008 Admin Rights?

    Can you check them then right click sql server 2008 setup run as Administrator then try to install

    when i users add page did you added users for your sql server installation?

    Name : Dotnet Developer-2015
    Email Id :kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • #762342
    Hi

    I used run as administrator while running setup.
    And I added current user option while adding users.
    I didn't set any password.
    If any problem with sql server agent, then it should open when we select as windows authentication but its not accepting.

    Regards

    Sridhar Thota.

    Sridhar Thota.
    Editor: DNS Forum.

  • #762345
    Hi
    Sridhar

    You can go through below links for sql server 2008 Installation error.


    http://serverfault.com/questions/119875/is-not-a-valid-login-or-you-do-not-have-permission-on-sql-server-installati


    http://kb.swiftpage.com/app/answers/detail/a_id/27152

    http://www.sequalserver.com/2010/08/sql-2008-r2-setup-error-is-not-valid.html


    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8b2d89fe-cbe6-4cb6-8828-184358596215/error-installing-sql-server-express-2008-is-not-a-valid-login-or-you-do-not-have-permission?forum=sqlexpress

    Name : Dotnet Developer-2015
    Email Id :kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • #762346
    Hi

    Sridhar

    Try to put username and password while install sql server give different name from your useraccount for the sql server username



    You can go through links for Installation sql server 2008


    http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/

    https://www.youtube.com/watch?v=8WAdeP5YREo


    http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx

    http://www.codeproject.com/Articles/305113/How-to-Install-SQL-server-on-Windows

    Name : Dotnet Developer-2015
    Email Id :kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • #762356
    Hi Sridhar,

    As a Software Developers, it is very difficult to say the exact reason behind this, my request is better to uninstall fully and restart your system and then Install again, when you Add user give proper login details, I hope this will help you to resolve the issue.

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/

  • #762361
    Jayakumar, I googled more than you to find the solution. Please avoid posting links as those already we search in google.

    Yes Naveen. You are right, these type of issues we can solve by ourself if we dig deep in to the root cause.

    Regards

    Sridhar Thota.

    Sridhar Thota.
    Editor: DNS Forum.

  • #762433
    Hello Sridhar,

    It may occurred due to same username if system and sql server, so that you can change your system's username and try to install it again.

    See the attached image.

    Hope this will work for you.

    Regards,
    Nirav Lalan
    DNS Gold Member
    "Failure is the path of least persistence"

    Delete Attachment


Sign In to post your comments