.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Unable to open MSDB Folder Under integration services in SSMS. Urgent!!

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server


I uanble to open MSDB folder in under integration services in SSMS. Please help me.

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476


Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)



View Complete Post

More Related Resource Links

Unable to open MSDB node

I'm sure there is a simple answer to this but it eludes me at the moment.
I'm using the Developer Edition of SQL Server 2005.

The MSDB node under Integration Services->Stored Packages refuses to open.
It always fails with a login timeout message and that the connection was
actively refused.

I've run the SQL Server Surface Area Configuration tool and allowed remote
and local access, even though it's all installed on the local machine. This
didn't help.

The next thing I did was to turn off all my firewalls and internet access
control software and it's still not working.

I'm using integrated authentication and the user is part of the
administrators group,
any ideas how I can try and rectify this?


Reporting Service Integration, Unable to access Reporting Services Site Settings


I am attempting to get reporting services running in integrated mode with sharepoint 2010. I have everything installed and features turned on. In the site collection, when I click on  Site Settings > Reporting Services Site Settings, I am presented with:

Error: The request failed with HTTP status 401: Unauthorized.


I get virtually zero hits when searching for this. Any help is appreciated.


VS2008 unable to load Integration Services package document after creation

Upon creating a new IS project in Visual Studio 2008, I get this error message in a tabbed window:

"Microsoft Visual Studio is unable to load this document: To design Integration Services packages in BI Development Studio, IS has to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation.  To install IS, run SQL Server setup and select Integration Services."

But I do have IS installed.  I have two databases, one from the free Express Advanced edition and one from Developer edition.  SQL 2008 setup (Developer edition) shows IS installed as a shared component.  I installed the Express edition before later installing the Developer edition and had no problems.  What needs to be done here?  Help, and thanks for any help!

I experienced this problem while running and following a video tutorial "Creating a Basic Package," from this MSDN site:


If it helps, I have .NET 3.5 SP1 installed.

Can't log into a SQL Server 2005 Integration Services with SSMS 2008.


We have a server running SQL Server 2005 Ent on a Windows Server 2003 platform. It runs just fine and I have no problem accessing any of the Business Intelligence services using SSMS 2005.

I recently upgraded my development PC to SQL Server 2008 as we'll be deploying it to our production servers in the next few days. I am able to access the Database Engine, SSAS and SSRS on the 2005 server with SSMS 2008, but when I try to log into Integration Services, I get the following error:

TITLE: Connect to Server
Cannot connect to servername.
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Connect to SSIS Service on machine "servername." failed:
Class not registered

Luckily I did not uninstall SSMS 2005, so I can still access it from there, but it would be nice if I could use just one client. I'm also afraid that this might happen after the production server gets upgraded.

Thanks in advance for any help in resolving this.

Thanks Ron...

COM+ Integration: How .NET Enterprise Services Can Help You Build Distributed Applications


The .NET Common Language Runtime (CLR) is Microsoft's next-generation component technology. The CLR is a replacement for COM, but not for COM+. COM+, now called .NET Enterprise Services, is the Microsoft object runtime environment for scalable system development. This article explains how to implement and deploy COM+ configured classes using the CLR, how to access object context and call context, and the rules for managing context-relative object references. Also discussed are ways to manage precious resources such as data connections and pooled objects, and the relationship between COM+ and the new .NET remoting architecture.

Tim Ewald

MSDN Magazine October 2001

Unable to open pdf from document library MOSS 2007


When I click on a pdf document uploaded in a document library it comes up with a blank page. 

I guess it's trying to open pdf on the browser. I turned off "Display PDF in browser " option in Adobe Preferences, but it doesn't help, same issue.

I tried other browsers too, it's the same issue.

I am able to open all other pdf files local to my machine fine.

I am using IE 8 on my machine (Windows 7) and the Sharepoint server is MOSS 2007.



Reporting Services in SharePoint integration - configurtion errors in 64bit version



We have build an MOSS 2007 environment on 64 bit servers. We build the reporting services server and configured in SharePoint integration mode. Initially configuration looks fine with reporting services integration with green indicators.


After creating a web application and accessing the web site from the report servor, i have found the following errors:


Server Error in '/' Application.

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'RSSharePointSoapProxy, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot fi

When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open


When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open.

I am using IE7 and the path of the folder does not contains more than 100 characters.

Also it opening on few on the machines which has IE7.


HTTP 401: Unauthorized when trying to specify reporting services for integration, cannot connect to




I am trying to install reporting services and join it into existing service farm.

Main  MOSS 2007 is on one pc, with config bases etc, while reporting services, reporting services db will be on other pc. 

We are using same domain account to run sharepoint services and reporting services. 

I've installed web part of MOSS on that other computer, also reporting services and sql server, set reporting services in integration mode.

Either way, it wont work for me:


If i am running the service of reporting services as Network Service account, then the /reportserver page will complain about some generic error "probably you dont have access to the farm if you are in integrated mode" etc.... 

