home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
General Support
How to set Sql Authentication?
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="wiiremote" data-source="post: 849906"><p><span style="font-size: 15px"><strong><p style="text-align: left"><span style="color: #3f529c"><span style="font-family: 'Segoe UI'">To change security authentication mode</span></span></p><p></strong></span></p><p style="text-align: left"><span style="font-family: 'Segoe UI'"> <ol> <li data-xf-list-type="ol">In SQL Server Management Studio Object Explorer, right-click the server, and then click <strong>Properties</strong>.</li> <li data-xf-list-type="ol">On the <strong>Security</strong> page, under <strong>Server authentication</strong>, select the new server authentication mode, and then click <strong>OK</strong>.</li> <li data-xf-list-type="ol">In the SQL Server Management Studio dialog box, click <strong>OK</strong> to acknowledge the requirement to restart SQL Server.</li> </ol></p> <p style="text-align: left"></span></p><p><span style="font-size: 15px"><strong><p style="text-align: left"><span style="color: #3f529c"><span style="font-family: 'Segoe UI'">To restart SQL Server from SQL Server Management Studio</span></span></p><p></strong></span></p><p style="text-align: left"><span style="font-family: 'Segoe UI'"> <ul> <li data-xf-list-type="ul">In Object Explorer, right-click your server, and then click <strong>Restart</strong>. If SQL Server Agent is running, it must also be restarted.</li> </ul></p> <p style="text-align: left"></span></p><p><span style="font-size: 15px"><strong><p style="text-align: left"><span style="color: #3f529c"><span style="font-family: 'Segoe UI'">To enable the sa login by using Transact-SQL</span></span></p><p></strong></span></p><p style="text-align: left"><span style="font-family: 'Segoe UI'"> <ul> <li data-xf-list-type="ul">Execute the following statements to enable the sa password and assign a password.<br /> <span style="font-family: 'Consolas'">ALTER LOGIN sa ENABLE ;<br /> GO<br /> ALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ;</span><br /> <span style="font-family: 'Consolas'">GO</span><br /> <br /> <span style="font-size: 15px"><strong><span style="color: #3f529c"><span style="font-family: 'Segoe UI'">To enable the sa login by using Management Studio</span></span></strong></span><br /> <br /> <span style="font-family: 'Segoe UI'"><ol> <li data-xf-list-type="ol">In Object Explorer, expand <strong>Security</strong>, expand Logins, right-click <strong>sa</strong>, and then click <strong>Properties</strong>.</li> <li data-xf-list-type="ol">On the <strong>General</strong> page, you might have to create and confirm a password for the sa login.</li> <li data-xf-list-type="ol">On the <strong>Status</strong> page, in the <strong>Login</strong> section, click <strong>Enabled</strong>, and then click <strong>OK</strong>.</li> </ol></span> </li> </ul></p> <p style="text-align: left"></span></p></blockquote><p></p>
[QUOTE="wiiremote, post: 849906"] [SIZE=4][B][LEFT][COLOR=#3f529c][FONT=Segoe UI]To change security authentication mode[/FONT][/COLOR][/LEFT][/B][/SIZE] [LEFT][FONT=Segoe UI][LIST=1] [*]In SQL Server Management Studio Object Explorer, right-click the server, and then click [B]Properties[/B]. [*]On the [B]Security[/B] page, under [B]Server authentication[/B], select the new server authentication mode, and then click [B]OK[/B]. [*]In the SQL Server Management Studio dialog box, click [B]OK[/B] to acknowledge the requirement to restart SQL Server. [/LIST][/FONT][/LEFT] [SIZE=4][B][LEFT][COLOR=#3f529c][FONT=Segoe UI]To restart SQL Server from SQL Server Management Studio[/FONT][/COLOR][/LEFT][/B][/SIZE] [LEFT][FONT=Segoe UI][LIST] [*]In Object Explorer, right-click your server, and then click [B]Restart[/B]. If SQL Server Agent is running, it must also be restarted. [/LIST][/FONT][/LEFT] [SIZE=4][B][LEFT][COLOR=#3f529c][FONT=Segoe UI]To enable the sa login by using Transact-SQL[/FONT][/COLOR][/LEFT][/B][/SIZE] [LEFT][FONT=Segoe UI][LIST] [*]Execute the following statements to enable the sa password and assign a password. [FONT=Consolas]ALTER LOGIN sa ENABLE ; GO ALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ;[/FONT] [FONT=Consolas]GO[/FONT] [FONT=Consolas] [/FONT] [SIZE=4][B][COLOR=#3f529c][FONT=Segoe UI]To enable the sa login by using Management Studio[/FONT][/COLOR][/B][/SIZE] [FONT=Segoe UI][LIST=1] [*]In Object Explorer, expand [B]Security[/B], expand Logins, right-click [B]sa[/B], and then click [B]Properties[/B]. [*]On the [B]General[/B] page, you might have to create and confirm a password for the sa login. [*]On the [B]Status[/B] page, in the [B]Login[/B] section, click [B]Enabled[/B], and then click [B]OK[/B]. [/LIST][/FONT] [FONT=Consolas] [/FONT] [/LIST][/FONT][/LEFT] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
General Support
How to set Sql Authentication?
Contact us
RSS
Top
Bottom
