Showing posts with label deploy. Show all posts
Showing posts with label deploy. Show all posts

Wednesday, March 28, 2012

problem in deploying the website developed in visual web developer 2005

Hi,

I am new to asp.net.I am trying to deploy the website on IIS created in visual web developer 2005 express.I am having problem with the aspnetdb.mdf for login.
I have copied my entire contents to the physical directory( shared floder),from where the iis virtual directory can access the contents.I can see my login form but when i enter my username and password and click login it gives my error
"error occured in establishing the connection".

I am using the sql server 2005.I don't know what should i do with aspnetdb.mdf?

thanks and urgent help needed

The following article mentions similar issue, you can take a look to see if it solves your problem.

http://forums.asp.net/1257344/ShowPost.aspx

Wednesday, March 21, 2012

Problem getting some users to be able to run reports (probably security of some sort)

I am able to deploy and run reports from my screen at work, but some non-developers cannot run them. They can see the reports, but get the following error message when they click on the report:

  • An error has occurred during report processing. (rsProcessingAborted)

  • Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)

  • For more information about this error navigate to the report server on the local server machine, or enable remote errors

  • --

  • --

  • - I assume the preceding error has something to do with credentials. I am using Windows security authentication for this. One user has worked through this and is now getting cannot run report query (one of the report queries in the report). Help would be appreciated.

  • Can you make sure that the users who are having issues can actually connect to the SQL Server & database?

    Have you tried running Profiler to see what credentials are actually passed to the SQL Server when the user runs the report?

    Jarret

    |||What was found was a security issue. I got some DBA help in setting up permissions to login to the database and to grant run permissions on the queries. First access was granted to the database itself, the we had to go into security on the database and setup the user and grant permissions. This resolved the problem.
  • Monday, March 12, 2012

    problem deploying SSIS to another server.

    Hello, I am trying to deploy a SSIS package (using deployment utility create at build time) to a different server and ran into problem wonder if someone and direct me to the right path.

    development environment: WIN XP, SQL 2005. package is built using server buisiness intelligence. Package content: connect to a "target"SQL2005server using OLE DB using SQL Login authentication to process data. The SQL 2005 DB is on a Win 2003 server (R2) as OS platform.

    The package was built, install ( SQL not file system)and ran fine on the development environement; when attempt to deploy the package to the SQL 2005 server where data reside and should be processed (also install to SQL), I receive error " 0x80004005 ...description TCP Provider: No connection could be made because the target machine activily refuse it". which is an odd error since the package is on the server that it try to connect to the data base on it.

    If anyone can give me some hint at what cause this problem, appreciate the help.

    Not sure, but have you checked that the SQL Server Integration Services service is running on the target machine?|||Yes, that the first thing I check, via surface area configuration and administration tools -> Services both confirmed that the Ingergrated services is started and running.

    Friday, March 9, 2012

    Problem deploying reports from VS.NET with SSL

    Hi.
    I'm using Reporting services for my company's web site and it worked fine
    until I tried to activate SSL : now when I try to deploy new reports from
    VS.NET I'm asked to login to https://www.mysite.com/reportserver and no
    credentials are accepted.
    Debugging from VS.NET I can see a call without SSL (http instead of https),
    although I changed http in https everywhere.
    Can somebody give me some help ?
    ThanksNot sure if this solves your problem, but have you tried running rsconfig?
    It would be something like:
    rsconfig -c -s https://www.mysite.com -d ReportServer -a Windows -u
    domain\username -p password
    Pieter van Maasdam
    Macaw B.V.
    "Moreno" <movendra@.yahoo.com> wrote in message
    news:eMXvt6ThEHA.536@.TK2MSFTNGP11.phx.gbl...
    > Hi.
    > I'm using Reporting services for my company's web site and it worked fine
    > until I tried to activate SSL : now when I try to deploy new reports from
    > VS.NET I'm asked to login to https://www.mysite.com/reportserver and no
    > credentials are accepted.
    > Debugging from VS.NET I can see a call without SSL (http instead of
    https),
    > although I changed http in https everywhere.
    > Can somebody give me some help ?
    > Thanks
    >

    Problem deploying a custom renderer on MSRS 2005.

    Hi,

    I have been struggling to deploy a custom rendering extension onto
    Reporting services 2005. I have followed all the steps given in the
    MSDN article
    http://msdn.microsoft.com/msdnmag/issues/05/02/customrenderers/defaul...

    Especially -

    1. Copied the dll generated to the reporting service bin folder.

    2. Made the entry in C:\Program Files\Microsoft SQL Server\MSSQL.
    3\Reporting Services\ReportServer\rsreportserver.config file as
    <Extension Name="CUSTOM_RENDERER"
    Type="MSDNMagazine.CustomRSRenderer.Renderer,MSDNMagazine.CustomRSRenderer"-/


    3. Made an entry in C:\Program Files\Microsoft SQL Server\MSSQL.
    3\Reporting Services\ReportServer\rssrvpolicy.config file as

    <CodeGroup class="UnionCodeGroup" version="1"
    PermissionSetName="FullTrust" Name="Custom Render Extension"
    Description="This code group grants data extensions full trust.">
    <IMembershipCondition class="UrlMembershipCondition" version="1"
    Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services
    \ReportServer\bin\MSDNMagazine.CustomRSRenderer.dll"/>
    </CodeGroup>

    I am able to see the extension being listed in the Report manager list
    of available rendering options,
    But I get the following error from the report server when I try
    exporting to the custom rendering extension


    An attempt has been made to use a rendering extension that is not
    registered for this report server.
    Description: An unhandled exception occurred during the execution of
    the current web request. Please review the stack trace for more
    information about the error and where it originated in the code.

    Exception Details: System.Exception: An attempt has been made to use a
    rendering extension that is not registered for this report server.

    Source Error:

    An unhandled exception was generated during the execution of the
    current web request. Information regarding the origin and location of
    the exception can be identified using the exception stack trace
    below.

    Stack Trace:

    [Exception: An attempt has been made to use a rendering extension that
    is not registered for this report server.]
    Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean
    isAbortable, String url, Stream outputStream, String& mimeType,
    String& fileNameExtension) +489
    Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean
    isAbortable, String format, String deviceInfo, NameValueCollection
    urlAccessParameters, Stream reportStream, String& mimeType, String&
    fileNameExtension) +958

    Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String
    format, String deviceInfo, NameValueCollection additionalParams,
    String& mimeType, String& fileExtension) +84

    Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueColl-ection
    urlQuery, HttpResponse response) +143
    Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
    context) +75

    System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionSt-ep.Execute()
    +154
    System.Web.HttpApplication.ExecuteStep(IExecutionStep step,
    Boolean& completedSynchronously) +64

    Looking at the logs of the report server at Max trace level, gives me
    the following dump


    w3wp!processing!b!03/01/2007-22:35:22:: e ERROR: Throwing
    Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
    An attempt has been made to use a rendering extension that is not
    registered for this report server., ;
    Info:
    Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
    An attempt has been made to use a rendering extension that is not
    registered for this report server.
    w3wp!chunks!b!03/01/2007-22:35:22:: v VERBOSE: ###
    ID=3f94a6f1-8ff7-448c-8cf3-494ab8fe4837, Length=0, CompressedLength=0,
    TimeCompressing=0, TimeUncompressing=0, Ratio=0, Buffering=0,
    Permanent=False
    w3wp!library!b!03/01/2007-22:35:22:: v VERBOSE: Transaction rollback.
    w3wp!webserver!b!03/01/2007-22:35:22:: e ERROR: Reporting Services
    error Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
    An attempt has been made to use a rendering extension that is not
    registered for this report server. >
    Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
    An attempt has been made to use a rendering extension that is not
    registered for this report server.
    at
    Microsoft.ReportingServices.ReportProcessing.ReportRendererFactory.GetRende-rer(String
    format, IReportServerInformation serverInfo)
    at
    Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateRendere-r(String
    format)
    at
    Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapsho-t(CreateReportChunk
    createChunkCallback, RenderingContext rc, GetResource
    getResourceCallback)
    at
    Microsoft.ReportingServices.Library.RenderSnapshotAction.Render()
    at
    Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(Cata-logItemContext
    reportContext, ClientRequest session, RenderingResult& result)
    at
    Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItem-Context
    reportContext, ClientRequest session, Warning[]& warnings,
    ParameterInfoCollection& effectiveParameters)
    at
    Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
    reportContext, ClientRequest session, Warning[]& warnings,
    ParameterInfoCollection& effecectiveParameters, String[]&
    secondaryStreamNames)
    at
    Microsoft.ReportingServices.Library.RenderNextCancelableStep.Execute()
    at
    Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper(-)
    End of inner exception stack trace
    at
    Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper(-)
    at
    Microsoft.ReportingServices.Library.RenderNextCancelableStep.RenderNext(RSS-ervice
    rs, CatalogItemContext reportContext, ClientRequest session, JobType
    type, Warning[]& warnings, ParameterInfoCollection&
    effectiveParameters, String[]& secondaryStreamNames)
    at
    Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport-(HttpResponseStreamFactory
    streamFactory)
    at
    Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOp-eration(StreamedOperation
    operation)
    at
    Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(I-temType
    itemType)
    at
    Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCo-ntent()
    at
    Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
    w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Starting database
    cleanup.
    w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Call to CleanBatch()
    w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Cleaning expired
    sessions from DB
    w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction begin.
    w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction commit.
    w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Cleaning expired cache
    from DB
    w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction begin.
    w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction commit.
    w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Cleaning orphaned
    snapshots from DB
    w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction begin.
    w3wp!library!9!3/1/2007-22:35:41:: v VERBOSE: Transaction commit.
    w3wp!library!9!3/1/2007-22:35:41:: i INFO: Cleaned 0 batch records, 0
    policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
    running jobs, 0 persisted streams
    w3wp!dbcleanup!9!3/1/2007-22:35:41:: v VERBOSE: Database cleanup
    executed.

    Any inputs will be of great help to me. Thanks

    Does deploying a custom rendering extension require Reboot of the

    machine. I restarted MSSQL Report Server service on the server and this

    _did not_ solve the problem.

    What is the difference between deploying a custom Data Extension and a

    custom Rendering Extension. The former is being deployed properly while

    the later isn't.

    Atleast, Please point me to some documentation on frequently

    encountered problems with custom rendering extensions. I tried

    searching on the net but there seems to be lack of any helping

    information.
    Thanks in advance.

    Monday, February 20, 2012

    Problem connection to FoxPro database via ole db

    Hi,
    I'm accessing a FoxPro database via ole db and ths works fine on my local
    report server. However, when I deploy the report to the live report server
    I'm getting the error 'Invalid path or file name'
    The FoxPro database is on a separate server and the connection string is :
    string connectionString = @."provider=vfpoledb;" +
    @."data source='\\server\data\foxpro.dbc';" +
    "password='';user id=''";
    I've read a few articles explaining that it's a permissions problem. I've
    tried granting full permissions to the data folder for myself and 'Network
    Service' but this still occurs. The web.config file for the report server has
    impersonate set to true and IIS is configured for 'Integrated Windows
    authentication' and does not use anonymous access.
    Any ideas would be much appreciated.
    Regards
    MikeHi Mike,
    Does the report server's account have permissions to the directory?
    --
    Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
    cindy_winegarden@.msn.com www.cindywinegarden.com
    "MikeD" <MikeD@.discussions.microsoft.com> wrote in message
    news:9A295512-41F7-48A0-B406-08AE86F55CA8@.microsoft.com...
    > Hi,
    > I'm accessing a FoxPro database via ole db and ths works fine on my local
    > report server. However, when I deploy the report to the live report server
    > I'm getting the error 'Invalid path or file name'
    > The FoxPro database is on a separate server and the connection string is :
    > string connectionString = @."provider=vfpoledb;" +
    > @."data source='\\server\data\foxpro.dbc';" +
    > "password='';user id=''";
    > I've read a few articles explaining that it's a permissions problem. I've
    > tried granting full permissions to the data folder for myself and 'Network
    > Service' but this still occurs. The web.config file for the report server
    > has
    > impersonate set to true and IIS is configured for 'Integrated Windows
    > authentication' and does not use anonymous access.
    > Any ideas would be much appreciated.
    > Regards
    > Mike