SUPPORT Q&A - Database Creation Problems

dac - Monday, January 29, 2007 3:05 PM:

Having difficulty doing a database creation through the Wizard.

Using Windows Server 2003/SP1
.net 2.0
Windows Installer 3.1
SQLServer Express

Installation goes smoothly until Database creation page.  Server is named correctly, UID/PW for DBA is correct, and have created other accounts in SQL Express and tried as well, still will not accept.  To error messages received (depending on uid/pw used)...

"user not associated with a trusted SQL Server Connection"
"SQL Server does not exist or access denied"

Any help would be greatly appreciated.
Thank you

Dominick C
[email protected]

Bill - Tuesday, January 30, 2007 8:20 PM:

The most common reason for the error messages you are seeing is that SQL Server Authentication is not enabled.

To check this:

1)  Open the SQL Server Management studio, and login to the desired SQL Server instance.

2)  From the object browser, right click on the SQL Server instance and select Properties from the menu.

3)  Under the Security Server Properties, make sure “SQL Server and Windows Authentication mode” is selected.  (Changes to this setting may require you to restart SQL Server)

4)  Select OK

5)  Finally you will need to enable the sa login, or a suitable substitute, to use in the installer.  (You can find these logins under the security folder in the object browser.)

6) You will need to restart the SQL Server service for this change to take affect.

After enabling SQL Server Authentication, you should be able to install the database.

For more details about database installation options see the Aras Innovator-  Installation Guide.

http://www.aras.com/support/Documentation/documentation.aspx