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: 426198" data-attributes="member: 90819"><p><span style="font-size: 9px"><strong>TV-Server Version</strong>: 1.0.2</span></p><p><span style="font-size: 9px"><strong>MediaPortal Version</strong>: 1.01</span></p><p><span style="font-size: 9px"><strong>MediaPortal Skin</strong>: default</span></p><p><span style="font-size: 9px"><strong>Windows Version</strong>: Xp-Pro-Sp3</span></p><p><span style="font-size: 9px"><strong>CPU Type</strong>: Intel core-duo</span></p><p><span style="font-size: 9px"><strong>Memory</strong>: 2go</span></p><p><span style="font-size: 9px"><strong>Motherboard</strong>: Gigabyte P35</span></p><p><span style="font-size: 9px"><strong>Video Card</strong>: Msi Ati 2600 Pcie</span></p><p><span style="font-size: 9px"><strong>Video Card Driver</strong>: 9.x</span></p><p><span style="font-size: 9px"><strong>Sound Card</strong>: Realtek Alc889a</span></p><p><span style="font-size: 9px"><strong>1. TV Card</strong>: Leadtek WinFast PxDVR3200 H</span></p><p><span style="font-size: 9px"><strong>1. TV Card Type</strong>: Dvb-T + Analog Radio</span></p><p><span style="font-size: 9px"><strong>1. TV Card Driver</strong>: Bda 2.xxx</span></p><p><span style="font-size: 9px"><strong>MPEG2 Video Codec</strong>: Arcosft + multiple</span></p><p><span style="font-size: 9px"><strong>h.264 Video Codec</strong>: Arcosft + Coreavc +multiple</span></p><p><span style="font-size: 9px"><strong>Satelite/CableTV Provider</strong>: Free (freebox + multiposte)</span></p><p><span style="font-size: 9px"><strong>Remote</strong>: Ati remote wonder 1</span> </p><p></p><p>I had a 1.01 one-seat Tvserver installed with Mysql (working from few months without any install or usage issue)</p><p>I choosed to start from scratch removing and erasing all the MP data & configs ..</p><p>And also planed to install MP 1.02 on Ms Sql Server 2008 Express sp1 already installed with visual studio etc .. </p><p></p><p>and It's a mess !!!!</p><p>SqlServer is not in "mixed mode" but in "windows Authentication integrated mode"</p><p>Ok, i've read that mixed mode is required with SqlServerExpress 2005 </p><p><a href="https://www.team-mediaportal.com/manual/TV-Server/install-SQL-Server" target="_blank">TV-Server/install-SQL-Server - MediaPortal Manual Documentation</a></p><p></p><p><u>1st try- Install with "advanced option" and already installed database</u> option</p><p>When starting TvServer config, ask for user/pass with "sa" user</p><p>I can't as i'm not in "mixed mode" - "sa" will be deprecated in next releases and "sysadmin" is recommended - but can't use it</p><p>What is the solution with MP 1.02?? I looked for on Wiki and Forum, but didn't find </p><p></p><p><u>2nd try - using automatic install (risky isn't it)</u></p><p>MP start to download SqlExpress 2005 - then try to uninstall Sql Server 2008 - i let MP proceeding as i thought maybe will be possible after to configure Mp and upgrade to 2008...</p><p>But in fact, MP unsuccessfully finish the uninstall of 2008 and unsuccessfully install 2005, probably because there is a conflict between 2005 & 2008 - as a consequence MP Install the Client but don't install the Tv Server programm</p><p></p><p>Here, where i am ...</p><p>If anybody had some trick and tips about that, in advance, thanks for</p><p></p><p>But, for now, i decided to change the "Server Authentication" setting </p><p></p><p><strong>How to Change the Sql Server Authentication Mode ...</strong></p><p>Very easy process with "Microsoft Sql Server Management Studio" </p><p><a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displayLang=en" target="_blank">Download details: Microsoft SQL Server 2008 Management Studio Express</a></p><p></p><p><u>Step 1 - Reconfigure mode ....</u></p><p>-> Launch "Microsoft Sql Server Management Studio" Program</p><p>-> Loginto with your credentials, -> Right-click on the Top Tree instance Server (if you have more than one instance of sqlserver, there is more than one tree) -> Choose Properties -> On the popup window "Server Properties" choose "Security" -> In the "Server Authentication" Zone, choose the "Sql Server and Windows Auth....", this is the mixed mode</p><p>-> Restart the SqlServer (administration services - SQLEXPRESS)</p><p></p><p><u>Step 2 - Activate "sa" user or create one .. </u></p><p>-> Launch "Microsoft Sql Server Management Studio" Program</p><p>-> login with your credentials, </p><p>-> Go into the tree '/your.SqlServername'/Security/Logins/sa -> Right-Click on "sa" login -> Choose Properties</p><p>1) 'General' Tab - Set the password you choose - It will be the one the MP Install require </p><p>2) You can check "enforce pass policy" </p><p>3) If you choose "enforce pass expiration" you will be asked to change it at the expiration date</p><p>3) 'Status' Tab - verify and check "Login= enabled"</p><p>If you decide to create an account - be careful to select the adequate "server roles" and "user mapping"</p><p></p><p><u>Step 3 - Install MP Tv Server </u></p><p><a href="https://www.team-mediaportal.com/manual/GeneralUserGuides/Installation_SingleSeat_TvServer" target="_blank">GeneralUserGuides/Installation_SingleSeat_TvServer - MediaPortal Manual Documentation</a></p><p>-> Selecting Perform an Advanced Installation</p><p>-> Select "SQL Server is already present ...."</p><p>When you will start "TV Server Configuration" for the first time, it will display a windows to test the connection to SqlServer/Mysql, display the 'sa' user default login and ask you to set the password (the one from the last step)</p><p>-> Clic test - if success - click 'save' and the install process will continue</p><p></p><p><u>Trick for memory</u></p><p>Be careful because Sql Server is really hungry for memory - For the diet, </p><p>-> Launch "Microsoft Sql Server Management Studio" program</p><p>-> login with your credentials, </p><p>-> Right-Click into the tree '/your.SqlServername'/</p><p>-> Choose Properties</p><p>-> Select "Memory" Page </p><p>-> Adjust "Maximum server memory" (Awe is for 64bit)</p><p></p><p>Ok, i wrote that in the time i try this process on my installation and it works .. </p><p>all others posts are welcome ...</p></blockquote><p></p>
[QUOTE="incogito, post: 426198, member: 90819"] [SIZE=1][B]TV-Server Version[/B]: 1.0.2 [B]MediaPortal Version[/B]: 1.01 [B]MediaPortal Skin[/B]: default [B]Windows Version[/B]: Xp-Pro-Sp3 [B]CPU Type[/B]: Intel core-duo [B]Memory[/B]: 2go [B]Motherboard[/B]: Gigabyte P35 [B]Video Card[/B]: Msi Ati 2600 Pcie [B]Video Card Driver[/B]: 9.x [B]Sound Card[/B]: Realtek Alc889a [B]1. TV Card[/B]: Leadtek WinFast PxDVR3200 H [B]1. TV Card Type[/B]: Dvb-T + Analog Radio [B]1. TV Card Driver[/B]: Bda 2.xxx [B]MPEG2 Video Codec[/B]: Arcosft + multiple [B]h.264 Video Codec[/B]: Arcosft + Coreavc +multiple [B]Satelite/CableTV Provider[/B]: Free (freebox + multiposte) [B]Remote[/B]: Ati remote wonder 1[/SIZE] I had a 1.01 one-seat Tvserver installed with Mysql (working from few months without any install or usage issue) I choosed to start from scratch removing and erasing all the MP data & configs .. And also planed to install MP 1.02 on Ms Sql Server 2008 Express sp1 already installed with visual studio etc .. and It's a mess !!!! SqlServer is not in "mixed mode" but in "windows Authentication integrated mode" Ok, i've read that mixed mode is required with SqlServerExpress 2005 [url=https://www.team-mediaportal.com/manual/TV-Server/install-SQL-Server]TV-Server/install-SQL-Server - MediaPortal Manual Documentation[/url] [U]1st try- Install with "advanced option" and already installed database[/U] option When starting TvServer config, ask for user/pass with "sa" user I can't as i'm not in "mixed mode" - "sa" will be deprecated in next releases and "sysadmin" is recommended - but can't use it What is the solution with MP 1.02?? I looked for on Wiki and Forum, but didn't find [U]2nd try - using automatic install (risky isn't it)[/U] MP start to download SqlExpress 2005 - then try to uninstall Sql Server 2008 - i let MP proceeding as i thought maybe will be possible after to configure Mp and upgrade to 2008... But in fact, MP unsuccessfully finish the uninstall of 2008 and unsuccessfully install 2005, probably because there is a conflict between 2005 & 2008 - as a consequence MP Install the Client but don't install the Tv Server programm Here, where i am ... If anybody had some trick and tips about that, in advance, thanks for But, for now, i decided to change the "Server Authentication" setting [B]How to Change the Sql Server Authentication Mode ...[/B] Very easy process with "Microsoft Sql Server Management Studio" [url=http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displayLang=en]Download details: Microsoft SQL Server 2008 Management Studio Express[/url] [U]Step 1 - Reconfigure mode ....[/U] -> Launch "Microsoft Sql Server Management Studio" Program -> Loginto with your credentials, -> Right-click on the Top Tree instance Server (if you have more than one instance of sqlserver, there is more than one tree) -> Choose Properties -> On the popup window "Server Properties" choose "Security" -> In the "Server Authentication" Zone, choose the "Sql Server and Windows Auth....", this is the mixed mode -> Restart the SqlServer (administration services - SQLEXPRESS) [U]Step 2 - Activate "sa" user or create one .. [/U] -> Launch "Microsoft Sql Server Management Studio" Program -> login with your credentials, -> Go into the tree '/your.SqlServername'/Security/Logins/sa -> Right-Click on "sa" login -> Choose Properties 1) 'General' Tab - Set the password you choose - It will be the one the MP Install require 2) You can check "enforce pass policy" 3) If you choose "enforce pass expiration" you will be asked to change it at the expiration date 3) 'Status' Tab - verify and check "Login= enabled" If you decide to create an account - be careful to select the adequate "server roles" and "user mapping" [U]Step 3 - Install MP Tv Server [/U] [url=https://www.team-mediaportal.com/manual/GeneralUserGuides/Installation_SingleSeat_TvServer]GeneralUserGuides/Installation_SingleSeat_TvServer - MediaPortal Manual Documentation[/url] -> Selecting Perform an Advanced Installation -> Select "SQL Server is already present ...." When you will start "TV Server Configuration" for the first time, it will display a windows to test the connection to SqlServer/Mysql, display the 'sa' user default login and ask you to set the password (the one from the last step) -> Clic test - if success - click 'save' and the install process will continue [U]Trick for memory[/U] Be careful because Sql Server is really hungry for memory - For the diet, -> Launch "Microsoft Sql Server Management Studio" program -> login with your credentials, -> Right-Click into the tree '/your.SqlServername'/ -> Choose Properties -> Select "Memory" Page -> Adjust "Maximum server memory" (Awe is for 64bit) Ok, i wrote that in the time i try this process on my installation and it works .. all others posts are welcome ... [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Installation, configuration support
Sql Server 2008 Authentication mode issue
Contact us
RSS
Top
Bottom
