Error access CF8 to Microsoft SQL Server 2008

[VladL_]

Hello!

I have created a database in SQL Server 2008.

Further, in CF Administrator Add New Data Source - also there is an error.

Connection verification failed for data source:  dbo.Articles

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error  establishing socket to host and port: localhost:1433. Reason: Connection  refused: connect
The root cause was that: java.sql.SQLException:  [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port:  localhost:1433. Reason: Connection refused: connect

Prompt how to solve this problem?

[Libby_H]

What type of authentication do you use on the SQL Server database?  If you use 'SQL Server and Windows', did you use this id/password in setting up the Data Source within ColdFusion Administrator?

[VladL_]

Libby H Yes, I used Administrator CF, I already managed to solve this problem. The Server field I has installed the empty...

Also I have customised TCP/IP in the Manager of configuration SQL Server 2008 - all TCP-port have assigned value 1433

[Guest]

What is the solution?

I have the same thing with SQL Server 2008 64 bit. When i switch my datasource from SQL 2008 to SQL 2000 it works great otherwise it will not work. I have checked SQL Server 2008 that all the ports show 1433. I have been stuck on this for a while. I also checked the SQL Server Network Configuration / TCP/IP and i have nothing in the dynamic field and all the ports show 1433. If someone has allready figured this out it would be good to have a solution- Especially since coldfusion is supposed to connect to the database....

Thanks for any help.