Hello,

Thanks for your replies. We are getting the updates every month. We have a encrypted database and need to run certain tools to get a lookup tables.

As both of you...

Now when I am trying to migrate the packages to SQL Server 2008 it is giving an error

Execution cannot continue as the language dependent resource file

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\dtspkg.rll could...

I hope I will not face any such issue when I will upgrade actual server.

Changing the collation at the time of installation worked. Thanks for the help.

Creating procedure [dbo].[sp_syscollector_upload_instmdw]...

2010-10-26 13:26:17.47 spid7s Error: 468, Severity: 16, State: 9.

2010-10-26 13:26:17.47 spid7s Cannot resolve the collation conflict between "SQL_1xCompat_CP850_CI_AS"...

Unfortunately both the solutions not working.

I am not able to get any clue as why this error should come.

I am getting following error in SQL Server LOG

Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 200, state 7, severity 25. This is...

I have windows server 2003 as OS.

I uninstalled reporting services and reinstalled the same. Now I am getting the following error

"The attempt to connect to the report server failed. Check your connection information and that...

Hello,

The problem is resolved. I used the same domain user with local administrative rights on both the machines as startup user account for SQL Server.(on both the machines)

Then I executed...

We checked the combination of another machines as Principal and Mirror. Every time the problem is faced when setting Mirror as partner from Principal.

I am trying to configure mirroring using script.Everything went fine until I tried to configure the partner on the Principle using following command

Alter database AdventureWorks set partner = 'TCP://ws1512:5023'(ws1512 is...

telnet 5022 says Connect Failed. Windows firewall is inactive on all the machines.

I used the user interface to configure Principle, Mirror and witness for the mirroring purpose. I configured the end point in the same way.End point state shows "Started".