Red Gate forums: SmartAssembly 5

RE: Help needed to connect to sqlserver

dom.smith — Wed, 23 Feb 2011 09:35:08 GMT

Hi,

The instructions for integrating SmartAssembly with MSBuild are at http://www.red-gate.com/supportcenter/Content?p=SmartAssembly&c=SmartAssembly/help/5.5/SA_UsingSmartAssemblyWithMSBuild.htm&toc=SmartAssembly/help/5.5/toc1210451.htm

RE: Help needed to connect to sqlserver

yogesh.settty — Wed, 23 Feb 2011 06:26:44 GMT

Thanks for the quick reply and i wanna konw one more thing:

"How to integrate smart assembly 5 with build process"

RE: Help needed to connect to sqlserver

dom.smith — Tue, 22 Feb 2011 17:10:26 GMT

Hi,

By default, SmartAssembly uses Windows authentication to connect to the database. Using SQL Server Management Studio, check that the user account under which SmartAssembly runs can connect to the SmartAssembly database on the SQL server.

If you need to use SQL authentication to connect to the database, instructions are at http://www.red-gate.com/supportcenter/Content?p=SmartAssembly&c=SmartAssembly/help/5.5/SA_ConfigureErrorReports.htm&toc=SmartAssembly/help/5.5/toc1210448.htm

Help needed to connect to sqlserver

yogesh.settty — Tue, 22 Feb 2011 13:13:14 GMT

I have installed smart assembly 5 on "Application Server" and i wanna connect to "SQL Server" which is on another machine. This tool is unable to connect and displays "unable to connect to sql server".

Any suggestion will be appreciated.

RE: SA changes file alignment

Brian Donahue — Tue, 22 Feb 2011 09:33:26 GMT

The tracking number for this feature request is SA-842, if you need to check back with us.

RE: SmartAssembly Queries

Simon C — Mon, 21 Feb 2011 11:32:55 GMT

Thanks for trying out SmartAssembly. In response to your queries:

1. No. Everything smartassembly needs to run will be included in your main executable or library.

2. No, although if you do run into an issue please do post on the forum or contact our support team directly. There is also answers to some common questions on the support center - http://www.red-gate.com/supportcenter/Product?p=SmartAssembly

3. Internally we use the hashing and cryptographic providers built into the .NET class libraries, and our own compression library.

Hope this answers your questions

SimonC

SmartAssembly Queries

adive — Mon, 21 Feb 2011 04:31:56 GMT

Hello,

Can I please get the following queries addressed by Redgate:

1. If I use SmartAssembly to obfuscate my C# code when I ship my product will any SmartAssembly file (as in dll, library, exe, etc) need to be shipped with my product? If there is a URL addressing this please let me know.

2. Is there an online list of all vulnerabilies (defects, known issues, etc)?

3. Does the obfuscator internally use cryptography related technologies such but not limited to hashing, signatures, encryption, key management, etc?

Thanks in advance!
adive

RE: Setting up custom webserver to use database

kimpenhaus — Fri, 18 Feb 2011 18:15:41 GMT

uhh - this feels like a slap in the face

In my humble opinion you loose a lot of functionality while decoupling the webservice from it's "backoffice" processes. If you guys really intend to make the sync tool public I bet it would be better to give more possibilities on the web-service side because you have a bidirectional communication port opened to the customers in that case. I think I can construct a dozen use-cases where instant feedback can be useful. You a simple scenario: The customer ran into an exception caused by bug which is already fixed and ready to ship. While giving him the ticket id from the bugtracker it's an absolute transparent process for him and he can see when the milestone containing the fix is being shipped.

