need help connecting to sql server 2000 on from client


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: need help connecting to sql server 2000 on from client

  1. #1
    Join Date
    Aug 2006
    Location
    Albuquerque
    Posts
    32

    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
    Posts
    38
    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
    Location
    Albuquerque
    Posts
    32

    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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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