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:
also, security login screenshot here
and still error "login failed user 'hcdidmz\tcpisanweb'."
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
Post a Comment