+ Post New Thread
Results 1 to 4 of 4
Home Access Plus+ Thread, SQL Connection Error after changing SQL instance name in Projects:; @ nickbro Hi Nick, I have installed dirsync for Office 365 today which wanted to install a fresh version of ...
  1. #1

    Join Date
    Apr 2013
    Location
    Birmingham
    Posts
    115
    Thank Post
    4
    Thanked 4 Times in 4 Posts
    Rep Power
    3

    SQL Connection Error after changing SQL instance name

    @nickbro

    Hi Nick,

    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.

    SQL Connection Error after changing SQL instance name-sql-error.png

    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

  2. #2
    fairm010's Avatar
    Join Date
    Jun 2010
    Location
    C:/Windows/System32/
    Posts
    1,168
    Thank Post
    47
    Thanked 151 Times in 132 Posts
    Rep Power
    46
    Open your web.config file, your SQLConnectionString line should look like this. Did you change the instance name in the web.config?

    Code:
      <connectionStrings>
        <add name="SQLConnectionString" connectionString="Server=DMS-APP-01\SQLEXPRESS;Database=hap;Trusted_Connection=True;" />
      </connectionStrings>

  3. #3

    Join Date
    Apr 2013
    Location
    Birmingham
    Posts
    115
    Thank Post
    4
    Thanked 4 Times in 4 Posts
    Rep Power
    3
    @fairm010

    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?

  4. #4
    fairm010's Avatar
    Join Date
    Jun 2010
    Location
    C:/Windows/System32/
    Posts
    1,168
    Thank Post
    47
    Thanked 151 Times in 132 Posts
    Rep Power
    46
    To be honest I have no idea. I tried using local host but used server \instance as that worked too

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] FMS general SQL error after server move
    By yjb in forum MIS Systems
    Replies: 12
    Last Post: 2nd November 2012, 03:37 PM
  2. [SIMS] General SQL Error aftering upgrading to FMS 6.136
    By adamf in forum MIS Systems
    Replies: 1
    Last Post: 22nd December 2010, 11:24 AM
  3. MS SQL 2005 Database connection error
    By mcheung0 in forum Windows Server 2000/2003
    Replies: 5
    Last Post: 22nd June 2010, 10:22 AM
  4. Help With SQL Query Error
    By penfold_99 in forum Coding
    Replies: 6
    Last Post: 15th May 2009, 01:30 PM
  5. Replies: 0
    Last Post: 3rd February 2009, 06:07 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •