Error while connection

[Volker Pieper - Rayman]

Hi I want to connect with Magic 9.4 to the northwind table.

I get always this error:

Error during the registration user SA. A cause: No familiar SQL server
connection assigned.

How can I create a trusted server connection ?

Thanks.

Volker

[Simon Hayes]

"Volker Pieper - Rayman" <ra****@idepro.d> wrote in message news:<bv**********@online.de>...

Hi I want to connect with Magic 9.4 to the northwind table.

I get always this error:

Error during the registration user SA. A cause: No familiar SQL server
connection assigned.

How can I create a trusted server connection ?

Thanks.

Volker

To make a trusted connection (and assuming you're using SQL 2000),
then you need to grant server access to the Windows account you're
using to connect, as well as the necessary database access. You can
use Enterprise Manager, or see sp_grantlogin and sp_grantdbaccess in
Books Online.

After that, you have to tell your client application to use a trusted
connection instead of a SQL login/password. That depends on which
client library you're using, so you would need to check your Magic
documentation on that.

Simon