Format Alignment: sample

Showing posts with label sample. Show all posts

Sunday, February 26, 2012

File Share Data Processing Extension Sample

Hi all, I am very new to this Reporting Services and I want to follow this
sample that comes with SQL Server 2005 Beta. However, I tried everything
according to the documentation (build the sample, deploy it by modifying the
config files, etc.). Unfortunately, when I create a new report (using the
Report Wizard) in Visual Studio 2005, I still cannot see the File Share
Information.
Searching this newsgroup pointed me to this
http://blogs.msdn.com/bryanke/archive/2004/05/14/132110.aspx#148541
However, this does not help me either.
Any help is greatly appreciated!
Thanks a lot!
JennyHi Jenny,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to deploy
FsiDataExtension and then use it in the Report Manager. If I have
misunderstood your concern, please feel free to point it out.
Based on my knowledge, here is a sample in Reporting Services 2000 but I am
not sure whether it is available in SQL Server 2005 Reporting Services.
For SQL Server 2005's issue, please post the question in the link below
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
cid=us
For SQL Server 2000 Reporting Services, you could follow the steps below as
described in MSDN Online
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/ht
m/rss_sampleapps_v1_16g2.asp
- Copy Microsoft.Samples.ReportingServices.FsiDataExtension.dll to the
report server. The default location for report server extensions is
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin.
- Copy the assembly to Report Designer. The default location for
extensions for Report Designer is C:\Program Files\Microsoft SQL
Server\80\Tools\ReportDesigner.
- Add the following entry to both the RSReportServer.config and
RSReportDesigner.config files under the Data element.
<Extension Name="FSI"
Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
rosoft.Samples.ReportingServices.FsiDataExtension"/>
- To enable the generic query designer for the sample data processing
extension, add the following entry to the RSReportDesigner.config file
under the Designer element.
<Extension Name="FSI"
Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
ngServices.Designer"/>
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael
Thanks for the reply. Please see my questions inline. Thanks in advance!!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi Jenny,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood you would like to deploy
> FsiDataExtension and then use it in the Report Manager. If I have
> misunderstood your concern, please feel free to point it out.
Yes you're right.
> Based on my knowledge, here is a sample in Reporting Services 2000 but I am
> not sure whether it is available in SQL Server 2005 Reporting Services.
> For SQL Server 2005's issue, please post the question in the link below
> http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
> cid=us
It's available and the steps look the same to me! Anyway, I have posted my
question in that beta newsgroup as well. Thanks!
> For SQL Server 2000 Reporting Services, you could follow the steps below as
> described in MSDN Online
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/ht
> m/rss_sampleapps_v1_16g2.asp
> - Copy Microsoft.Samples.ReportingServices.FsiDataExtension.dll to the
> report server. The default location for report server extensions is
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\bin.
> - Copy the assembly to Report Designer. The default location for
> extensions for Report Designer is C:\Program Files\Microsoft SQL
> Server\80\Tools\ReportDesigner.
I interpreted 'Copy the assembly' as 'copy the dll' as in the previous step.
Is this correct?
> - Add the following entry to both the RSReportServer.config and
> RSReportDesigner.config files under the Data element.
> <Extension Name="FSI"
> Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
> rosoft.Samples.ReportingServices.FsiDataExtension"/>
> - To enable the generic query designer for the sample data processing
> extension, add the following entry to the RSReportDesigner.config file
> under the Designer element.
> <Extension Name="FSI"
> Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
> ngServices.Designer"/>
>
I did all the above plus the steps in 'To configure code access security for
the sample'. I didn't know where exactly to put the CodeGroup info in the
config files unfortunately. I have tried a few spots and none succeeds. :-(
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>|||Hi
For you questions
>>I interpreted 'Copy the assembly' as 'copy the dll' as in
>>the previous step. Is this correct?
Yes, I copied Microsoft.ReportingServices.Interfaces.dll from C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting
Services\Samples\Extensions\FsiDataExtension\cs\bin\Debug to the
destination.
>> I did all the above plus the steps in 'To configure code access security
for
>> the sample'. I didn't know where exactly to put the CodeGroup info in
the
>> config files unfortunately. I have tried a few spots and none succeeds.
:-(
snippet from my RSReportServer.config in C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer for your reference.
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
oft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
osoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
er,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
soft.ReportingServices.DataExtensions"/>
<Extension Name="FSI"
Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
rosoft.Samples.ReportingServices.FsiDataExtension"/>
</Data>
snippet from my RSReportDesigner.config file in C:\Program Files\Microsoft
SQL Server\80\Tools\Report Designer for your reference.
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
oft.ReportingServices.DataExtensions" />
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
osoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
er,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
soft.ReportingServices.DataExtensions"/>
<Extension Name="FSI"
Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
rosoft.Samples.ReportingServices.FsiDataExtension"/>
</Data>
<Designer>
<Extension Name="SQL"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="ODBC"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="FSI"
Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
ngServices.Designer"/>
</Designer>
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi there
Thank you for your help, but what I wanted was where to put the following
code group info in both the rssrvpolicy.config and rspreviewpolicy.config.
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="FSICodeGroup"
Description="Code group for my FSI data processing extension">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\bin\Microsoft.Samples.ReportingServices.FsiDataExtension.dll"
/>
</CodeGroup>
Thanks again and I appreciate your help!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi
> For you questions
> >>I interpreted 'Copy the assembly' as 'copy the dll' as in
> >>the previous step. Is this correct?
> Yes, I copied Microsoft.ReportingServices.Interfaces.dll from C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting
> Services\Samples\Extensions\FsiDataExtension\cs\bin\Debug to the
> destination.
> >> I did all the above plus the steps in 'To configure code access security
> for
> >> the sample'. I didn't know where exactly to put the CodeGroup info in
> the
> >> config files unfortunately. I have tried a few spots and none succeeds.
> :-(
> snippet from my RSReportServer.config in C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer for your reference.
> <Data>
> <Extension Name="SQL"
> Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
> oft.ReportingServices.DataExtensions"/>
> <Extension Name="OLEDB"
> Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
> osoft.ReportingServices.DataExtensions"/>
> <Extension Name="ORACLE"
> Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
> er,Microsoft.ReportingServices.DataExtensions"/>
> <Extension Name="ODBC"
> Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
> soft.ReportingServices.DataExtensions"/>
> <Extension Name="FSI"
> Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
> rosoft.Samples.ReportingServices.FsiDataExtension"/>
> </Data>
> snippet from my RSReportDesigner.config file in C:\Program Files\Microsoft
> SQL Server\80\Tools\Report Designer for your reference.
> <Data>
> <Extension Name="SQL"
> Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
> oft.ReportingServices.DataExtensions" />
> <Extension Name="OLEDB"
> Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
> osoft.ReportingServices.DataExtensions"/>
> <Extension Name="ORACLE"
> Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
> er,Microsoft.ReportingServices.DataExtensions"/>
> <Extension Name="ODBC"
> Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
> soft.ReportingServices.DataExtensions"/>
> <Extension Name="FSI"
> Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
> rosoft.Samples.ReportingServices.FsiDataExtension"/>
> </Data>
> <Designer>
> <Extension Name="SQL"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="OLEDB"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="ORACLE"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="ODBC"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="FSI"
> Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
> ngServices.Designer"/>
> </Designer>
> If you have any questions or concerns, don't hesitate to let me know. We
> are always here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Oh I see! Thanks for your help. I finally see the File Share Extension in
the list, but when I want to do more with that, I got this error:
"The designer extension FSI could not be loaded. Check the configuration
file RSReportDesigner.config." [OK]
Am I still missing something?
Thanks a lot!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi Jenny,
> I have attached rssrvpolicy.config and rspreviewpolicy.config for your
> reference.
> Put the <CodeGroup > like other <CodeGroup> does will be OK. Something like
> this
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="Dundas_Strong_Name"
> Description="This code group grants
> Dundas assemblies. ">
> <IMembershipCondition
> class="StrongNameMembershipCondition"
> version="1"
> PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000
> 10043D98F8A9067EF3BCD442ADE2DD48CC6A6FACBCEB1C42DE2847B0A464096C02EEBF6FD87E
> 3889BEED32B9ABD1525A11A282232CD4C46CC8123F8CC08A113CD435429646220969FF444734
> 8D1C21874670834C7A7E89EA8956FC00E0F84FD3DF6FB3EBF21774438AF9E760414FDE06BC2C
> 3AF35FF3DD87578630ED13FE12CBDBC"
> />
> </CodeGroup>
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="FSICodeGroup"
> Description="Code group for my FSI data processing extension">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="C:\Program Files\Microsoft SQL
> Server\80\Tools\ReportDesigner\bin\Microsoft.Samples.ReportingServices.FsiDa
> taExtension.dll"
> />
> </CodeGroup>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights|||Actually, I have figured it out. I got the Assembly name wrong. Once I
fixed it, I could see it in the list and load it as well. The report preview
looks good too. :-)
Unfortunately, I couldn't deploy the report. The Report Server cannot be
started for unknown reasons. When I browse http://localhost/ReportServer,
the error is
"The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError) "
What did I do wrong? I have tried re-setting these config files but it
still doesn't work. :-(
rssrvpolicy.config
rsreportserver.config
Please help!! Thanks!!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi Jenny,
> I have attached rssrvpolicy.config and rspreviewpolicy.config for your
> reference.
> Put the <CodeGroup > like other <CodeGroup> does will be OK. Something like
> this
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="Dundas_Strong_Name"
> Description="This code group grants
> Dundas assemblies. ">
> <IMembershipCondition
> class="StrongNameMembershipCondition"
> version="1"
> PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000
> 10043D98F8A9067EF3BCD442ADE2DD48CC6A6FACBCEB1C42DE2847B0A464096C02EEBF6FD87E
> 3889BEED32B9ABD1525A11A282232CD4C46CC8123F8CC08A113CD435429646220969FF444734
> 8D1C21874670834C7A7E89EA8956FC00E0F84FD3DF6FB3EBF21774438AF9E760414FDE06BC2C
> 3AF35FF3DD87578630ED13FE12CBDBC"
> />
> </CodeGroup>
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="FSICodeGroup"
> Description="Code group for my FSI data processing extension">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="C:\Program Files\Microsoft SQL
> Server\80\Tools\ReportDesigner\bin\Microsoft.Samples.ReportingServices.FsiDa
> taExtension.dll"
> />
> </CodeGroup>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights|||Hi Jenny,
The error message seems to indicate that you do not set congifuration file
rssrvpolicy.config and rsreportserver.config correctly. Please double check
configuration files again and my attachment file is just a sample file for
your reference. You cannot use them directly.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Sunday, February 19, 2012

File in use error on connecting to database.

* Running SQL 2005 on XP Pro *

After running a ETL package to populate a sample DW which completed successfully, I attempted to open the SQL Server Management Studio. After login, an error was reported :

TITLE: Microsoft SQL Server Management Studio

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

ADDITIONAL INFORMATION:

Database 'msdb' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=945&LinkId=20476

In the server error log I see... (note, the problem persists after reboot)

2006-01-13 11:24:07.25 spid12s The Service Broker protocol transport is disabled or not configured.
2006-01-13 11:24:07.25 spid12s The Database Mirroring protocol transport is disabled or not configured.
2006-01-13 11:24:07.77 Logon Error: 17187, Severity: 16, State: 1.
2006-01-13 11:24:07.77 Logon SQL Server is not ready to accept new client connections; the connection has been closed. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: <local machine>]
2006-01-13 11:24:07.82 Logon Error: 17187, Severity: 16, State: 1.
2006-01-13 11:24:07.82 Logon SQL Server is not ready to accept new client connections; the connection has been closed. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: <local machine>]
2006-01-13 11:24:08.24 spid12s Service Broker manager has started.
2006-01-13 11:24:14.97 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2006-01-13 11:24:14.97 Server Dedicated admin connection support was established for listening locally on port 1434.
2006-01-13 11:24:14.97 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2006-01-13 11:24:17.28 Logon Error: 18456, Severity: 14, State: 16.
2006-01-13 11:24:17.28 Logon Login failed for user 'FUSION-NET\scottt'. [CLIENT: <local machine>]
2006-01-13 11:24:18.91 spid15s Starting up database 'ReportServer'.
2006-01-13 11:24:18.91 spid14s Starting up database 'msdb'.
2006-01-13 11:24:18.91 spid17s Starting up database 'Subscriptions'.
2006-01-13 11:24:18.91 spid16s Starting up database 'ReportServerTempDB'.
2006-01-13 11:24:19.23 spid14s Error: 17207, Severity: 16, State: 1.
2006-01-13 11:24:19.23 spid14s FCB::Open: Operating system error 32(The process cannot access the file because it is being used by another process.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf'. Diagnose and correct the operating system error, and retry the operation.
2006-01-13 11:24:19.23 spid14s Error: 17204, Severity: 16, State: 1.
2006-01-13 11:24:19.23 spid14s FCB::Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf for file number 1. OS error: 32(The process cannot access the file because it is being used by another process.).
2006-01-13 11:24:19.25 spid14s Error: 5120, Severity: 16, State: 101.
2006-01-13 11:24:19.25 spid14s Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
2006-01-13 11:24:19.37 spid16s Error: 17207, Severity: 16, State: 1.
2006-01-13 11:24:19.37 spid16s FCB::Open: Operating system error 32(The process cannot access the file because it is being used by another process.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ReportServerTempDB.mdf'. Diagnose and correct the operating system error, and retry the operation.
2006-01-13 11:24:19.37 spid17s Error: 17207, Severity: 16, State: 1.
2006-01-13 11:24:19.37 spid17s FCB::Open: Operating system error 32(The process cannot access the file because it is being used by another process.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Subscriptions.mdf'. Diagnose and correct the operating system error, and retry the operation.
2006-01-13 11:24:19.37 spid17s Error: 17204, Severity: 16, State: 1.
2006-01-13 11:24:19.37 spid17s FCB::Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Subscriptions.mdf for file number 1. OS error: 32(The process cannot access the file because it is being used by another process.).
2006-01-13 11:24:19.37 spid17s Error: 5120, Severity: 16, State: 101.
2006-01-13 11:24:19.37 spid17s Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Subscriptions.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
2006-01-13 11:24:19.38 spid16s Error: 17204, Severity: 16, State: 1.
2006-01-13 11:24:19.38 spid16s FCB::Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ReportServerTempDB.mdf for file number 1. OS error: 32(The process cannot access the file because it is being used by another process.).
2006-01-13 11:24:19.38 spid16s Error: 5120, Severity: 16, State: 101.
2006-01-13 11:24:19.38 spid16s Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ReportServerTempDB.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
2006-01-13 11:24:19.91 spid14s Starting up database 'AdventureWorksDW'.
2006-01-13 11:24:19.91 spid17s Starting up database 'AdventureWorks'.
2006-01-13 11:24:19.91 spid16s Starting up database 'DnBSampleDW'.
2006-01-13 11:24:28.07 spid5s Error: 8355, Severity: 16, State: 1.
2006-01-13 11:24:28.07 spid5s Service Broker is disabled in MSDB or MSDB failed to start. Server level event notifications can not be delivered. Event notifications with FAN_IN in other databases could be affected as well.
2006-01-13 11:24:28.11 spid5s Recovery is complete. This is an informational message only. No user action is required.
2006-01-13 11:24:34.23 Logon Error: 18456, Severity: 14, State: 16.
2006-01-13 11:24:34.23 Logon Login failed for user 'FUSION-NET\scottt'. [CLIENT: <local machine>]
2006-01-13 11:24:34.90 Logon Error: 18456, Severity: 14, State: 16.
2006-01-13 11:24:34.90 Logon Login failed for user 'FUSION-NET\scottt'. [CLIENT: <local machine>]
2006-01-13 11:26:50.52 spid53 Using 'xpstar90.dll' version '2005.90.1399' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.

Just a note here... I let the computer sit after a reboot while at lunch, I opened the Studio and tried the connection and it came up just fine...

|||I am getting a similar problem with my instance running on Windows 2003 Server. I have a database that is used by a .Net application. When somebody is using the .Net application I am unable to open the database in Management Studio. The same goes the other way, when I have the database open in Management Studio the application is unable to access the database. Why can I not have the database open and still have the application access the database?|||Turn your anti-virus scanner off or at least exclude the directory containing your SQL Server files from the scanning.|||

I have a similar problem here but it occurs only when I attempt to use my other application's web service which needs to be connected to my db. The db's file is there.

System.Web.Services.Protocols.SoapException: Server was unable to process request. > System.Data.SqlClient.SqlException: Unable to open the physical file "c:\inetpub\wwwroot\WebSite1\App_Data\ASPNETDB.MDF". Operating system error 32: "32(error not found)".
An attempt to attach an auto-named database for file c:\inetpub\wwwroot\WebSite1\App_Data\ASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at ViewPropertyTableAdapters.AgentInfoTableAdapter.GetAgentInfo(String AgentUserName) in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\website1\353383d4\c7efb847\App_Code.ekppx9ry.1.vb:line 3229
at getDetails.getAgentInfo(String userName) in c:\inetpub\wwwroot\WebSite1\App_Code\getDetails.vb:line 11
at getAgentContact.getContact(String userName) in c:\inetpub\wwwroot\WebSite1\App_Code\getAgentContact.vb:line 17

File in use error on connecting to database.

* Running SQL 2005 on XP Pro *

After running a ETL package to populate a sample DW which completed successfully, I attempted to open the SQL Server Management Studio. After login, an error was reported :

Just a note here... I let the computer sit after a reboot while at lunch, I opened the Studio and tried the connection and it came up just fine...

I have a similar problem here but it occurs only when I attempt to use my other application's web service which needs to be connected to my db. The db's file is there.

File in use error on connecting to database.

* Running SQL 2005 on XP Pro *

After running a ETL package to populate a sample DW which completed successfully, I attempted to open the SQL Server Management Studio. After login, an error was reported :

Just a note here... I let the computer sit after a reboot while at lunch, I opened the Studio and tried the connection and it came up just fine...

I have a similar problem here but it occurs only when I attempt to use my other application's web service which needs to be connected to my db. The db's file is there.

Sunday, February 26, 2012

File Share Data Processing Extension Sample

Sunday, February 19, 2012

File in use error on connecting to database.

File in use error on connecting to database.

File in use error on connecting to database.

Format Alignment

Blog Archive

About Me