SQL-Server 2005

Allow other PC's to connect over LAN

!!!ATTENTION!!!

If you are running your SQL server on a dedicated Server and have Client HTPC's which must be able to connect to the SQL server, then you have to allow Remote Connections.

1. Open Surface Area Configuration under All Programs -> Microsoft SQL Server 2005 -> Configuration tools -> SQL Server Surface Area Configuration.

2. Select Surface Area Configuration for Services and Connections

3. Select remote connections on the left.

4. Enable Local and remote connections and select Using both TCP/IP and named pipes.

   • note: You may have to restart the SQL server.

5. Select SQL Server Browser and Service under that, and change the Startup Type to Automatic and Start it.

Required running SQL Service

!!!ATTENTION!!!

Make sure that the windows service SQL Server Browser is configured to be started automaticaly. If it is not, then clients in the LAN are unable to connect to your SQL-Server, which means that MyTV will not work!

To check if this service is enabled go to Start -> run -> enter services.msc

Limit SQL Server 2005 memory usage

By default SQL Server decides itself how much memory it uses. But in some cases like a single-seat configuration you might want to limit the memory used by Sql Server You can configure the min/max amount by :

1. Open SQL Server Management Studio Express under All Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio Express.

2. Select Right click on the server and select properties

3. Click on memory in the left tree
4. Fill in the min/max values for the amount of memory