SQL permissions

[Andy B]

Have just created a MS SQL database on a SQL server and followed the instructions to attach from EA. When I open the project EA just seems to sit there doing nothing. I have previously installed and used a locla SQL database on my laptop without any problems. Is it likely to be a permissions problem? If so what pwemisssions need to be set?

Any help appreciated.

Andy.

[«Midnight»]

Hi Andy,

Did you do a project transfer to 'seed' the project data?

If not, create an empty (or non-empty, but with your basic structure set the way you want) project in an EAP file. Then open EA - you don't need to open a project - and from the main menu choose Tools | Data Management | Data Transfer. On the dialog, choose the .EAP to DBMS option button, then use the browse (i.e. "...") buttons to select you .EAP file and your new repository. Note that you will erase the target project. Then run the transfer.

Once that is done, try opening your repository.

David

[Andy B]

Hi Andy,

Did you do a project transfer to 'seed' the project data?

If not, create an empty (or non-empty, but with your basic structure set the way you want) project in an EAP file. Then open EA - you don't need to open a project - and from the main menu choose Tools | Data Management | Data Transfer. On the dialog, choose the .EAP to DBMS option button, then use the browse (i.e. "...") buttons to select you .EAP file and your new repository. Note that you will erase the target project. Then run the transfer.

Once that is done, try opening your repository.

David

David - did what you suggested and worked - thanks

Andy.