+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, Discover failed to connect to database during transfer in Technical; Had some training today, it's just a shame that the data wasn't up to date. I can't force a manual ...
  1. #1

    Join Date
    Feb 2007
    Posts
    205
    Thank Post
    6
    Thanked 9 Times in 9 Posts
    Rep Power
    17

    Discover failed to connect to database during transfer

    Had some training today, it's just a shame that the data wasn't up to date.
    I can't force a manual transfer as I keep getting the above error message. The scheduled task runs but obviously a similar message is being recieved.

    I'm stumped. I have tried everything other than a reinstall of the discover server.

    Any suggestions before I go ahead and do this?

    Thanks

  2. #2
    round2it's Avatar
    Join Date
    May 2009
    Location
    UK
    Posts
    1,016
    Thank Post
    199
    Thanked 148 Times in 105 Posts
    Rep Power
    38
    i had something similar after an upgrade.

    the issue was a dodgy config file cant remember which one

    will check tomorrow

  3. #3

    Join Date
    Feb 2007
    Posts
    205
    Thank Post
    6
    Thanked 9 Times in 9 Posts
    Rep Power
    17
    That does make sense. I would really appreciate it as it is following an upgrade. Thanks

  4. #4
    round2it's Avatar
    Join Date
    May 2009
    Location
    UK
    Posts
    1,016
    Thank Post
    199
    Thanked 148 Times in 105 Posts
    Rep Power
    38
    will discover run on the server ?

    mine did but clients got upset

  5. #5

    Join Date
    Feb 2007
    Posts
    205
    Thank Post
    6
    Thanked 9 Times in 9 Posts
    Rep Power
    17
    No it wont run on the server. But it does on the clients. It says catalog failed to load. So I assume there is a dodgy file

  6. #6
    round2it's Avatar
    Join Date
    May 2009
    Location
    UK
    Posts
    1,016
    Thank Post
    199
    Thanked 148 Times in 105 Posts
    Rep Power
    38
    will check tomorrow for you. it was a simple entry in a config file that broke discover for me.

  7. #7
    round2it's Avatar
    Join Date
    May 2009
    Location
    UK
    Posts
    1,016
    Thank Post
    199
    Thanked 148 Times in 105 Posts
    Rep Power
    38
    ok the file I had issues with was Discover.Designer.Desktop.exe.local.config
    c:\programdata\discover
    change your server and database names in the file
    mine now reads (please check line for line as it was something or nothing i had to change sorry cant remember what though

    <?xml version="1.0" encoding="utf-8"?>
    <appSettings>
    <add key="allowExternalConfiguration" value="True" />
    <add key="allowDatabaseRedirection" value="True" />
    <add key="useDatabaseSessions" value="False" />
    <add key="useIntegratedSecurity" value="False" />
    <add key="authenticationServer" value="yourserver\sims2012" />
    <add key="authenticationDatabase" value="sims" />
    <add key="interactiveLogonAuthenticationPrefix" value="sims_" />
    <add key="discoverInstance" value="yourserver\sims2012" />
    <add key="discoverDatabase" value="discover" />
    <add key="sessionTimeout" value="-1" />
    <add key="dataEngineEntityModelTemplate" value="metadata=res://*/DataEngineModel.csdl|res://*/DataEngineModel.ssdl|res://*/DataEngineModel.msl;provider=System.Data.SqlClient ;provider connection string=&quot;{0}&quot;" />
    <add key="queryModelTemplate" value="metadata=res://*/DiscoverWarehouse.csdl|res://*/DiscoverWarehouse.ssdl|res://*/DiscoverWarehouse.msl;provider=System.Data.SqlClie nt;provider connection string=&quot;{0}&quot;" />
    <add key="dataEngineFactory" value="Discover.Designer.SIMS.SimsServerAuthentica tingDataEngineFactory, Discover.Designer.SIMS, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" />
    <add key="applicationRole" value="DiscoverUser" />
    <add key="passwordObfuscator" value="Discover.Designer.SIMS.SIMSPasswordObfuscat or, Discover.Designer.SIMS, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" />
    </appSettings>
    Last edited by round2it; 11th July 2014 at 09:45 AM.

  8. #8

    Join Date
    Feb 2007
    Posts
    205
    Thank Post
    6
    Thanked 9 Times in 9 Posts
    Rep Power
    17
    All seems well. Strange one

  9. #9
    round2it's Avatar
    Join Date
    May 2009
    Location
    UK
    Posts
    1,016
    Thank Post
    199
    Thanked 148 Times in 105 Posts
    Rep Power
    38
    is every line the same?
    i had to delete 2 characters out of my old config file to get it working

    i would remove discover completely and reinstall its a quick job and wont affect sims

  10. #10

    Join Date
    Feb 2007
    Posts
    205
    Thank Post
    6
    Thanked 9 Times in 9 Posts
    Rep Power
    17
    Nothing a uninstall and reinstall can't solve. I assume permissions went a little screwy. Anyway thanks for your help

SHARE:
+ Post New Thread

Similar Threads

  1. ISA Failing it Connect To RPC Service
    By glennda in forum Internet Related/Filtering/Firewall
    Replies: 1
    Last Post: 5th January 2010, 04:33 PM
  2. [CLOSED] Bug/Error: Unable to connect to jabber server
    By mark in forum EduGeek.net Site Problems
    Replies: 3
    Last Post: 8th July 2009, 08:59 AM
  3. Getting Outlook to connect to Exchange from outside the network
    By richard_s in forum How do you do....it?
    Replies: 8
    Last Post: 6th March 2009, 01:36 PM
  4. Joomla : Unable to Connect to Database
    By deano in forum Web Development
    Replies: 0
    Last Post: 28th September 2007, 03:09 PM
  5. Workstations unable to connect to domain
    By richard in forum Wireless Networks
    Replies: 8
    Last Post: 8th September 2006, 08:54 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
  •