Solved

multiple invalid login attempts

Posted on 2009-05-14
9
542 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

628 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