October 28, 2002 at 1:48 pm
Hi All,
I had to reinstall SQL Server 7.0 on my machine. Now I could not find my local database (i.e. SQL server database on my C:\ drive). I tried to register the local machine using enterprise manager. But the register dialog box says, "Specified SQL server not found (connection open (create file())" and connection fails.
I have never seen such type of error. Does any one have any idea as to what's going on here ?
Thanx for any help.
-Bheemsen
October 29, 2002 at 5:29 pm
Do you have the data and log files in the disk (.mdf and .ldf)? If you have them after you reinstall SQL you can attach the database with those files.
October 30, 2002 at 2:53 pm
racosta,
Thanx for the reply. Looks like the problem is with my operating system. Mine is NT workstation. I think one should have NT server OS to have local database. I am not quiet sure about this. I did not find the ldf and mdf files in the machine. I have ldf and mdf files in service pack 2 folder. Can you please tell me how to get them and how to attach those files.
thanx..
-Bheemsen
October 31, 2002 at 5:04 am
quote:
Looks like the problem is with my operating system. Mine is NT workstation. I think one should have NT server OS to have local database.
Not necessary. I have SQL2k server running under NT4 workstation as my desktop environment, and previously had SQL7 server on this same PC.
The "Connection Open (CreateFile())" error is often due to some sort of network issue that prevents the client from finding the server. What communication protocol is SQL using? Named Pipes, TCP/IP or something else?
Thomas Rushton
blog: https://thelonedba.wordpress.com
November 1, 2002 at 10:02 am
ThomasRushton,
Thanx for your reply. I had tried with both Named Pipes and TCP/IP protocols and still getting the same error.
Any one has any idea as to why this problem occurs ?
-Bheemsen
November 2, 2002 at 6:38 am
It seems to point to having just installed the client tools and not the server components. SQL server can run on any system 98 onwards (enterprise version has to run on an enterprise server os).
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply