none
install sql server 2008 R2 in windows 8

    Question

  • i am trying to install sql server 2008 R2 in my laptop have windows 8 , but I am trying to setup the NT_Authorizatioh system service or local account or network serive all failed to login < always giving error 1456 , even I try to use the user account login info , but still the same.

    any help ?

    Sunday, February 03, 2013 12:24 PM

Answers

  • Please clarify if the sql setup installtion completed successfully ? If no provide us the setup log details .

    How to: View and Read SQL Server Setup Log Files
    http://msdn.microsoft.com/en-us/library/ms143702(v=sql.105).aspx

    How to: Verify path for SQL Server Error Log Files
    http://blogs.msdn.com/b/varund/archive/2009/03/21/how-to-verify-path-for-sql-server-error-log-files.aspx

    Some Common scenarios of service starup issues !

    •Access denied on the folders for the SQL Server Service Account, specifically on the DATA folder which contains the SQL Server system databases.
    •Due to some other processes like anti-virus holding a lock on the SQL database files.
    •Insufficient permissions granted to the SQL Server Service account.
    •Server side protocols for SQL not set correctly or disabled.
    •Critical system database files not found due to either accidental deletion of files or disk failures.
    •System database files having inconsistencies preventing SQL Server startup.
    •Password of the service account was changed but not updated on the server that has the SQL instance installed.
    •Startup parameters have incorrect file path locations.
    •The SQL Server service is disabled in Service Control Manager.

    Important:
    Always make SQL service account changes via the SQL Configuration manager since only this tool sets the proper permissions or ACL’s to the new service account. Services.msc does not set ACL’s.

    -------------------------

    Thanks,Suhas Vallala

     

     

    Sunday, February 03, 2013 3:41 PM

All replies

  • please share the complete error message? When you installed SQL Server 2008 R2, you must have provided a login as sysadmin, do you remember that?
    Sunday, February 03, 2013 3:01 PM
  • Please clarify if the sql setup installtion completed successfully ? If no provide us the setup log details .

    How to: View and Read SQL Server Setup Log Files
    http://msdn.microsoft.com/en-us/library/ms143702(v=sql.105).aspx

    How to: Verify path for SQL Server Error Log Files
    http://blogs.msdn.com/b/varund/archive/2009/03/21/how-to-verify-path-for-sql-server-error-log-files.aspx

    Some Common scenarios of service starup issues !

    •Access denied on the folders for the SQL Server Service Account, specifically on the DATA folder which contains the SQL Server system databases.
    •Due to some other processes like anti-virus holding a lock on the SQL database files.
    •Insufficient permissions granted to the SQL Server Service account.
    •Server side protocols for SQL not set correctly or disabled.
    •Critical system database files not found due to either accidental deletion of files or disk failures.
    •System database files having inconsistencies preventing SQL Server startup.
    •Password of the service account was changed but not updated on the server that has the SQL instance installed.
    •Startup parameters have incorrect file path locations.
    •The SQL Server service is disabled in Service Control Manager.

    Important:
    Always make SQL service account changes via the SQL Configuration manager since only this tool sets the proper permissions or ACL’s to the new service account. Services.msc does not set ACL’s.

    -------------------------

    Thanks,Suhas Vallala

     

     

    Sunday, February 03, 2013 3:41 PM
  • please read the following article from SQL Server Support Team about installing SQL Server on Windows 8 http://blogs.msdn.com/b/psssql/archive/2012/09/01/installing-sql-server-on-windows-8.aspx


    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Sunday, February 03, 2013 5:57 PM
  • NOT WORKING BOSSS...............
    Sunday, March 03, 2013 7:09 PM