Locked out-- help!!!

[Ana]

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!

 

[Norman Yuan]

What you missed is detailed description, other than "locked out", of how the
SQL Server is set up, what steps you did to try to connect to the SQL
Server; or dare I say, a bit study on SQL Server setp and its security.

It seems you have difficulty to connect from other computers. So, here are a
few questions you can ask yourself:


1. Do you know the correct server name or server instance name?

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.

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

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?

 

[Ana]

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

 

[Norman Yuan]

Which version of SQL Server is it?

For Sql Sever2000, remote connection is enable by default (i think). You may
need to run "server network utility" to make sure neccessary network
protocol(s) enabled (named pipes, or TCP/IP with correct port number).

For SQL Server2005, run "Surface Area Configuration" to make sure remote
access is allowed.

Of course, if you need to make sure the username/password is correct, since
you use SQL Server security.

 

[Ana]

Resolved the problem but recycling the services..
Thank you.