I am trying to connect to a SQL Server 2005 instance from another machine
using Query Analyzer (SQL Server 2000 version) and I am getting the following
error:
Server: Msg 11, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
I can connect to other SQL Server 2000 versions but not the 2005.
Thanks
Allen
Did you enable the Allow Remote Connections option for the SQL2005 server
instance?
Andrew J. Kelly SQL MVP
"Allen" <Allen@.discussions.microsoft.com> wrote in message
news:7F4792F3-8931-4E92-BEDA-0058D9917CFD@.microsoft.com...
>I am trying to connect to a SQL Server 2005 instance from another machine
> using Query Analyzer (SQL Server 2000 version) and I am getting the
> following
> error:
> Server: Msg 11, Level 16, State 1
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
> I can connect to other SQL Server 2000 versions but not the 2005.
> Thanks
> --
> Allen
Showing posts with label machineusing. Show all posts
Showing posts with label machineusing. Show all posts
Thursday, March 8, 2012
Connection Failure to SQL Server 2005
Connection Failure to SQL Server 2005
I am trying to connect to a SQL Server 2005 instance from another machine
using Query Analyzer (SQL Server 2000 version) and I am getting the followin
g
error:
Server: Msg 11, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network err
or.
I can connect to other SQL Server 2000 versions but not the 2005.
Thanks
--
AllenDid you enable the Allow Remote Connections option for the SQL2005 server
instance?
Andrew J. Kelly SQL MVP
"Allen" <Allen@.discussions.microsoft.com> wrote in message
news:7F4792F3-8931-4E92-BEDA-0058D9917CFD@.microsoft.com...
>I am trying to connect to a SQL Server 2005 instance from another machine
> using Query Analyzer (SQL Server 2000 version) and I am getting the
> following
> error:
> Server: Msg 11, Level 16, State 1
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network e
rror.
> I can connect to other SQL Server 2000 versions but not the 2005.
> Thanks
> --
> Allen|||I've serched high and low for this facility and cannot find it.
I have enabled both client/server tcp/ip named pipes shared memory
and still cannot connect.
"Andrew J. Kelly" wrote:
> Did you enable the Allow Remote Connections option for the SQL2005 server
> instance?
> --
> Andrew J. Kelly SQL MVP
>
> "Allen" <Allen@.discussions.microsoft.com> wrote in message
> news:7F4792F3-8931-4E92-BEDA-0058D9917CFD@.microsoft.com...
>
>|||how does one:
enable the Allow Remote Connections option for the SQL2005 server
> instance?
I've set up ports and enabled tcp/ip, shared memory, pipes and do not see a
Allow Remote Connections option
I've shut off my firewall. I just installed sql server 2005 and am trying to
connect on the SAME MACHINE
"Landon Kelsey" wrote:
[vbcol=seagreen]
> I've serched high and low for this facility and cannot find it.
> I have enabled both client/server tcp/ip named pipes shared memory
> and still cannot connect.
> "Andrew J. Kelly" wrote:
>|||Try running through this quick tutorial to see if you missed anything:
http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx
--
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.
"Landon Kelsey" <landonmkelsey@.hotmail.com> wrote in message
news:D98FEEC7-327F-4079-A971-B8A30A6D8FAE@.microsoft.com...[vbcol=seagreen]
> how does one:
> enable the Allow Remote Connections option for the SQL2005 server
> I've set up ports and enabled tcp/ip, shared memory, pipes and do not see
> a
> Allow Remote Connections option
> I've shut off my firewall. I just installed sql server 2005 and am trying
> to
> connect on the SAME MACHINE
>
> "Landon Kelsey" wrote:
>
using Query Analyzer (SQL Server 2000 version) and I am getting the followin
g
error:
Server: Msg 11, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network err
or.
I can connect to other SQL Server 2000 versions but not the 2005.
Thanks
--
AllenDid you enable the Allow Remote Connections option for the SQL2005 server
instance?
Andrew J. Kelly SQL MVP
"Allen" <Allen@.discussions.microsoft.com> wrote in message
news:7F4792F3-8931-4E92-BEDA-0058D9917CFD@.microsoft.com...
>I am trying to connect to a SQL Server 2005 instance from another machine
> using Query Analyzer (SQL Server 2000 version) and I am getting the
> following
> error:
> Server: Msg 11, Level 16, State 1
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network e
rror.
> I can connect to other SQL Server 2000 versions but not the 2005.
> Thanks
> --
> Allen|||I've serched high and low for this facility and cannot find it.
I have enabled both client/server tcp/ip named pipes shared memory
and still cannot connect.
"Andrew J. Kelly" wrote:
> Did you enable the Allow Remote Connections option for the SQL2005 server
> instance?
> --
> Andrew J. Kelly SQL MVP
>
> "Allen" <Allen@.discussions.microsoft.com> wrote in message
> news:7F4792F3-8931-4E92-BEDA-0058D9917CFD@.microsoft.com...
>
>|||how does one:
enable the Allow Remote Connections option for the SQL2005 server
> instance?
I've set up ports and enabled tcp/ip, shared memory, pipes and do not see a
Allow Remote Connections option
I've shut off my firewall. I just installed sql server 2005 and am trying to
connect on the SAME MACHINE
"Landon Kelsey" wrote:
[vbcol=seagreen]
> I've serched high and low for this facility and cannot find it.
> I have enabled both client/server tcp/ip named pipes shared memory
> and still cannot connect.
> "Andrew J. Kelly" wrote:
>|||Try running through this quick tutorial to see if you missed anything:
http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx
--
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.
"Landon Kelsey" <landonmkelsey@.hotmail.com> wrote in message
news:D98FEEC7-327F-4079-A971-B8A30A6D8FAE@.microsoft.com...[vbcol=seagreen]
> how does one:
> enable the Allow Remote Connections option for the SQL2005 server
> I've set up ports and enabled tcp/ip, shared memory, pipes and do not see
> a
> Allow Remote Connections option
> I've shut off my firewall. I just installed sql server 2005 and am trying
> to
> connect on the SAME MACHINE
>
> "Landon Kelsey" wrote:
>
Subscribe to:
Posts (Atom)