SQL Server 2005 Express Connection problems

Question

Hello,I have been trying for the past 2 hours to connect CFMX 8 to SQL Server 2005 Express on my windows7 laptop and it is throwing all kinds of errors."Connection verification failed for data source: sqlHPV java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Unknown host: SQLExpress The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Unknown host: SQLExpress"Please I need help.

Steve Sommers · Answer

Try using an IP address instead of SQLExpress for the host name. If it is on the same box, use 127.0.0.1 and make sure SQLExpress in configured for IP communication.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded