Re: Locked out-- help!!!

Thank you Norman...

1. Do you know the correct server name or server instance name?
Yes. Because no changes were made to the adp application.

2. Does it allow remote access (from other computer, if you use ADP or
other app to connect it from other computer). Hint: by default
installation, remote connection is disabled.
This may be the problem because the connection can be made within the
windows server.
Where should I start to look?


3. Do you try to connect it with Windows security or SQL Server security?
Hint, by default, Sql Server security is not enabled.
SQL security. Will look into it as well...

4. If you use Windows security, did you created a sql server login that
maps to the windows user account you used to connect to the SQL Server?

5. Did you gave to appropriate permmission to the database you want to
connect to on the SQL Server?
Yes. in fact, works locally.

Rds,
Ana




"Ana" <nospam@xxxxxxxxx> wrote in message
news:eF5%23kzGRHHA.5032@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I don't know what I have done to the SQL Server but I just locked myself
out. I cannot connect to it via Access from a desktop but, I can connect
to it using Access from the server itself (w2k).

It acts as if I'm blocked by a firewall. However, the web application
using .NET Framework can connect w/o a problem. All the adp users have
the same problem.

What am I missing?

TIA

Ana



--------------------------------------------------------------------------------

Estoy utilizando la versión gratuita de SPAMfighter para usuarios
privados.
Ha eliminado 2627 correos spam hasta la fecha.
Los abonados no tienen este mensaje en sus correos.
¡Pruebe SPAMfighter gratis ya!






--------------------------------------------------------------------------------
Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados.
Ha eliminado 2627 correos spam hasta la fecha.
Los abonados no tienen este mensaje en sus correos.
¡Pruebe SPAMfighter gratis ya!


.

Relevant Pages

  • Re: Local tables vs. linked
    ... automatically it's created in the SQL server. ... Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados. ... Ha eliminado 857 correos spam hasta la fecha. ... Then using a update query you can populate the ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Saving a check in SQL
    ... you should probably just change the "int" to ... a "bit" field in SQL Server. ... Estoy utilizando la versión gratuita de SPAMfighter para usuarios ... Ha eliminado 461 correos spam hasta la fecha. ...
    (microsoft.public.access.adp.sqlserver)
  • Locked out-- help!!!
    ... I don't know what I have done to the SQL Server but I just locked myself ... Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados. ... Ha eliminado 2627 correos spam hasta la fecha. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Locked out-- help!!!
    ... Which version of SQL Server is it? ... remote connection is enable by default. ... Do you try to connect it with Windows security or SQL Server security? ... Ha eliminado 2627 correos spam hasta la fecha. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Locked out-- help!!!
    ... a bit study on SQL Server setp and its security. ... Do you try to connect it with Windows security or SQL Server security? ... Ha eliminado 2627 correos spam hasta la fecha. ...
    (microsoft.public.access.adp.sqlserver)