Troubleshooting
This section answers the most frequently asked questions.
If you do not find answers to your questions here, please contact support.
Q. How to check and change the authentication mode that has been selected during the
MSDE or MS SQL Server 2005 Express Edition installation?
A. In the case of MSDE, this can be done only in the Windows Registry by using the Registry
Editor. For instructions how to check and change the authentication mode, refer to the Microsoft
support pages at:
http://support.microsoft.com/kb/322336
.
If you have installed Microsoft SQL Server Manager Studio Express (available as a free download
from Microsoft) with the Microsoft SQL Server 2005 Express Edition, you can use it to check
and change the authentication mode. If you have not installed this tool, the only way to check
and change the authentication mode is to edit the Windows Registry. See the above link for
further instructions.
Q. Can I use a blank password with the "sa" account when installing F-Secure PSB E-mail
and Server Security?
A. No. The password cannot be blank.
Q. What is the default installation directory for MSDE or MS SQL Server 2005 Express
Edition?
A. The default directory for the Microsoft SQL Server 2005 and MSDE is
C:\Program
Files\Microsoft SQL Server
.
Q. I need to verify my SA password. What to do?
A. You can use the osql.exe tool to verify that your SA password is valid and to make sure that
the database is up and running. The osql.exe tool in MSDE and Microsoft SQL Server 2005 is
located in your SQL installation directory. In the Command Prompt window, go to the directory
in which the
osql.exe
file is located (for example in
C:\Program Files\Microsoft
SQL Server\80\Tools\Binn
), and type:
osql.exe -U SA -P <password> -Q "USE master SELECT @@version" -p
If the query is successful, you will see output similar to the following:
16
| F-Secure | Getting Started