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
What are the correct settings for user "sa" in MSSQL Express?
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="etheesdad" data-source="post: 335484" data-attributes="member: 84335"><p><strong>TV-Server Version</strong>: svn2075</p><p><strong>MediaPortal Version</strong>: svn2075</p><p><strong>MediaPortal Skin</strong>: monochrome</p><p><strong>Windows Version</strong>: xp mce sp3</p><p><strong>CPU Type</strong>: celeron 2.4</p><p><strong>HDD</strong>: seagate 80 + WD 160</p><p><strong>Memory</strong>: 1gb ddr</p><p><strong>Motherboard</strong>: ga-8ig1000 pro</p><p><strong>Video Card</strong>: radeon 9200 se</p><p><strong>Video Card Driver</strong>: 8.252.0.0</p><p><strong>Sound Card</strong>: soundblaster</p><p><strong>Sound Card AC3</strong>: </p><p><strong>Sound Card Driver</strong>: 5.1.260.5512</p><p><strong>1. TV Card</strong>: hve-1100</p><p><strong>1. TV Card Type</strong>: dvb-t</p><p><strong>1. TV Card Driver</strong>: 2.122.2619.0</p><p><strong>2. TV Card</strong>: dvt2000h</p><p><strong>2. TV Card Type</strong>: dvb-t</p><p><strong>2. TV Card Driver</strong>: 4.0.112.3113</p><p><strong>3. TV Card</strong>: </p><p><strong>3. TV Card Type</strong>: </p><p><strong>3. TV Card Driver</strong>: </p><p><strong>4. TV Card</strong>: </p><p><strong>4. TV Card Type</strong>: </p><p><strong>4. TV Card Driver</strong>: </p><p><strong>MPEG2 Video Codec</strong>: k-lite</p><p><strong>MPEG2 Audio Codec</strong>: k-lite</p><p><strong>h.264 Video Codec</strong>: k-lite</p><p><strong>Satelite/CableTV Provider</strong>: </p><p><strong>HTPC Case</strong>: silverstone lc20</p><p><strong>Cooling</strong>: custom</p><p><strong>Power Supply</strong>: </p><p><strong>Remote</strong>: imon</p><p><strong>TV</strong>: </p><p><strong>TV - HTPC Connection</strong>: s-video</p><p></p><p>Ive got a recurring error trying to start tv server, with login failling for user "sa". This is from a fresh install of tvserver and mssql express. </p><p></p><p>I have not changed anything from default settings, and followed the instructions here to do the install</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>Firewall allows connection. (single seat setup). SQL Browser service is running.</p><p></p><p>---------</p><p></p><p>MEDIABOX5\SQLEXPRESS\Databases\MpTvDbRC2\Security\Users\</p><p></p><p>sa is not listed. Is this correct?</p><p></p><p>---------</p><p></p><p>MEDIABOX5\SQLEXPRESS\Databases\MpTvDbRC2\Security\Users\dbo</p><p></p><p>login name - sa</p><p></p><p>Owned schemas</p><p>(none)</p><p></p><p>Database Role Membership</p><p>- db_owner</p><p></p><p>MEDIABOX5\SQLEXPRESS\Security\Logins\sa</p><p></p><p>General</p><p>- enforce password policy is ticked</p><p>- default database = master</p><p></p><p>Server Roles</p><p>- public</p><p>- sysadmin</p><p></p><p>User mapping</p><p>:users mapped to this login</p><p>- master</p><p>- model</p><p>- MpTvDbRC2</p><p>- msdb</p><p>- tempdb</p><p></p><p>Database role membership </p><p>- db_owner</p><p>- public</p><p></p><p>Status</p><p>: permission to connect</p><p>- grant</p><p></p><p>:login</p><p>- enabled</p><p></p><p>(login is not "locked out")</p><p></p><p>-------------</p><p></p><p>Are there any other elements I should be looking at?</p><p></p><p>Thanks very much to anyone familiar with MSSQL who can help. </p><p></p><p>BTW, it would be really useful to have working settings for single-seat & multi-seat installations posted in the documentation for TV server....</p></blockquote><p></p>
[QUOTE="etheesdad, post: 335484, member: 84335"] [b]TV-Server Version[/b]: svn2075 [b]MediaPortal Version[/b]: svn2075 [b]MediaPortal Skin[/b]: monochrome [b]Windows Version[/b]: xp mce sp3 [b]CPU Type[/b]: celeron 2.4 [b]HDD[/b]: seagate 80 + WD 160 [b]Memory[/b]: 1gb ddr [b]Motherboard[/b]: ga-8ig1000 pro [b]Video Card[/b]: radeon 9200 se [b]Video Card Driver[/b]: 8.252.0.0 [b]Sound Card[/b]: soundblaster [b]Sound Card AC3[/b]: [b]Sound Card Driver[/b]: 5.1.260.5512 [b]1. TV Card[/b]: hve-1100 [b]1. TV Card Type[/b]: dvb-t [b]1. TV Card Driver[/b]: 2.122.2619.0 [b]2. TV Card[/b]: dvt2000h [b]2. TV Card Type[/b]: dvb-t [b]2. TV Card Driver[/b]: 4.0.112.3113 [b]3. TV Card[/b]: [b]3. TV Card Type[/b]: [b]3. TV Card Driver[/b]: [b]4. TV Card[/b]: [b]4. TV Card Type[/b]: [b]4. TV Card Driver[/b]: [b]MPEG2 Video Codec[/b]: k-lite [b]MPEG2 Audio Codec[/b]: k-lite [b]h.264 Video Codec[/b]: k-lite [b]Satelite/CableTV Provider[/b]: [b]HTPC Case[/b]: silverstone lc20 [b]Cooling[/b]: custom [b]Power Supply[/b]: [b]Remote[/b]: imon [b]TV[/b]: [b]TV - HTPC Connection[/b]: s-video Ive got a recurring error trying to start tv server, with login failling for user "sa". This is from a fresh install of tvserver and mssql express. I have not changed anything from default settings, and followed the instructions here to do the install [url=https://www.team-mediaportal.com/manual/TV-Server/install-SQL-Server]TV-Server/install-SQL-Server - MediaPortal Manual Documentation[/url] Firewall allows connection. (single seat setup). SQL Browser service is running. --------- MEDIABOX5\SQLEXPRESS\Databases\MpTvDbRC2\Security\Users\ sa is not listed. Is this correct? --------- MEDIABOX5\SQLEXPRESS\Databases\MpTvDbRC2\Security\Users\dbo login name - sa Owned schemas (none) Database Role Membership - db_owner MEDIABOX5\SQLEXPRESS\Security\Logins\sa General - enforce password policy is ticked - default database = master Server Roles - public - sysadmin User mapping :users mapped to this login - master - model - MpTvDbRC2 - msdb - tempdb Database role membership - db_owner - public Status : permission to connect - grant :login - enabled (login is not "locked out") ------------- Are there any other elements I should be looking at? Thanks very much to anyone familiar with MSSQL who can help. BTW, it would be really useful to have working settings for single-seat & multi-seat installations posted in the documentation for TV server.... [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
General Support
What are the correct settings for user "sa" in MSSQL Express?
Contact us
RSS
Top
Bottom
