Category Archives: SQL Server 2005

Updated database script for shared source ‘Redirect Manager’ module.

Posted on January 12, 2012 by paul

An update SQL create script for ‘Redirect Manager’ module now available. Continue reading →

Posted in Sitecore, Sitecore 6, SQL Server 2005, Web development and programming | Leave a comment

Cannot install Sql server Express 2005 in Windows Server 2008 x64 “cannot continue because the installation package could not be opened….”

Posted on December 22, 2008 by paul

The standard lightweight version of SQL Express 2005 is missing files that are required to install on Sever 2008 x64. You cannot install the lightweight version on server 2008 / 64-bit windows OS. Instead you must simply download the full package … Continue reading →

Posted in ASP.net, SQL Server 2005, Web development and programming | Tagged , , | 1 Comment

Silverlight and LINQ problems: ‘YourDataClassesDataContext’ does not contain a constructor that takes ’0′ arguments

Posted on December 7, 2008 by paul

After rebuilding my DBML file with SQL metal, my DataContext class no longer has a parameterless constructor. This is due to differences between the was that Visual studio generates the DBML (with SQL metal) and how SQLMetal command-line does by default. The parameterless … Continue reading →

Posted in ASP.net, C#, Silverlight, SQL Server 2005, Web development and programming | Tagged , , | Leave a comment

Named pipes / Connectivity error. Cannot see SQL server connection or databases from Visual studio 2008

Posted on December 7, 2008 by paul

Can be caused by the SQL server browser service being disabled.  Set to automatic and start the service. Restart the ‘add connection’ wizard from Visual studio and the local SQL server host and databases should be discoverable again.

Posted in ASP.net, SQL Server 2005, Web development and programming | Tagged , , | Leave a comment