May 19, 2018 at 4:01 pm
Have SQL Databases for my web sites on SQL 2008 now moving them to SQL 2014 on Windows 2012 R2 Cluster servers.
My 2008 Connect string file db_connecton.inc
<%strConnect="Provider=SQLOLEDB.1;Persist Security Info=True;UserID=sa;Password=xxxxxxxxxx;Initial Catalog=Music;Network Library=DBMSSOCN;DataSource=xx.x.x.xx,1433"%>
For 2014 I changed the account and used the cluster name in place of the ip address
<%strConnect="Provider=SQLOLEDB.1;Persist Security Info=True;UserID=musicman;Password=xxxxxxxxx;Initial Catalog=Music;NetworkLibrary=DBMSSOCN;Data Source=SERV014-N1-SQLC,1433"%>
My site did not work when I used the 2014 db_connection.inc file
I tested from the Web server using testsql.udl and the account all worked fine connection tested ok
any ideas
May 19, 2018 at 4:13 pm
Close this self resolved
changed to use the ip address of the cluster name and now working.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply