Hi jegan,
You have three ways to specify the SQL Server Credentials when using the sqlServerQuery statement. Here are your different options (based on the fact that a "Rick.Maverick" SQL Server user exists and has rights on the given SQL Server):
- Directly specify the Username / Password inside the connection string of the sqlServerQuery statement.
The username/password are directly stored within the report (not secure).
- A second option is to use data source variables for specifying the username and password (available starting from the version 3.5 of Enesys RS Data Extension).
The username/password are stored within the data source (not very secure).
Instead of specifying the values, variables are defined inside the data source and used within the connection string:
Here I defined two variables: $username! with the SQL server user name, and $password! with its password. I can re-use those variables:
- The third option is to directly use the Data Source credentials.
My data source uses specific user name and password (securely stored):
I can use the same credentials for the sqlServerQuery statement, by checking the "Use Data Source Credentials" radio button:
You can find more information about this inside the "sqlServerQuery statement" chapter inside the Enesys SharePoint Query manual, and inside the "Joining SharePoint lists and external SQL data" chapter inside the Enesys SharePoint Query Designer manual. Both manuals can be found inside your installation folder.
I hope everything is clear enough. Don't hesitate to contact us if you need more information.
Regards,
Marien MONNIER
ENESYS