Showing posts with label control. Show all posts
Showing posts with label control. Show all posts

Monday, March 26, 2012

Mircosoft.ReportViewer.WebForms.dll fails to load

I've just deployed a website to a test server and when I hit a web page that uses the ReportViewer control, I get an error "Microsoft.ReportViewer.WebForms.dll failed to load...". I've searched all hard drives attached to the server and the DLL is not there. I understand that this should be part of the .NET 2.0 framework redistributable package and should live in the WINDOWS\assembly folder. It is not there.

The Add/Remove Programs dialog from the Control Panel shows the .NET 2.0 framework as installed. This is a windows 2000 server box running IIS 5.

Anyone got a clue as to why this DLL would be missing?

Thanks,

Mike

I am having similar issues. I've manually copied the Microsoft.ReportViewer.WebForms.dll from my development PC to my production server's Web app's Bin directory, but am unable to view the ReportViewer's icons such as Export, Print, etc. They're just red x's.

What is the best way to publish the Report Viewer?

|||

The cause of this problem is because the ReportViewer is not installed on the Virtual (Production) Server. Install the ReportViewer by running ReportViewer.exe on your Virtual Server. You can most likely find the ReportViewer.exe on your development machine at C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\ReportViewer\ReportViewer.exe

Installation instructions(see link below) are easy to follow & unlike everything else you've probably been wrestling with, this installation should be painless.

http://msdn2.microsoft.com/en-us/library/ms251723(d=printer).aspx

Friday, March 9, 2012

Migration Of MSSQL instance along with security permissions

Hi All,

This is the scenario. Basically i work for a web hosting company now we have taken over control of a competitor and would like to migrate there existing data to our own MSSQL server's in order to integrate them into our automatic system etc etc ...

The current system is running MSSQL7.

The system been copied to is MSSQL2K.

Objectives:

Retain all security accounts listed on the MSSQL7 system and use them on the MSSQL2K system. This includes all the logins that use standard MSSQL login's. (Reason : To ensure that all the customers ASP pages work after the DB's have been copied.)
Backup all the databases on the MSSQL7 and restore them to the MSSQL2K system. Unfortunately system is running on a different network with firewall's etc in between. What type of maintenance plan and how should i implement the requirement to keep all the login account's?
Any help greatly appreciated......
thxone of the option can be like take all backups on either hdd or tape then connect it to ur server copy it from previous one to new one.
to copy all login info etc u can write a script if u need the script i can send u next time (this will take the info to a cursor and one by one it wil update.)
as far as sql 7 database schema and 2k schema is concerned i dont think it will be a problem.
this is an intersting case pl update me|||Hi ranjan apologies for not replying sooner (did not know if anyone had replied). I agree when u state that u dont think either that the difference between porting to 2000 is going to cause an issue. I have restored all the databases now but am in need of a little help / inspiration on how to port over the login names. Perhaps you can help or have a script that performs this task. Regards the script u have for updating i presume its independent to the current logins that are on the SQL2K system at present. How is this done?