What are the challenges you face when working across database platforms? Take the survey
Options

SmartAssembly Command line mode DbConnectionString

Hello there,
i have created a Windows-Service which should import CrashReports with the SmartAssembly Dos /downloadnewreports Command every Hour. Sadly when my Windows-Service starts the Process the only Output i get is this:
 
System.Exception: SmartAssembly v7.5.2.4508 Professional
Copyright ¸ Red Gate Software Ltd 2005-2020


------ Downloading New Error and Feature-Usage Reports ------

ERROR: Unable to connect to the SQL database:
'Fehler bei der Anmeldung fr den Benutzer 'MySQL-ServerName$'.'

Connection string:
Server=MySQL-ServerName;Integrated security=SSPI;database=master;Connect Timeout=6

FAILED : Unable to connect to the SQL database:
'Fehler bei der Anmeldung fr den Benutzer 'MySQL-ServerName$'.'

Connection string:
Server=MySQL-ServerName;Integrated security=SSPI;database=master;Connect Timeout=6

There is a /dbConn Command but i can't figure out how it works.
An Example of a /downloadnewReports Command with a ConnectionString like
"Data Source=LocalPc\LocalSQLServer;Initial Catalog=SmartAssembly;User Id=Sa;Password=Password"
would be very helpful.
Thanks in advanced.
Tagged:
Sign In or Register to comment.