×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Very frequent ado errors

Very frequent ado errors

Very frequent ado errors

(OP)
The issue I'm having is constant ado errors in the event log of the Goldmine server. Everything seems to be running nomrally, but these errors persist.

About our environment:
We used to have two pe2950's. One was a Citrix server and the other ran all of our applications including Goldmine. Late last year we upgraded to a single server that runs all of our applications in their own vm's. We'd had these same ado errors with our old server and we have them now as well.

We have about 10 remote users that all log on to our RDS server which then launch Goldmine from a shared drive where Goldmine is installed.

About Goldmine support:
I've called Frontrange about this twice. The first guy said this was "normal". The second guy said that this was a networking issue and they couldn't help me. This very well may be true, but I don't have a whole lot to go on and Google hasn't been very helpful.

This is the event in the event log I get over and over sometimes as often as 3 times per minute.

CODE -->

 

RE: Very frequent ado errors

(OP)
The code tag doesn't seem to have worked and I can't find the edit button.

The description for Event ID 0 from source GoldMine cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

GM version: 2014.1.0.503 R Thread ID 12304:

ADO Error in AdoConnection::open failed to open ADO connection
Com Error IDispatch error #3149
HRESULT : -2147217843
Description: Login failed for user 'sa'.

the message resource is present but the message is not found in the string/message table

RE: Very frequent ado errors

(OP)
One final piece of inromation is that this error I'm getting shows up on all of our clients. On the Goldmine server I get a matching "Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 192.168.1.xxx]."

RE: Very frequent ado errors

advancedconcrete (IS/IT--Management)
(OP)
30 Mar 15 15:14
One final piece of inromation is that this error I'm getting shows up on all of our clients. On the Goldmine server I get a matching "Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 192.168.1.xxx]."

This sounds like an intermittent connectivity issue and/or an actual credentials error. Make certain that the user has a login for the Server as well as a login for SQL Server. The same holds true for the Passwords for each.

DJ Hunt
Phone: (978)2-3333
WebSite: http://www.DJHunt.US

- GoldMine Premium - The Definitive Guide
- One-on-One GoldMine Technical Support ( Fee Based )
http://www.DJHunt.US

RE: Very frequent ado errors

(OP)
The users never lose connectivity so if it is a connectivity issue it's unnoticeable to the users. As far as SQL logins Goldmine uses the encrypted sa password in the dbalias.ini to make its connection with the server. There's no way any of the users are using the wrong password as they are all using the same dbalias.ini on a shared drive.

RE: Very frequent ado errors

I would make sure that Ports 1433 & 1434 are open for SQL Server on these Server.

I would make sure that I ran the Client Configuration Tool on each desktop, and confirm that Named Pipes & TCP/IP are both enabled in the Protocol section. I would then Order the Named Pipes as position 2, and TCP/IP as position 3.

On the SQL Server I would make sure that the Service SQL Browsing has been Started.

Beyond that, I'm at a loss.

DJ Hunt
Phone: (978)2-3333
WebSite: http://www.DJHunt.US

- GoldMine Premium - The Definitive Guide
- One-on-One GoldMine Technical Support ( Fee Based )
http://www.DJHunt.US

RE: Very frequent ado errors

Take a look in the user properties, ACCESS tab and see if they have a username/password specified there for SQL. Update/verify it and see if the errors persist.

Doug Castell
Castell Computers
www.castellcomputers.com

RE: Very frequent ado errors

(OP)
I think you may be onto something goner. I did as you said and I found a few users that this info was blank. I filled it in and today I had no errors from those machines. I'm still getting the message from my RDS server which has roughly 10 users so I'll have to update the users that did have the user/pass filled out just in case it is incorrect like you mentioned. Anyway, thanks!

RE: Very frequent ado errors

No problem.

As a side note, I think what you're seeing with those errors is relatively innocuous. It's just GoldMine going through its SQL login fall back progression.

When a user logs into GoldMine, the SQL login used is in any of a number of places:
1. their user properties
2. the database properties (tools|databases|open databases|properties of each)
3. the Alias properties (tools|databases|alias manager|properties of each)

It will try to use the one closest to the user and fall back, as necessary, through the progression as it finds them empty/wrong.

Doug Castell
Castell Computers
www.castellcomputers.com

RE: Very frequent ado errors

(OP)
Ok thanks again. For the first time in years I haven't seen that ado error in the event log. You could teach GM support a thing or two :).

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close