Attaching the Genesis R&D Database to your instance of SQL Server 2000

Note: If you are using Genesis version 9.12 or higher, you will not be able to use an instance of SQL Server 2000

Using the ESHA Database with your own instance of SQL Server will require the server collation to be 'SQL_Latin1_General_CP1_CI_AS'.

To attach the Genesis R&D Database (gendata) in SQL Server 2000:

  1. Copy the gendata.mdf file from "[CD]:\win32\program files\ESHA Research\data" into a drive that is local to the server (recommended is "c:\program files\ESHA Research\data").
  2. Check/change attributes on that file so it is not Read-Only.
  3. Start Query Analyzer (part of full SQL Server 2000).
  4. Connect to your server - MASTER database.
  5. In the text enter this (including quotes):
       exec sp_attach_single_file_db @dbname = 'gendata',
       @physname = 'C:\Program Files\ESHA Research\data\gendata.mdf'

    NOTE: the @physname parameter should be the path to .mdf from step 1 including extension.
  6. Execute the SQL.
  7. Exit Query Analyzer.

PERMISSIONS NOTE:  After it has been attached you will need to assign permissions for any user that will access the data. Use Enterprise Manager to add the user's Windows Authentication to the role 'FPRole' that exists in the database.  If you are not using Windows Authentication (Active Directory), refer to the Using SQL Authentication document for information.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Powered by Zendesk