Recent content by Hannie

Thank you.

We want to put virus protection software on our SQL Server and I was wondering if anyone knows of any issues with certain virus software and SQL. Currently, our server is behind a firewall but we would like to put virus protection on the box as files will be uploaded from clients. Are there...

Thanks for your suggestion. We have opened Port 80 but I need to check if port forwarding has been added.

We recently moved our server behind a firewall. Prior to the move I could access websites running on the box without any problem. I reconfigured the sites for the new IPs assigned to us by our ISP and subsequently cannot browse to anything on the server. I have checked IIS and related services...

I have a server behind a Firewall. I want to allow remote users access to a SQL server. Do I only need to open Port 1433 or are other ports required to be opened also?

To allow remote users access to a SQL server do I only need to open Port 1433 or are other ports required to be opened also?

Thank you. Index Server is not running.

Thank you both for your responses. Unfortunately my password has not changed in a very long time and the auditing for successful and failed logons is turned on. I appreciate your comments.

We are running an NT 4.0 server on which I have an admin account. For the past week, my account is being locked out every few hours. I can't find anything in the event logs to indicate attempted logons. I am confused, does anyone have any ideas please.

I tried to run the IIS patch for Code Red on an NT 4.0 server this morning and the setup keeps failing stating: Setup could not find the setup.log file in your repair directory. This file is there however. Has anyone got any ideas as I would really like to apply this patch.

Tried things listed in the Article. Does not seem to be the root cause of our problem.

When I reboot our SQL server yesterday, the MSSQL service would not restart. From the event log I determined that an evaluation copy of SQL 2000 had been installed on the server and has expired. I tried using a retail copy of SQL 2000 to upgrade the server and thus enable me to restart the...

I have set up a maintenance plan for backing up my SQL databases. The logs are generating the following error Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4062: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open user default...