Re: login failed for user 'username'

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 09/29/04 

Date: Tue, 28 Sep 2004 22:22:23 -0500

Hello,

Since the Master database holds the login information, Did u restored the
Master database, if not you have move the logins atleast to new server.

How to transfer syslogins between servers.

http://www.databasejournal.com/features/mssql/article.php/2228611

Thanks
Hari
MCDBA

"Antonin" <Antonin.Koudelka@fmc.sa.gov.au> wrote in message
news:uHSND%23cpEHA.1296@TK2MSFTNGP12.phx.gbl...
> Our SQL Server 2000 running on NT 4 was installed on Windows 2003 Server.
> All the databases were attached to the new installation.
> Now, when I try to run a program loading data in a database I get an
> error: Login failed for user 'username'.
> In the SQL Server log there is a message Login failed for user 'username'.
>
> What do I need to do to fix this?
>
> Antonin
>
>

Relevant Pages

  • Re: ASP.NET User.Identity.Name value after a domain username chang
    ... Can you point me to any resources I can use about getting the SID of the ... WebRequest user without using the username as the base of a lookup (since I ... access a website on the server. ... I have a very confusing issue when the domain login of a user is changed ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: No username prompt SSHD
    ... it is the client side. ... The client takes the current user and passes that to the server as the ... To override this you must supply a username to the client in one of two ways: ... $ ssh -l login serveur ...
    (SSH)
  • Re: Cant send mail through secure smarthost on 2003
    ... that you are relaying all your users e-mail through your Exchange ... their SMTP server? ... username password. ... 250-AUTH PLAIN LOGIN ...
    (microsoft.public.exchange.admin)
  • Re: Authentication problems?
    ... roaming profile to a local profile but it will not change. ... she receives a prompt to login to the server. ... The username you typed is the same as the username ...
    (microsoft.public.windows.server.active_directory)
  • Re: Users Logging on to Domains
    ... Many IT technicians will deliberately configure and login to their work ... laptops as a non-domain user, to allow easier portability going from one ... If you go to a user PC, you log in as the Username, and the Domain ... All the server applications work as normal, ...
    (microsoft.public.windows.server.sbs)