Red Gate forums :: View topic - Help needed to connect to sqlserver
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SmartAssembly 5
SmartAssembly 5 forum

Help needed to connect to sqlserver

Search in SmartAssembly 5 forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
yogesh.settty



Joined: 22 Feb 2011
Posts: 5

PostPosted: Tue Feb 22, 2011 2:13 pm    Post subject: Help needed to connect to sqlserver Reply with quote

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.
Back to top
View user's profile Send private message
dom.smith



Joined: 03 Jun 2010
Posts: 85
Location: Cambridge, UK

PostPosted: Tue Feb 22, 2011 6:10 pm    Post subject: Reply with quote

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,
Project Manager,
Red Gate Software.
Back to top
View user's profile Send private message
yogesh.settty



Joined: 22 Feb 2011
Posts: 5

PostPosted: Wed Feb 23, 2011 7:26 am    Post subject: Reply with quote

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

"How to integrate smart assembly 5 with build process"
Back to top
View user's profile Send private message
dom.smith



Joined: 03 Jun 2010
Posts: 85
Location: Cambridge, UK

PostPosted: Wed Feb 23, 2011 10:35 am    Post subject: Reply with quote

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,
Project Manager,
Red Gate Software.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group