I would assume the gaping silence in your logs in between "trying
public key file ...authorized_keys" and "restore_uid: 0/0" is a failure
to open the public key file, though I really wish sshd would say WHY
it failed to open the public key file.

In any case, I'm betting the problem is "permissions of some parent
directory of ~/.ssh".

Relevant Pages

Re: Logging in irrespective of database access... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...(microsoft.public.sqlserver.programming)

Re: Logging in irrespective of database access... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...(microsoft.public.sqlserver.server)

Re: Logging in irrespective of database access... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...(microsoft.public.sqlserver.server)

Re: Logging in irrespective of database access... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...(microsoft.public.sqlserver.programming)

Re: ODBC in MS Access ignores DSN authorization method...login doesn't have permissions, you get an error. ... to use a trusted connection or a SQL login, ...>permissions, and instead use the PUBLIC permissions. ... >When the Windows login I am using has access to the database, ...(microsoft.public.sqlserver.odbc)