Results 1 to 9 of 9

Thread: Errors in SQL Server connection

  1. #1
    Join Date
    Jul 2010
    Posts
    29

    Errors in SQL Server connection

    I am now having good knowledge about the SQL. But not good enough to solve some server connections issues. During the process of implementation of BDD 2007 (Behavior Driven Development), I want to retrieve information from SQL databases. The broken connection error to SQL Server may be caused by not enable named pipe connections in SQL Server 2000 or SQL Server 2005. Now frankly speaking, I am not having enough ideas about it. So thought that someone hanging out there might be helpful and would provide some solutions. Please tell me how to enable the pipe connections in SQL Server. Also I want to ask that is there different ways to enable the pipe connections in different versions of SQL Server? Hoping that someone will help me soon (as usual ).

  2. #2
    Join Date
    Jan 2009
    Posts
    84

    Re: Errors in SQL Server connection

    To enable named pipe connections in SQL Server 2000 :
    1. On the computer running SQL Server 2000 and hosting the database in which queries, click Start, point to All Programs, select Microsoft SQL Server, and then click Server Network Utility.
    2. In the dialog box Network Utility SQL Server, on the General tab, make sure Named Pipes is in the Enabled protocols list box.
    3. If Named Pipes is in the Disabled Protocols list box, click Named Pipes, Enable, and then click OK.
    4. Click Start, point to All Programs, select Microsoft SQL Server, and then click SQL Service Manager.
    5. In the dialog box SQL Service Manager, click Services, select SQL Server and click Stop.
    6. In the dialog box SQL Service Manager, click Start.
    7. Close the SQL Service Manager.

  3. #3
    Join Date
    Feb 2009
    Posts
    81

    Re: Errors in SQL Server connection

    During the process of implementation of BDD 2007 (Behavior Driven Development), I want to retrieve information from SQL databases. The broken connection error to SQL Server may be caused by not enable named pipe connections in SQL Server 2000 or SQL Server 2005.
    You have to enable named pipes in SQL Server to resolve these errors.

    Also I want to ask that is there different ways to enable the pipe connections in different versions of SQL Server?
    Obviously, since they are different versions, there are different methods to enable pipes in SQL Server 2000 and SQL Server 2005. Some devices may appear as multiple logical drive letters, as partitions. In some cases, can emulate a floppy drive and a 1.44-MB memory storage unit. Therefore, the same device can be assigned drive letters A: and B: floppy emulation and F: for memory storage unit. BDD 2007 scripts use the lowest drive letter by default.

  4. #4
    Join Date
    Apr 2009
    Posts
    89

    Re: Errors in SQL Server connection

    To enable named pipe connections in SQL Server 2005, the following steps would be useful for you :
    1. On the computer running SQL Server 2005 and hosting the database in which queries, click Start, point to All Programs, select Microsoft SQL Server 2005, Configuration Tools, and then click Surface Area Configuration SQL Server.
    2. In the Settings dialog box surface SQL Server 2005, click Surface Area Configuration for Services and Connections.
    3. In the Settings dialog box surface for Services and Connections - server_name, under Select a component and then configure its services and connections, expand MSSQLSERVER, then database engine and then click Remote Connections (where server_name is the name of the computer running SQL Server 2005).
    4. Click Local and Remote Connections in Using TCP / IP and named pipes, and then click Apply.
    5. In the Settings dialog box surface for Services and Connections - server_name, under Select a component and then configure its services and connections, expand MSSQLSERVER, then database engine and click Service (where server_name is the name of the computer running SQL Server 2005).
    6. Click Stop.
    7. MSSQLSERVER service stops.
    8. Click Start.
    9. The MSSQLSERVER service is started.
    10. Click OK.
    11. Close the Settings dialog box of SQL Server 2005 surface.

  5. #5
    Join Date
    Jan 2009
    Posts
    124

    Re: Errors in SQL Server connection

    Implementing BitLocker Drive Encryption (BDE) in LTI in BDD 2007 requires a specific configuration for proper implementation. Below are the possible problems that may be related to the target computer's configuration:
    • USB devices, CD drives, DVD drives or other removable media devices on the target computer that appear as multiple drive letters
    • Reducing the volume C: to the target computer to provide sufficient unallocated disk space



    Some devices may appear as multiple logical drive letters, as partitions. In some cases, can emulate a floppy drive and a 1.44-MB memory storage unit. Therefore, the same device can be assigned drive letters A: and B: floppy emulation and F: for memory storage unit. BDD 2007 scripts use the lowest drive letter by default.
    You can override the default value in the Specify the BitLocker recovery details (Specify the BitLocker recovery details) the Deployment Wizard in Windows. A warning appears on the summary page of the Deployment Wizard in Windows in which users are informed of what drive letter is selected to store BitLocker recovery information. Furthermore, in the log files are recorded ZTIBDE.log BDD.log and removable media devices detected and selected devices for storing BitLocker recovery information.

  6. #6
    Join Date
    Feb 2010
    Posts
    131

    Re: Errors in SQL Server connection

    To deploy BDE on a target computer, you need at least 2 GB of unallocated disk space to create the system volume. The system volume is the volume containing hardware specific files needed to load Windows machines after the basic input / output system (BIOS) has launched the platform. The script runs ZTIBDE.wsf Disk Preparation Tool (album preparation) (bdehdcfg.exe) and configures the default partition size of the volume of 2000 MB system. ZTIBDE.wsf can customize the script to change the default if necessary. Note You should change the script of BDD 2007. Target computers are not ads OSD Feature Pack package with SMS. Verify that the target computers are in the SMS collection used for the distribution of OSD Feature Pack package with SMS.

  7. #7
    Join Date
    Feb 2010
    Posts
    638

    Re: Errors in SQL Server connection

    Existing equipment, you need to reduce the volume C: so you can create the system volume. You can use the Diskpart tool to reduce the volume C:. In some cases, you may run the tool Diskpart can not reduce the volume C: enough to provide 2 GB of unallocated disk space. This may be due to the fragmented disk space on volume C:. One possible solution to solve this problem is to defragment the volume C: performing the following steps:
    1. Run Diskpart querymax shrink to identify the maximum amount of disk space that can be assigned.
    2. If the value returned in step 1 is less than 2 GB, defragment the volume C:.
    3. Rerun querymax shrink Diskpart to verify that you have more than 2 GB of unallocated disk space.
    4. If the value returned in step 3 is still less than 2 GB, do one of the following:

      • Defragment the volume C: several times to ensure that the volume C: is fully optimized.
      • Back up data on the volume C:, delete the existing partition, create a new partition and then restore the data to the new partition.

  8. #8
    Join Date
    Feb 2010
    Posts
    533

    Re: Errors in SQL Server connection

    In short, the protocol pre-execution environment (PXE) works as follows: the client initiates the protocol by broadcasting a detection kit Protocol Dynamic Host Configuration (DHCP) that contains an extension that identifies the request as coming from a client that implements the PXE protocol. Assuming that there is a boot server implementing this extended protocol, the server sends an offer containing the IP address of the server that will serve the customer. The client uses the Protocol Trivial File Transfer Protocol (TFTP) to download the executable file for server startup. Finally, the client initiates execution of the downloaded image. The initial phase of this protocol is based on a subset of DHCP messages to enable the client to detect a boot server (ie, a server providing files for the installation of new equipment). The client can leverage to obtain an IP address (which is the expected behavior) but it is not necessary. The second phase of this protocol is between the client and boot server and uses the DHCP message format as a format suitable for communication. Moreover, this second phase of the protocol is not related to the standard DHCP services. The following pages outline the process step by step through the initialization of the PXE client.

  9. #9
    Join Date
    Feb 2010
    Posts
    766

    Re: Errors in SQL Server connection

    You should also check the proper DHCP settings. According router models that are used, the specific router configuration of DHCP broadcast forwarding is admissible in a subnet (or router interface) or a specific host. If the DHCP server and Windows DS are independent teams, make sure that the routers that forward DHCP broadcasts are designed so that the DHCP server and Windows DS client receive the broadcasts, otherwise, the client receives no response to your request for remote boot. Is there a router between the client and the remote installation server that does not support the requests or responses based on DHCP? When the Windows DS client and the Windows DS server are on separate subnets, the router between the two systems must be configured to forward DHCP packets to the Windows DS server. This provision is necessary because the Windows DS client detects a Windows DS server with a DHCP broadcast message. Without DHCP forwarding settings on a router, DHCP broadcasts do not reach the customers of Windows DS server. This DHCP forwarding process is sometimes referred to as DHCP Proxy or IP Helper Address in router configuration manuals. Check your router instructions for more information about configuring DHCP forwarding on the router specific.

Similar Threads

  1. Windows 7 desktop encountering Internet connection errors frequently
    By Lopazax98 in forum Technology & Internet
    Replies: 3
    Last Post: 07-02-2011, 06:51 PM
  2. Replies: 4
    Last Post: 14-10-2010, 05:56 AM
  3. Replies: 5
    Last Post: 26-06-2010, 05:11 PM
  4. Replies: 1
    Last Post: 06-04-2010, 09:36 PM
  5. Replies: 0
    Last Post: 05-02-2009, 11:34 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,710,826,181.58849 seconds with 17 queries