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

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

Re: Cannot Remote Connect to SQL2008 on Windows Server 2008

Show all headers | View raw

On Sep 25, 5:54 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Joe Cool (joecool1...@live.com) writes:
> > 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 don't know what this "establish remote connection" is; it is nothing
> I recognize.

Sorry, didn't properly describe that. On the server properties window,
on the Connections page, there is a checkbox that is labelled "Allow
remote connections to this server".

>
> On the VM which is running SQL Server, open SQL Server Configuration
> Manager. Under the node SQL server Network Configuration, verify that
> TCP/IP is enabled. If not enable it. Also double-click TCP/IP and
> verify that the port is 1433 and that the IP-adress is active. When you
> are done restart SQL Server, even if you did not change anything. (In
> case you forgot to restart SQL Server last time you changed something
> here.)

Thanks, this was the problem. TCP/IP was not enabled. Once I did I was
able to connect from my notebook to the VM.

>
> Also verify that the servername you use actually map to the IP address
> used by the server. You can also try to connect by IP address.
>
> I don't know how confident you are with your firewalls, but it is a
> good idea to disable all firewalls until you get a connection working.
> Then you know that your firewalls are not blocking the road for you.
> Once you are there, you can start configuring the firewalls.
>
> > 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.
>
> Could you post the exact error message? From your description it sounds
> like the standard error message when the server is not reachable, but
> that message has number 53, not 64. So maybe there is something in the
> message that gives a specific hint.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous 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