Enabling SQL Server 2008 (R2) access over Network

First: enable SQL Server itself to be accessed over the network Open SQL Server Configuration Manager Expand SQL Server Network Configuration and click Protocols for MSSQLSERVER Doubleclick TCP/IP Set Enabled to Yes Secondly: change the Windows Firewall to allow incoming connections on the TCP port of SQL Server Open Windows Firewall with Advanced Security Click […]

SQL Server 2008 Express Edition: Access over network

To connect to your SQL Server 2008 Express edition over network you need to enable the following options: First: open SQL Configuration Manager (SQLServerManager10.msc): Double click on ‘Named Pipes’ and enable them. ‘ Then click ‘OK’ on the bottom. Now we have the access set up, now we need to start the service. Now open […]

Linq To Entities with a SQL Compact Database

A while ago I wrote this (Dutch) article on how to perform LINQ to SQL for your SQL Compact databases, since Visual Studio did not understand this, we had to do it manually, as described in the article just mentioned. But since the release of .NET Framework 3.5 SP1, and the therein included ADO.NET Entity […]

SQL Server 2008 Express Edition + Visual Studio 2008 x64 User instance problems.

As described in this connect article there is an issue with the integration of SQL Server 2008 Express Edition ans Visual Studio 2008 if you are running on an x64 system (the OS itself! Not runing 32-bit Vista on a Core 2 Duo) (although some report this bug on a 32-bit OS). This issue is […]

SQL Server Management Studio Express 2005 Security Error (29506)

Should you ever want to install SQL Server Management Studio Express 2005 you MUST run it as Administrator. When you try to install it on Vista (by double clicking the .exe) it extracts the files to a temp folder. Then it launches the setup, asking you some questions. After that UAC asks you to gain […]