Solved

multiple invalid login attempts

Posted on 2009-05-14
9
537 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:scorp8
  • 6
  • 3
9 Comments
 
LVL 13

Expert Comment

by:adraughn
ID: 24387964
When you linked the tables, did you use a trusted connection or did you use a sql login? did you save the password?
0
 
LVL 1

Author Comment

by:scorp8
ID: 24388034
I've tried it both ways.  One trusted connection, the other with a sql login.

What do you mean by "save the password"?
0
 
LVL 13

Expert Comment

by:adraughn
ID: 24397087
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:scorp8
ID: 24397684
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
 
LVL 1

Author Comment

by:scorp8
ID: 24397687
sorry, "linked table manager"...
0
 
LVL 13

Expert Comment

by:adraughn
ID: 24412530
can you post your code that links the tables? Why relink via code?
0
 
LVL 1

Author Comment

by:scorp8
ID: 24413118
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
 
LVL 1

Author Comment

by:scorp8
ID: 24477672
"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
 
LVL 1

Accepted Solution

by:
scorp8 earned 0 total points
ID: 25831230
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

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question