Web config error with two databases in asp.net -
i develop website , there 2 databases in web site. made 2 database , users in plesk panel , upload ups, database first name database_journal , database name 2 database_general , users userid1 , userid. there thing wrong in , gave me error:
a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: named pipes provider, error: 40 - not open connection sql server)
my web config this:
<add name="dbconn" connectionstring="password==******;; persist security info=true;user id=userid1; initial catalog=database_general; data source=***.**.**.**" providername="system.data.sqlclient" /> <remove name="localsqlserver"/> <add name="localsqlserver" connectionstring="password=******;persist security info=true;user id=userid1; initial catalog=database_general; data source=***.**.**.**" providername="system.data.sqlclient" /> <add name="dbconn_general" connectionstring="password==******;; persist security info=true;user id=userid; initial catalog=database_journal; data source=***.**.**.**" providername="system.data.sqlclient" />
try format...
<add name="dbconn" connectionstring="server=yourservernameorserveripaddress; database=database_general; uid=userid1; password=******" providername="system.data.sqlclient" />