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
Installation, configuration support
Sql Server 2008 Authentication mode issue
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="incogito" data-source="post: 426957" data-attributes="member: 90819"><p>"sysadmin" appears on sql server 2008 with same rights than sa</p><p>Referencing to some sources, 'sa' will be removed in next version </p><p><a href="http://blog.sqlauthority.com/2008/07/12/sql-server-2008-user-account-sa-or-sysadmin/" target="_blank">SQL SERVER – 2008 – User Account – sa or sysadmin Journey to SQL Authority with Pinal Dave</a></p><p>the two "authentication mode" will no changed, it's just an reorganization of group/user</p><p></p><p></p><p>The reason i post here, was </p><p>1) verifying that "mixed mode" is absolutely necessary - answer = Yes</p><p>2) Report the MP installation trying to un-install Sql Server 2008 and downloading & installing SqlServer Express 2005 without success for both</p><p>3) as i didn't find anywhere in MediaPortal Domain an explanation of the "how to" for people with my configuration, i decided to share and explain the procedure to swap the Authentication Mode with Sql Server 2008 (different from the 2005 one procedure)</p></blockquote><p></p>
[QUOTE="incogito, post: 426957, member: 90819"] "sysadmin" appears on sql server 2008 with same rights than sa Referencing to some sources, 'sa' will be removed in next version [url=http://blog.sqlauthority.com/2008/07/12/sql-server-2008-user-account-sa-or-sysadmin/]SQL SERVER – 2008 – User Account – sa or sysadmin Journey to SQL Authority with Pinal Dave[/url] the two "authentication mode" will no changed, it's just an reorganization of group/user The reason i post here, was 1) verifying that "mixed mode" is absolutely necessary - answer = Yes 2) Report the MP installation trying to un-install Sql Server 2008 and downloading & installing SqlServer Express 2005 without success for both 3) as i didn't find anywhere in MediaPortal Domain an explanation of the "how to" for people with my configuration, i decided to share and explain the procedure to swap the Authentication Mode with Sql Server 2008 (different from the 2005 one procedure) [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Installation, configuration support
Sql Server 2008 Authentication mode issue
Contact us
RSS
Top
Bottom