SQL Server troubleshooting: Difference between revisions

From Yggenyk
Jump to navigation Jump to search
No edit summary
No edit summary
Line 17: Line 17:
* [http://connect.microsoft.com/SQLServer/feedback/details/375231/installing-sql-server-2008-with-user-name-that-equals-computer-name-fails# Installing SQL Server 2008 with user name that equals computer name fails]
* [http://connect.microsoft.com/SQLServer/feedback/details/375231/installing-sql-server-2008-with-user-name-that-equals-computer-name-fails# Installing SQL Server 2008 with user name that equals computer name fails]


==Repairing SQL Server database==
. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf).
* [http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/290f3875-2c73-4f73-8228-b3713cf7853b/ Database Recovery]
<google>ENGELSK</google>
<google>ENGELSK</google>

Revision as of 09:01, 16 January 2013

Reasons why SQL server installation will fail

A reboot is pending

If something else like a Windows update, ore another program that requires a reboot was installed before SQL server, and scheduled the rest of .dll replacements to happen during next reboot.
Reboot PC before installing SQL server, if it fails, try to reboot again and try once more.

Regional settings not is same as Windows language type

If Regional settings isn't same as Windows language type SQL server will fail to install.
If Windows is (US) the users Regional settings should also be English (US).
The same goes for other regioanl versions of windows.
FIX: If not set regional settings to same as Windows version install SQL server again.
After installing regional settings can be set back.

Username is the same as Computername

Repairing SQL Server database

. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf).

<google>ENGELSK</google>

id=siteTree

Retrieved from "http://yggenyk.dk/index.php?title=SQL_Server_troubleshooting&oldid=6731"