Sql server 2005 and IIS 7



Hi,

I am using ultimate vista on my laptop and have sql server 2005 dev edition
and IIS 7.0. installed. I have build very simple cube with four dimensions.
Now when I want to browse my cube with browser in Sql Server Bussiness
Inteligence Development Studio I am getting error from IIS. "The remote
server returned an error (405) method is not allowed. Below are details. Any
solutions? I suppose I should make some configuration on IIS?
--
Predrag Korać

Details>>>
===================================

The connection either timed out or was lost. (Microsoft Visual Studio)

------------------------------
Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest()
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean
endReceivalIfException, Boolean readSession, Boolean
readNamespaceCompatibility)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Discover(String
requestType, String requestNamespace, ListDictionary properties, IDictionary
restrictions, Boolean sendNamespacesCompatibility)
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String
requestType, IDictionary restrictions, InlineErrorHandlingType
inlineErrorHandling, Boolean sendNamespaceCompatibility)
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ReadDataSourceInfo()
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean
createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.AnalysisServices.Browse.ConnectionsManagerBase.Connect()
at
Microsoft.AnalysisServices.Browse.CubeBrowser.ConnectionsManager.Connect()
at Microsoft.AnalysisServices.Browse.CubeBrowser..ctor(String nameOfCube,
Object cube, IServiceProvider iserviceProvider, DesignerPageRelevantData
designerPageRelevantData, UserContextData securityContextData)
at Microsoft.AnalysisServices.Browse.CubeBrowserHostControl.CreateBrowser()
at Microsoft.AnalysisServices.Browse.BrowserHostControl.LoadBrowser()

===================================

The remote server returned an error: (405) Method Not Allowed. (System)

------------------------------
Program Location:

at System.Net.HttpWebRequest.GetResponse()
at Microsoft.AnalysisServices.AdomdClient.HttpStream.GetResponseStream()
at Microsoft.AnalysisServices.AdomdClient.HttpStream.GetResponseDataType()


.



Relevant Pages

  • Re: New to Merge/Replication
    ... ADO.NET 3.0 includes "Synchronization Services" that does not require IIS. ... Hitchhiker's Guide to Visual Studio and SQL Server ... It was my deepest hope that Merge/Replication between SQL Compact Edition and SQL Server 2005 Enterprise Edition would have it's own sync services NOT dependent on IIS. ... You can use merge replication with SQL Server on your main desktop serving as the publisher with SQL Compact on PPC, TabletPC, or other desktops as subscribers, so that would probably be the easiest solution for you. ...
    (microsoft.public.sqlserver.ce)
  • Re: Help on synch to SQL server
    ... from SQL CE to SQL Server from your smart-device application's code. ... This can occur whenever the device has a network path to IIS, ... Unlike merge replication between SQL Servers where you can use RMO ... Ideally I would like to use Sql CE to synch with a SQL ...
    (microsoft.public.sqlserver.ce)
  • Re: SMS_MP_CONTROL_MANAGER error 4960
    ... When I try to restart the IIS it says nothing.... ... Manually restart the SMS Agent Host service on the MP. ... MP encountered an error when connecting to SQL Server. ... The Default Web Site is disabled in IIS. ...
    (microsoft.public.sms.setup)
  • Inconsistent negative numerical values in SQL2K database table
    ... not contain a '-' (minus sign). ... This "condition" came to light when a cube built on the fact table (where ... SQL Server table or in the cube interpretation of the table values that is ... Sample data from SQL Server 2000 SP3 Query Analyzer ...
    (microsoft.public.sqlserver.server)
  • Re: Inconsistent negative numerical values in SQL2K database table
    ... >and that value shows with a minus sign. ... The cube sees all values as ... >copied from another SQL Server 2000 server. ... >The cube reports: 66.63 ...
    (microsoft.public.sqlserver.server)