Re: SQL Management Studio will not connect to x64 bit SP2 server

Does Management Studio communicate over 1433? Below what works and what
doesn't.

Management Studio on the x64 bit server with named instance.
1. Connects to named instance on itself
2. Connects to 32bit remote 2005 Server
3. Connects to 32bit remote 2000 Server

Management Studio on my XP SP2 workstation
1. Connects to 32x remote 2005 Server
2. Connects to 32x remote 2000 Server
3. Fails to connect to x64 named instance 2005 Server

If port 1433 was not working I don't think other connections would connect
without issue.

Thanks,


"Jason Massie" wrote:

Hi Cindy,
I don't think it is possible for x64 to be the issue. Once we start talking
TCPIP, we don't care what the hosts are.

I just caught that this is a named instance. Are you sure it is 1433? Double
check in the errorlog. If we can connect with telnet, try creating creating
an alias forcing TCPIP and hardcoding in 1433.

--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio

"Cindy" <Cindy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:703457D7-6943-4095-B810-AF2EA740CEE9@xxxxxxxxxxxxxxxx
The server was put in production this weekend and is doing fine answering
applications over port 1433. That is not the issue. Management Studio
will
not connect from non x64 OS.

"Jason Massie" wrote:

I would start of by trying to telnet to the server to verify ports are
open.
telnet YourServer 1433 (or your port)


--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio

"Cindy" <Cindy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:503B8FE2-E013-4464-AEAE-6D6876F26911@xxxxxxxxxxxxxxxx
I cannot connect from my XP computer using SQL Management Studio to 2005
X64
SP2 SQL named instance. I can connect to 2005 x32 SP1 fine. Below is
error,
also in seems to be a SSL error on server I am trying to connect to. I
can
connect directly on the server. Remote connections are allowed.

An error has occurred while establishing a connection to the server.
When
connecting to SQL Server 2005, this failure may be caused by the fact
that
under the default settings SQL Server does not allow remote
connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance
Specified) (Microsoft SQL Server, Error: -1)







.

Relevant Pages

  • Re: Server 2003 32-bit Queue with XP Pro 64-bit
    ... server OS and was successful in adding the drivers for the printer to the ... now when I go to the x64 XP Pro ... The driver files you are installing should also be engineerd for Server 2003 ... open the inf for the device driver you are attempting to install. ...
    (microsoft.public.windowsxp.print_fax)
  • Re: Virtual SBS2003 R2 Test Machine Hosted by WXP X64 SP2
    ... I chose the EE Trial thinking I might want to try running multiple versions of VS Server running and hosting. ... Other is still running XP x64 because it needs a legacy app that is ported to XP x64, but not to Vista x64 or LH Server. ... Using local account on the host means that it won't Auto Update thru WSUS - at least that was my finding with the set up that I have.... ... Which sort of makes sense as the R2 box being a virtual machine won't come alive until after the Host is running and starts it. ...
    (microsoft.public.windows.server.sbs)
  • Re: Virtual SBS2003 R2 Test Machine Hosted by WXP X64 SP2
    ... I chose the EE Trial thinking I might want to try running multiple versions of VS Server running and hosting. ... Other is still running XP x64 because it needs a legacy app that is ported to XP x64, but not to Vista x64 or LH Server. ... Using local account on the host means that it won't Auto Update thru WSUS - at least that was my finding with the set up that I have.... ... Which sort of makes sense as the R2 box being a virtual machine won't come alive until after the Host is running and starts it. ...
    (microsoft.public.windows.server.sbs)
  • Re: Regarding 64 bit machine
    ... vista x64 edition if my driver doesnt use any special API s that are ... used in vista x64 edition.or do I need eto build vista or server longhorn x64 ... Windows SDK MVP ...
    (microsoft.public.development.device.drivers)
  • Re: Regarding 64 bit machine
    ... vista x64 edition if my driver doesnt use any special API s that are ... used in vista x64 edition.or do I need eto build vista or server longhorn x64 ... Windows SDK MVP ...
    (microsoft.public.development.device.drivers)
Loading