Solved

multiple invalid login attempts

Posted on 2009-05-14
9
538 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

739 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