Adding a Microsoft SQL Server Data Source
To connect a Microsoft SQL Server data source to My webMethods Server, use the following procedure:
To add a new data source for Microsoft SQL Server databases
1. To navigate to the correct page, do one of the following:
In
My webMethods:
Navigate > Applications > Administration > My webMethods > Data Sources > Add DataSource.
As system administrator:
Administration Dashboard > Configuration > DataSource Administration > Add DataSource.
2. Type a unique DataSource Name to be used by My webMethods Server on the View DataSources panel.
3. Type a Display Name to be used when you identify a data source to use for a database directory service.
4. Select MS SQL Server from the Server Type list and click Next.
5. Type the SQL Server host name.
6. Type the port number used by the SQL Server. The default port is 1433.
7. Type the database name.
8. Type a valid SQL Server user name and password that, at a minimum, has READ access to the database to which you will connect.
9. Click Submit.