Reply to thread

Message

<blockquote data-quote="thebalance" data-source="post: 347945" data-attributes="member: 81611">I've made some progress - it appears that the problem is with the server not the client &amp; I know that because ...SQL Server Express 2005 has installed using dynamic TCP ports for connections - that randomly allocates a potentially different port to use everything the service starts (madness but if using SQL Server browser the system can work). So I have set that to have a static port number 1433 and that is no longer a problem for the TV client.However, port 554 still is. I can see using netstat -an that the port is listening on the server however the difference is that 1433 is listening on IP 0.0.0.0 whilst 554 is listening on 127.0.0.1 which is about as useless as I can think of (if you are wondering why I say that, 127.0.0.1 is the current machine ie itself). TV Service is clearly configured to use that (currports from nirsoft.net is a handy freebie).Could it be because I originally installed the server as a dedicated machine (probably not because I did get TV once for a few minutes but I don't know what changed).Can anyone tell me how to make the TV service listen in the correct place / solve my problem?Thanks</blockquote>

[QUOTE="thebalance, post: 347945, member: 81611"] I've made some progress - it appears that the problem is with the server not the client & I know that because ... SQL Server Express 2005 has installed using dynamic TCP ports for connections - that randomly allocates a potentially different port to use everything the service starts (madness but if using SQL Server browser the system can work). So I have set that to have a static port number 1433 and that is no longer a problem for the TV client. However, port 554 still is. I can see using netstat -an that the port is listening on the server however the difference is that 1433 is listening on IP 0.0.0.0 whilst 554 is listening on 127.0.0.1 which is about as useless as I can think of (if you are wondering why I say that, 127.0.0.1 is the current machine ie itself). TV Service is clearly configured to use that (currports from nirsoft.net is a handy freebie). Could it be because I originally installed the server as a dedicated machine (probably not because I did get TV once for a few minutes but I don't know what changed). Can anyone tell me how to make the TV service listen in the correct place / solve my problem? Thanks [/QUOTE]

Verification