MS SQL Server

[Guest]

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?

[marcos-almeida]

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 https://www.fixtoolbox.com/sqlserverfix.html

[MrPhil]

What exactly are you trying to do here? osCommerce does not make use of MS SQL Server. As far as I know, no one has hacked osC to use that DB server, although presumably it's possible. If this query is unrelated to osC, please do not use this forum for general programming questions. Try StackExchange or something like that.

 

If you are trying to access data on an MS SQL Server from your osC store, that might be possible. Assuming that it's possible to have both MySQL and MS SQL active and accessible at the same time, presumably you could do what you want, although I can't offer any assistance on it. If you don't need a live connection for both, but only want to transfer over data from one to the other on a batch basis, it might be easier to generate an SQL backup file on one, massage it into the form needed by the other, and import it to the target system.