Troubleshooting

Cannot log on to Ad-Hoc Query

Problem: Cannot log on to Ad-Hoc Query screen.

Possible Solution: The Ad-Hoc query screen required an SQL user to be setup.

To setup an SQL user, open Enterprise Manager, select Security, then logins.
Add a new user, password, then grant that user access rights to those objects they will need to be using.

When using the ad-hoc query generator, this is the user you will be using to log into the database.