"PK9" <PK9@discussions.microsoft.com> wrote in message
news:D9632839-F31D-4F96-AFF0-82303A364304@microsoft.com...
> Alex,
> Yes, we use DHCP so I do get an IP from my router.
>
> The issue is connecting to SQL Server when I'm not plugged into the
network
> (locally). When I plug in, and get an IP address, I can connect just
fine.
> I'm always using "localhost" as the DataSource in the connection string
> (which should be the same as the local loop back you're suggesting).
Still
> can't figure this out.
>
> "Alex White" wrote:
>
> > Hi,
> >
> > Does your laptop get an IP address from your internet router?
> >
> > Sounds like your SQL install is listening on that connection, try and
> > connect on 127.0.0.1 this is the loopback address for your network card.
> >
> > Regards
> >
> > Alex White MCSE MCDBA
> > www.IntraLAN.co.uk
> >
> > -----Original Message-----
> > From: PK9 [mailto:PK9@discussions.microsoft.com]
> > Posted At: 23 April 2005 19:07
> > Posted To: microsoft.public.sqlserver.connect
> > Conversation: SQL Server Does Not Exist or Access Denied
> > Subject: SQL Server Does Not Exist or Access Denied
> >
> > I'm a newbie to SQL server. I've got my development environment up an
> > running just fine. I'm creating a web application that accesses some of
> > my
> > own web services to interact with the SQL Server database.
> >
> > Everything works fine "WHEN" I have my laptop hooked up to the internet.
> > If
> > I don't have my lan cable connected then I get the error "SQL Server
> > does not
> > exist or Access Denied".
> >
> > Not sure if this is a configuration / install / password issue since I'm
> > new
> > to SQL Server. Any help would be greatly appreciated.
> >
> > Thanks,
> > Paul
> > --
> > PK9
> >
> >

"Scott Morris" wrote:

> Perhaps this will shed some light.
>
> http://groups-beta.google.com/group/microsoft.public.sqlserver.misc/browse_frm/thread/f196f395a2649bff/d17803e61bb2d296?q=localhost+difference+local+group:microsoft.public.sqlserver.*&rnum=1&hl=en#d17803e61bb2d296
>
> "PK9" <PK9@discussions.microsoft.com> wrote in message
> news:D9632839-F31D-4F96-AFF0-82303A364304@microsoft.com...
> > Alex,
> > Yes, we use DHCP so I do get an IP from my router.
> >
> > The issue is connecting to SQL Server when I'm not plugged into the
> network
> > (locally). When I plug in, and get an IP address, I can connect just
> fine.
> > I'm always using "localhost" as the DataSource in the connection string
> > (which should be the same as the local loop back you're suggesting).
> Still
> > can't figure this out.
> >
> > "Alex White" wrote:
> >
> > > Hi,
> > >
> > > Does your laptop get an IP address from your internet router?
> > >
> > > Sounds like your SQL install is listening on that connection, try and
> > > connect on 127.0.0.1 this is the loopback address for your network card.
> > >
> > > Regards
> > >
> > > Alex White MCSE MCDBA
> > > www.IntraLAN.co.uk
> > >
> > > -----Original Message-----
> > > From: PK9 [mailto:PK9@discussions.microsoft.com]
> > > Posted At: 23 April 2005 19:07
> > > Posted To: microsoft.public.sqlserver.connect
> > > Conversation: SQL Server Does Not Exist or Access Denied
> > > Subject: SQL Server Does Not Exist or Access Denied
> > >
> > > I'm a newbie to SQL server. I've got my development environment up an
> > > running just fine. I'm creating a web application that accesses some of
> > > my
> > > own web services to interact with the SQL Server database.
> > >
> > > Everything works fine "WHEN" I have my laptop hooked up to the internet.
> > > If
> > > I don't have my lan cable connected then I get the error "SQL Server
> > > does not
> > > exist or Access Denied".
> > >
> > > Not sure if this is a configuration / install / password issue since I'm
> > > new
> > > to SQL Server. Any help would be greatly appreciated.
> > >
> > > Thanks,
> > > Paul
> > > --
> > > PK9
> > >
> > >
>
>