Does enterprise server support MS SQL 2005?

Last updated: Wednesday, February 22, 2006

TOC :: Up

Does enterprise server support Microsoft SQL Server 2005?

Article Details

Yes you can use Enterprise Server with SQL Server 2005. However, Microsoft made two important changes to the way applications connect to SQL Server in SQL Server 2005.

The interface for the Shared Memory protocol was changed in SQL Server 2005 so you will not be able to connect to SQL Server 2005 using the Shared Memory protocol. This means that you will have to enable the TCP/IP protocol for your SQL Server 2005 database server (which you can do using SQL Server Manager which is installed when you install SQL Server 2005).

In order to be able to connect to named instances of SQL Server 2005 [Express] using the TCP/IP network protocol, you will need to make sure the SQL Server Browser service is enabled and running. The install set for SQL Server 2005 Express will install SQL Server 2005 as a named instance by default (using the instance name is SQLEXPRESS).

As with MSDE 2000 and SQL Server 2000 you will need to make sure Mixed Mode Authentication is enabled, but otherwise you shouldn't have any problems. As always, let us know if you have any difficulties.