Viewing 15 posts - 31 through 45 (of 71 total)
May 10, 2018 at 3:03 pm
Thanks for help I will put a issue on hold for for some time
I tried to create new ssis that use mysql as data source and pass connection string...
May 10, 2018 at 12:40 pm
When "Edit it" inside package
I see that is listed as .\Net providers\MySQL Data provider
In properties of connection
Connection manager type = ADO.NET:MySql.Data.MySqlClient.MySqlConnection, MySql.Data, Version=6.9.8.0, Culture=neutral,...
May 9, 2018 at 10:30 am
Thank for the tip!
I did not no that that additional parameters overwrite ..values
Managed to connect as
On login tab
Server name =CANSQLSERVER1\SQL2V2017
login = 'myUser1'
password ='****'
May 7, 2018 at 11:40 am
I tried installation with
/RSINSTALLMODE=FilesOnlyMode
yes SSRS installed and no ReportServer databases created
I would probably will use this option and create PowerShell script that will run...
May 10, 2017 at 1:53 pm
>Can you run a SQL script to rename the database post install? Is that an option for your method or no?
if ReportServer db is renamed after install...
May 10, 2017 at 1:41 pm
installing as new instance of sql2008R2
server already has 2 more named instances (2008R2 and SQL2014)
we automating installation of SQL in our shop (similar to azure and amazon), "click...
May 10, 2017 at 12:44 pm
Might be I am not clear
let say I created Data source as following
Data source name: Dummy1
Connection string: myserver,1499;inicial catalog =mydb1;uid=mydomain\ssrs_report_user1
Credentials stored securely in the report...
March 28, 2017 at 12:32 pm
Thank a lot .
Provided solution is working fine
February 9, 2017 at 12:04 pm
January 24, 2017 at 8:20 am
Thanks Jeff,
PowerShell replacement of sql based stored procedures is part our project
bellow is solution I used (part of the code)
#call to unix script
$UnixOutput = (Run-Cmd -command "listdbpriv...
January 23, 2017 at 9:01 am
January 20, 2017 at 11:40 am
Jeff Moden - Thursday, January 19, 2017 9:38 PMWhat version of SQL Server are you using for this?
1.SQL 2014
January 20, 2017 at 8:05 am
Viewing 15 posts - 31 through 45 (of 71 total)