how does one:
enable the Allow Remote Connections option for the SQL2005 server
[quoted text, click to view] > 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
[quoted text, click to view] "Landon Kelsey" wrote:
> 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...
> > >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
> >
> >
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] "Landon Kelsey" <landonmkelsey@hotmail.com> wrote in message
news:D98FEEC7-327F-4079-A971-B8A30A6D8FAE@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:
>
>> 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...
>> > >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
>> >
>> >
>> >