Login Problem

what error are you getting ? What version of sql server
and windows are you running ?
Just a guess, this may be a network, are you able to ping
the sql server from your pc, also try running following
command on a DOS command prompt:
telnet <yoursqlservername> 1433
you should get a blank screen, if you get an error then
more likely this is a network issue.
hth.

>--Original Message--
>Hi All,
>I am not able to login into my SQL Server using Query
Analyser using a valid SA Password. But My web application
is working fine.
>Any Idea why it is happening.
>Thanks & Regards
>Balaji Prabhu.T
>.
>Hi,
I feel that you are using "Windows Only" authentication mode. In that case
you cant login using SQL server authentication with SA user.
How to check and change
1. Open Enterprise manger
2. Right click above the server and select properties
3. Select Security Tab
4. Check the Authentication, If it is Windows Only then
click "SQL Server and Windows"
5. Restart SQL server and try connecting.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:c2fd01c4085c$3cb75dc0$a101280a@.phx.gbl...
> what error are you getting ? What version of sql server
> and windows are you running ?
> Just a guess, this may be a network, are you able to ping
> the sql server from your pc, also try running following
> command on a DOS command prompt:
> telnet <yoursqlservername> 1433
> you should get a blank screen, if you get an error then
> more likely this is a network issue.
> hth.
>
> Analyser using a valid SA Password. But My web application
> is working fine.