In my life, mySQL database is very touch to use. Because it's very complicated to add or remove data column, rename the table name and inserting demo data without installing phpMyAdmin. That's why I decided to remove mySQL as my project database and to install SQL 2005 server Express version.

So, download both of SQL 2005 Server and also management studio express version. Honestly, installing of SQL 2005 express version is very simple and easy. Because, my before time I've used to develop Coldfusion Project with SQL server. That's why I can say it's simple. Unfortunately, I encountered the following error when I tried to connection SQL 2005 server in Coldfusion Administrator.

I was very speechless when I encountered this error message. Because, in SQL 2000, we don't need to do any configurations in both of SQL server and Coldfusion administrator. I feel I need to configure anything in SQL 2005 express version. That's why I opened SQL 2005 configuration manager and looked through of it. Finally, I found that TCP/IP is disabled in Protocols for SQLExpress. That's why I've done the following configuration of SQL Express.

• Open SQL 2005 Express Configuration Manager
• Open SQL 2005 Network Configuration
• Click on Protocols for SQLEXPRESS
• Click on TCP/IP (the right side) and open Properties box
• In Properties box, click on IP Addresses tab
• In IP Addresses tab, scroll down the bottom to IPAll
• In IPAll, set 1433 to TCP Port. Then, Apply and Ok it.
• Then, enable TCP/IP protocol and Restart SQL services.

After all, you can successfully connect SQL 2005 server in Coldfusion Administration.

This entry was posted on April 24, 2011 at 1:16 AM and has received 1794 views. There are currently 3 comments. Print this entry.