Need help :_(

Is there any way to register an evaluation version of SQL 2005?

So I had a database using the evaluation version of SQL 2005 and didn’t know it was a trial version until it locked me out of it a couple days ago now I got a big problem.

Is there any way I can move the data that I had to another database without using the SQL server management studio.

But what I would really like to do is register this trial version of SQL that the @.#%# people left me with and didn’t tell any one.

Any help would be grate

I don't think u can register trial version... what u can do is, download sql server 2005 Express edition (free) and install. Move the database from evaluation version using Dettach/attach or backup /restore method. Remove evaluation edition.

Madhu

|||

Stop the service. Copy the MDF and LDF files of the database you need and attach them to another running SQL Server instance.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Is there any thing else i need to save after that? Most of the stuff in the database was for a website done in ASP

so i guess i got to redo my connection strings to or is there any way around that?

|||

You can 'install' a licensed edition of SQL Server 'over the top' of the evaluation version, and it will upgrade.

If you choose to move the data files to another server, you will have to change the connnections strings on the applications.

You may also have to deal with adding the logins and permissions for the new server.

|||

Be aware that upgrading you instance will need the same edition type as the original version. If you want to (down-)Update your eval-Version, you will have to do a attach/restore to another instance. (As Arnie mentioned you will have to change the connectionstrings to the appropiate new instance and keep track of the logins (server principals) as they are stored in the master database.

Jens K. Suessmeyer

http://www.sqlserver2005.de