DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006

    need help connecting to sql server 2000 on from client

    i have a server running sql server. on the server i can create databases just fine but i am trying to connect from a client machine on the network. can you please help me with some instruction on how to connect to an instance of sql that resides on a server( win 2k). i have tried googling for some help with this but have had no luck. it seems like such an easy task but i have wasted all day trying to figure this out.

    thanks for your help.

  2. #2
    Join Date
    Aug 2006
    Are you trying to connect using query analyzer? or .Net? or Enterprise Manager?
    Rupak Guha

    Lets not do it your way or my may. Lets try doing it the best way.

  3. #3
    Join Date
    Aug 2006

    trying sql server express "..server does not allow remote connections.."

    i am trying to connect using vb.net 2003 and also have tried vb.net 2005 but no luck with either.

    i also tried using sql server express 05 on my local machine and cannot connect using vb.net 05 the message i am getting with sql server 05 is "An error has occured while establishing 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:named pipes provider error 40:-could not open a connection to SQL Server"

    For this i have went to sql surface area configuration and enabled remote connection for tcp and also tried tcp/ and named pipes. However I get the same error message. any help is appreciated

Similar Threads

  1. Replies: 1
    Last Post: 07-17-2001, 01:39 AM
  2. Access to SQL server
    By Nate in forum Database
    Replies: 29
    Last Post: 05-09-2001, 10:04 AM
  3. Replies: 1
    Last Post: 12-30-2000, 04:02 PM
  4. Sql Server, VB, Word 2000 Mailmerge
    By Liam Breen in forum VB Classic
    Replies: 0
    Last Post: 06-09-2000, 12:21 PM
  5. Multi-row calculations
    By Bob Hines in forum Database
    Replies: 7
    Last Post: 04-27-2000, 11:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.