asp.net - Login failed for user 'HCDIDMZ\tcpisanweb' -


i giving up. have setup database user tcpisanweb , gave access db owner of database. in 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 database below: enter image description here

also, security login screenshot here enter image description here

and still error "login failed user 'hcdidmz\tcpisanweb'." enter image description here

also, in sql configuration manager, have setup tcp/ip enabled , assigned tcp port 1433 under ip addresses tab.

i not sure else do, connect successfully.

if in sql server error log have more details reason failure.

i notice using sql authentication. out of box disabled , needs enabled - e.g. using security tab in server properties dialogue.


Comments

Popular posts from this blog

sublimetext3 - what keyboard shortcut is to comment/uncomment for this script tag in sublime -

java - No use of nillable="0" in SOAP Webservice -

ubuntu - Laravel 5.2 quickstart guide gives Not Found Error -