Model transfer

[Mr. Sanders]

Hello,

I try to transfer an EAP file to an MS SQL Server, but I always get the message:

Could not open target database.

I already tried a couple of things, e.g. assigning the user do the admin roles, give him all right explicitly, ...

Nothing works.

We use Windows Authentification.

Is there a hint to solve this?

Regards
Michael

[Mr. Sanders]

Hello,

after droping and recreateing the DB everything worked fine.




I don't care anymore.

Thank you

[David Myers]

I got the same problem. When I test the connection it connects ok, but then when I click on the transfer button on the Project Transfer page it works comes up with the error "Could not open target database".

I created the necessary tables using the script from the website and did the same on a local database. I could transfer to my local database but not a remote database.

Clearly there is something different in terms of the setup of the non-local database, but because there is nothing that specifies the setup of the sql server database in order to use EA I have nothing to go back to the DBA's with.

Anyone have an idea how to resolve this issue, or even where to start?

[Mr. Sanders]

Hello David,

I had these problems with the sql native client.
When I switched to ole db provider for sql server I was able to access the db.

Did you configure the remote sql server, that it allows remore connections?

Regards
Michael

[David Myers]

I found the issue when trying to connect to the remote database after transfering my local data to it. I got the following error:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I then found that this is a MS issue and there is a work around by specifying the port explicitly in the connection string as described in the following KB article:

http://support.microsoft.com/kb/888228

Hope this helps someone else!

[Mr. Sanders]

Hello,

the standard Ports are

TCP: 1433
UDP: 1434

Michael