SQL Issuses (1 Viewer)

[copperwave]

TV-Server Version: 19603
MediaPortal Version: 19603
MediaPortal Skin: Blue
Windows Version: XP SP2
CPU Type: Athlon 64bit
HDD: Several
Memory: 2GB
Motherboard: N/A
Video Card: N/A
Video Card Driver: N/A
Sound Card: N/A
Sound Card AC3: N/A

Sound Card Driver: N/A
1. TV Card: Hauppauge Nova DT
1. TV Card Type:
1. TV Card Driver:
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec:
MPEG2 Audio Codec:
h.264 Video Codec:
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote:
TV:
TV - HTPC Connection: LAN


I have TVServer Multi-seat working very nicely to two other MP Clients. Problem is I cannot get my preferred PC (the one detailed above) to connect to the freakin TVServer. All three clients are on the same network & subnet. They can all see each other (there are also no firewalls active) and all three can pull video content off the server drives no problem. I think (after trawling the forums) it is an SQL on this PC as opposed to SQL on the server issue. I have applied all the various SP's detailed elsewhere...still no joy. Log is attached.

I have also tried renaming the TVServer from its' host name to its' IP address. Again, the two clients that worked before continue to work fine....just this guy refuses to connect to the DB.

I think what I would dearly love is some kind of SQL client test tool...any idea's?

Thanks in advance

//copperwave

 

[burr]

I think the problem is the ip adress set for the TvServer look at this link on how to change it. https://forum.team-mediaportal.com/get-support-90/change-network-connection-33850/

/Mathias

 

[copperwave]

Hi- thanks for taking the time to respond. Did you come to this conclusion by looking at the logs? My TVServer is already set for a static IP address and is set to "Master Server". Are you suggesting I set it some other IP address or just to make sure it is set to what the network card is set to? Don't forget I already have it working fine to two other MP clients.

Thanks
//copperwave

 

[Marcusb]

I had a similar issue a while ago.
In the TV server console, check the IP address that the server is listed as, or is it listed as a server name?
In the logs, it looks like the server is called HTPC.
Check if the others are also using HTPC or if they are using the IP address. I find for best reliability it's best to always use the IP address to specify the server. This can eliminate any DNS issues or such.

It's just a wild guess, as I am about to head out so only had a very quick look but it doesn't hurt to try that.

 

[Mouch.net]

Maybe you can also check if your SQL server allows remote connections with Pipe and TCP/IP.
a second point i'm not sure aout in the express version:
standard version doesn't allow password authentication in the default configuration.
maybe you can also check this.

 

[burr]

Hi- thanks for taking the time to respond. Did you come to this conclusion by looking at the logs? My TVServer is already set for a static IP address and is set to "Master Server". Are you suggesting I set it some other IP address or just to make sure it is set to what the network card is set to? Don't forget I already have it working fine to two other MP clients.

Thanks
//copperwave

If you look in the TvServer error log you can see that it's trying to connect to 127.0.0.1. But if you have two clients this can't be the problem, do you remember what
password you set during installation of TvServer?.

 

[copperwave]

In the TV server console, check the IP address that the server is listed as, or is it listed as a server name?

It is in as an IP address - the same address as the network card used to connect to the LAN with.

In the logs, it looks like the server is called HTPC.

Hmmm, it was originally configured as this - but then the other two clients that can connect were happy with this.
It has only changed to a fixed IP address following the various tips & tricks on the board - and even stranger...I am sure I have re-installed the MP client with the server set to an IP address...so where is it getting this from....is there some registry value left lurking around?

TIA
//copperwave

 

[copperwave]

If you look in the TvServer error log you can see that it's trying to connect to 127.0.0.1. But if you have two clients this can't be the problem, do you remember what password you set during installation of TvServer?.

I used the default "MediaPortal"

//copperwave

 

[burr]

In the logs, it looks like the server is called HTPC.

Hmmm, it was originally configured as this - but then the other two clients that can connect were happy with this.
It has only changed to a fixed IP address following the various tips & tricks on the board - and even stranger...I am sure I have re-installed the MP client with the server set to an IP address...so where is it getting this from....is there some registry value left lurking around?

TIA
//copperwave

Look inside MediaPortal.xml and search for the parameter "hostname" and look for the value?

/Mathias

 

[copperwave]

In the logs, it looks like the server is called HTPC.

Hmmm, it was originally configured as this - but then the other two clients that can connect were happy with this.
It has only changed to a fixed IP address following the various tips & tricks on the board - and even stranger...I am sure I have re-installed the MP client with the server set to an IP address...so where is it getting this from....is there some registry value left lurking around?

TIA
//copperwave

Look inside MediaPortal.xml and search for the parameter "hostname" and look for the value?

/Mathias

OK - a trawl through MediaPortal.xml in \Documents and Settings\All Users\Application Data\Team MediaPortal\MediaPortal comes up with:

<section name="tvservice">
<entry name="hostname">192.168.2.210</entry>
<entry name="preferac3">no</entry>
<entry name="preferAudioTypeOverLang">yes</entry>
<entry name="dvbbitmapsubtitles">no</entry>
<entry name="dvbttxtsubtitles">no</entry>
<entry name="audiodualmono">no</entry>
<entry name="preferredaudiolanguages">
</entry>
<entry name="preferredsublanguages">
</entry>
</section>

This is the same as the working clients....any other idea's? Like I said I am sure the problem is at the DB connectivity level, not MP itself.

Regards
//copperwave