Thank you Jose. Your suggestion worked for me.

Make sure your Report Project properties: TargetServerURL is set to http://servername/ReportServer

I kept trying by changing the configurations on the server and noticed the following behavior:

When SQL Min/Max memory is changed to 0Mb/16Mb the query worked fine. BUt i cannot use...

I kept trying by changing the configurations on the server and noticed the following behavior:

When SQL Min/Max memory is changed to 0Mb/16Mb the query worked fine. BUt i cannot use...

I kept trying by changing the configurations on the server and noticed the following behavior:

When SQL Min/Max memory is changed to 0Mb/16Mb the query worked fine. BUt i cannot use...

RK

Lynn,

Our infrastructure guy said that there is not difference in the disk configurations between both the servers.

However I found other differences:

Server that freezes (32 bit)

AWE enabled

SQL Log on as:...

Noting in the error log and SQL Server Event logs about the error.

I checked the defaut trace file - pasting below the record that appears to be around the...

The only difference i could find between the two servers :

Server that freezes: Intel(R) Xeon(R) CPU X5355,@2.66GHz, 32 Gb Ram

Server that didn’t freeze: Intel(R) Xeon(R) CPU E5345 @2.33 Ghz 16.0...

After opening the solution/project, before opening any package, set the VS to offline mode (SSIS -> Work Offline). Then try opening the packages. I feel that the packages open...

Follow this link: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97685

It has the solution to your issue.

Executable: C:\Program Files\Winzip\WINZIP32.EXE

Arguments: -e...

In response to Jacques post on 3/8/2007:

When I use the following create statement, it gives the error "Size of field column3 is too long". It does not solve...