Re: Windows password change locked me out of local Sql
From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 09/22/05
- Previous message: Mark White: "Windows password change locked me out of local Sql"
- In reply to: Mark White: "Windows password change locked me out of local Sql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 22 Sep 2005 21:49:00 +0200
Hi
In SQL Server 2000, Windows Authentication does not affect SQL
Authentication.
Maybe the password you are using to access SQL Server is not what you though
it was.
Since it is SQL Server, Windows Authentication will work, so log in with the
administrator account of the SQL Server machine as builtin\administrators
group has access to SQL Server (unless you removed that NT group in SQL
Server).
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mark White" <markw2927@yahoo.com> wrote in message
news:uhbluh5vFHA.2864@TK2MSFTNGP10.phx.gbl...
> Hello
>
> I have my local instance of Sql Server setup for Sql Server Auth., for sa.
>
> Yesterday, I changed my Windows password, and now I cannot login to the
> local using either the Sql Auth. or Windows Auth. (obviously the password
> change took, and I can access Windows).
>
> Sql Auth. is seperate from the Windows Auth., so I don't understand how
> changing Windows affects Sql.
>
> Any help would be greatly appreciated. Thanks.
> Mark
>
>
- Previous message: Mark White: "Windows password change locked me out of local Sql"
- In reply to: Mark White: "Windows password change locked me out of local Sql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
