Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
install sql server 2008 R2 in windows 8

Answered install sql server 2008 R2 in windows 8

  • Sunday, February 03, 2013 12:24 PM
     
     
    Sign In to Vote
    0

    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 ?

     

All Replies

  • Sunday, February 03, 2013 3:01 PM
     
     
    Sign In to Vote
    0
    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:41 PM
     
     Answered
    Sign In to Vote
    0

    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 5:57 PM
     
     
    Sign In to Vote
    0

    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, March 03, 2013 7:09 PM
     
     
    Sign In to Vote
    0
    NOT WORKING BOSSS...............