Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 558
  • Last Modified:

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
0
scorp8
Asked:
scorp8
  • 6
  • 3
1 Solution
 
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
 
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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
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
 
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
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.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now