Is there some point where I can vote for such a functionality (or isn't this out of scope for what is meant to be done by SmartAssembly)? I know it's not just Automated Error Reporting but goes a bit far more in starting an Error Processing Workflow from within a client.

Anyway thank's for your help - I appreciate much!! I need to think a little while about what my use-case is and if it is even implementable with the SDK.

Kind regards,
Marcus.

RE: Setting up custom webserver to use database

Alex.Davies — Fri, 18 Feb 2011 13:40:28 GMT

Sorry, that document is about an old version of the webservice.

The custom web service is not intended to connect to the database. I would just stick to using the redgate web service to save yourself the cost of a custom web service.

The recommended way to do things automatically when new error reports come in is to poll the web service, say every 5 or 10 minutes. That's how the example code I sent you in intended to be run.

RE: Setting up custom webserver to use database

kimpenhaus — Fri, 18 Feb 2011 09:24:46 GMT

Hi Brian,

not sure but I think you are absolutly right - there is not direct access to the database. I searched a little while yesterday in the evening and on the SDK wiki-link (http://sdk.red-gate.com/index.php/SmartAssembly_SDK) you posted on the other thread (http://www.red-gate.com/MessageBoard/viewtopic.php?t=12825) there is the downloadable pdf document: http://sdk.red-gate.com/uploads/7/7c/HowToSetupCustomWebServer.zip. As I read it again I stumbled upon following:

Quote:

RunOnException: (Optional). An application file name. This application will be launched each time the server receives an exception report. It can be used to send an email, update a database, etc�

I think this is the clue to get it working - it's a standalone process which will be triggered after the receiving of a report which has to put it into database. Right?

This leads me to my next question

In the document it says:

Quote:

Edit the �{smartassembly}.WebServer.Settings.xml� file to configure your Custom Web Server:
<SmartAssembly.WebServer.Settings>
<ServerURL>http://www.myWebServer.com/{sa}WebServices/</ServerURL>
<SecuredURL>https://www.myWebServer.com/{sa}WebServices/</SecuredURL>
<RunOnException>c:\MyCustomWebServer\SendEmail.exe</RunOnException>
<Debug>0</Debug>
</SmartAssembly.WebServer.Settings>

Where do I find this file? And does the decoupled process gets any start-parameter?

Kind regards,
Marcus.

RE: Setting up custom webserver to use database

Brian Donahue — Thu, 17 Feb 2011 18:20:03 GMT

This is interesting -- I can't find any reference to a "database" in the webservice code. It looks like it simply dumps all of the exception reports to a folder on the hard disk specified in the ReportsFolder node of the web.config.

I suppose sawebservice just stores the report files until they are requested by a SmartAssembly client, which then puts the information in the Smartassembly database.

RE: SA changes file alignment

Brian Donahue — Thu, 17 Feb 2011 14:57:43 GMT

Hi Jens,

Honestly, no. These decisions are up to the product management who make them based on number of requests, etc.

Some other Red Gate products are moving over to UserVoice, so maybe we can be transparent in the future if SmartAssembly also moves that way.

RE: SA changes file alignment

JNeck — Thu, 17 Feb 2011 14:12:17 GMT

Hello Brian,

Thanks for looking into this!

For us it is very urgent to have such an option because without it we can't use SA on our newest projects.

Is it possible for you to say if and when this feature will be available?

Regards,
Jens

RE: Setting up custom webserver to use database

kimpenhaus — Thu, 17 Feb 2011 13:55:27 GMT

Hey Brian,

thanks - but I knew that already and as I said the database is already up, running and filled with a catalog named SmartAssembly.

The problem I am facing is - how will the web service know which database to use, what are the credentials etc. I can't believe that this is told by smartassembly application. I guess it has to be somewhere in the web.config maybe as subnode of the connectionstrings?

RE: Setting up custom webserver to use database

Brian Donahue — Thu, 17 Feb 2011 13:43:23 GMT

If you need to specify a named instance of SQL, you can specify SERVER <backslash> INSTANCE, for instance MYSERVER\SQL2008R2. If you have an older version of SmartAssembly, you may have to hack this yourself into C:\ProgramData\Red Gate\SmartAssembly\SmartAssembly.Settings.