Showing posts with label newbie. Show all posts
Showing posts with label newbie. Show all posts

Sunday, March 25, 2012

changing Authentication mode

Hi,
I am a newbie and i am trying to change authenication mode under enterprise
manager the sql server properties -> security tab to "SQl Server and Windows
NT" but as soon as i click on ok and close the properties it changes bak, to
Windows NT.
I have installed sharepoint services and someday i would configure something
(i dont remember what) i changed authentication to Windows NT , now i want t
o
change it back to mixed mode (Sql server and Windows) but it does want to
obey.
what can i do?From memory, changing the authentication mode only takes affect the
next time you restart SQL Server. Have you stopped & restarted SQL
Server since changing the authentication mode?
*mike hodgson*
http://sqlnerd.blogspot.com
Cyrus wrote:

>Hi,
>I am a newbie and i am trying to change authenication mode under enterprise
>manager the sql server properties -> security tab to "SQl Server and Window
s
>NT" but as soon as i click on ok and close the properties it changes bak, t
o
>Windows NT.
>I have installed sharepoint services and someday i would configure somethin
g
>(i dont remember what) i changed authentication to Windows NT , now i want
to
>change it back to mixed mode (Sql server and Windows) but it does want to
>obey.
>what can i do?
>sql

Sunday, February 19, 2012

Change sa Password in MSDE

This is a newbie question but how can I change the sa password in MSDE?
You don't have the graphical tools with MSDE that come with full blown SQL
Server versions, but you have a command line tool that is called osql. You
can run this and then change the sa password with the following SQL
statement (assuming you are logged in as sa):
EXEC sp_password '<old password>', '<new password>'
Jacco Schalkwijk
SQL Server MVP
"JohnK" <JohnK@.discussions.microsoft.com> wrote in message
news:EC4A5773-DA53-4B46-9B3B-6EDD58409012@.microsoft.com...
> This is a newbie question but how can I change the sa password in MSDE?
|||Hi John,
We've also got a tool (MSDE Manager) that's free for personal use. Details
are on our web site. It can do things like this easily.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"JohnK" <JohnK@.discussions.microsoft.com> wrote in message
news:EC4A5773-DA53-4B46-9B3B-6EDD58409012@.microsoft.com...
> This is a newbie question but how can I change the sa password in MSDE?