Today I ran the install of SQL Server 2012 RC2 on another computer this time a Windows 7 computer not on a domain.  Here is the trouble that I ran into.   SQL Server Setup has encountered the following error: There was a failure to validate setting CTLRUSERS in validaton function ValidateUsers. Error code 0x85640004.   Then immediately after, I …

Error code 0x85640004 when installing SQL Server 2012 RC0 on a Non Domain Computer Read more »

SQL 2012 Compatibility Level With SQL Server 2012, there was a new compatibility level being introduced, level 110 the new SQL 2012 compatibility level. SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 …

SQL Server 2012 Compatibility Level Read more »