Move Act database to a dedicated SQL server

We are looking at purchasing Act. I want to be able to move the database to our dedicated sql server. I'd like to share this database to the users. I can't seem to find how to do this. I have ACT7 database attached, but I don't see how to get Act to recognize it. SQL files are ldf and mdf, but when I try to open a database from Act it show I can only open pad, adf, and dbf.

Re: Move Act database to a dedicated SQL server

Both entries were helpful. I appreciate it. First question, the instruction are for Premium. Does this still work for Pro?

Next, I have the database setup on my database server. I went to do the step called "Run SecurityCmdLnApp.exe with the new "SA" password", and I get an error that pops up saying the service has stopped. I open Act and it doesn't do anything different than open the demo database. I don't quite understand how to get it to use that database on the remote server. Also, those install instruction show that you should install sql express. I don't want sql express on all the workstations, nor do I want them to use a local database.

So, I went to follow the instructions from Hammertime to see if I need to do the restore. If I open Act and choose restore database, I get three options, restore, restore as, and unpack and restore remote database. I don't see which option works best. I don't want to restore from the database server to this workstation. I just want all the workstations to use the same database that is on our database server. Can you explain further?

Re: Move Act database to a dedicated SQL server

to attach the database to a Standard SQL you need the Premium, it is mandatory, the pro is not supporting this feature as i know,

you can disable the SQL express installation while checking the custom Install, but for full email functionality you would not like to do this.

the restore only works, if you created the ACT instance on the SQL, and therefore you need to follow the instructions shown in the KB i did send you upfront. then, after this is done, you can restore any ACT premium Database on the standard SQL.

Re: Move Act database to a dedicated SQL server

So, in order to do a shared database, we'd have to stand up a server dedicated to Act and install sql express on it, install the database there and then share it? Then, the workstations can access that shared database from there. Will that work since we don't intend to use Premium?

Just for some background, I don't want to install a shared database on a workstation. We use xendesktop, which I'm not sure will work anyway (I have a whole different post on that issue). From what I believe you are saying, I need a dedicated install of Act somewhere that houses the database with the Act install. I'm not going to install Act on our dedicated database server, so standing up a new server dedicated to Act is my only way around, correct?