Second, the SQL Server should allow SQL Server Authentication. This is the authentication method used by Dynamic AI to connect to the database server.
This option can be controlled from the SQL Management Studio which is provided with the SQL database server and usually installed on the same machine.
A free edition, SQL Management Studio Express, is downloadable from Microsoft.com.
The Management studio can be especially helpful when attaching databases - e.g.: the sample database Adventureworks available from Microsoft.
Microsoft, Windows and SQL Server are registered trademarks of Microsoft Corporation. All other products may be trademarks or registered trademarks of their respective companies.
