1 Reply Latest reply on Apr 21, 2016 3:09 PM by John Neighbors

    goldmine requires login to database

    MRitte Apprentice

      I was able to open the database finally.  I had forgotten to open the port for SQL.

       

      However, now anyone that tries to access GoldMine from a workstation times out and is prompted for the database login before GoldMine opens.  I have seen this a couple of times at other installation but for the life of me can't remember what the fix was.

       

      Even if you check the box to save the settings it does not.

       

      I checked the GoldMine share and users have full access.

       

      Help.

        • 1. Re: goldmine requires login to database
          John Neighbors SSMMVPGroup

          I would do the following:

           

          1. Go to Tools | Databases | Alias Manager

          2. Walk through EACH alias and make sure it's properly defined AND that the password is set.

          3. Test EACH connection and verify success.

           

          That will probably do it. If not, then you might want to check each GM ID's Access tab (under Properties) and make sure SQL Logon Name and SQL Password are either BLANK OR that those SQL IDs/passwords are legit.

           

          Hope this feedback helps.