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.

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.

Problem with sa password

Hi All,
I get error when I tried to edit the properties of the sa password. I get
the follwing message:
"Error 21776: [SQL-DMO] The name 'dbo' was not found in the users
collection"
No problems with editing others.
This is very serious because it is the production server.
I urgently need help.
Thank
Egbon.Check out this article: Q218172. It sounds like you have some databases
where dbo is mapped to null.
You should still be able to change the password with sp_changepassword.
"Egbon" <Vnjowusi@.gosps.com> wrote in message
news:unQGxgsUDHA.1680@.tk2msftngp13.phx.gbl...
> Hi All,
> I get error when I tried to edit the properties of the sa password. I get
> the follwing message:
> "Error 21776: [SQL-DMO] The name 'dbo' was not found in the users
> collection"
> No problems with editing others.
> This is very serious because it is the production server.
> I urgently need help.
> Thank
> Egbon.
>|||Many thanks, James.
Egbon
"James Luetkehoelter" <james.luetkehoetler@.NOSPAMspyglassllc.com> wrote in
message news:em1EQmsUDHA.3220@.tk2msftngp13.phx.gbl...
> Check out this article: Q218172. It sounds like you have some databases
> where dbo is mapped to null.
> You should still be able to change the password with sp_changepassword.
> "Egbon" <Vnjowusi@.gosps.com> wrote in message
> news:unQGxgsUDHA.1680@.tk2msftngp13.phx.gbl...
> > Hi All,
> >
> > I get error when I tried to edit the properties of the sa password. I
get
> > the follwing message:
> > "Error 21776: [SQL-DMO] The name 'dbo' was not found in the users
> > collection"
> > No problems with editing others.
> > This is very serious because it is the production server.
> > I urgently need help.
> >
> > Thank
> >
> > Egbon.
> >
> >
>