Choose your SQL server:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Subscribe to our newsletter
Partners
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".
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".

More

Add your opinion

Customers
Download Buy

MS SQL Maestro online Help

Prev Return to chapter overview Next

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.



Prev Return to chapter overview Next