|
Home > Archive > MS SQL Server security > September 2005 > Windows password change locked me out of local Sql
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Windows password change locked me out of local Sql
|
|
| Mark White 2005-09-22, 1:23 pm |
| 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
| |
| Mike Epprecht \(SQL MVP\) 2005-09-22, 8:23 pm |
| 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\administrato
rs
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
>
>
|
|
|
|
|