SQL 2005 Express

Just installed SQL 2005 Express and the Management Studio but cannot connect to the server, the error message is "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! Error 26." Any ideas?

Find more posts tagged with

Free for TechExams community: Cybersecurity salary guide

Compare cert salaries and plan your next career move

Button

Comments

Bl8ckr0uter

billybob01 wrote: »

Just installed SQL 2005 Express and the Management Studio but cannot connect to the server, the error message is "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! Error 26." Any ideas?

Is the service running? There is a checkbox if I recall correctly inside the sql server configuration manager which allows remote connections and enables TCP/IP and Named pipes. You might want to check there first.

RobertKaucher

phoeneous wrote: »

Does this help?

SQL Server does not allow remote connections::Resolution

This is a pretty common error. You need to setup TCP/IP in Configuration Manager.

Why are you using 2005 Express? 2008 R2 Express supports larger DBs!