Monday, March 12, 2012

Problem with 'sa' user and password

Hello.
I have problem with connection to my SQL server 2000 through 'sa' user
without password.
On my windows XP with Access XP I created ODBC Source, user DSN source for
default user 'sa'. On SQL this user has not a password. Now, in Access, when
I try to open linked (from SQL Server) tables the dialog window appears and
system tells me to enter the password (which is empty). Then I must only
press Enter, and table is being opened. What should I do to avoid pressing
Enter, in other words, What should I do in order to get access to tables
without this appearing dialog window to enter the password?
Thank you very much for help.
PS. Without solution for this problem I can not run my batch jobs, and it is
very bad, and I'm getting nervous ;)
I am not sure that you can do this. The password, or in this case, the lack
of password, does not get stored in the DSN. So the dialog box has to open
so you cna supply it.
Rand
This posting is provided "as is" with no warranties and confers no rights.

No comments:

Post a Comment