SQL issue during installation and afterward as well (1 Viewer)

[ps-gunkie]

MediaPortal Version: 1.1.0
MediaPortal Skin: Default
Windows Version: Windows 7 Ultimate x64
CPU Type: Intel Core2 Quad Q9550 E0 @ 2.83GHz
HDD: Western Digital Caviar Black 1TB
Memory: 4 x 2GB Corsair XMS2 DDR2 800MHz
Motherboard: Gigabyte GA-EP45-UD3R
Video Card: Zotac GeForce 9800GT Synergy 512MB
Video Card Driver: 258.96
Sound Card: Asus Xonar DX
Sound Card Driver: 7.12.8.1780
1. TV Card: Creatix CTX 953
1. TV Card Type: analog & DVB-T
1. TV Card Driver: 1.4.0.3
Satelite/CableTV Provider: Telenet
HTPC Case: Antec P183
Cooling: CPU: ThermalRight Ultra Extreme Black + Scythe S-Flex 1600; Case: 2x Antec TriCool exhaust
Power Supply: Corsair HX750
Remote: X10 RF Vista Remote Control OR24V
TV: ADI 14" LCD Monitor
TV - HTPC Connection: VGA

During the MediaPortal setup, it tells me that Microsoft SQL Server 2005 is disabled, but that it will install MySQL 5. When the "Setup database connection" window appears, I can try either of the options with the suggested password ("MediaPortal") but neither will work. When I test the Microsoft SQL Server 2005 option I first get this:

---------------------------
Error
---------------------------
Connection error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
---------------------------
OK   
---------------------------

and when I click "OK", I get the same error in a different message box. Clicking "OK" on that window brings me back to the database setup window with the Hostname and Dependency fields colored red.

When I test MySQL 5, the Dependency field turns green. Then I get this message along with the Hostname field turning red:

---------------------------

---------------------------
Connection failed!
Unable to connect to any of the specified MySQL hosts.
---------------------------
OK   
---------------------------

In addition to that, the link at the top of the database setup window leads here, which gives me a very useful "You are not allowed to view this page.".

Any help would be highly appreciated as I've just about had it with Windows Media Center . Thanks in advance!

 

[llambion]

I try to install tvserver now and i have the same problem.
I use MePo 1.1.0 final over windows 7 professional x32

 

[chemelli]

can you both please post a screenshot of the DB dialog form filled ? And logs as well.

Simone

 

[ps-gunkie]

I'd love to post a log, but after launching the Debugger and hitting Proceed, it throws an Unhandled exception for a missing file (C:\ProgramData\Team MediaPortal\MediaPortal\MediaPortal.xml). Details here:

************** Exception Text **************
System.IO.FileNotFoundException: Could not find file 'C:\ProgramData\Team MediaPortal\MediaPortal\MediaPortal.xml'.
File name: 'C:\ProgramData\Team MediaPortal\MediaPortal\MediaPortal.xml'
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite)
   at WatchDog.MPWatchDog.CreateTemporaryConfiguration()
   at WatchDog.MPWatchDog.GetMPArguments()
   at WatchDog.MPWatchDog.LaunchMediaPortalAction()
   at WatchDog.MPWatchDog.ProceedButton_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
WatchDog
    Assembly Version: 1.1.0.16047
    Win32 Version: 1.1.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Team%20MediaPortal/MediaPortal/WatchDog.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Utils
    Assembly Version: 2.2.7.16040
    Win32 Version: 2.2.7.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Team%20MediaPortal/MediaPortal/Utils.DLL
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------

As for the screenie, here you go:

 

[chemelli]

really confusing: the DB form is from Tv-Server, the jit error from mediaportal.xml

Simone

 

[ps-gunkie]

No, the error is from the Debugger, it pops up after I click Proceed in the Debugger to try and generate that log for you.

 

[chemelli]

What I mean is that is doesn't make sense that mediaportal.xml is accessed by DB form or Tv-Server in general.

Simone

 

[ps-gunkie]

It's not, it's accessed by the Debugger. The error happens during the loading of the debugger, before I access the DB connection screen or the TV Server in general.

Anyway, any idea on how I fix the issue with the Debugger or the issue with the DB connection?

 

[chemelli]

if you use SQL managent interface, does it works or not ?

Simone

 

[ps-gunkie]

Huh? I'm not sure I understand what you mean by that. If you mean the MySQL Server Instance Configuration Wizard, I don't have any experience using that.