Cannot Remote Connect to SQL2008 on Windows Server 2008
I would like to upgrade a desktop from Windows 7 to Server 2008 and
host SQL instances on it in my home Workgroup network. But before I do
that, I am running a test of this configuration with a VMWare Virtual
I have just a single instance of SQL2008 installed in a VM running
Windows Server 2008. The VM is in the same workgroup as my Windows 7
notebook. I have an login account on it that is the name login name
and password as I am logged in on my Windows 7 Notebook that also has
SQL2008 installed. If I can get this working I plan to remove SQL from
the notebook and reinstall just the client connectivity tools.
I can map a network drive to a share on the Server from my notebook. I
can log into the server and connect locally either with Windows
Authentication or SQL Authentication. While logged into my account on
the notebook I cannot establish a remote connection either with
Windows Authentication or SQL Authentication. The "establish remote
connections" property is turned on. The SQL port 1433 is added to the
list of exception ports in the Windows Firewall settings. Turning the
firewall off (which is not a desired fix) does not help.
I have added rules for the SQL2008 Management Studio executable and
the SQL Port 1433 to the notebook's outbound firewall rules. The
notebook is running McAfee anti-virus software and is configured to
allow SQL Management studio and the SQL port full access.
The exact error message I get is Microsoft SQL Server Error 64.
Basically the text of the message says that the server is either not
configured to allow remote connection or I am specifying the wrong
instance name. The server is only running one instance of SQL and was
configured as the default instance. So when connecting all I am
specifying for the Server name is just the computer name of the server
with no specific instance specified.
Any help would be appreciated.