Posted 10 September 2017, 12:31 pm EST
I'm running into some issues building my connection string through the C1 Report Designer vers. 2.5.20071.231.
Using the data-link properties, I build out a connection string that should look like:
Provider=SQLOLEDB.1;
Password=;
Persist Security Info=True;
User ID=;
Initial Catalog=;
Data Source=
Instead, I'm getting a string like this:
Provider=SQLOLEDB.1;
Integrated Security=SSPI;
Persist Security Info=False;
Initial Catalog=;
Data Source=
What I'm entering in and what I'm getting for a connection string are not the same, and it's not letting me connect to build the report properly. Could there be something with SQL User Permissions that's forcing the connection string to be built using SSPI?
I'm at a loss with this one, any help would be appreciated!