I have been having a heck of a time connecting to a remote 2K5 instance from
my local Management Studio.
Each time I have tried to connect, regardless of the account, I have been
greeted with "SQL Server does not exist/access denied" errors.
I have configured the server to accept remote connections. It is configured
for mixed mode, and even my SA account cannot be authenticated. The error
logs dont even display my login attempts, which at first led me to believe
this was a firewall issue. The network admin has assured me that nothing at
the firewall level has changed, and I connected to the previous 2000
instance without a problem prior to this upgrade.
I went and checked the logs and noticed something that to me looks funny:
there are 4 entries in the log after startup that read:
- Server is listening on ['any' <ipv4 1358]
- Server local connection provider is ready to accept connection on [bla
h]
- Server local connection provider is ready to accept connection on [bla
h]
- Server is listening on [127.0.0.1 <ipv4> 1359]
Its the entry with the loopback that looks weird to me. Shouldnt this be the
server's IP?
ThanksThe IP address entries look normal but the port numbers are unusual. Not
wrong, just not the default setup. E.g. my server says:
Server is listening on [ 'any' <ipv4> 1433].
Server is listening on [ 127.0.0.1 <ipv4> 1434].
You can probably connect to <ip_address>, 1358
That is, the ip address and the port number.
You probably have a named instance. To connect to
<computer_name>\<instance_name> you need to start the SQL Server Browser
Service (which uses UDP port 1434) which will report the current port number
(1358) of your instance name back to your client so can connect to the
correct port.
You can start the the SQL Server Browser Service with the SQL Server
Configuration Manager.
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Elliot Rodriguez" <elliotrodriguezatgeemaildotcom> wrote in message
news:OSDEIi$MGHA.2628@.TK2MSFTNGP15.phx.gbl...
>I have been having a heck of a time connecting to a remote 2K5 instance
>from my local Management Studio.
> Each time I have tried to connect, regardless of the account, I have been
> greeted with "SQL Server does not exist/access denied" errors.
> I have configured the server to accept remote connections. It is
> configured for mixed mode, and even my SA account cannot be authenticated.
> The error logs dont even display my login attempts, which at first led me
> to believe this was a firewall issue. The network admin has assured me
> that nothing at the firewall level has changed, and I connected to the
> previous 2000 instance without a problem prior to this upgrade.
> I went and checked the logs and noticed something that to me looks funny:
> there are 4 entries in the log after startup that read:
> - Server is listening on ['any' <ipv4 1358]
> - Server local connection provider is ready to accept connection on [b
lah]
> - Server local connection provider is ready to accept connection on [b
lah]
> - Server is listening on [127.0.0.1 <ipv4> 1359]
> Its the entry with the loopback that looks weird to me. Shouldnt this be
> the server's IP?
> Thanks
>
Saturday, February 25, 2012
Remote Connectivity and Listening IP
Labels:
2k5,
connect,
connecting,
connectivity,
database,
frommy,
heck,
instance,
listening,
local,
management,
microsoft,
mysql,
oracle,
regardless,
remote,
server,
sql,
studio,
time
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment