all groups > sql server connect > january 2006 >
You're in the

sql server connect

group:

Connection Failure to SQL Server 2005


Connection Failure to SQL Server 2005 Allen
1/27/2006 11:12:26 AM
sql server connect:
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
--
Re: Connection Failure to SQL Server 2005 Andrew J. Kelly
1/27/2006 9:08:16 PM
Did you enable the Allow Remote Connections option for the SQL2005 server
instance?

--
Andrew J. Kelly SQL MVP


[quoted text, click to view]

Re: Connection Failure to SQL Server 2005 Landon Kelsey
4/22/2006 9:26:01 AM
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.

[quoted text, click to view]
Re: Connection Failure to SQL Server 2005 Landon Kelsey
4/22/2006 10:40:01 AM
how does one:

enable the Allow Remote Connections option for the SQL2005 server
[quoted text, click to view]
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


[quoted text, click to view]
Re: Connection Failure to SQL Server 2005 Rick Byham [MS]
4/24/2006 8:40:27 AM
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.

[quoted text, click to view]

AddThis Social Bookmark Button