Sql Server 2012 listener not working with sql server authentication with asp.net on windows server 2012 -
i in process of setting asp.net application on windows server 2012 , iis 8.0 connected sql server 2012 database alwayson availability groups database. however, having error message popping when trying access application login failure message. @ point have replicated same set on windows server 2008 r2 sp1 , iis 7.5 , site works expected.
my connection string
<add name="databaseconnectionstring" connectionstring="server=tcp:testdblistener;database=ibank;user id=xx;password=xxxxxxx;multisubnetfailover=true" providername="system.data.sqlclient"/>
if replace testdblitener
machine name of nodes works perfectly.
please help
Comments
Post a Comment