Timeout when connecting to SQL Server 2000


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Timeout when connecting to SQL Server 2000

Hybrid View

  1. #1
    Parviz Guest

    Timeout when connecting to SQL Server 2000


    Hi again. When I try to connect to SQL Server 2000s registered in Enterprise
    manager, I really encounter problems. Mose of the time I get timeout or something
    like can not create file.
    I have tried several protocols and it does not change.

    Please help. I have to quit 2000 if I can not solve the problem.

    Thanks


    Share on Google+

  2. #2
    Gert E.R. Drapers Guest

    Re: Timeout when connecting to SQL Server 2000

    What is the exact message?

    You can change the timeout of Enterprise Manager, Tools->Options Advanced
    tab Login timeout, default 10 seconds.
    Also make sure you set you package size to 4096 or higher, not to the
    default 512 bytes. Last make sure you have the right default client
    protocol, it looks like you have named pipes as the default, better use
    TCP/IP because it does not use NetBIOS.

    -GertD

    "Parviz" <aghasadeghi@hotmail.com> wrote in message
    news:3a6f188c$1@news.devx.com...
    >
    > Hi again. When I try to connect to SQL Server 2000s registered in

    Enterprise
    > manager, I really encounter problems. Mose of the time I get timeout or

    something
    > like can not create file.
    > I have tried several protocols and it does not change.
    >
    > Please help. I have to quit 2000 if I can not solve the problem.
    >
    > Thanks
    >
    >



    Share on Google+

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