Help needed to connect to sqlserver

[yogesh.settty]

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.

[dom.smith]

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
_________________
Dominic Smith,
ANTS Performance Profiler Project Manager,
.NET Division, Red Gate Software.

[yogesh.settty]

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

"How to integrate smart assembly 5 with build process"

[dom.smith]

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
_________________
Dominic Smith,
ANTS Performance Profiler Project Manager,
.NET Division, Red Gate Software.