Can't connect to SQL Server 2005 Express

PLEASE HELP ME

I ran the upsize wizard on one of my databases to SQL Server 2005 Express. I can connect to it just fine. I have 3 test users and they cannot. They get the following:

Connection failed:

SQL State: '01000'

SQL Server Error: 11004

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connt()).

Connection failed:

SQL State: '08001'

SQL Server Error: 6

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

I tried adding the SQL Server to 1 users System DSN, but I got this message:

Connection failed:

SQL State: '01000'

SQL Server Error: 53

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connt()).

Connection failed:

SQL State: '08001'

SQL Server Error: 17

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

What am I doing wrong?

See my whitepaper on Connecting... http://betav.com/blog/billva/2006/06/getting_and_staying_connected_1.html

I expect that you you have not properly configure the SQL Server instances to be visible on the network--they are hidden by default.

|||

Please follow steps to configure your Server and be aware of firewall issues.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Basically, you need make sure remote connection is enabled and it's not firewalled.