Single-click script execution on multiple SQL Servers.
Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor
In our network, we do not have Active Directory access to all of our production servers (they're in a separate domain), so we use a SQL account to login. I just added a few servers to a distribution list, and by default Multi Script attempted to connect using Windows Authentication. Since it cannot authenticate, a Severity 20 Alert is fired from SQL Server, which is something we monitor. Any plans to modify this default behavior so we are immediately prompted for connection information instead of automatically attempting to connect with Windows Authentication?
Aside from this, this is an excellent product!
- Posts: 21
- Joined: Fri Sep 07, 2007 6:12 pm
Thanks for your feedback.
There is a work around for you issue. Before you click the [+] icon to expand a SQL Server, select the server and click the "Authentication..." button. You can then set up your SQL login details.
I agree that it would be nice to turn off the 'auto login' behavior. I'll log this as a feature to be considered for future releases of SQL Multi Script.
- Posts: 151
- Joined: Tue Aug 14, 2007 5:10 pm
- Location: Red Gate Software, Cambridge
Return to SQL Multi Script 1
Who is online
Users browsing this forum: No registered users and 0 guests