Re: interesting sql login issue

What do you mean by hardcoded? I just login to my workstation using my
windows domain login and password?

I have tried dropping and re-creating the login in SQL Server.


"Leon Shargorodsky" <LeonShargorodsky@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:D1639F71-646C-4286-983F-87AF7C25360A@xxxxxxxxxxxxxxxx
http://support.microsoft.com/kb/555332

Is it possible that you have your Windows auth password hardcoded
somewhere?
When worse comes to worse, you may have to drop and re-create your login
on a
SQL Server.

"param@xxxxxxxxxxxxxxxx" wrote:

Hi all,

I have a SQL 2005 server running on SERVERA. I have the management studio
installed on my desktop (Windows XP Pro SP2) and connect to the sql
server
using my regular domain login account (windows auth). This worked fine
until
I had to change my domain user account's password as it had expired (we
have
to change it every 90 days). Now, ever since then, I have been unable to
connect to the sql server in management studio. I get:-

Login Failed for user ''. Error: 18452

If I remote into the server and try to connect to sql it works fine (I am
member of local admin group on the server)

Any ideas??





.

Relevant Pages

  • Re: SQL User SID format?
    ... When you move databases to another server, you can remap users to logins ... capability to remap a user to a login with new ALTER USER syntax - I ... The new ALTER USER syntax works for remapping both SQL and Windows ... this means you already have access to a SID from the syslogins catalog; ...
    (microsoft.public.sqlserver.security)
  • Re: ASP.NET User.Identity.Name value after a domain username chang
    ... Since .NET is just calling into Windows API calls to resolve the user name, ... I have an ASP.NET application that is on a Win2000 server in a domain ... I have a very confusing issue when the domain login of a user is ... I thought this might have been some caching issue on the client so I ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: SQL Server on XP Home Network
    ... The sa account is the system administrator "God" account witihin SQL ... This account is a SQL-Server login. ... You might be able to use Enterprise Manager to go in and create a new SQL ... Select the "SQL Server Authentication" ...
    (microsoft.public.sqlserver.setup)
  • Re: CAN WE LOGIN TO A WINDOWS 2003 ACTIVE DIRECTORY DOMAIN OVER TH
    ... Having a user login to a windows 2003 server over the internet is not a good ...
    (microsoft.public.windows.server.active_directory)
  • Re: New Windows Infrastructure
    ... vendor's application runs on windows with an SQL database and I will also need a web server for a separate module which will allow our customers to access account data online. ... I would think that if the app runs on windows, I do not need the citrix server. ... It makes sense to have separate DCs though, because let's say you want to upgrade your Active Directory in two weeks time, with separate DCs it's easy, but if you've got a bunch of apps installed it could be a nightmare. ...
    (microsoft.public.win2000.setup_deployment)