Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

multiple invalid login attempts

Posted on 2009-05-14
9
Medium Priority
?
552 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

783 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