Welcome to Sign in | Help
in Search

Report Server SqlServer2005-eroare conectare

Last post 02-15-2010, 3:46 PM by ggciubuc. 1 replies.
Sort Posts: Previous Next
  •  02-10-2010, 1:56 PM 8045

    Report Server SqlServer2005-eroare conectare

    Buna ziua,

    Am o masina W2k3 cu SqlServer2005 Standard Edition ce are instalat si Report Server. Versiunea este 9.00.4273(SP3&CU7). Folosesc o singura instanta(default instance), iar autentificarea este doar tip windows. Toate serviciile Sql ruleaza sub 'Local system'. In urma reinstalarii unor aplicatii ce foloseau report server, acesta nu mai poate fi accesat nici din aplicatiile respective si nici cu tools-urile Sql Server. Serviciul 'Sql Server Reporting Services' este startat, bazele de date 'ReportServer' si 'ReportServerTempDB' au fost verificate(DBCC CheckDB)  nu s-au semnalat erori. CU7 a fost instalat odata cu reinstalarea aplicatiilor

    1.Astfel, in SqlServer Management Studio-Connect-Reporting Services unde specific: Server,Windows authentication, primesc eroarea:
    "Cannot connect to SERVERNAME.
    Additional information:
    The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.(Microsoft.SqlServer.Management.UI.RSClient)
    The request ed with HTTP status 404:Not Found.
    (Microsoft.SqlServer.Management.UI.RSClient)"

    2. In SqlServer Surface Area Configuration-Surface Area Configuration for Features-Reporting Services- incerc sa accesez(dau click) componenta Windows Integrated Security si apare eroarea:
    "The request failed with HTTP status 404: Not Found. (SQLSAC)"
    Checkbox-ul cu 'Enable Windows integrated security for report data source connection' este nebifat si zona este dezactivata (nu poate fi accesata)

    Poate fi drept cauza CU7 ori problema este de fapt din configurarile IIS(si care ar fi acestea)?


  •  02-15-2010, 3:46 PM 8052 in reply to 8045

    Re: Report Server SqlServer2005-eroare conectare

    Cautati in fisierul RSWebApplication.config elementul <ReportServerVirtualDirectory> , nu trebuie sa fie nimic acolo; de asemenea completati <ReportServerUrl> potrivit.

    Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems