SQL Server problem
Results 1 to 5 of 5

Thread: SQL Server problem

  1. #1
    Join Date
    Jul 2015
    Posts
    1

    SQL Server problem

    I get following error message while attempting to connect to a MS SQL Server:
    A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)
    what causes the problem?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Sounds dropping packets on network, can you ping the server?

  3. #3
    Join Date
    Jul 2015
    Posts
    2
    Go to the SQL Configuration Manager. (You can refer to the link above for a walk through with screen shots to get there)
    Expand the SQL Network Configuration and click on the PROTOCOLS node
    Right click on TCP/IP and open up the PROPERTIES panel
    Select the IP ADDRESS tab
    Make sure the values for the IP ADDRESS fields are correct and match the system it is running on.
    Restart the service, and you should be back in business, I was.
    On a side note, this is also the same place where lots of people get hung up when setting up remote access to a SQL Server instance.
    Make sure you fill in the TCP PORT, even if you are using the default 1433.
    7. Now extract and you should have your content without any errors out of RAR files.
    If you are still experiencing the issue you can try SQL Server Fix Toolbox

  4. #4
    Join Date
    Jul 2015
    Posts
    2

  5. #5
    Join Date
    May 2015
    Posts
    19
    Read this blog carefully and solve your problem: http://escapekeys.com/microsoft-sql-...-the-server/89

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •