Friday, March 9, 2012

Installation password - using NT auth, want to change original password

During the installation of MSSql personal you are asked
whether you would like to use NT auth or SA or mixed mode
for your DBA password.
I am currently using only NT authentication, however my
network password has changed since the installation of
mssql personal.
Is there anyway in MSSql to change the DBA login
password? I can not seem to find it anywhere.
Thanks in advance.
BenderYou don't have to change anything in SQL Server, if you are using Windows
authentication. If you manage to log into Windows, then that's fine, as long
as your Windows account is granted access to SQL Server.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"bender" <anonymous@.discussions.microsoft.com> wrote in message
news:034501c3dec9$4b6970e0$a101280a@.phx.gbl...
During the installation of MSSql personal you are asked
whether you would like to use NT auth or SA or mixed mode
for your DBA password.
I am currently using only NT authentication, however my
network password has changed since the installation of
mssql personal.
Is there anyway in MSSql to change the DBA login
password? I can not seem to find it anywhere.
Thanks in advance.
Bender

No comments:

Post a Comment