Q:  An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

Iain Kick says:  By default SQL Server 2005 does not allow remote connections. Enable these using the Surface Area Configuration tool.

Technorati Tags:
SQL Server 2005, remote database connections, error handling, Surface Area Configuration
Add to: | Technorati | Digg | del.icio.us | Yahoo | reddit |

Q:  I am developing a web application using SQL Server 2005 Express. When I deploy it I will need to create the database on my host’s database server, which is of course the full editon. How does one go about converting the Express file to a full version database?

Bryan Oliver says:  SQL Server Express uses the same reliable and high-performance database engine as the other versions of SQL Server 2005. It also uses the same data access APIs such as ADO.NET, SQL Native Client, and T-SQL. In fact, it is differentiated from the rest of the SQL Server 2005 editions only by the following:

Lack of enterprise features support
Limited to one CPU
One GB memory limit for the buffer pool
Databases have a 4 GB maximum size

So in other words you have nothing to worry about moving from the express edition to the full version of SQL Server

Technorati Tags:
SQL Server 2005 Express, migration, database engine, API
Add to: | Technorati | Digg | del.icio.us | Yahoo | reddit |