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
Watch / Listen Media
Television (MyTV frontend and TV-Server)
Having trouble setting up MsSQL 2005 on Vista?
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="risu" data-source="post: 234308" data-attributes="member: 25038"><p>I recently tried installing TV server to Vista and had new problems. When I initially (and later) tried to start setuptv, I got error telling I couldn't get access to sql service.</p><p></p><p>Last time I tried on clean install MsSQL 2005 Express SP2, but I'm pretty sure I got this with normal package too. If you are having this problem, here are some solutions:</p><p></p><p>1) You may have installed multiple intances of SQL Service or got instances named differently from default which TVServer is looking for. When you initially start up TV Server, it asks you connection type, You have to put the instance of SQL that's correctly setup for TV server use on that textbox. You can find running instance name by browsing Windows Services. If possible remove all other instances with Control Panels Programs -utility if you can.</p><p></p><p>If you however, can't even get to connection type configuration you may have following:</p><p></p><p>2) You haven't made exceptions for firewall settings. Make sure sqlservice and sqlbrowser are allowed to pass through (and tvservice too).</p><p></p><p>3) MsSQL is configured to use dynamic IP addresses (I had this one). You can force it to use port 1433 using SQL Server Configuration Manager. With Manager, select SQL Server 2005 Network Configuration -> Protocols. Select TCP/IP and right click to adjust its properties, select IP Addresses tab and go to bottom where you find IPAll, there clear the value from TCP Dynamic Ports and add 1433 to TCP Port. After this either reboot computer or restart SQL Service.</p><p></p><p></p><p><strong>EDIT-> ADDED:</strong></p><p>I also had trouble with MySQL running on Vista. I couldn't get the one pointed from Wiki (5.0) to install at all on Vista. I found out that 6.0 alpha did install and work with TV Server but on my machine if was way too slow for some reason. I later found out that Chemelli posted this: <a href="https://forum.team-mediaportal.com/get-support-90/mysql-5-0-51a-install-under-vista-35478/" target="_blank">https://forum.team-mediaportal.com/get-support-90/mysql-5-0-51a-install-under-vista-35478/</a></p><p></p><p>4) When installing TV Server nightly build from fresh, I usually get gentle.config file which doesn't point to any database. In this case TV Server doesn't start up at all. So find the line for DefaultProvider and add Data Source=computername\SQLEXPRESS; as follows:</p><p></p><p><DefaultProvider name="SQLServer" connectionString="Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=HTPC\SQLEXPRESS;" /></p><p></p><p>Please note that you have to use password you entered during mssql installation. I used default "sa" on this example.</p><p></p><p>Gentle.config is used at least on ProgramData\MediaPortal TV Server and on Program Files\Team MediaPortal\MediaPortal TV Server (maybe on MediaPortal client folder too?). So modification is needed to these files. </p><p></p><p>If your mini-EPG doesn't work but rest of your TV does with tv-server, it's likely that you have at least one gentle.config -file missing data source.</p></blockquote><p></p>
[QUOTE="risu, post: 234308, member: 25038"] I recently tried installing TV server to Vista and had new problems. When I initially (and later) tried to start setuptv, I got error telling I couldn't get access to sql service. Last time I tried on clean install MsSQL 2005 Express SP2, but I'm pretty sure I got this with normal package too. If you are having this problem, here are some solutions: 1) You may have installed multiple intances of SQL Service or got instances named differently from default which TVServer is looking for. When you initially start up TV Server, it asks you connection type, You have to put the instance of SQL that's correctly setup for TV server use on that textbox. You can find running instance name by browsing Windows Services. If possible remove all other instances with Control Panels Programs -utility if you can. If you however, can't even get to connection type configuration you may have following: 2) You haven't made exceptions for firewall settings. Make sure sqlservice and sqlbrowser are allowed to pass through (and tvservice too). 3) MsSQL is configured to use dynamic IP addresses (I had this one). You can force it to use port 1433 using SQL Server Configuration Manager. With Manager, select SQL Server 2005 Network Configuration -> Protocols. Select TCP/IP and right click to adjust its properties, select IP Addresses tab and go to bottom where you find IPAll, there clear the value from TCP Dynamic Ports and add 1433 to TCP Port. After this either reboot computer or restart SQL Service. [B]EDIT-> ADDED:[/B] I also had trouble with MySQL running on Vista. I couldn't get the one pointed from Wiki (5.0) to install at all on Vista. I found out that 6.0 alpha did install and work with TV Server but on my machine if was way too slow for some reason. I later found out that Chemelli posted this: [url]https://forum.team-mediaportal.com/get-support-90/mysql-5-0-51a-install-under-vista-35478/[/url] 4) When installing TV Server nightly build from fresh, I usually get gentle.config file which doesn't point to any database. In this case TV Server doesn't start up at all. So find the line for DefaultProvider and add Data Source=computername\SQLEXPRESS; as follows: <DefaultProvider name="SQLServer" connectionString="Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=HTPC\SQLEXPRESS;" /> Please note that you have to use password you entered during mssql installation. I used default "sa" on this example. Gentle.config is used at least on ProgramData\MediaPortal TV Server and on Program Files\Team MediaPortal\MediaPortal TV Server (maybe on MediaPortal client folder too?). So modification is needed to these files. If your mini-EPG doesn't work but rest of your TV does with tv-server, it's likely that you have at least one gentle.config -file missing data source. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Watch / Listen Media
Television (MyTV frontend and TV-Server)
Having trouble setting up MsSQL 2005 on Vista?
Contact us
RSS
Top
Bottom