Can't Connect to SQL 2005 Express Edition via Server Manangment Studio

I have installed SQL 2005 Express Edition on a Windows 2003 Web Edition server. Everything installed correctly, no errors to be found. I also have:

Local & Remote Connections using TCP/IP only turne don

SQL Browser is running as well.

I have tried connecting with the most recent CTP of Microsoft SQL Server Management Studio Express 9.00.1399.00

When trying to connect using the SA account I recieve:

'An error has occured 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)

After that failed I tried creating a connection locally on the server using ODBC Manager with no luck as well.

Microsoft SQL Native Client Version 09.00.1399

Running connectivity tests...

Attempting connection
[Microsoft][SQL Native Client]TCP Provider: No connection could be made because the target machine actively refused it.

[Microsoft][SQL Native Client]Login timeout expired
[Microsoft][SQL Native Client]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.

TESTS FAILED!

Any help would be appreciated.

Try this.

Start > All Programs > Microsoft SQL Server 2005 > Configuration tools > SQL Server Surface Area Configuration

Then click Surface Area Configuration for Services and Connection. Select your instance of sql server (by default MSSQLSERVER). Then expand Database Engine and click on remote connections. On the right side select Local and remote connections > Using both TCO/IP and named pipes.

|||

I'm having the same issue, i've tried all of the above. My server has 9 active IP addresses, and I've tried connecting to the one which I use to remote in to the server. Is this the correct approach?

Also, in the SQL Server Configuration Manager, I've set that IP address to 'Active' and 'Enabled' with no luck. Same error as the gentleman above.

Any other suggestions?

Thank you,

Bret

|||I still can't get it to work. I've even tried the old remove and reinstall approach. This is very aggravating as I've tried everything under the sun that I can think of.|||

Got it working:

Under Protocols for SQLEXPRESS and tcp/ip and the ip addresses tab

Tcp dynamic ports – set to blank

Disabled other ips except the loopback

At the bottom, set dynamic ports to blank and the tcp port to 1433

Stopped and restarted the sql server.