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/C ... 210448.htm

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/C ... 210451.htm