Using Db Maint, Working with…
Login
Both the client and the server need to login using the sa account for version
6.5 or on 7.0 and higher an account with sysadmin privileges.
Client login
You can only be connected to one server at a time. If you connect to a server
while already connected to some other, you will be presented a dialog asking
for confirmation to disconnect.
The tree pane
There are two or three top-level folders in the tree pane of the client
program. You login by right clicking on a server and choose connect. You can also configure the client to auto-connect whenever you left-click a
server (see Client Properties). Whether a login dialog is displayed or not is determined from whether the
server has been registered in Enterprise Manager or not.
Registered Servers
One or two of the top-level folders show you the servers as registered in SQL
Server Enterprise Manager. This is a convenient way to log in, since the login
name and password doesn’t have to be supplied at login time. Db Maint does not provide support for
registering server; use Enterprise Manager to register your SQL Servers. One
folder show server registered as 6.5 servers the other show servers registered as
higher version. Note that a server can appear under both nodes if it has been
registered as both a 6.5 and a 7.0+ server.
Most recently used
This will represent the most recently used SQL Servers. This is convenient to
use if you have several registered servers and most often only use a few of
them. When you connect from here, the client will search among the registered
server. If the server is registered, the login will be performed as if you
connected from the registered servers’ folder. If not, an interactive login dialog is displayed.
Login to a server which is not registered
Use the leftmost button in the toolbar or the Connect option in the Configure menu. The following dialog is displayed:
SQL Server
Name of the SQL Server.
Login Name
The loginId, must be sa (or an account with system administrator privileges
for version 7 and later)
Password
The password.
Use Windows authentication
You can use this if your Windows NT account has system administrator
privileges in SQL Server. By default, the Administrators group has sysadmin privileges
in SQL Server.
Server Login:
Windows login
The server uses a trusted connection (Windows NT Authentication). Since
SQLExecutive/SQLServerAgent starts the server, it has system administrator privileges
by default. If SQLExecutive/SQLServerAgent is using an NT user account, the
account needs system administrator privileges as well. You can configure which
account SQLServerAgent is using in version 7 and later (Enterprise Manager,
right-click on SQL Server Agent).
Make sure that the scheduler runs under an NT account that system
administrator privileges if you are using a 3:rd party scheduler.
SQL Server login
In Db Maint 4.0, you can define an SQL Server login to be used for the server
login. This is configured in the Server properties dialog. This IS NOT recommended, as the password is stored in clear text in the msdb database.
Only use this for testing purposes or emergency situations.