problem using sqlserver on remote server

[Peter Kellner]

When I tried to "transfer" my data to an empty database with just the populated tables from the sql script, I got an error so I loaded the data on a local sqlserver and it worked fine.  I then moved that database up to a sqlserver on a hosted provider (slower connection but still fast cable modem speeds).  When I try and connect to that, it says "loading project" for several minutes and eventually errors.

Any suggestions?  Below is the error I'm getting when I try and open a file over the internet.  BTW, other apps work fine for me connecting to sql server 2005 remotely so there is something different in EA causing the problem.  Also, I followed the directions to use the oledb sqlserver connection parameters.

"an error has occured loading the requested project. Microsoft Cursor Engine [-2147467259]... Data provider or other service returned an E_FAIL status."

Thanks,

-Peter

b

[«Midnight»]

I had a series of mysterious errors like this once. Two different servers were complaining. We never did get one of them resolved. That's not to say it cannot be done, just that we gave up when we got the first one going.

Among the things we ended up doing was downloading a new script from the Sparx site. A quick look didn't reveal anything objectionable in the old one, and it seemed to work fine on the local DBMS, but the new one made a difference.

We also had to be really careful with network segmenting and domain credentials. I don't remember which combination worked in the end - and I was not the only one working on this; the client's network people and DBA staff did legion duty for us - but it did involve some tweaking of what we called things.

Finally, make absolutely sure you have the appropriate privileges on the remote server. One thing that tripped us up what the the network administrators gave me an account on that server, hoping it would make things easier. Turns out that the account had the same username as my local (domain) account, which itself did not have administrative privileges (for the usual good reasons). No way would the remote connection recognize the correct set of credentials. Until the offending (server) account was removed (completely, not just deactivated) someone else had to do everything for me.

Sorry I can't be more help, but that's all I remember from when we did this. It's been about a year.

David

[Peter Kellner]

I'm using non domain auth. (username/password) for sqlserver so hopefully no domain issues involved.  How long does it take to load a small model over a fast connection?  It's very slow for me until it finally crashes.  I've got an insanely fast cable connection so maybe there is something else going on regarding permissions.  Are there any special permissions needed for sql server?

[Peter Kellner]

actually, I meant I am not using domain auth.  Just standard sql server authentication with username and password.

[«Midnight»]

Yes, but that can still involve crossing the domain. As I said, I've not tried all the combinations so I can't provide a solution here. All I was trying to do was give you some idea of where we got things going and where we were stumped.

Sorry I cannot be of real help here. I do know how frustrating this can be.

David