Network Error

[philchudley]

A fellow user of EA has encountered a problem when making a connection to a SQL server database

A local EAP file needs to be transfered to a SQL DBMS and the database and scripts have been run. A connection between the host machone and SQL server is attainable using SQL Server Management studio and windows authentication.

When the connection is attempted within EA, "Test Connection" succeeds, but the next step fails with

"Enterprise Architect has encountered a Network Error and needs to Close" (or very similar wording)

It does not appear to be an authentication problem since the DB can be accessed via SQL Server Management Studio ...

... any ideas?

Cheers

[Geert Bellekens]

Which driver is he using to make the connection?
For SQL Server (2000) we are using the '"Microsoft OLE DB Provider for SQL Server"

Geert

[philchudley]

Am pretty sure same as you, however they are using SQL Server 2005

[«Midnight»]

It might - possibly, not for sure - be an access problem on the SQL Server side. If that's the case the following might help.

Make absolutely sure you have rights to the server and database you are trying to access. In SQL Server Management Studio check whether there is a user (or login) and role associated with your username. If so, ensure that the defined user is defined to match your login credentials completely, including domain or machine name. Also make sure that the roles assigned to this user allow modification of the schema you are connecting to.

Pay particular attention to the credentials (as mentioned above). It is very common to have the username defined without credentials. SQL Server won't necessarily match these up, and defaults to 'protecting' the database from you in these cases. Not only that, but in the default configuration SQL Server provides only a 'generic' error message in these cases, perhaps for security reasons. The message you mention sound like it might be one of these generic responses.

[Note: If you have a DBA to help you this might go more smoothly. Just make sure you get the message about credentials across. Otherwise your DBA might see your username and assume 'the user is defined; it is not a database problem' without digging deeper.]

David

[randydorning]

I am running into the exact same issue but with a postgreSQL database. Did anyone come up with a solution for this? Thanks.

[jumbie]

I have the same problem with MySQL connection (ODBC driver 5.1):

1. MySQL and EA are installed on the same local machine (for testing)

2. All tests of connection and MySQL clients are working good with username = ROOT , pswd is empty, another combination of username and pswd are not working

3. EA reports "network error"

Can anybody help me?