Choose your SQL server:

Customers

Become a customer

Testimonials

Paolo Benjamin T. Briones:
"I just downloaded the trial and its great! IMHO, its a lot better than the Enterprise Manager from SQL Server".

Kevin Settler:
"If you need the job done right and on time, do it with MS SQL Maestro on your team. The software is a pleasure for us. SQL Maestro Group do excellent work and are dedicated to producing products that all can be proud of".

Alex Torin:
"Several months ago I downloaded the trial versions of several Microsoft SQL administration tools that I was able to find using google. I had considerable trouble with most of them crashing... but using your product I was able to isolate and solve the problems I was having. I decided to add it to my toolkit and have recommended it to a few others".

DavidNR:
"MS SQL Maestro is a great app. Loved it. I only used it for its blob support thus far, very nice and very fast".

Add your opinion

SQL Maestro Group / Products / MS SQL Server / MS SQL Maestro / Documentation

Download Buy

MS SQL Maestro online Help

Return to chapter overview

Setting connection properties

The first wizard step allows you to specify the database connection properties that will be used on further connections.

MS SQL Maestro allows you to connect to Microsoft SQL servers using Windows and SQL Server authentication modes.

Windows Authentication (more preferable)

Microsoft Windows Authentication mode allows a user to connect through a Windows user account.

SQL Server Authentication

When a user connects with a specified Login name and Password from a non-trusted connection, SQL Server performs the authentication itself by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded.

Check the Create a single profile option to set the database name manually and create a single profile for this database.

Hide already registered databases

Check the box to shorten the databases list on the next wizard step.

Return to chapter overview

Company news

Nov 1, 2008

MS SQL Maestro 8.11 released

Introduces a new Dependency Tracker tool, support for some SQL Server 2008 new features, and a lot of interface improvements.

Jan 8, 2008

MS SQL Maestro 8.1 released

Extended property management, SQL server logs analysis and some other features.

Oct 16, 2007

MS SQL Maestro 7.10 released

Features a new Backup Database tool, Attach and Detach Database Wizards, cancellation of long-running queries, SQL Formatter for DML statements and more.

More news

Feature of the day

Database Queries

MS SQL Maestro allows you to save frequently used queries to profiles and use them as usual database objects.

Object Duplicating

MS SQL Maestro allows you to make a copy of a database object by dragging it from one database to another.