
May 3rd, 2012, 04:59 AM
|
|
Contributing User
|
|
Join Date: Mar 2008
Posts: 140
Time spent in forums: 17 h 21 m 53 sec
Reputation Power: 6
|
|
|
MSSQL remote connections refused!
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
SERVER/SPSQL
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
http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx
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?
Thanks!
|