multiple invalid login attempts

I have linked tables to SQL Server 2005.  The SQL dba's say they are recieving hundreds, even thousands of invalid login attempts from my user id and an admin account accross all my users.  I'm stumped as to what the issue might be.  I didn't have this issue with SQL Server 2000.

Any suggestions would be apprciated.

scorp8
LVL 1
scorp8Asked:
Who is Participating?
 
scorp8Author Commented:
We figured out the issue.  Come to find out, it's an internal MS Access issue.  If we didn't us a System or File DSN, on every click event of a linked table, there was an underlying error that only the dba's were seeing.  Once we used an acutal System or file dsn, the error ceased.
0
 
adraughnCommented:
When you linked the tables, did you use a trusted connection or did you use a sql login? did you save the password?
0
 
scorp8Author Commented:
I've tried it both ways.  One trusted connection, the other with a sql login.

What do you mean by "save the password"?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
adraughnCommented:
when you link the tables, the last screen, where you select the tables to link has a checkbox that states "save password". If you are using a sql login, you will want to save your password. If you use a trusted connection you do not. Note that in order to use a trusted connection, all of the users must have access to the tables on the server thru sql permissions.

With your SQL password that you supplied, are you able to login to the server directly, using SQL?

-a
0
 
scorp8Author Commented:
I don't use the linked manager manager.  I spin throught the table defs and relink in code.

Each user is setup in sql server.  Yes, I can login to the server via windows or sql authentication.

scorp8
0
 
scorp8Author Commented:
sorry, "linked table manager"...
0
 
adraughnCommented:
can you post your code that links the tables? Why relink via code?
0
 
scorp8Author Commented:
Let me add, Everything is fine from the user end.  I can CRUD data all day long.  It's the dba's that are getting their feathers ruffled from all the invalid login attempts.  I'm not seeing any interruption on my side.  It's business as usual.
0
 
scorp8Author Commented:
"can you post your code that links the tables? Why relink via code? "  So I can easily switch between the development and production server of the data tier.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.