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" /> 

My SQL setting for the database is below: enter image description here

Also, my security login screenshot is here enter image description here

and i still get the error "Login failed for user 'HCDIDMZ\tcpisanweb'." enter image description here

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.

Related posts

Recent Viewed