Example: MSSQL server setup screens are attached in this solution.

NOTE: MSSQL2005 is supported starting with xCoupler Release 1.3.1

Remember, we use SQL AUTHENTICATION and MS SQL SERVER 2005 defaults to WINDOWS ONLY AUTHENTICATION so you will need to add this capability in many cases.

To get to this option, go to the top level (i.e. SERVER name) and RIGHT CLICK then select PROPERTIES, then SECURITY and select SQL and WINDOWS AUTHENTICATION mode.

You will have to restart in order for this to now be functional.  To RESTART, go to the top level (i.e. SERVER name) and RIGHT CLICK and select RESTART.

Note       

Your USERID used by the xCoupler will also need to use SQL AUTHENTICATION.

To get to check this option, select SERVER / SECURITY / LOGINS / your_xCoupler_USERID then double click to view the LOGIN PROPERTIES / GENERAL (an example is shown below).

Note       

HINTS : If you are setting up a new account and database--

Server Configuration :

In the object explorer, right click the database and click "Properties"
Under security tab choose "SQL Server and Windows Authentication Mode"
Click ok

Create a new Database :

Right click on Databases and create a new database.

Create a new User:

Expand the Security then Logins tree. Right click on Logins and choose "New Login..."
Enter a Login Name
Choose "SQL Server Authentication"
Type a password
Uncheck "User must change password at next login"
Click on User Mapping tab.
Check the database to give the user access to.
Click ok.