Home : Products : OPS SQL : Authentification Mode Setup - Microsoft SQL Server 2005/2000
Q10067 - HOWTO: Authentification Mode Setup - Microsoft SQL Server 2005/2000

Hach WIMS requires mixed mode server authentication.  If you are using WIMS with our provided MS SQL Server 2005 Express database, this setting will automatically be set during install.  If you are using Hach WIMS against your own Microsoft SQL Server (i.e. you have the Database Support option) you may need to set your Security Server Authentification to "SQL Server and Windows Authentification mode". 

1. Log into Microsoft SQL Server Management Studio Express:

 

2. Right click on the server and choose Properties:

 

3.  Click on the Security Page and make sure that Authentification is set to SQL Server and Windows Authentication Mode. If it is not, make the change and click the OK button.

 

 

 

NOTE:  The following instructions are for Microsoft SQL Server 2000 and only apply to older versions of OPS SQL.  Hach WIMS does NOT support Microsoft SQL Server 2000!!

  1. Open Enterprise Manager

  2. Expand Console Root to point to the SQL Server that OPS SQL is to reside on.

  3. Right click on the highlighted server and bring up Properties.

  4. Click on the Security Tab. Make sure that Authentification is set to SQL Server and Windows. If it is not, make the change and click the OK button.

 

 

 

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 11/15/2004 12:02 PM.
Last Modified on 7/22/2011 12:58 PM.
Last Modified by Scott Dorner.
Article has been viewed 7824 times.
Rated 6 out of 10 based on 8 votes.
Print Article
Email Article