Hi,

I had a similar issue and found there were two instances of report server that were being refered.

Click on 'Initialization' in the Configure Report Server screen. If you have...

Thank you for the reply Kshitij.

You are right. There are firewalls installed between both hosts and both were in different domains. The appropriate network configurations were taken care of and...

The networkname was changed to 'SQL2K5SWPROD'. But SQL Server was installed after the name change happened. So I reckon this should show the new name for @@SERVERNAME as well.

I...

Hi,

If the application is being used during a specific time window and you want to collect the error for the specific time window, you can setup a scheduled trace to...

Thank you for your response. Unfortunately, the default backup location is the same in the registry and the account executing the backup has the required permissions in the backup location.

Also,...

Manual backup from enterprise manager is also failing with the same error.

This is a SQL Server 2005 instance. Also, the backups were happening fine earlier.

I do not have much in the error logs and I don't have a backup of the database before this error popped up.

The only noticeable thing that happens is,...

The column name 'sql_handle' is available in SQL Server 2005 but not in SQL Server 2000.

Is there any way to find out the same information in SQL Server 2000?

I had blank spaces in the Friendly Network names 'Public Cluster Connection' and 'Private Cluster Connection' and tried removing them. I renamed them as 'PublicClusterConnection' and 'PrivateClusterConnection'. Even after doing so,...

The cluster is in good shape. I am able to failover to/from the other node. I tried the failover by restarting the primary and was able to get the services...

There are a few other articles that gets changed time and again which prompts to re-initialize the subscription.

I have found a workaround to acheive this.

After the initial snapshot...

Has any one encountered "Exception Ox0000005" while sending emails using CDO objects?

Kindly let me know incase you have any workarounds for this exception.

Also, in the SQL Server Agent Properties, Under the General tab, the section "Mail Session" is disabled on the server which has this problem. On all other installations, this section...

Thank you for the reply.

Yes the job uses excel to generate reports and send them to the requested users. If the executable is run manually, the reports are sent...

The package executes without any errors if I execute the package from the command prompt by logging on to the SQL Server with the SQL Server Agent Service account.