Reporting services and existing application

Hello everyone I have a small application in asp.net now I'm trying to use the SQL reporting services. But as soon as I try to connect to the DB on the "connection properties" window I get this error.

Unable to open the physical file "C:\my\Apps\mydb.mdf". Operating system error 32: "32(The file is in use by another process.)".

\

Thanks

Looks like you are using SQLExpress and in your web site, web.config file you are directly attaching a dbf file, so it is getting used by ASP.NET worker process. But again you are trying to access it through reporting services, which is another process. So that is why you are getting this exception.

Try to modify your connection string, instead of AttachDB file name, build a proper connection string to SQL Express

|||

I change my connection string to:

<connectionStrings>
<add name="DBCSCompany" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=true;Database=C:\Inetpub\wwwroot\apps\App_Data\Database.mdf" />
</connectionStrings>

but I still get the same error

|||

Hi,

First, be sure that the physical path of the mdvb file is correct, I suggest that you shoud put your mdf file in app_code directory. so you can use "AttachDBFilename=|DataDirectory|someMdfFile"to locate the mdf file.

Second, when this problem occurred, just to check if other program is using the mdf file. Such as Visual Studio developpment server. If so, turn it off and try again.

Thank.

reporting services 2000 installation problem

Hi all, I recently installed Reporting Services 2000 on my server for the
first time and it caused my existing web apps to stop functioning. I have a
few custom dlls in the GAC and I had to end up re-registering them in the
GAC and restart iis services. That fixed my apps not working. But now, for
some reason Report Manager will not work. Here is what I get:-
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: Required permissions cannot be acquired.
Source Error:
Line 256: <add assembly="System.EnterpriseServices,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 257: <add assembly="System.Web.Mobile,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 258: <add assembly="Appone.Data.Services,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=1949095674c58f09" />
Line 259: <add assembly="Appone.Web.Security,
Version=1.0.0.0, Culture=neutral, PublicKeyToken=7b58630078eb0f75" />
Line 260: <add assembly="Appone.Web.Config, Version=1.0.0.0,
Culture=neutral, PublicKeyToken=01a8235a19f330a7" />
Source File:
c:\windows\microsoft.net\framework\v1.1.4322\Config\machine.config Line:
258
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032
Any ideas? What can I do to fix this?
TIA,
ParamOK just came in this morning and everything was down. Had to re-register
dlls into GAC and restart again and now seems to be back up. Except Report
Manager still does not work.
thanks
"Param R." <pr@.nospam.com> wrote in message
news:uENazG6BFHA.2012@.TK2MSFTNGP15.phx.gbl...
> Hi all, I recently installed Reporting Services 2000 on my server for the
> first time and it caused my existing web apps to stop functioning. I have
> a few custom dlls in the GAC and I had to end up re-registering them in
> the GAC and restart iis services. That fixed my apps not working. But now,
> for some reason Report Manager will not work. Here is what I get:-
> 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: Required permissions cannot be acquired.
> Source Error:
>
> Line 256: <add assembly="System.EnterpriseServices,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
> Line 257: <add assembly="System.Web.Mobile,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
> Line 258: <add assembly="Appone.Data.Services,
> Version=2.0.0.0, Culture=neutral, PublicKeyToken=1949095674c58f09" />
> Line 259: <add assembly="Appone.Web.Security,
> Version=1.0.0.0, Culture=neutral, PublicKeyToken=7b58630078eb0f75" />
> Line 260: <add assembly="Appone.Web.Config,
> Version=1.0.0.0, Culture=neutral, PublicKeyToken=01a8235a19f330a7" />
>
> Source File:
> c:\windows\microsoft.net\framework\v1.1.4322\Config\machine.config
> Line: 258
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
> ASP.NET Version:1.1.4322.2032
> Any ideas? What can I do to fix this?
> TIA,
> Param
>sql