How can I use Navision to connect SQL SERVER 2000

kevin.7710

I want to use Navision to connect SQL server 2000, Now I use the Navision database. When I create database for SQL SERVER, I must use "Windows Authentication" to create database, I don't use "Database server Authentication" to Create database,Why?
When I use "Database server Authentication" to create database, I imput the user id i"sa"and password, the message tell me it cann't connect sql server.

sendoh

what nav version are you using?

kevin.7710

Navision 4.0 SP2

kriki

Probably because your SQL-server does not allow those connections. Check the properties of your SQL-server to allow for it (Server authentication => SQL Server and windows authentication mode).

kriki

[Topic moved from Navision forum to SQL General forum]