SQL Server needs to be configured to allow remote connections, and TCP protocol must be enabled.

>Hi
>
>I'm trying to set up a connection to a database in my SQL 2008, I've read that stage 1 is to create an ODBC connection
>
>So if I have this right I create a SQL ODBC Driver on the server.
>
>I go into Control Panel --> Administrative Tools --> Data Sources (ODBC)--.> Add System DSN
>
>SQL Server
>
>Which SQL Server do you want to connect to? Server:
>MSSQLServer
>
>or with the domain its hosted on:
>\\bungle\mssqlserver
>
>I'm using Windows Authentication
>
>Testing the connection always Fails!
>
>Specified SQL Server not found?
>
>HELP!!!!