Sql 2005 Express connection problems

[ebelaw]

hi,
I just installed Sql Server 2005 express edition on my Win XP, and i am unable
until this moment to add a database from it as a datasource on coldfusion
administration, it give me this error:

Connection verification failed for data source: housejamp
java.sql.SQLException: Error establishing socket. Connection refused: connect
The root cause was that: java.sql.SQLException: Error establishing socket.
Connection refused: connect

------------------------------------------------------

i tried to acess it by a file i created in ASP on dreamweaver and i
sucessfully connected to the database, can it be any incompability with the
driver?

Thank you in advance for your time and help.

[paross1]

What kind of authentication are you using? Instead of Windows authentication,
you might try setting up a user in SQL Server that has access to your
database(s) so that you can use SQL Server authentication.

Phil

[ebelaw]

I did use the SQL Server Authentication, both times but only sucessfull with asp.