Reply to thread

Message

<blockquote data-quote="copperwave" data-source="post: 285450" data-attributes="member: 52084">Hi burr many thanks for this. Not sure what the valid test cases should be but here are my results. Note that I too had installed the TVServer DB with sa/MediaPortal.Test #1: Run from the ..\Media Portal dir on the TVServer itself:Write the Client to connect to...192.16.2.210An error has occurred while establishing a connection to the server.&nbsp; When connecting to SQL Server 2005, this failure may be caused by the fact that under thedefault settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)The connection didn't succeedTest #2: Again from the TVServer itself but this time using the PC's hostname: htpcWrite the Client to connect to...htpcCannot open database &quot;TvLibrary&quot; requested by the login. The login failed.Login failed for user 'sa'.The connection didn't succeedPress a key to end the program.....Test # 3 - From the &quot;client&quot; PC that doesn't work - with htpc as the hostname:Write the Client to connect to...htpcAn error has occurred while establishing a connection to the server.&nbsp; When connecting to SQL Server 2005, this failure may be caused by the fact that under thedefault settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)The connection didn't succeedTest #4: Again from the failing PC but this time with the IP address:Write the Client to connect to...192.168.2.210Cannot open database &quot;TvLibrary&quot; requested by the login. The login failed.Login failed for user 'sa'.The connection didn't succeedI would have thought at the very least running this in the TVServer would have run OK...like I say it is very weird&nbsp; <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite3" alt=":(" title="Frown&nbsp; &nbsp; :(" loading="lazy" data-shortname=":(" />Thanks//copperwave</blockquote>

[QUOTE="copperwave, post: 285450, member: 52084"] Hi burr many thanks for this. Not sure what the valid test cases should be but here are my results. Note that I too had installed the TVServer DB with sa/MediaPortal. Test #1: Run from the ..\Media Portal dir on the TVServer itself: Write the Client to connect to... 192.16.2.210 An error has occurred while establishing a connection to the server. When conne cting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Ne twork Interfaces, error: 26 - Error Locating Server/Instance Specified) The connection didn't succeed Test #2: Again from the TVServer itself but this time using the PC's hostname: htpc Write the Client to connect to... htpc Cannot open database "TvLibrary" requested by the login. The login failed. Login failed for user 'sa'. The connection didn't succeed Press a key to end the program..... Test # 3 - From the "client" PC that doesn't work - with htpc as the hostname: Write the Client to connect to... htpc An error has occurred while establishing a connection to the server. When conne cting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Ne twork Interfaces, error: 26 - Error Locating Server/Instance Specified) The connection didn't succeed Test #4: Again from the failing PC but this time with the IP address: Write the Client to connect to... 192.168.2.210 Cannot open database "TvLibrary" requested by the login. The login failed. Login failed for user 'sa'. The connection didn't succeed I would have thought at the very least running this in the TVServer would have run OK...like I say it is very weird :( Thanks //copperwave [/QUOTE]

Verification