Re: problem connecting server from client through enterprose manager

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Sunny (sunny_1178_at_hotmail.com)
Date: 02/23/04 

Date: Mon, 23 Feb 2004 09:20:19 -0600

I am providing SQL login name and getting error "Login Failed".
"Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
news:OhO152A#DHA.4080@tk2msftngp13.phx.gbl...
> 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: Parameterized query problem
    ... Microsoft OLE DB Provider for SQL Server error '80004005' ... Cannot open database "Mydb" requested by the login. ... EXEC sp_helplogins 'aspuser' ...
    (microsoft.public.inetserver.asp.db)
  • Re: dsn-less connection
    ... It worked pretty much as I was hoping in prompting the user for a SQL ... Server login and was able to remove the specific dsn that's in the odbc ... straight to the SQL Server login prompt? ... with the login prompt but the Use Trusted Connection is checked on. ...
    (microsoft.public.access.security)
  • Re: Logging in irrespective of database access
    ... My problem is that in the Login section of Enterprise Manger I have to ... like there used to be in SQL 6.5. ... What's the point in having the Database Access section if the System Admin ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Logging in irrespective of the database access settings
    ... My problem is that in the Login section of Enterprise Manger I have to ... like there used to be in SQL 6.5. ... What's the point in having the Database Access section if the System Admin ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... My problem is that in the Login section of Enterprise Manger I have to ... like there used to be in SQL 6.5. ... What's the point in having the Database Access section if the System Admin ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)