Jesper Frier Certified Professional


Joined: 09 Sep 2006 Posts: 1940 Location: Stoevring, Denmark
|
| Posted: Tue May 17, 2011 5:08 pm Post subject: How to: Change SQL Server Authentication Mode |
|
|
You've created the SQL back-end database for eMailSignature.
Symptom
Your are getting errors when trying to connect to the database using the built-in SQL Server login and user.
Cause
During installation, SQL Server Database Engine is set to Windows Authentication mode.
Resolution
Change Authentication to mixed mode.
To change security authentication mode:
- In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
- On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
- In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.
_________________ </Jesper> | Test Email Signature | Showcase |  |
|