[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL server 6.5 security/server register problems

Posted on 2012-08-24
10
Medium Priority
?
615 Views
Last Modified: 2012-08-28
I am attempting to install and use a SQL server 6.5 database server on a server 2000 operating system due to a client conversion.  The only error I get during install is that the password does not meet security requirements.  My account does have admin rights.  The local database server does not show up in the list of servers.  I am able to register the server in Enterprise Manager.  However,  I get a login failed for trusted connection and Standard Security.   I have attempted to go back thru set up and set the security to mixed mode.  The install never prompted me to enter a sa password.  The security setup feature did.  However, I now get an error "The SQL server security options could not be successfully set.  Setup could not connect to the SQL Server."  I am open to any ideas.
0
Comment
Question by:edbrinkm
  • 6
  • 4
10 Comments
 

Author Comment

by:edbrinkm
ID: 38331108
I have also tried testing the ODBC connection that the install created.  It states I cannot connect either.

I have tried uninstalling and deleting all files and reinstalling.  The install hangs.  The error log has the below message.

Launched startup procedure 'sp_sqlregister'
12/08/24 20:51:28.25 spid9    EXCEPTION_ACCESS_VIOLATION raised, attempting to create symptom dump
12/08/24 20:51:28.25 spid9    Initializing symptom dump and stack dump facilities
12/08/24 20:51:29.42 spid9    Unable to locate symbol information for 'SQLSERVR.EXE'
12/08/24 20:51:29.42 spid9    Error : 0, Severity: 19, State: 0
12/08/24 20:51:29.42 spid9    SQLDumpExceptionHandler: Process 9 generated access violation; SQL Server is terminating this process

*******************************************************************************
*
* STACK DUMP:
*
*   Exception Address = 00450E46
*   Exception Code    = c0000005
*   Access Violation occurred writing address 00000060
*
* MODULE LISTING:
*
*  MODULE                          BASE      SIZE
*
* PROCESSOR SPECIFIC CONTEXT:
*
12/08/24 20:51:29.42 kernel   The current contents of process' input buffer are 'with log
      end
0
 
LVL 16

Accepted Solution

by:
DcpKing earned 2000 total points
ID: 38331794
Hi,

Refer here:
http://technet.microsoft.com/en-us/library/cc966518.aspx

I'd suggest you try installing a copy of SQL Server 2000 and upgrading your databases.

Alternatively, Try finding a copy of Windows NT 4 Server to use instead of Win2KServer, which may be too new!

Here are the MS guidelines for installing 6.5, which you may find helpful:
http://support.microsoft.com/kb/192710

hth

Mike
0
 

Author Comment

by:edbrinkm
ID: 38338092
I have made progress.  I can connect to the local SQL server 6.5 instance and display the database objects.  I cannot install the service pack 5.  The problem I have now is to create a database off the DAT file I have from the client.  I have tried stopping/starting the MSSQLserver service and database server.  The DAT file does not show up.  I am open to ideas.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:edbrinkm
ID: 38338228
Thanks, the link did help me install the database software.
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 38339177
A .DAT file from 6.5 is a backup file. You'll need to create a database in the UI, right-click the name and choose restore, and search for and select your .DAT file. You should get a Restore Backup window with your .DAT file shown, and you should be able to restore it from there "Restore Now" button).

hth

Mike
0
 

Author Comment

by:edbrinkm
ID: 38339340
Yes.  I did that.  I did not put it in this ticket.  The link got me started.  I had to turn off single user mode and make the database large enough to hold the data.  SQL server did give me enough error messages to correct it.

I do have one more question.  My .net client code cannot execute a query.  It is using the Enterprise library 5.0 with the OLEDB provider.  It gets an "Unspecified error" with -2147467259 code.  The SQL server instance gives out an "Unable to Read Login Packets" Error : 17832, Severity: 18, State: 0.  Do you have any suggestions?  I have had to turn on TCP/IP and named pipes on SQL server 2000 in the past.  I do not know what to do with SQL server 6.5.
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 38339489
I wouldn't bother with .Net - it came out about 6 years after 6.5! I assume that now you've got the DB up and running and can "see" into it, you want to pull the info out into something more modern - Oracle 7, perhaps :)  

You should be able to export the data to .csv files with the bcp utility.

Alternatively, open up the ODBC shell in the control panel (admin tools) and see if you have a driver for SQL Server there. You should have. Now try to find an old copy of Access or Paradox or Excel that will pull the data from 6.5 and put it into something like a .csv file.

Keep asking questions (see you tomorrow)!

hth

Mike
0
 

Author Comment

by:edbrinkm
ID: 38342311
The bcp command seems to tedious.  I will try Access 1997 with an ODBC connection.  I tried using the SQL server switch command on another computer.  However it did not run.  I also tried using DTS to import the SQL server 6.5 data using an OLE database provider.  However, I got an error stating "The cataloged stored procedures installed on server are  version6.5.0.193; version 0.7.00.0330 or later is required to support IDBschemarowset.  Run instcat.sql.  I tried running instcat.sql from the command prompt but got a connection error stating the server was not found.  I tried both local and the actual database server name.
0
 

Author Comment

by:edbrinkm
ID: 38342681
Access 1997 with an ODBC connection worked.  I created an Access database.  I then selected File/get external data/import with ODBC datasource pointing at the database I needed.  I imported the Access file to a SQL server 2008 instance.  Thanks for the tip!
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 38343756
Yaaay!! Well done Ed!    At one point I was wondering if I'd have to offer to send you a copy of Windows NT 4 Server to mount the thing onto :) !

BTW, when you have a chance take a look at the bcp and bulk insert facilities - they're actually not too tedious. I was having problems with an SSIS import a few months ago and tried the bulk import out and suddenly found my self with a robust way of hauling 5 million+ record files in to the database. Most gratifying!
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question