I've read that i should include networkservice into a group WSS_WPG which i did, no luck anyway, same error

If i try to type the adress into the integration with reporting services in moss admin page, i will get error like "expected xml received html" and alot of red text.


If i switch service to run from domain account (the one that is used for running sharepoint on the domain) (we did the spn thing, didnt work either), the /reportserver page will open

(moss2k7/ReportServer - /

Installed Visual Studio 2005 on new laptop - can't open C# web services project solution.

Installed Visual Studio 2005 on new laptop - can't open C# web services project solution - get the 'project not supported by this installation' error. Tried re-installing to no avail. Have run various flavors of devenv as recommended in various posts. Still the same message. I can open the solution fine on my old laptop.    Update: We re-installed service pack 1 for VS and the problem was resolved.

SPS 2003 : Unable to open file more than 1Mb

Hi, I work in the creation of a portal in SPS 2003. We found that some documents whose size was greater than 1 Mb can no longer be opened. Word returns a runtime error "1177". When we restart the farm ,problem is resolved but reappeared after several hours .We have tried to restart the database to see if it could solve the problem, the problem is not corrected. Then we restarted the front-end web services SharePoint, this does not work. Then we did an IIS reset,the problem is not corrected. This problem affects all types of documents (pdf, doc, ppt, xls ...). Thanks for your help. Best Regards. Mawi. + DEVELOPER

Issues with SSIS and SQL 2008 - Integration services not running

Hey guys, I installed SQL 2008 with complete BI studio including Integration Services. When i check in my services - i cant see my integraiton services in there When i try to connect to Integration Service using localhost, I cant connect it And when i try to run setup of SQL 2008 - It shows that Integration Services already installed and that what i checked when i fetched my Installation tool report from SQL Server to verify i have it installed. Why can i access Integration services, if i already have it, Please suggest with ideas, checks i can make to ensure every setting is in place. Thanks. Would appreciate for quick response.  

Unable to open physical file - Operating system error 5: 5(error not found) Microsoft SQL Server: Er

I am trying to attach a database to SQL 2005. This database has not previously been attached. I have only just installed SQL.   I get the following message: Unable to open physical file "C:\ArrowSQL\Arr@Data\Arrow_data.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: Error 5120)".   I have loaded SQL and the database fiel and directory with the same user acccount which is a local adminstrator ont hsi machine. I have checked that I have read/write access to the file.   The machine runs Windows Vista Business. SQL has SP 2 loaded.   What causes this?

Unable to install SP3 on SQL 2005 due to Database Services language being blank

Hi all,   I have an issue that requires me to upgrade to a later SP (currently on RTM), but when I try to install SP3 Database Services cannot be ticked. Upon inspection I see that its reporting "This update requires language ENU.  The language for this product instance MSSQLSERVER is . Download the upadte for langage .", when I check teh Language field to the right it is blank, other parts however are fine and can be upgraded. Can you advise please as I don't know how to manually set the language (which is reported inside SQL itself as English (United Kingdom)) and I cannot un/reinstall. Thanks, John

Reporting Services and Sharepoint Integration - Sharepoint Alternate Access Mappings (Zones)

I get the following error when I try to navigate to a report/model/data source, stored in a Sharepoint Document Library using a Sharepoint URL based on an Extranet or Intranet zone - but it works OK using the url for the Default zone: System.Web.Services.Protocols.SoapException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SecurityZoneNotSupportedException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. Is this a limitation of the SQLRS-WSS3 integration or is there a workaround? Many thanks to anyone who can help!

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

Unable to consume ADO.NET Data Services from Silverlight.

Hi Everyone, I am having trouble consuming an ADO.NET Data Service from Silverlight.  I am able to get data back from a browser, but not in Silverlight. I am at a loss to figure this out.  Any help is much appreciated.  Let me know if you need more info. Thank you in advance for any help! Here is the the silverlight code: private Uri svcUri = new Uri("http://localhost:64522LocalTariffsDataService.svc"); private void ctrlViewLocalTariffs_Loaded(object sender, RoutedEventArgs e) { svcContext = new LocalTariffEntities(svcUri); svcContext.LocalTariffs.BeginExecute(OnLocalTariffsQueryCompleted, svcContext.LocalTariffs); } private void OnLocalTariffsQueryCompleted(IAsyncResult result) { Dispatcher.BeginInvoke(() => { DataServiceQuery<LocalTariffsEntityDataService.LocalTariff> query = result.AsyncState as DataServiceQuery<LocalTariffsEntityDataService.LocalTariff>; LocalTariffsEntityDataService.LocalTariff returnedLocalTarrifs = query.EndExecute(result).FirstOrDefault(); // Exception is thrown here. dgLocalTariffs.DataContext = returnedLocalTarrifs; }); } Here is the exception: < E2ETraceEvent xmlns = " http://schemas.microsoft.com/2004/06/E2ETraceEvent " >
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend