Reply to thread

Message

<blockquote data-quote="nathang" data-source="post: 279452" data-attributes="member: 57623">For those using SQL Server 2005 Express Edition as the database on the TV server:Just a reminder that if you are going to set up a multi-seat environment, as well as configuring the firewalls on server and client computers, you also need to configure SQL Server Express to allow remote connections - by default it only accepts local connections, i.e. from the computer it is running on.To do this, go into Programs &gt; Microsoft SQL Server 2005 &gt; Configuration Tools &gt; SQL Server Surface Area Configuration Click on the option for &quot;Surface Area configuration for Services and Connections&quot;Select the component called &quot;Remote Connections&quot; and change the setting to &quot;Local and Remote connections&quot; and &quot;Using TCP/IP only&quot;.Click OK - you will see a prompt to restart the service for this to take effect. (You can restart the through the SQL Server Configuration Manager, the Services administrative tool, or just restart the computer).</blockquote>

[QUOTE="nathang, post: 279452, member: 57623"] For those using SQL Server 2005 Express Edition as the database on the TV server: Just a reminder that if you are going to set up a multi-seat environment, as well as configuring the firewalls on server and client computers, you also need to configure SQL Server Express to allow remote connections - by default it only accepts local connections, i.e. from the computer it is running on. To do this, go into Programs > Microsoft SQL Server 2005 > Configuration Tools > [B]SQL Server Surface Area Configuration [/B] Click on the option for "Surface Area configuration for Services and Connections" Select the component called "Remote Connections" and change the setting to "Local and Remote connections" and "Using TCP/IP only". Click OK - you will see a prompt to restart the service for this to take effect. (You can restart the through the SQL Server Configuration Manager, the Services administrative tool, or just restart the computer). [/QUOTE]

Verification