Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #675

Re: Cannot Remote Connect to SQL2008 on Windows Server 2008

Show all headers | View raw

On Sep 25, 5:01 pm, Joe Cool <joecool1...@live.com> wrote:
> 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
> Machine.
>
> 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.
>
> TIA.

Forgot to mention that I goggled this problem and did not find a
solution that helped.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Cannot Remote Connect to SQL2008 on Windows Server 2008 Joe Cool <joecool1969@live.com> - 2011-09-25 14:01 -0700
  Re: Cannot Remote Connect to SQL2008 on Windows Server 2008 Joe Cool <joecool1969@live.com> - 2011-09-25 14:01 -0700
  Re: Cannot Remote Connect to SQL2008 on Windows Server 2008 Erland Sommarskog <esquel@sommarskog.se> - 2011-09-25 23:54 +0200
    Re: Cannot Remote Connect to SQL2008 on Windows Server 2008 Joe Cool <joecool1969@live.com> - 2011-09-25 16:14 -0700

csiph-web