Login problem when using Softalk Organizer with SQL Server

Symptoms

When browsing to the login page of Softalk Organizer, you may get the following error if you have installed Softalk Organizer to use Microsoft SQL Server:

ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection. ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection.

Cause

This is because the ASPNET user context (which is the default security context for Softalk Organizer) has not been given access to the SQL Server database.

Resolution

There are several choices available to you in order to overcome this:

1. Create a user login called DOMAINASPNET in SQL Server and assign them sufficient access to create databases and tables.
2. Enable impersonation in the web.config file (in the inetpubwwwrootsoftalkorganizer folder) by adding the following line:

   <identity impersonate=”true” />

   You can then set the anonymous user for the virtual directory (in IIS admin tool) to be a user who has sufficient access within SQL Server.

3. Enable impersonation for a specific user, who has sufficient access within SQL Server. You can do this by adding the following line:

   <identity impersonate=”true” userName=”domainuser” password=”password” />

   for Windows authentication, or if SQL Server is set up for Standard authentication,

   <identity impersonate=”true” userName=”username” password=”password” /&gt