Question posted by TomHowe on September 2nd, 2015
Ms Sql Server
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?
Current Answers
Answer #1: Posted by TommyKervz on September 4th, 2015 4:18 AM
TommyKervz
Member since:
January 10th, 2013 Points: 17,776,813
Member since:
January 10th, 2013 Points: 17,776,813
For Microsoft SQL Server, Error: 64 Please refer on this links below
OR see the discussion here:
Answer #2: Posted by SachaBoudon on September 9th, 2015 4:54 AM
SachaBoudon
Member since:
September 9th, 2015 Points: 120
Member since:
September 9th, 2015 Points: 120
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.
Also check this link and read comments:
Similar Questions
Operational Db Without An .ldf File And No Useful Backups On Sql Server 2005.
No, the question isn't stupid but the "admin" sure is.... BUT, if you can help, please do! The probl...
No, the question isn't stupid but the "admin" sure is.... BUT, if you can help, please do! The probl...
(Posted by silasperkins 8 years ago)
Dbase Files Into Microsoft Access
When i try to import dBASE files into Microsoft Access, ireceive the following error message:Unexpec...
When i try to import dBASE files into Microsoft Access, ireceive the following error message:Unexpec...
(Posted by botrel 8 years ago)
Lotus Notes Mailman Error
When i try to send a document with send email from ms word, lotus notes does'nt open and i have an e...
When i try to send a document with send email from ms word, lotus notes does'nt open and i have an e...
(Posted by bertamuniz 8 years ago)
Winzip Error.what Causes It?
When I try to open Zip file I get errors message:"Cannot open file: it does not appear to be a valid...
When I try to open Zip file I get errors message:"Cannot open file: it does not appear to be a valid...
(Posted by JTraeger 8 years ago)
Problem With Database
GreetingsSuddenly, one of the dbf files lost 21 records, those 21 records were entered that day and ...
GreetingsSuddenly, one of the dbf files lost 21 records, those 21 records were entered that day and ...
(Posted by Isacco5 8 years ago)