Windows

General discussion

Gravatar
0 Votes
Locked

SQL Server Logon

By HereInOz ·
Hi all,

We have a Win2K machine that is connected to a Web Hosting service via a VPN. For database maintenance we log on to the SQL server using SQL Server 7 client software over the VPN.

Following a problem with the Hive file, we needed to re-install most of the software including SQL Server client. We now find that the client on this machine is unable to register and log on to the SQL server.

The error message is:

Client unable to establish connection Connection Open(CreateFile())

It is not a problem of the procedure, as the same procedure works fine with other machines on the network, as well as a Win2K box at home, and it is not a problem of network connection, as we can connect to the server using telnet over the VPN from the offending machine, so all is OK at that level.

I feel that there is either a file that is missing that is preventing SQL Server client from logging on, or perhaps there is a file that is in existence, that is causing the same effect. But that is just a guess. My knowledge of SQL Server does not run deep enough here.

Has anyone got any knowledge of this situation and a possible remedy, short of a clean re-install (politically unsound at the moment!)?

I would really appreciate it if you could come up with a fix. Please feel free to e-mail me with any questions that need answering.

Cheers,

Alan

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

SQL Server Logon

by Adam A. In reply to SQL Server Logon

Firstly, how exact is that error message? Does it include an error number at all?

What version of SQL Server is running on the Win2k box? I'm assuming 7.0, but if it's running 2000, I believe that would be your problem. Fix for that is to install SQL 2000 client software.

If the server is 7.0, how did you reinstall your client software? Have you tried making a new server registration? Hope this helps... I'm still relatively new to SQL, but I've encountered similar problems before.

gravatar
Collapse -

SQL Server Logon

by HereInOz In reply to SQL Server Logon

Sorry Adam, I have been down all those paths before I posted the question. Looks like no-one else knew the answer either.

gravatar
Collapse -

SQL Server Logon

by HereInOz In reply to SQL Server Logon

G'Day Adam,
SQL Server 7 works fine on 3 other boxes logging on to the remote server, so that is not it. The error report is verbatim - no error number.
We had to re-install SQL 7 client because of a system problem, and the New Server Registration is where it is getting the error message.
As I said, my feeling is that there is baggage from the old installation somewhere that is preventing the registration, but I really don't know enough in this area.

gravatar
Collapse -

SQL Server Logon

by HereInOz In reply to SQL Server Logon

This question was closed by the author

Back to Windows Forum

Start or search

Related Discussions

Related Forums