I have followed the advice of both Bill & Rick. I learned allot from
recommendations has resolved my problem. I seem to be having a problem only
when connecting to sql server on a remote server from a web service. My sql
tools work fine and my asp.net web application connects fine. Its just the
web service that will not connect and produces the error message. I have
have tried all of them with no success. Any help would be appreciated.
"Rick Byham, (MSFT)" wrote:
> Bill's blog has lots of good info, but if you just want the connectivity
> issue, look through the connectivity tutorial in Books Online. The online
> version is at
http://msdn2.microsoft.com/en-us/library/ms345318(sql.90).aspx
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "William (Bill) Vaughn" <billvaRemoveThis@betav.com> wrote in message
> news:%23wiwO8vqHHA.4108@TK2MSFTNGP06.phx.gbl...
> > See my blog for articles on connecting.
> >
> > --
> > ____________________________________
> > William (Bill) Vaughn
> > Author, Mentor, Consultant
> > Microsoft MVP
> > INETA Speaker
> >
www.betav.com/blog/billva > >
www.betav.com > > Please reply only to the newsgroup so that others can benefit.
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > __________________________________
> > Visit
www.hitchhikerguides.net to get more information on my latest book:
> > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> > and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> > -----------------------------------------------------------------------------------------------------------------------
> >
> > <amripaul@gmail.com> wrote in message
> > news:1181286503.038358.154830@a26g2000pre.googlegroups.com...
> >> An error has occurred while establishing a connection to the server.
> >> When connecting to SQL Server 2005, this failure may be caused by the
> >> fact that under the default settings SQL Server does not allow remote
> >> connections. (provider: SQL Network Interfaces, error: 26 - Error
> >> Locating Server/Instance Specified) ...........give me a solution.
> >> Thank you
> >> Amritendu Paul
> >>
> >
> >
