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.

Can't connect to MySQL 2005 Express

I'm trying to upsize an Access database to SQL 2005 Express. When I follow the wizard and I've tried all ways of connecting to the database I get the following error

Connection failed
SQL State '01000'
SQL Server Error 53
[Microsoft] [ODBC SQL Server Driver][DBNETLIB] ConnectionOpen()).
Connection failed
SQL State '08001'
SQL Server Error 17
[Microsoft] [ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or access denied

I've tried using local host and typing the exact server connection string from the SQL Express Management tool and nothing is working

How come I can't do this? Everyone says this is easy and straight forward -- not for me.

The most common cause of this is using the wrong instance name. SQL Express installs by default to an instance name of SQLEXPRESS that you must specify when connecting. You can not use the machine name alone, or just (local) for example.

When the Upsize wizard asks for the server, specify

<machinename>\SQLEXPRESS

and see how that works.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!