Home Access Plus+ Thread, SQL Connection Error after changing SQL instance name in Projects:; @ nickbro
I have installed dirsync for Office 365 today which wanted to install a fresh version of ...
6th June 2014, 03:44 PM #1
- Rep Power
SQL Connection Error after changing SQL instance name
I have installed dirsync for Office 365 today which wanted to install a fresh version of SQL so I took a backup of the HAP database and restored it once dirsync install had complete, the original SQL instance was called SQLEXPRESS, the new one was named automatically by the install as MSONLINE. The restore of the database to MSONLINE has gone fine and all the tables are there but HAP+ won't login, it's showing the below SQL connection error.
I have added the IIS AppPool to SQL, I have enabled named pipes and tcp/ip for the SQL server and when I type SQLCMD - L in command prompt, the server is in the list, I have also changed the SQL connection in IIS, is there anything I need to change in the HAP files because it already registered itself to another database name or something like that?
Your help is appreciated
6th June 2014, 03:55 PM #2
Open your web.config file, your SQLConnectionString line should look like this. Did you change the instance name in the web.config?
<add name="SQLConnectionString" connectionString="Server=DMS-APP-01\SQLEXPRESS;Database=hap;Trusted_Connection=True;" />
6th June 2014, 05:45 PM #3
- Rep Power
I didnt change that as I had it set to localhost but I've just changed it now to servername\SQL instance and that's sorted it. Don't suppose you know why I can't use localhost now thought? Does it need to have an alias set for the SQL instance to be set as localhost?
6th June 2014, 06:19 PM #4
To be honest I have no idea. I tried using local host but used server \instance as that worked too
By yjb in forum MIS Systems
Last Post: 2nd November 2012, 03:37 PM
By adamf in forum MIS Systems
Last Post: 22nd December 2010, 11:24 AM
By mcheung0 in forum Windows Server 2000/2003
Last Post: 22nd June 2010, 10:22 AM
By penfold_99 in forum Coding
Last Post: 15th May 2009, 01:30 PM
By link470 in forum Windows
Last Post: 3rd February 2009, 06:07 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)