Hi, i have configured MSSQL 2008 and have setup a named instance SPSQL.

I am trying to allow remote connections to this instance. My server name is SERVER


However, the program and client will not connect to this SQL Server. I can sucessfully logon to the instance with windows authentication on the SERVER (localhost)

I have followed this guide


specified a port in configuration manager, opened it in firewall, and also added sqlservr.exe for my instance as a program. None of these have worked!

Has anyone any ideas?