Symptoms
When you try to install Microsoft SQL Server 2008 on a computer that is running Windows Server 2003 by using the New SQL Server Installation Center option in Windows Explorer, you receive the following message:
Access Denied
Resolution
This problem occurs because the Internet Explorer Enhanced Security Configuration featureis enabled.
Symptoms
When you bind a DateTimePicker control to a data source, you may receive the following error message:
An unhandled exception of type ‘System.InvalidCastException’ occurred in mscorlib.dll
Additional information: Object cannot be cast from DBNull to other types.
Resolution
This behavior occurs if the field that is bound to the DateTimePicker control contains a null value that is represented by the System.DBNull object. The DateTimePicker control does not support the System.DBNull object.
Symptoms
When you install Microsoft SQL Server 2008 Express, the default instance name is set incorrectly to SQLEXPRESS.
Resolution
This problem occurs because of a bug in SQL Server 2008 Setup.
Symptoms
When you try to connect to MicrosoftSQL Server Compact 3.5 Service Pack1 (SP1) from SQL Server Management Studio in Microsoft SQL Server 2008, you may receive an exception error message that resembles the following:
Unable to load Microsoft SQL Server Compact. Install Microsoft SQL Server Compact MSIs from the folderServers\Setup on the SQL Server installation media. For more details, refer to KB Article 952218.
Resolution
This problem occurs because SQL Server Compact 3.5 SP1 or SQL Server Compact 3.5 SP1 Query Tools is not installed on the computer that is running SQL Server 2008.