I am giving up. I have setup my database with user tcpisanweb and gave access as the db owner of the database. In my web.config
<add name="TCPISANConnectionString" connectionString="Data Source=PHOENIX\DMZSQL;Initial Catalog=TCPISAN;uid=HCDIDMZ\tcpisanweb;pwd=1tcpisan@web" providerName="System.Data.SqlClient" />
Also, in my SQL Configuration manager, I have setup my TCP/IP enabled and assigned the TCP port to 1433 under the IP Addresses tab.
I am not sure what else to do, to connect successfully.