Re: problem connecting server from client through enterprose manager

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 23:52:32 -0000

Are you logging in using Windows authentication or providing SQL Login name
and password? Can you post the exact error message? 

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Sunny" <sunny_1178@hotmail.com> wrote in message
news:uUgcYEA#DHA.3292@TK2MSFTNGP11.phx.gbl...
I have sql server 2000 installed on windows 2000 server. I just replaced new
workstation (win2K) and installed SQL Client Tools. Now I am trying to
register my SQL server but it says login failed. I use same login and
password to log on SQL 2000 server directly from windows 2000 server and it
works.
I also tried to setup port number from network utility but couldn't sucess.
Can anyone help me what am I doing wrong?
Thanks.

Relevant Pages

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: login 101..
    ... On Windows 2003, SQL Server 2005 can enforce the Windows password complexity ... Windows authentication - SQL Server uses a special protocol to ask ... user is in the list of allowed logins, ...
    (microsoft.public.sqlserver.security)
  • RE: How to create a trusted connection
    ... You need to grant access for the Windows login by referring to the books ... is set to use Windows authentication to be able to do trusted connection. ... There are two modes of authentication in SQL Server: ...
    (microsoft.public.sqlserver.security)
  • RE: How to create a trusted connection
    ... What do you mean by "creating a Windows login"? ... To login SQL Server 2000 using trusted connection, grant the Windows ... Group" in SQL Server Books Online to get the concept, ...
    (microsoft.public.sqlserver.security)
  • Re: Connecting to SQL from a Windows Service
    ... There is probably some way to debug this, but that's deeper Windows knowledge than I can dredge up right now. ... I looked into the Event Log and found that when my service ... 1st Login succeeds. ... You can try turning on login auditing in SQL Server and then check the ...
    (microsoft.public.sqlserver.connect)