User Friendly Error Reporting

Is There A Way To Show A User-friendly Error When User Did Not Select A Required Parameter ?
Hi all,

 

I was wondering whether there is a way to show the user an error when the user did not select a specific parameter.

 

In my case, I have two optional parameters. The user has to select either one to view the report. If the user does not select either one, I would like to show some sort of an error page indicating so. However, all i am getting is a complete blank with no report in sight. I as a developer know this is an error as a result of missing parameters, but i was wondering whether I could produce a page or direct it to a page so that the user doesn't go all horrified at an empty page ?

 

Thanks

Bernard

View Replies !   View Related

---

Raising User Friendly Message In Case Of DB Error
Hi,I am using sql server 2005 and  i am having table with a column which has unique key constraint.So if the user tries to enter the duplicate value for that particular column and try to save it ,it errors out in runtime..how do i raise the user friendly error message in this DB error, when user tries to save it.Thanks

View Replies !   View Related

---

Change Field Name To User Friendly Data
I have a data model based upon (views and tables) in a database.  The field names of the views and tables are not user friendly and carry no meaning for the end user (AS400). 
I need to change those attributes to show user friendly information.   I would like to know if there is a way to change the (name) for each of the fields other than manual entry.  I am trying to have the model (and there fore the entity) show user friendly names for each field in the model.  The names and descriptions can typed in and this method will change the name and you can even add a description.   Can the name field be bound to a field in the view or table that shows a friendly name?  How can this process be scripted or automated so that each of the fields shows a user friendly description that is available. 
 
We have a number of tables and views that require this information and its way too much data to enter by hand.
 
Thanks for any help! 

View Replies !   View Related

---

I Need Away To Show The Pending Transaction From Transaction Replication In A User Friendly Format.
 

I want to list out the pending transaction for transaction replication  by publication.

 

Help needed.

View Replies !   View Related

---

Error When User Is Trying To Access The Report Properties In SQL Server Reporting Services
When user is trying to access the property of the report in the project report site, he/she is getting an permission error saying "The permissions granted to user 'user account' are insufficient for performing this operation.".  The user is a member of project admin group, and this user group has 'content manager' permission.  According to the article, http://msdn2.microsoft.com/en-us/library/ms181640(VS.80).aspx, it says that 'content managers' permission is only required.  Please help...

View Replies !   View Related

---

Setup Issue For Security On Reporting Service Unknown User Or Password Error
I need security setup help as after I deploy the reports I get login failed error trying to run them.  Invalid User name or bad password.  I have it set up as a shared data source with credential supplied by the user running the report. 
This is to be setup for some users to access this to print the reports by logging into this server. 
I need to complete this as I am out of the office next week.
 
w3wp!library!5!04/30/2008-08:43:37:: i INFO: Call to GetPermissions:/
w3wp!library!5!04/30/2008-08:43:37:: i INFO: Catalog SQL Server Edition = Standard
w3wp!library!8!04/30/2008-08:43:38:: i INFO: Call to GetSystemPermissions
w3wp!library!1!04/30/2008-08:43:43:: i INFO: Call to GetPermissions:/CBIZ Reports
w3wp!library!1!04/30/2008-08:43:43:: i INFO: Call to GetSystemPermissions
w3wp!library!1!04/30/2008-08:43:44:: i INFO: Call to GetPermissions:/CBIZ Reports/rptRequirements Summary by Type  Sales
w3wp!library!1!04/30/2008-08:43:45:: i INFO: Call to GetSystemPermissions
w3wp!library!5!04/30/2008-08:43:48:: i INFO: Call to RenderFirst( '/CBIZ Reports/rptRequirements Summary by Type  Sales' )
w3wp!library!5!04/30/2008-08:43:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. ---> System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
   at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
   at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
   --- End of inner exception stack trace ---
w3wp!webserver!5!04/30/2008-08:43:53:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Logon failed. ---> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. ---> System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
   at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
   at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
   at Microsoft.ReportingServices.Diagnostics.ImpersonationContext..ctor(CredentialsType credType, Guid dataSourceId, String userName, String password, String domain)
   at Microsoft.ReportingServices.Library.SurrogateContextFactory.CreateContext(ExecutionType& execType)
   at Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
   at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
   at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
   at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
   at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
   at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService 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.DoStreamedOperation(StreamedOperation operation)
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
 
Thanks!
Terry Beckman

View Replies !   View Related

---

Showing Friendly Values In The GUI
I am new to SQL server and I am looking for the best practiceregarding the following:The GUI for the database I am creating has a number of questions like:A. Where are you currently living?1) In my own home2) In the home of a family member3) In a shelter4) On the streetHowever, for speed of data entry, the GUI (it's a web front-end,ASP/VBScript) accepts the number only. Futhermore the database onlystores the number entered.So for example for the above question, when the user is doing the dataentry, they would just enter a 1, 2, 3, or 4.However, when viewing the data, the end user wants to see the textthat corresponds to the number. So for example, if the user entered"3" for the above question, when they are viewing the data in the GUI(not to make edits, just viewing), they want to see "(3) In ashelter".My question is how best to display these friendly values?Should I do all the conversions in a stored procedure? If so, whatwould be the best way to do that? I tried something like this:SELECT Current_living =CASE Current_livingWHEN 1 THEN '(1) In my own home with my partner'WHEN 2 THEN '(2) In the home of a family member'ELSE NULLENDFROM tbl_DemographicInfo WHERE ClientID = @ClientIDbut I can't figure out how to do this for multiple fields.ALSO, I'm not sure if burying this stuff in a stored proc is the wayto go, because if the client wants a slight change to the friendlyname I have to get into the SP and change it. Seems like there mustbe a better way.I can also do this in the ASP code, but that also doesn't seem likethe best practice.I can have a lookup table, but again, where do I do the conversion?In an SP? With a view?Again, I'm looking for the best practice here. I know some ways Icould do it (like in the ASP), but I want to do it efficiently andcorrectly.Any help/comments are greatly appreciated.thanks in advance,Jon LaRosajlarosa at alumni dot brown dot edu

View Replies !   View Related

---

Friendly DataSet Table Names
I have a stored procedure that returns a set of tables based on data in a table for a company.  These tables are being used to create drop down lists for criteria selection for the client.  We have a Javascript based control that will make use of these based on the control name.  So... ideally, I would like the stored procedure to return tables named "EmployeeID", "ResourceName", so that I can accurately name the controls when they are being created.  The data that is returned is not static, so, for example, client 1 may see the EmployeeID drop down, while client 2 may not.
I searched and didnt see anyone that was able to accomplish this in this way, but wanted to post something here before I moved forward in a different direction. 
I am thinking that I will likely return an extra table with the field names and their corresponding tables (i.e. "EmployeeID"/"Table0", "ResourceName"/"Table1", etc...)
Thanks,
Josh

View Replies !   View Related

---

Friendly Names To Attribute In Report Model
I am currently in a phase to develop report model so that our non technical end user do not have to learn the schema and know the database field names.
One of the requirements is to make the field names more English like instead of the cryptic field names in the tables. We have a database we call data dictionary where we have the English names to the fields in each table.
My challenge is to use the data dictionary to populate the names of the attributes without manually typing through the thousands of fields many of which are repeated across many report models.
I could love to hear ideas as to how I can automate this.
Thanks,
Rahul

 

View Replies !   View Related

---

Open A Report In A Print Friendly Format
 

Hi experts,

 

What I am trying to do is  to open an existing report in a Print Friendly format .
What is the simplest way to do this using Visual Studio?

Here's the sort of thing I hope is feasible:

I can open my Report on a web page , then on that page can be a button / link for the user in case they want to open
that report in a separate window.
So I'd like to jump to that page by jumping to an URL and sending all parameters

something like :

http://Dev_Server/Reports/Pages/Report.aspx?ItemPath=%2fMy+Reports%2fTest+Report&rsaramOne=Parameters!paramOne.value + paramTwo=Parameters!paramTwo.value + etc all other parameters , I have on that report

Any suggestions would be really appreciated .

 

Regards,TIA

View Replies !   View Related

---

Friendly Front-end Interface For Full-text Search
Hi,I want to setup a search on my website that will allow the type of search expressions that people are familiar with - eg. use of "OR" vs "AND", wildcards etc.I was wondering if anyone knows of an interface to Microsoft SQL that will convert user-friendly expressions to the format required by CONTAINS and other full text functions.This seems like a fairly common thing to do. At my old company someone had done it but it required a huge, ugly, unmaintainable SQL stored procedure to achieve it.

View Replies !   View Related

---

Friendly Way To Look At Sqlagent Ssis Messages Without Exporting Rest Of Log
I just started playing with sqlagent and am finding that viewing a specific message from an ssis step is cumbersome when other entries are also in the log.  Exporting seems only able to export all history entries.  Viewing right in the log viewer leads to a series of boundary expansions and right scrolls that dont seem convenient for quick identification of a problem in a medium sized ssis message.  Right clicking on the message in the viewer seems like it is preparing the message for possible copy but it seems to end there.  I'm already familiar with the different levels of verbosity available in the command line.  Dont see anything useful on the web.
 
Is there a user friendly way to copy the contents of a specific message for perhaps pasting to notepad , so that problem identification is facilitated?  Is there a not so user friendly way available, one taht doest involve 1st exporting the entire log?    

View Replies !   View Related

---

[JavaScript Error] Cannot Delete User Or User's Authority In Specific Report After Install SQL SP2
 Hi,

I have several reports for users to view on our Intranet. After installation of SQL 2005 SP2 patch, I cannot delete user or user's authority from Report in Properties Tab. An error message was shown on the status bar. It indicated that JavaScript Error: 'Return' statement outside of function. Seems something wrong with the 'Delete' funciton in SQL 2005 after update. The other functions worked fine. Could you point me out how to fix it or need to install any updates / hotfix. Thanks a lot!

Regards,

Kenneth Lai
Programmer


Error Pic


Message Box

 

View Replies !   View Related

---

[298] SQLServer Error: 18452, Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.
I received the above error yesterday and haven't been able to trace it to any job or process running.  We haven't implemented any changes to the server in the past few months, and it doesn't look to be a user-established connection, since the Client IP Address of the SSPI handshake error is from the server itself.
 
I logged this set of messages in SQL AgentServer error log:
 

Date  10.03.2008 6:15:19 PM
Log  SQL Agent (Current - 10.03.2008 6:15:00 PM)

Message
[298] SQLServer Error: 18452, Login failed for user ''. The user is not associated with a trusted SQL Server connection. [SQLSTATE 28000]
 
Date  10.03.2008 6:15:19 PM
Log  SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[382] Logon to server '<server>' failed (ConnAttemptCachableOp)

Date  10.03.2008 6:15:19 PM
Log  SQL Server (Current - 11.03.2008 2:32:00 PM)
Source  Logon
Message
Error: 17806, Severity: 20, State: 2.

Date  10.03.2008 6:15:19 PM
Log  SQL Server (Current - 11.03.2008 2:32:00 PM)
Source  Logon
Message
SSPI handshake failed with error code 0x80090304 while establishing a connection with integrated security; the connection has been closed. [CLIENT: <IP Address>]
 
Date  10.03.2008 6:15:19 PM
Log  SQL Server (Current - 11.03.2008 2:32:00 PM)
Source  Logon
Message
Error: 18452, Severity: 14, State: 1.

Any help in explaining this would be greatly appreciated.
 

View Replies !   View Related

---

Reporting Off Of User Activity
I would like to be able to identify "who does what" such as who deleted records or merged them and when.  How would I best get at that type of info?

View Replies !   View Related

---

Error : &&"cannot Open User Default Database. Login Failed. Login Failed For User 'server/user'
 

i'm using the Enterpirse library logger to write logs into a database.
When choosing connection string i choose the database i want in the "connection properties" dialog box and
push 'Test connection' button.
everything goes well.
 
then i open the SQL Server Management studio express and connect to the databse to check some things,
from that point on , when i push the 'Test Connection' button in the Enterprise library i get the error:

 
"cannot open user default database. Login failed. login failed for user My'server/MyuserName'"

 
even when i close the sql server manager , it is still stuck - the connection test doesn't work anymore....
it only work when i restart the computer.
 
why ?

View Replies !   View Related

---

Problm Setting Up User. Error: User Is Null
On MS-SQL 2k I have a created user. Security for the SQL instance isset to mixed.When I attempt to connect to SQL using Enterprise client on anothermachine on the local network using Windows Auth I get the error: DBName-Login Failed for user ('null')- Reason: Not associated with atrusted SQL Server Connection.What am I over looking?TIA

View Replies !   View Related

---

Reporting Services And ASPNET User Account
I have a asp.net, vb.net web application using sql and reporting services on a win 2003 server.

I pass a @whereClause parameter to reporting services and reporting services responds with the data inside an iframe. Right now the report call works because I have set myself as a domain/user account in reporting services.

What I would like to figure out is how to create a generic user/group in reporting services and when my web application calls reporting services for data, the web app uses its ASPNET credentials, which it runs under, to authenticate to reporting services. I wold in turn add the ASPNET user to reporting services and grant the group browser level security. I could also set up a generic user with impersonate = false userName="ReportWebUser" ... etc.

I can't add all the different users/groups to reporting services, I would like to grant overall limited browser access.

Any suggestions or leads would be extremely helpful. I'm not sure if my mind is just blank right now and it's an easy problem or it can't really be done.

View Replies !   View Related

---

Cannot Delete User In SQL 2005 Reporting Services
Hi,

I have several reports for users to view on our Intranet. After SQL 2005 SP2
patch installed, I cannot delete user or user's authority from Report in
Properties Tab. An error message was shown on the status bar. It indicated
that JavaScript Error: 'Return' statement outside of function. Seems
something wrong with the 'Delete' funciton in SQL 2005 after update. The
other functions worked fine. Could you point me out how to fix it or need to
install any updates. Thanks a lot!

Regards,

Kenneth Lai
Programmer

View Replies !   View Related

---

Login Failed For User In Reporting Services
 

Hi
 
I am trying to shedule the reports in reporting services to work, I am getting the error login failed even if I use my sa password. Could some body help me with this. I am working on this from three days but failed to find out the solution on this. Thank you in advance for your help!

View Replies !   View Related

---

SQL Reporting Services 2005: End User Deployment
Is there another way for users to access reports online besides the Report Manager? Or is there a way for users to go to a URL that does not include the server? The same question goes for Report Models and Report Builder. Can they access these features without access to the server and databases?

View Replies !   View Related

---

Create User Roles In Reporting Server 2005
Hi,
 
 I would like to create the folders Sales, Orders and Credit under the Home folder.
The Sales folder contains a set of reports that should be accessible to a group of users, similarly Orders folder contains a set of reports that should be accessible to a group of users.
 I do not have facility to create user groups in SQL Reporting Service. I create a user group in my machine (from Control Panel) but Reporting service is not able to view this group.
  I am able to add individual users to a folder, but I would like to check if I can create a group and then add users to this group.

  Any help in how to resolve this issue.

 

Cheers,

 

View Replies !   View Related

---

Reporting Services 2005 - Report Slow To Render For End User
We're using SQL Reporting services 2005 that connects to Analysing Services 2005 OLAP Cube that we have built. We've built reports using Microsoft Report Builder using a datasource mapped to our Cube.
 
If the reports are run by a domain administrator, the reports take 4 to 6 seconds to run.. if i'm using a user that is not a domain administrator the report takes 2 minutes to render... it's the same report using the same machine with the same filter.
 
We're using Windows Authentifications
 
I Went into the ExecutionLog of the Report Server and the number are exactly showing what a just describe.
 
DataRetreivalTime is the problem in this case but i'm not really sure how to correct the problem since that running the report as an administrator is working fine...

View Replies !   View Related

---

Reporting Service Not Starting - The User Or Group Name 'VIDICOMASPNET' Is Not Recognized.
Hi, I've been trying for the past week to get SQL 2005 Server up and running.The SQL is up and running however I am unable to get the Reporting service to start.  The log file is below but the main line is:

ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOMASPNET' is not recognized., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:The user or group name 'VIDICOMASPNET' is not recognized.

But the domain user ASPNET is present.  Similar posts across the internet mention about the .NET Framework not be installed correctly.  I have reinstalled it many times.

Any help is most appreciated.

Tom

Here is the full log file:
<Header>  <Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>  <Locale>en-US</Locale>  <TimeZone>GMT Daylight Time</TimeZone>  <Path>C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesReportServerService__main_06_29_2006_14_33_39.log</Path>  <SystemName>CRM</SystemName>  <OSName>Microsoft Windows NT 5.0.2195 Service Pack 4</OSName>  <OSVersion>5.0.2195.262144</OSVersion></Header>ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing ConnectionType to '1'  as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing ProcessRecycleOptions to '0'  as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.ReportingServicesService!servicecontroller!9!29/06/2006-14:33:45:: Total Physical memory: 267894784ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOMASPNET' is not recognized., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOMASPNET' is not recognized.ReportingServicesService!servicecontroller!4!29/06/2006-14:33:47:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOMASPNET' is not recognized.   at Microsoft.ReportingServices.Library.Native.NameToSid(String name)   at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)

View Replies !   View Related

---

How Can Create User In Reporting Server 2005 And Assign To Role
how can create user in reporting server 2005 and assign to role

i convert reporting server to forms authentication 

and i want create user from my applection and assign to role

 

thanks for all

 

 

View Replies !   View Related

---

How To Setup User Security For Reporting Services Used Inside ASP.NET Web Applications?
I'm working on a project that requires integration of SQL Server Reporting Services with ASP.NET 3.0 Web Applications.
I'm working on Visual Studio 2005, with SQL Server 2005 on an XP development workstation.
SQL Server, Reporting Services, and IIS are all running on my local machine.

I'm trying to prototype two approaches, one using the Report Viewer control, and the second using the Reporting Services Web Service. I have the two examples setup in projects in Visual Studio.
The sample reports and data sources work fine in Visual Studio. I can access the report using the Reporting Services URL like this: http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fBTT_BDS_DEV%2fCustomers; Report works fine.

My problem is, that when I try and access the report using the Report Viewer inside an ASP.NET page or from the Web Serivce hooked up inside an ASP.NET Page I get a security errors. I have chosen Windows Security for the Datasource, and ASP.NET pages. In the case of the Web Service, I'm passing in my local domain user name as the credentials.

I'm prototyping this on my local workstation, but I need to design this to be used on our corporate Intranet using Windows Security.

My questions are:

1. How do I need to setup users on my local development workstation to get this to work.
2. How should I plan for user security for enterprise deployment, i.e. using Reporting Services inside a large ASP.NET Web Application?
3. Can anybody give me some links to some good developer type working examples of doing this. I've looked but have not found the answers
to the "how do I setup users" part of the question specifcally related to ASP.NET apps?

Below is the code example of the Web Services example app I'm working with which came out of a book I have on
Reporting Services. This example compiles and seems like it would work but doesn't. Also following are a few of the
error messages I get when experimenting with the example apps:

Errors:

1. The permissions granted to user 'LocalMachineNameASPNET' are insufficient for performing this operation. (rsAccessDenied)

2. System.Web.Services.Protocols.SoapException was unhandled by user code
Message="System.Web.Services.Protocols.SoapException: The permissions granted to user 'LocalMachineName\ASPNET' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'WCRBUSCNC2830B\ASPNET' are insufficient for performing this operation. at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc) at Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext reportContext, ClientRequest session, String historyID, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings) at Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext reportContext, ClientRequest session, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& executionDateTime, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings) at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save() at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo) at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)"
Source="System.Web.Services"
Actor="http://localhost/ReportServer/ReportExecution2005.asmx"
Lang=""
Node="http://localhost/ReportServer/ReportExecution2005.asmx"
Role=""
StackTrace:
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at WebReportTester.localhost.ReportExecutionService.LoadReport(String Report, String HistoryID) in C:Documents and SettingsconbcxMy DocumentsVisual Studio 2005ProjectsBTT_BDS_DEVWebReportTesterWeb ReferenceslocalhostReference.cs:line 242
at WebReportTester._Default.btnExecuteReport_Click(Object sender, EventArgs e) in C:Documents and SettingsconbcxMy DocumentsVisual Studio 2005ProjectsBTT_BDS_DEVWebReportTesterDefault.aspx.cs:line 82
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Web Service Code Example:

protected void btnExecuteReport_Click(object sender, EventArgs e)
{
byte[] report;

//Create an instance of the Reporting Services Web Reference
localhost.ReportExecutionService rsv = new localhost.ReportExecutionService();

//Create the credentials that will be used when accessing Reporting Services
//This must be a logon that has rights to the Customers Report
rsv.Credentials = System.Net.CredentialCache.DefaultCredentials;
rsv.PreAuthenticate = true;

//The Reporting Services virtual path to the report.
string reportPath = @"/ReportFolder/Customers";

//The rendering format for the report
string reportFormat = "HTML4.0";

//The devInfo string tells the report viewer how to display with the report
StringBuilder deviceInfoBuilder = new StringBuilder();
deviceInfoBuilder.Append(@"<DeviceInfo>");
deviceInfoBuilder.Append(@"<Toolbar>");
deviceInfoBuilder.Append(@"False");
deviceInfoBuilder.Append(@"</Toolbar>");
deviceInfoBuilder.Append(@"<Parameters>");
deviceInfoBuilder.Append(@"False");
deviceInfoBuilder.Append(@"</Parameters>");
deviceInfoBuilder.Append(@"<DocMap>");
deviceInfoBuilder.Append(@"True");
deviceInfoBuilder.Append(@"</DocMap>");
deviceInfoBuilder.Append(@"<Zoom>");
deviceInfoBuilder.Append(@"100");
deviceInfoBuilder.Append(@"</Zoom>");
deviceInfoBuilder.Append(@"</DeviceInfo>");

string deviceInfo = deviceInfoBuilder.ToString();

//Create an array of the values for the report parameters
localhost.ParameterValue[] parameters = new localhost.ParameterValue[1];
localhost.ParameterValue parameterValue = new localhost.ParameterValue();
parameterValue.Name = "@WTRKCustomerCode";
parameterValue.Value = "B34186";
parameters[0] = parameterValue;

//Create variables for the remainder of the parameters
string historyId = string.Empty;
string credentials = string.Empty;
string showHideToggle = string.Empty;
string extension = string.Empty;
string mimeType = string.Empty;
string encoding = string.Empty;
localhost.Warning[] warnings;
localhost.ParameterValue[] reportHistoryParameters;
string[] streamIds;

localhost.ExecutionInfo execInfo = new WebReportTester.localhost.ExecutionInfo();
localhost.ExecutionHeader execHeader = new WebReportTester.localhost.ExecutionHeader();
rsv.ExecutionHeaderValue = execHeader;

execInfo = rsv.LoadReport(reportPath, null);
rsv.SetExecutionParameters(parameters, "en-us");

try
{
//Execute the Report
report = rsv.Render(reportFormat, deviceInfo, out extension, out mimeType, out encoding, out warnings, out streamIds);

//Flush the pending response
Response.Clear();

//Set the HTTP Headers for a PDF response.
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ContentType = "text/html";

//Filename is the default filename displayed
//if the user does a save as.
HttpContext.Current.Response.AppendHeader("Content-Disposition", "Customers.htm");

//Send the byte array containing the report as a binary response.
HttpContext.Current.Response.BinaryWrite(report);
HttpContext.Current.Response.End();

}
catch (Exception ex)
{
if(ex.Message != "Thread was being aborted.")
{
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ContentType = "text/html";

StringBuilder errorMessageBuilder = new StringBuilder();
errorMessageBuilder.Append(@"<HTML>");
errorMessageBuilder.Append(@"<BODY>");
errorMessageBuilder.Append(@"<H1>");
errorMessageBuilder.Append(@"Error");
errorMessageBuilder.Append(@"</H1>");
errorMessageBuilder.Append(@"<BR>");
errorMessageBuilder.Append(@"<BR>");
errorMessageBuilder.Append(ex.Message);
errorMessageBuilder.Append(@"</BODY>");
errorMessageBuilder.Append(@"</HTML>");

string errorMessage = errorMessageBuilder.ToString();

HttpContext.Current.Response.Write(@errorMessage);
HttpContext.Current.Response.End();

}
}

}



Any direction here related to best practices on setting up users for code use with
ASP.NET applications would be greatly appreciated...

Thanks in advance...

View Replies !   View Related

---

Loading Subscriptions Without Users In Reporting Services User Table
We need to import subscriptions for other platform to Reporting Services.
We have written an ASP .Net Web Services to load the Subscriptions.
We have mapped old system ids to the new owner id for each subscription.
We need to load these subscriptions to a new Reporting Services server to which these report owners have never connected.
We are attempting to assign ownership to reports using a SQL update statement which needs to be in synch with the USER table in reporting services.
Since the reports owners are not listed in the USER table the reassignment fails.

How do we create the users required in the USER table without them having to log into the report server?

View Replies !   View Related

---

Setting User Roles Without Using Reporting Manager - Using Setpolicies In Visual Studio VB
I have created an web reference called ReportingSerivce 2005. i am trying to set an user to have browser rights without going into Report Manager.
 
But I can't get the SetPolicies function to work correctly. Any ideas?
 
Code written in VB.
 

            Dim rs As ReportingService2005
            rs.Url = "https://wa.hrconnect.treas.gov/reportserver/reportservice2005.asmx"


            Dim Item As String = "/"
            Dim Policies() As Policy
            Policies(0) = New Policy
            Policies(0).GroupUserName = TxtUser.ToString
            Policies(0).Roles = New Role(0) {}
            Policies(0).Roles(0) = New Role
            Policies(0).Roles(0).Name = "Browser"
            Policies(0).Roles(0).Description = "May view folders and reports."
            rs.SetPolicies(Item, Policies)

View Replies !   View Related

---

Reporting Serivces In SharePoint Integrated Mode Give The Wrong User.
Hi,

I'm using reporting services 2005 SP 2 in SharePoint integrated mode (with WSS 3.0) with forms authentication.
Both reporting services and SharePoint are installed on same server under the same website.

This setup was working correctly until I extended the site for an intranet version of the application to enable the site search to work with forms authentication (see http://technet2.microsoft.com/windowsserver/WSS/en/library/8208d71e-7c41-4845-bc06-95429de02cf11033.mspx?mfr=true)
Now the search works correctly but the logged in user reported by reporting service is always the SharePoint application pool user.  If I stop the intranet site reporting services reports the correct logged in user but obviously the search stops working.

How do I get round this problem? Any help would be greatly appreciated.

Thanks


Andy

View Replies !   View Related

---

Cannot Re-establish A User That Is Deleted And Readded To Active Directory In Reporting Services
 


 

 The permissions granted to user 'xxxxyyy' are insufficient for performing this operation. When a user is deleted and then readded to active directory. Reporting services returns the insufficient permissions granted error.  In dbo.users in the sql database there are 2 entries for the deleted user one with UserType 0 and another with UserType 1. How do you clean up reporting services or sql to allow the reciently re-added user to re-connect to reporting services. We use the MY-Reports option of reporting services but cannot delete the home directory for this user either in report Mgr. The same error is returned for this action.

View Replies !   View Related

---

Login Failed For User , The User Is Not Associated With A Trusted Sql Server Connection. (microsoft SQL Server,Error:18452)
Login Failed for user , the user is not associated with a trusted sql server connection. (microsoft SQL Server,Error:18452)

 
hi ,
i am getting the above error message once in a while maybe two or 3 times a week , and then it goes away in 10 to 15 minutes or 5 minutes ,
 
our mode is set to mixed and we are able to connect and use both sql and windows , but once in a while ,  it will give us the above message when we try connecting throught sql server management studio client (using sql 05) using windows login , although it lets us connect using sql login while the windows login is denied, and after a while it lets us connect with both.
 
occurs randomly on some days , we run our servers on VM ware virtual machines using windows 2003 r2 enterprise 64  bit  with sp2 with esx 301 virtual machine.
 
would appericate any feedback on this thanks
 
 

View Replies !   View Related

---

Error 15185: There Is No Remote User 'sa' Mapped To Local User '(null)' From The Remote Server 'DTS_FSERVER'.
I am trying to add a linked server from a AMD x64 server (Windows 2003) with  SQL Server 2005 64 bit to a Server running SQL 2000.  These are not in the same domain.

I can create a linked server using the option "Be made using the login's current security context"  but can not when trying to specify the security context, i.e. sa and the sa password.   When I try I get the following message:

Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote server 'DTS_FSERVER'.

I have several other x64 server that I have no problem creating a linked server and specifying sa and the sa password.

The problem with using "the login's current security context" option is that I get an error when trying to run any Jobs against the linked server. The job fails withe the following error:

Executed as user: NT AUTHORITYSYSTEM. Access to the remote server is denied because no login-mapping exists. [SQLSTATE 42000] (Error 7416).  The step failed.

I'm sure the two errors are related.  Any ideas what is going on?

View Replies !   View Related

---

Error &"Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection. &"
All the research I found dealing with this problem is that the solution is to set SQLserver to mix mode.  I have SQL server already set to mix mode. I am not sure what else to do. Has anybody run into this problem?
my connection string: <connectionStrings>
<add name="ConnectionString" connectionString="Data Source= server name ;
Initial Catalog=FILESHAREDB.MDF;
Integrated Security=false;"providerName="System.Data.SqlClient"/>
</connectionStrings>
 
Server Error in '/SendItNow' Application.


 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.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.Source Error:



Line 41:
Line 42: 'open the connection and execute the stored procedure
Line 43: mConnection.Open()
Line 44: mResourceID = mCommand.ExecuteScalar()
Line 45: mConnection.Close()Source File: H:MIS DepartmentIntranetSendItNowApp_CodeDalResourceDB.vb    Line: 43 Stack Trace:



[SqlException (0x80131904): Login failed for user ''. The user is not associated with a trusted SQL Server connection.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
ResourceDB.SaveResource(String filename, String fromContactEmail, String toContactEmail, String message, Int32 ID) in H:MIS DepartmentIntranetSendItNowApp_CodeDalResourceDB.vb:43
Resource.SaveResource(String filename, String fromContactEmail, String toContactEmail, String message) in H:MIS DepartmentIntranetSendItNowApp_CodeBllResource.vb:31
ContentFiles_Default.ImageButton1_Click1(Object sender, ImageClickEventArgs e) in H:MIS DepartmentIntranetSendItNowContentFilesDefault.aspx.vb:33
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +86
System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115
System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746



Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

View Replies !   View Related

---

Login Failed For User '' ..... Sql Server, Error: 18452 (The User Is Not Associated With A Trusted SQL Server Connection)
Hi
 
Last week I was receiving an error when trying to connect to two of our seven sql servers from my laptop via my domain admin account. The only fix was to have my laptop rebuilt and everything re-installed.
 
Today however another administrator is starting to have the same problem but to only one of the seven servers!
When that administrator uses my laptop with her domain admin account it works!?
 
What could possibly be going wrong with our laptops? We have not installed or changed anything.
 
The full error message we see:
 
Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft Sql Server, Error: 18452)
 
The error being logged on the server: (two errors are logged each time)
 

SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 53.35.165.148]
 

Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 53.35.165.148]

View Replies !   View Related

---

FIX TO: Reporting Server 2005 Prompting For User Name /ID And Domain When Accessing Http:localhost/reports
Hello all,

Could some one please explain the security piece of SQL 2005 reporting services? What type of IDs do I need during the installation/configuration part; do I need to use SPN accounts? If yes how and where would I put/specify this SPN account? Basically I am trying to understand how to setup security when I install reporting services.

 

Thanks

MA

View Replies !   View Related

---

SQL Reporting - An Internal Error Occurred On The Report Server. See The Error Log For More Details. (rsInternalError)
I have created an RDL file programatically. When I execute the code I get the error as mentioned below:

Error: Sub report cannot be shown.
An internal error occurred on the report server. See the error log for more details. (rsInternalError)

When I copy and paste the code of RDL file into new RDL file and try to preview the output I get correct result.
Note: The new RDL file does not give any error if the output is seen using preview tab but it gives the error only when executed from report viewer or from internet explorer.

Any Suggestion/feedback is highly appreciated.
Thank You.


The code of the sample RDL is shown below:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
  <DataSources>
    <DataSource Name="DataSource1">
      <DataSourceReference>DataSource1</DataSourceReference>
      <rd:DataSourceID>fe4806ee-0358-4a87-b764-ac5de049545e</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <BottomMargin>0.25in</BottomMargin>
  <RightMargin>0.25in</RightMargin>
  <PageWidth>11in</PageWidth>
  <ReportParameters>
    <ReportParameter Name="machine_id">
      <DataType>String</DataType>
      <Prompt>machine_id</Prompt>
    </ReportParameter>
    <ReportParameter Name="from_date">
      <DataType>String</DataType>
      <AllowBlank>true</AllowBlank>
      <Prompt>From Date</Prompt>
    </ReportParameter>
    <ReportParameter Name="to_date">
      <DataType>String</DataType>
      <AllowBlank>true</AllowBlank>
      <Prompt>To Date</Prompt>
    </ReportParameter>
  </ReportParameters>
  <rd:DrawGrid>true</rd:DrawGrid>
  <InteractiveWidth>8.5in</InteractiveWidth>
  <rd:SnapToGrid>true</rd:SnapToGrid>
  <Body>
    <ReportItems>
      <Table Name="table1">
        <DataSetName>Main_Report</DataSetName>
        <TableGroups>
          <TableGroup>
            <Header>
              <TableRows>
                <TableRow>
                  <TableCells>
                    <TableCell>
                      <ReportItems>
                        <Textbox Name="textbox2">
                          <rd:DefaultName>textbox2</rd:DefaultName>
                          <ZIndex>1</ZIndex>
                          <Style>
                            <TextAlign>Left</TextAlign>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingBottom>2pt</PaddingBottom>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                          </Style>
                          <CanGrow>true</CanGrow>
                          <Value>=Fields!syscode.Value</Value>
                        </Textbox>
                      </ReportItems>
                    </TableCell>
                  </TableCells>
                  <Height>0.25in</Height>
                </TableRow>
              </TableRows>
              <RepeatOnNewPage>true</RepeatOnNewPage>
            </Header>
            <Grouping Name="table1_Group1">
              <PageBreakAtEnd>true</PageBreakAtEnd>
              <GroupExpressions>
                <GroupExpression>=Fields!syscode.Value</GroupExpression>
              </GroupExpressions>
            </Grouping>
          </TableGroup>
        </TableGroups>
        <Details>
          <TableRows>
            <TableRow>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Subreport Name="subreport1">
                      <Parameters>
                        <Parameter Name="machine_id">
                          <Value>=Fields!machine_ip.Value</Value>
                        </Parameter>
                        <Parameter Name="syscode">
                          <Value>=Fields!syscode.Value</Value>
                        </Parameter>
                        <Parameter Name="from_date">
                          <Value>=Parameters!from_date.Value</Value>
                        </Parameter>
                        <Parameter Name="to_date">
                          <Value>=Parameters!to_date.Value</Value>
                        </Parameter>
                      </Parameters>
                      <ReportName>Holding_Summary_Multi_Period</ReportName>
                    </Subreport>
                  </ReportItems>
                </TableCell>
              </TableCells>
              <Height>0.25in</Height>
            </TableRow>
          </TableRows>
        </Details>
        <TableColumns>
          <TableColumn>
            <Width>10.5in</Width>
          </TableColumn>
        </TableColumns>
        <Height>0.5in</Height>
      </Table>
    </ReportItems>
    <Height>0.75in</Height>
  </Body>
  <rd:ReportID>d0a1293a-e98c-4f75-9597-03426d2e7218</rd:ReportID>
  <LeftMargin>0.25in</LeftMargin>
  <DataSets>
    <DataSet Name="Main_Report">
      <Query>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
        <CommandText>select account_syscode as syscode , 'display Name' as display_name , * from mars_customer_list
where machine_ip = @machine_id</CommandText>
        <QueryParameters>
          <QueryParameter Name="@machine_id">
            <Value>=Parameters!machine_id.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <DataSourceName>DataSource1</DataSourceName>
      </Query>
      <Fields>
        <Field Name="syscode">
          <rd:TypeName>System.Int64</rd:TypeName>
          <DataField>syscode</DataField>
        </Field>
        <Field Name="display_name">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>display_name</DataField>
        </Field>
        <Field Name="customer_syscode">
          <rd:TypeName>System.Int64</rd:TypeName>
          <DataField>customer_syscode</DataField>
        </Field>
        <Field Name="account_syscode">
          <rd:TypeName>System.Int64</rd:TypeName>
          <DataField>account_syscode</DataField>
        </Field>
        <Field Name="machine_ip">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>machine_ip</DataField>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <Code>Shared offset As Integer

Public Function GetPN(reset As Boolean, pagenumber As Integer) As Integer
  If reset
    offset = pagenumber - 1
  End If
  Return pagenumber - offset
End Function

</Code>
  <Width>10.5in</Width>
  <InteractiveHeight>11in</InteractiveHeight>
  <Language>en-US</Language>
  <PageFooter>
    <ReportItems>
      <Image Name="image1">
        <Sizing>Fit</Sizing>
        <Left>8.875in</Left>
        <MIMEType />
        <Width>1.5in</Width>
        <Source>External</Source>
        <Style />
        <Value>bottom_right_logo.gif</Value>
      </Image>
    </ReportItems>
    <Height>0.5in</Height>
    <PrintOnLastPage>true</PrintOnLastPage>
    <PrintOnFirstPage>true</PrintOnFirstPage>
  </PageFooter>
  <TopMargin>0.5in</TopMargin>
  <PageHeight>8.5in</PageHeight>
</Report>

View Replies !   View Related

---

Error Opening Reporting Services Site --- Server Error In '/Reports' Application
I recently installed SQL Server 2005 Enterprise on a machine running Server 2003.  I have successfully configured Reporting Services (see below for summary of settings)
-  Used the defaults for the Repor tServer and Report Manager Virtual Directories
-  Windows Service Identity set to domain user.  The domain user is part of the administrator group on the machine and has sysadmin rights to the database
-  Web Service Identity set to NT AuthorityNetworkService
 
When I open http://localhost/reports/, I get the following error:
 
I have check a bunch of forums, but have no success.  Any advise would be greatly appreciated!!

 
 

Server Error in '/Reports' Application.


Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. '

Source Error:







[No relevant source lines]
Source File:    Line: 0



Show Detailed Compiler Output:





c:windowssystem32inetsrv> "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WINDOWSassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3a890e9c0068591f_f54cc701ReportingServicesFileShareDeliveryProvider.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Mobile2.0.0.0__b03f5f7f11d50a3aSystem.Web.Mobile.dll" /R:"C:WINDOWSassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Services2.0.0.0__b03f5f7f11d50a3aSystem.Web.Services.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Configuration2.0.0.0__b03f5f7f11d50a3aSystem.Configuration.dll" /R:"C:WINDOWSassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.IdentityModel3.0.0.0__b77a5c561934e089System.IdentityModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.ServiceModel3.0.0.0__b77a5c561934e089System.ServiceModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl34a099978068591f_f54cc701ReportingServicesEmailDeliveryProvider.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727mscorlib.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3de5a23320958a20_f54cc701ReportingServicesWebUserInterface.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3498aee86042473c_93d0c501ReportingServicesCDOInterop.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Runtime.Serialization3.0.0.0__b77a5c561934e089System.Runtime.Serialization.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Drawing2.0.0.0__b03f5f7f11d50a3aSystem.Drawing.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3cd47089b0f2a80e_f54cc701Microsoft.ReportingServices.Interfaces.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3f180608d0083daf_b16dc701Microsoft.ReportingServices.Diagnostics.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl323449648068591f_f54cc701ReportingServicesNativeClient.DLL" /out:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699;1701 "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.0.cs" "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.1.cs"


Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.1433
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.

error CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. '








Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

View Replies !   View Related

---

614 Error On A User Database And 806 Error On Tempdb Seen In The Error Log
Hi,

We have a production SQLServer 6.5 running with service pack SP5a update:

I got the following 2 errors.....

1.

Error : 806, Severity: 21, State: 1
Could not find virtual page for logical page 67833121 in database 'tempdb' database 'tempdb'

2.

I got error when I ran a job for Update statistics
Error : 614, Severity: 21, State: 3
A row on page 2697653 was accessed that has an illegal length of -8631 in database 'abc'.

For Error 2: I ran update statistics using query analyser. It is fine
Is there anything I have to do further?


For Error 1 : The work around given by Microsoft
=================================================
I ran
DBCC CHECKTABLE(syslogs)

I am getting the following message on :
master:
Checking syslogs
The total number of data pages in this table is 1.
*** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device.
Table has 11 data rows.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.

model:
Checking syslogs
The total number of data pages in this table is 47.
*** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device.
Table has 532 data rows.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.

tempdb:

Checking syslogs
The total number of data pages in this table is 1.
*** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device.
Table has 31 data rows.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.

I ran dbcc checkdb on master,model and tempdb . Still I get the same problem.

for tempdb:

Checking 8
The total number of data pages in this table is 1.
*** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device.
Table has 19 data rows.

for master:
Checking 8
The total number of data pages in this table is 1.
*** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device.
Table has 27 data rows.

for model:
Checking 8
The total number of data pages in this table is 47.
*** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device.
Table has 532 data rows.

All system databases and userdatabase recovered successfully when I restarted sqlserver.

Please advice how to get rid of this problem.


Thanks in advance,
Anu

View Replies !   View Related

---

Failed To Generate A User Instance Of SQL Server Due To Failure In Retrieving The User's Local Application Data Path. Please Make Sure The User Has A Local User Profile On The Computer. The Connection Will Be Closed
This is my first time to deploy an asp.net2 web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed" (only in pages that try to access the database)
Help pleaseee

View Replies !   View Related

---

An Error Occurred In The Service Broker Internal Activator While Trying To Scan The User Queue '(null)' For Its Status. Error: 2
Hello - can't find any info on this error - can anyone shed some light?

 

There was a deadlock - which preceeded this message by 2 seconds.

 

 

 

04/25/2007 08:20:12,spid108,Unknown,An error occurred in the Service Broker internal activator while trying to scan the user queue '(null)' for its status. Error: 2905<c/> State: 1.
04/25/2007 08:20:12,spid108,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
04/25/2007 08:20:12,spid108,Unknown,Stack Signature for the dump is 0x1229B5AA
04/25/2007 08:20:12,spid108,Unknown,78132A36 Module(MSVCR80+00002A36)
04/25/2007 08:20:12,spid108,Unknown,781329AA Module(MSVCR80+000029AA)
04/25/2007 08:20:12,spid108,Unknown,01447720 Module(sqlservr+00447720)
04/25/2007 08:20:12,spid108,Unknown,0144789A Module(sqlservr+0044789A)
04/25/2007 08:20:12,spid108,Unknown,0144859B Module(sqlservr+0044859B)
04/25/2007 08:20:12,spid108,Unknown,01447562 Module(sqlservr+00447562)
04/25/2007 08:20:12,spid108,Unknown,01006DAB Module(sqlservr+00006DAB)
04/25/2007 08:20:12,spid108,Unknown,01006BBC Module(sqlservr+00006BBC)
04/25/2007 08:20:12,spid108,Unknown,01006A96 Module(sqlservr+00006A96)
04/25/2007 08:20:12,spid108,Unknown,0112F65C Module(sqlservr+0012F65C)
04/25/2007 08:20:12,spid108,Unknown,0112F70F Module(sqlservr+0012F70F)
04/25/2007 08:20:12,spid108,Unknown,0112CB04 Module(sqlservr+0012CB04)
04/25/2007 08:20:12,spid108,Unknown,0112D1D1 Module(sqlservr+0012D1D1)
04/25/2007 08:20:12,spid108,Unknown,0112EA61 Module(sqlservr+0012EA61)
04/25/2007 08:20:12,spid108,Unknown,0108A5CB Module(sqlservr+0008A5CB)
04/25/2007 08:20:12,spid108,Unknown,0108A56B Module(sqlservr+0008A56B)
04/25/2007 08:20:12,spid108,Unknown,01060A5A Module(sqlservr+00060A5A)
04/25/2007 08:20:12,spid108,Unknown,01476CB2 Module(sqlservr+00476CB2)
04/25/2007 08:20:12,spid108,Unknown,01476FD3 Module(sqlservr+00476FD3)
04/25/2007 08:20:12,spid108,Unknown,017FA720 Module(sqlservr+007FA720)
04/25/2007 08:20:12,spid108,Unknown,017FAADC Module(sqlservr+007FAADC)
04/25/2007 08:20:12,spid108,Unknown,01796B1B Module(sqlservr+00796B1B)
04/25/2007 08:20:12,spid108,Unknown,01793310 Module(sqlservr+00793310)
04/25/2007 08:20:12,spid108,Unknown,0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:12,spid108,Unknown,* Short Stack Dump
04/25/2007 08:20:12,spid108,Unknown,* -------------------------------------------------------------------------------
04/25/2007 08:20:12,spid108,Unknown,* *******************************************************************************
04/25/2007 08:20:12,spid108,Unknown,*      SegSs: 00000023:
04/25/2007 08:20:12,spid108,Unknown,*        Esp: 1302E584:  13025387  80C87378  80C872F0  00000000  78140001  0009D9C2
04/25/2007 08:20:12,spid108,Unknown,*     EFlags: 00010202:  00610067  00650074  0049003B  0076006E  006C0061  00640069
04/25/2007 08:20:12,spid108,Unknown,*      SegCs: 0000001B:
04/25/2007 08:20:12,spid108,Unknown,*        Ebp: 1302F67C:  1302F788  01793310  13025373  80C872F0  7093AB12  801E8B38
04/25/2007 08:20:12,spid108,Unknown,*        Eip: 0179438B:  828B118B  000000E0  C085D0FF  00B9850F  9D890000  FFFFEF8C
04/25/2007 08:20:12,spid108,Unknown,*        Edx: 00000E38:
04/25/2007 08:20:12,spid108,Unknown,*        Ecx: 00000000:
04/25/2007 08:20:12,spid108,Unknown,*        Ebx: 00000000:
04/25/2007 08:20:12,spid108,Unknown,*        Eax: A99EE598:  00000000  00000000  A99EE5B0  00000000  00000000  00000000
04/25/2007 08:20:12,spid108,Unknown,*        Esi: 00000000:
04/25/2007 08:20:12,spid108,Unknown,*        Edi: 80C872F0:  7093AB12  80C87FF0  00000007  B8A20008  7093AB15  00000000
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* dbghelp                        14200000  14312FFF  00113000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       76780000  76913FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       764A0000  76633FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       76300000  76493FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       341D0000  343AFFFF  001e0000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       33590000  33764FFF  001d5000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       333F0000  33583FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       14490000  1467AFFF  001eb000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       13D10000  13EFBFFF  001ec000
04/25/2007 08:20:12,spid108,Unknown,* OLEDB32R                       13770000  13780FFF  00011000
04/25/2007 08:20:12,spid108,Unknown,* MSDART                         133D0000  133E9FFF  0001a000
04/25/2007 08:20:12,spid108,Unknown,* oledb32                        13350000  133C8FFF  00079000
04/25/2007 08:20:12,spid108,Unknown,* msxml3                         11BD0000  11CE1FFF  00112000
04/25/2007 08:20:12,spid108,Unknown,* msxmlsql                       11AF0000  11BC5FFF  000d6000
04/25/2007 08:20:12,spid108,Unknown,* System.Xml                     10FA0000  11193FFF  001f4000
04/25/2007 08:20:12,spid108,Unknown,* System.Security                10F20000  10F61FFF  00042000
04/25/2007 08:20:12,spid108,Unknown,* System                         10C10000  10EF3FFF  002e4000
04/25/2007 08:20:12,spid108,Unknown,* System.Security.ni             10A90000  10B45FFF  000b6000
04/25/2007 08:20:12,spid108,Unknown,* System.Transactions            0FAD0000  0FB12FFF  00043000
04/25/2007 08:20:12,spid108,Unknown,* System.ni                      7A440000  7ABFDFFF  007be000
04/25/2007 08:20:12,spid108,Unknown,* System.Data                    102D0000  10596FFF  002c7000
04/25/2007 08:20:12,spid108,Unknown,* mscorjit                       0F910000  0F962FFF  00053000
04/25/2007 08:20:12,spid108,Unknown,* SqlAccess                      0F8A0000  0F8F5FFF  00056000
04/25/2007 08:20:12,spid108,Unknown,* SensApi                        0F880000  0F884FFF  00005000
04/25/2007 08:20:12,spid108,Unknown,* cryptnet                       0F680000  0F691FFF  00012000
04/25/2007 08:20:12,spid108,Unknown,* SOFTPUB                        0F670000  0F674FFF  00005000
04/25/2007 08:20:12,spid108,Unknown,* mscorsec                       0F640000  0F652FFF  00013000
04/25/2007 08:20:12,spid108,Unknown,* mscorlib.ni                    0EAC0000  0F5A7FFF  00ae8000
04/25/2007 08:20:12,spid108,Unknown,* mscorwks                       080E0000  08640FFF  00561000
04/25/2007 08:20:12,spid108,Unknown,* xplog70                        07CA0000  07CA2FFF  00003000
04/25/2007 08:20:12,spid108,Unknown,* xplog70                        07C80000  07C8BFFF  0000c000
04/25/2007 08:20:12,spid108,Unknown,* xpstar90                       07C50000  07C75FFF  00026000
04/25/2007 08:20:12,spid108,Unknown,* odbcint                        07C30000  07C46FFF  00017000
04/25/2007 08:20:12,spid108,Unknown,* ATL80                          7C630000  7C64AFFF  0001b000
04/25/2007 08:20:12,spid108,Unknown,* BatchParser90                  07A40000  07A5EFFF  0001f000
04/25/2007 08:20:12,spid108,Unknown,* ODBC32                         07A00000  07A3CFFF  0003d000
04/25/2007 08:20:12,spid108,Unknown,* SQLSCM90                       079E0000  079E8FFF  00009000
04/25/2007 08:20:12,spid108,Unknown,* xpstar90                       07980000  079C7FFF  00048000
04/25/2007 08:20:12,spid108,Unknown,* xpsqlbot                       07960000  07965FFF  00006000
04/25/2007 08:20:12,spid108,Unknown,* msftepxy                       07490000  074A4FFF  00015000
04/25/2007 08:20:12,spid108,Unknown,* SQLNCLIR                       007A0000  007D2FFF  00033000
04/25/2007 08:20:12,spid108,Unknown,* comdlg32                       762B0000  762F9FFF  0004a000
04/25/2007 08:20:12,spid108,Unknown,* COMCTL32                       77530000  775C6FFF  00097000
04/25/2007 08:20:12,spid108,Unknown,* sqlncli                        337A0000  339C1FFF  00222000
04/25/2007 08:20:12,spid108,Unknown,* CLBCatQ                        777B0000  77832FFF  00083000
04/25/2007 08:20:12,spid108,Unknown,* xpsp2res                       10000000  102C4FFF  002c5000
04/25/2007 08:20:12,spid108,Unknown,* ntdsapi                        766F0000  76704FFF  00015000
04/25/2007 08:20:12,spid108,Unknown,* wshtcpip                       070B0000  070B7FFF  00008000
04/25/2007 08:20:12,spid108,Unknown,* hnetcfg                        071F0000  07248FFF  00059000
04/25/2007 08:20:12,spid108,Unknown,* dssenh                         070C0000  070E3FFF  00024000
04/25/2007 08:20:12,spid108,Unknown,* imagehlp                       76C10000  76C38FFF  00029000
04/25/2007 08:20:12,spid108,Unknown,* WINTRUST                       76BB0000  76BDAFFF  0002b000
04/25/2007 08:20:12,spid108,Unknown,* dbghelp                        06C10000  06D22FFF  00113000
04/25/2007 08:20:12,spid108,Unknown,* msfte                          069B0000  06C08FFF  00259000
04/25/2007 08:20:12,spid108,Unknown,* security                       06190000  06193FFF  00004000
04/25/2007 08:20:12,spid108,Unknown,* rasadhlp                       76F80000  76F84FFF  00005000
04/25/2007 08:20:12,spid108,Unknown,* winrnr                         76F70000  76F76FFF  00007000
04/25/2007 08:20:12,spid108,Unknown,* DNSAPI                         76ED0000  76EF8FFF  00029000
04/25/2007 08:20:12,spid108,Unknown,* RESUTILS                       05D50000  05D62FFF  00013000
04/25/2007 08:20:12,spid108,Unknown,* CLUSAPI                        05D30000  05D41FFF  00012000
04/25/2007 08:20:12,spid108,Unknown,* OLEAUT32                       77D00000  77D8BFFF  0008c000
04/25/2007 08:20:12,spid108,Unknown,* WSOCK32                        71BB0000  71BB8FFF  00009000
04/25/2007 08:20:12,spid108,Unknown,* VERSION                        77B90000  77B97FFF  00008000
04/25/2007 08:20:12,spid108,Unknown,* MTXCLU                         05D10000  05D28FFF  00019000
04/25/2007 08:20:12,spid108,Unknown,* msvcp60                        780C0000  78120FFF  00061000
04/25/2007 08:20:12,spid108,Unknown,* MSDTCPRX                       05C90000  05D07FFF  00078000
04/25/2007 08:20:12,spid108,Unknown,* XOLEHLP                        05C80000  05C85FFF  00006000
04/25/2007 08:20:12,spid108,Unknown,* COMRES                         77010000  770D5FFF  000c6000
04/25/2007 08:20:12,spid108,Unknown,* schannel                       76750000  76776FFF  00027000
04/25/2007 08:20:12,spid108,Unknown,* cryptdll                       766E0000  766EBFFF  0000c000
04/25/2007 08:20:12,spid108,Unknown,* kerberos                       05BC0000  05C17FFF  00058000
04/25/2007 08:20:12,spid108,Unknown,* iphlpapi                       76CF0000  76D09FFF  0001a000
04/25/2007 08:20:12,spid108,Unknown,* msv1_0                         76C90000  76CB6FFF  00027000
04/25/2007 08:20:12,spid108,Unknown,* MSCOREE                        05950000  05994FFF  00045000
04/25/2007 08:20:12,spid108,Unknown,* AUTHZ                          76C40000  76C53FFF  00014000
04/25/2007 08:20:12,spid108,Unknown,* rsaenh                         04E90000  04EBEFFF  0002f000
04/25/2007 08:20:12,spid108,Unknown,* WLDAP32                        76F10000  76F3DFFF  0002e000
04/25/2007 08:20:12,spid108,Unknown,* SAMLIB                         5CCF0000  5CCFEFFF  0000f000
04/25/2007 08:20:12,spid108,Unknown,* ole32                          77670000  777A3FFF  00134000
04/25/2007 08:20:12,spid108,Unknown,* NTMARTA                        77E00000  77E21FFF  00022000
04/25/2007 08:20:12,spid108,Unknown,* SQLOS                          344D0000  344D4FFF  00005000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       4F610000  4F7A3FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* instapi                        48060000  48069FFF  0000a000
04/25/2007 08:20:12,spid108,Unknown,* psapi                          76B70000  76B7AFFF  0000b000
04/25/2007 08:20:12,spid108,Unknown,* comctl32                       77420000  77522FFF  00103000
04/25/2007 08:20:12,spid108,Unknown,* SHLWAPI                        77DA0000  77DF1FFF  00052000
04/25/2007 08:20:12,spid108,Unknown,* SHELL32                        7C8D0000  7D0D2FFF  00803000
04/25/2007 08:20:12,spid108,Unknown,* NETAPI32                       71C40000  71C97FFF  00058000
04/25/2007 08:20:12,spid108,Unknown,* opends60                       333E0000  333E6FFF  00007000
04/25/2007 08:20:12,spid108,Unknown,* USERENV                        76920000  769E3FFF  000c4000
04/25/2007 08:20:12,spid108,Unknown,* WS2HELP                        71BF0000  71BF7FFF  00008000
04/25/2007 08:20:12,spid108,Unknown,* WS2_32                         71C00000  71C16FFF  00017000
04/25/2007 08:20:12,spid108,Unknown,* MSWSOCK                        71B20000  71B60FFF  00041000
04/25/2007 08:20:12,spid108,Unknown,* Secur32                        76F50000  76F62FFF  00013000
04/25/2007 08:20:12,spid108,Unknown,* MSASN1                         76190000  761A1FFF  00012000
04/25/2007 08:20:12,spid108,Unknown,* CRYPT32                        761B0000  76242FFF  00093000
04/25/2007 08:20:12,spid108,Unknown,* GDI32                          77C00000  77C47FFF  00048000
04/25/2007 08:20:12,spid108,Unknown,* USER32                         77380000  77411FFF  00092000
04/25/2007 08:20:12,spid108,Unknown,* RPCRT4                         77C50000  77CEEFFF  0009f000
04/25/2007 08:20:12,spid108,Unknown,* ADVAPI32                       77F50000  77FEBFFF  0009c000
04/25/2007 08:20:12,spid108,Unknown,* MSVCP80                        7C420000  7C4A6FFF  00087000
04/25/2007 08:20:12,spid108,Unknown,* msvcrt                         77BA0000  77BF9FFF  0005a000
04/25/2007 08:20:12,spid108,Unknown,* MSVCR80                        78130000  781CAFFF  0009b000
04/25/2007 08:20:12,spid108,Unknown,* kernel32                       77E40000  77F41FFF  00102000
04/25/2007 08:20:12,spid108,Unknown,* ntdll                          7C800000  7C8BFFFF  000c0000
04/25/2007 08:20:12,spid108,Unknown,* sqlservr                       01000000  02BCEFFF  01bcf000
04/25/2007 08:20:12,spid108,Unknown,*  MODULE                          BASE      END       SIZE
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*   Access Violation occurred reading address 00000000
04/25/2007 08:20:12,spid108,Unknown,*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
04/25/2007 08:20:12,spid108,Unknown,*   Exception Address = 0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*   04/25/07 08:20:12 spid 108
04/25/2007 08:20:12,spid108,Unknown,* BEGIN STACK DUMP:
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* *******************************************************************************
04/25/2007 08:20:12,spid108,Unknown,SqlDumpExceptionHandler: Process 108 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
04/25/2007 08:20:12,spid108,Unknown,***Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0007.txt
04/25/2007 08:20:12,spid108,Unknown,Using 'dbghelp.dll' version '4.0.5'
04/25/2007 08:20:12,spid60,Unknown,An error occurred in the Service Broker internal activator while trying to scan the user queue '(null)' for its status. Error: 2905<c/> State: 1.
04/25/2007 08:20:12,spid60,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
04/25/2007 08:20:10,spid60,Unknown,Stack Signature for the dump is 0x1229B5AA
04/25/2007 08:20:10,spid60,Unknown,78132A36 Module(MSVCR80+00002A36)
04/25/2007 08:20:10,spid60,Unknown,781329AA Module(MSVCR80+000029AA)
04/25/2007 08:20:10,spid60,Unknown,01447720 Module(sqlservr+00447720)
04/25/2007 08:20:10,spid60,Unknown,0144789A Module(sqlservr+0044789A)
04/25/2007 08:20:10,spid60,Unknown,0144859B Module(sqlservr+0044859B)
04/25/2007 08:20:10,spid60,Unknown,01447562 Module(sqlservr+00447562)
04/25/2007 08:20:10,spid60,Unknown,01006DAB Module(sqlservr+00006DAB)
04/25/2007 08:20:10,spid60,Unknown,01006BBC Module(sqlservr+00006BBC)
04/25/2007 08:20:10,spid60,Unknown,01006A96 Module(sqlservr+00006A96)
04/25/2007 08:20:10,spid60,Unknown,0112F65C Module(sqlservr+0012F65C)
04/25/2007 08:20:10,spid60,Unknown,0112F70F Module(sqlservr+0012F70F)
04/25/2007 08:20:10,spid60,Unknown,0112CB04 Module(sqlservr+0012CB04)
04/25/2007 08:20:10,spid60,Unknown,0112D1D1 Module(sqlservr+0012D1D1)
04/25/2007 08:20:10,spid60,Unknown,0112EA61 Module(sqlservr+0012EA61)
04/25/2007 08:20:10,spid60,Unknown,0108A5CB Module(sqlservr+0008A5CB)
04/25/2007 08:20:10,spid60,Unknown,0108A56B Module(sqlservr+0008A56B)
04/25/2007 08:20:10,spid60,Unknown,01060A5A Module(sqlservr+00060A5A)
04/25/2007 08:20:10,spid60,Unknown,01476CB2 Module(sqlservr+00476CB2)
04/25/2007 08:20:10,spid60,Unknown,01476FD3 Module(sqlservr+00476FD3)
04/25/2007 08:20:10,spid60,Unknown,017FA720 Module(sqlservr+007FA720)
04/25/2007 08:20:10,spid60,Unknown,017FAADC Module(sqlservr+007FAADC)
04/25/2007 08:20:10,spid60,Unknown,01796B1B Module(sqlservr+00796B1B)
04/25/2007 08:20:10,spid60,Unknown,01793310 Module(sqlservr+00793310)
04/25/2007 08:20:10,spid60,Unknown,0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:10,spid60,Unknown,* Short Stack Dump
04/25/2007 08:20:10,spid60,Unknown,* -------------------------------------------------------------------------------
04/25/2007 08:20:10,spid60,Unknown,* *******************************************************************************
04/25/2007 08:20:10,spid60,Unknown,*      SegSs: 00000023:
04/25/2007 08:20:10,spid60,Unknown,*        Esp: 1189E584:  11895387  80C87378  80C872F0  00000000  03E90001  00087C2D
04/25/2007 08:20:10,spid60,Unknown,*     EFlags: 00010202:  00610067  00650074  0049003B  0076006E  006C0061  00640069
04/25/2007 08:20:10,spid60,Unknown,*      SegCs: 0000001B:
04/25/2007 08:20:10,spid60,Unknown,*        Ebp: 1189F67C:  1189F788  01793310  11895373  80C872F0  7093AB12  801E8B38
04/25/2007 08:20:10,spid60,Unknown,*        Eip: 0179438B:  828B118B  000000E0  C085D0FF  00B9850F  9D890000  FFFFEF8C
04/25/2007 08:20:10,spid60,Unknown,*        Edx: 00000E38:
04/25/2007 08:20:10,spid60,Unknown,*        Ecx: 00000000:
04/25/2007 08:20:10,spid60,Unknown,*        Ebx: 00000000:
04/25/2007 08:20:10,spid60,Unknown,*        Eax: 5ADE8598:  00000000  00000000  5ADE85B0  00000000  00000000  00000000
04/25/2007 08:20:10,spid60,Unknown,*        Esi: 00000000:
04/25/2007 08:20:10,spid60,Unknown,*        Edi: 80C872F0:  7093AB12  80C87FF0  00000007  B8A20008  7093AB15  00000000
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* dbghelp                        14200000  14312FFF  00113000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       76780000  76913FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       764A0000  76633FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       76300000  76493FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       341D0000  343AFFFF  001e0000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       33590000  33764FFF  001d5000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       333F0000  33583FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       14490000  1467AFFF  001eb000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       13D10000  13EFBFFF  001ec000
04/25/2007 08:20:10,spid60,Unknown,* OLEDB32R                       13770000  13780FFF  00011000
04/25/2007 08:20:10,spid60,Unknown,* MSDART                         133D0000  133E9FFF  0001a000
04/25/2007 08:20:10,spid60,Unknown,* oledb32                        13350000  133C8FFF  00079000
04/25/2007 08:20:10,spid60,Unknown,* msxml3                         11BD0000  11CE1FFF  00112000
04/25/2007 08:20:10,spid60,Unknown,* msxmlsql                       11AF0000  11BC5FFF  000d6000
04/25/2007 08:20:10,spid60,Unknown,* System.Xml                     10FA0000  11193FFF  001f4000
04/25/2007 08:20:10,spid60,Unknown,* System.Security                10F20000  10F61FFF  00042000
04/25/2007 08:20:10,spid60,Unknown,* System                         10C10000  10EF3FFF  002e4000
04/25/2007 08:20:10,spid60,Unknown,* System.Security.ni             10A90000  10B45FFF  000b6000
04/25/2007 08:20:10,spid60,Unknown,* System.Transactions            0FAD0000  0FB12FFF  00043000
04/25/2007 08:20:10,spid60,Unknown,* System.ni                      7A440000  7ABFDFFF  007be000
04/25/2007 08:20:10,spid60,Unknown,* System.Data                    102D0000  10596FFF  002c7000
04/25/2007 08:20:10,spid60,Unknown,* mscorjit                       0F910000  0F962FFF  00053000
04/25/2007 08:20:10,spid60,Unknown,* SqlAccess                      0F8A0000  0F8F5FFF  00056000
04/25/2007 08:20:10,spid60,Unknown,* SensApi                        0F880000  0F884FFF  00005000
04/25/2007 08:20:10,spid60,Unknown,* cryptnet                       0F680000  0F691FFF  00012000
04/25/2007 08:20:10,spid60,Unknown,* SOFTPUB                        0F670000  0F674FFF  00005000
04/25/2007 08:20:10,spid60,Unknown,* mscorsec                       0F640000  0F652FFF  00013000
04/25/2007 08:20:10,spid60,Unknown,* mscorlib.ni                    0EAC0000  0F5A7FFF  00ae8000
04/25/2007 08:20:10,spid60,Unknown,* mscorwks                       080E0000  08640FFF  00561000
04/25/2007 08:20:10,spid60,Unknown,* xplog70                        07CA0000  07CA2FFF  00003000
04/25/2007 08:20:10,spid60,Unknown,* xplog70                        07C80000  07C8BFFF  0000c000
04/25/2007 08:20:10,spid60,Unknown,* xpstar90                       07C50000  07C75FFF  00026000
04/25/2007 08:20:10,spid60,Unknown,* odbcint                        07C30000  07C46FFF  00017000
04/25/2007 08:20:10,spid60,Unknown,* ATL80                          7C630000  7C64AFFF  0001b000
04/25/2007 08:20:10,spid60,Unknown,* BatchParser90                  07A40000  07A5EFFF  0001f000
04/25/2007 08:20:10,spid60,Unknown,* ODBC32                         07A00000  07A3CFFF  0003d000
04/25/2007 08:20:10,spid60,Unknown,* SQLSCM90                       079E0000  079E8FFF  00009000
04/25/2007 08:20:10,spid60,Unknown,* xpstar90                       07980000  079C7FFF  00048000
04/25/2007 08:20:10,spid60,Unknown,* xpsqlbot                       07960000  07965FFF  00006000
04/25/2007 08:20:10,spid60,Unknown,* msftepxy                       07490000  074A4FFF  00015000
04/25/2007 08:20:10,spid60,Unknown,* SQLNCLIR                       007A0000  007D2FFF  00033000
04/25/2007 08:20:10,spid60,Unknown,* comdlg32                       762B0000  762F9FFF  0004a000
04/25/2007 08:20:10,spid60,Unknown,* COMCTL32                       77530000  775C6FFF  00097000
04/25/2007 08:20:10,spid60,Unknown,* sqlncli                        337A0000  339C1FFF  00222000
04/25/2007 08:20:10,spid60,Unknown,* CLBCatQ                        777B0000  77832FFF  00083000
04/25/2007 08:20:10,spid60,Unknown,* xpsp2res                       10000000  102C4FFF  002c5000
04/25/2007 08:20:10,spid60,Unknown,* ntdsapi                        766F0000  76704FFF  00015000
04/25/2007 08:20:10,spid60,Unknown,* wshtcpip                       070B0000  070B7FFF  00008000
04/25/2007 08:20:10,spid60,Unknown,* hnetcfg                        071F0000  07248FFF  00059000
04/25/2007 08:20:10,spid60,Unknown,* dssenh                         070C0000  070E3FFF  00024000
04/25/2007 08:20:10,spid60,Unknown,* imagehlp                       76C10000  76C38FFF  00029000
04/25/2007 08:20:10,spid60,Unknown,* WINTRUST                       76BB0000  76BDAFFF  0002b000
04/25/2007 08:20:10,spid60,Unknown,* dbghelp                        06C10000  06D22FFF  00113000
04/25/2007 08:20:10,spid60,Unknown,* msfte                          069B0000  06C08FFF  00259000
04/25/2007 08:20:10,spid60,Unknown,* security                       06190000  06193FFF  00004000
04/25/2007 08:20:10,spid60,Unknown,* rasadhlp                       76F80000  76F84FFF  00005000
04/25/2007 08:20:10,spid60,Unknown,* winrnr                         76F70000  76F76FFF  00007000
04/25/2007 08:20:10,spid60,Unknown,* DNSAPI                         76ED0000  76EF8FFF  00029000
04/25/2007 08:20:10,spid60,Unknown,* RESUTILS                       05D50000  05D62FFF  00013000
04/25/2007 08:20:10,spid60,Unknown,* CLUSAPI                        05D30000  05D41FFF  00012000
04/25/2007 08:20:10,spid60,Unknown,* OLEAUT32                       77D00000  77D8BFFF  0008c000
04/25/2007 08:20:10,spid60,Unknown,* WSOCK32                        71BB0000  71BB8FFF  00009000
04/25/2007 08:20:10,spid60,Unknown,* VERSION                        77B90000  77B97FFF  00008000
04/25/2007 08:20:10,spid60,Unknown,* MTXCLU                         05D10000  05D28FFF  00019000
04/25/2007 08:20:10,spid60,Unknown,* msvcp60                        780C0000  78120FFF  00061000
04/25/2007 08:20:10,spid60,Unknown,* MSDTCPRX                       05C90000  05D07FFF  00078000
04/25/2007 08:20:10,spid60,Unknown,* XOLEHLP                        05C80000  05C85FFF  00006000
04/25/2007 08:20:10,spid60,Unknown,* COMRES                         77010000  770D5FFF  000c6000
04/25/2007 08:20:10,spid60,Unknown,* schannel                       76750000  76776FFF  00027000
04/25/2007 08:20:10,spid60,Unknown,* cryptdll                       766E0000  766EBFFF  0000c000
04/25/2007 08:20:10,spid60,Unknown,* kerberos                       05BC0000  05C17FFF  00058000
04/25/2007 08:20:10,spid60,Unknown,* iphlpapi                       76CF0000  76D09FFF  0001a000
04/25/2007 08:20:10,spid60,Unknown,* msv1_0                         76C90000  76CB6FFF  00027000
04/25/2007 08:20:10,spid60,Unknown,* MSCOREE                        05950000  05994FFF  00045000
04/25/2007 08:20:10,spid60,Unknown,* AUTHZ                          76C40000  76C53FFF  00014000
04/25/2007 08:20:10,spid60,Unknown,* rsaenh                         04E90000  04EBEFFF  0002f000
04/25/2007 08:20:10,spid60,Unknown,* WLDAP32                        76F10000  76F3DFFF  0002e000
04/25/2007 08:20:10,spid60,Unknown,* SAMLIB                         5CCF0000  5CCFEFFF  0000f000
04/25/2007 08:20:10,spid60,Unknown,* ole32                          77670000  777A3FFF  00134000
04/25/2007 08:20:10,spid60,Unknown,* NTMARTA                        77E00000  77E21FFF  00022000
04/25/2007 08:20:10,spid60,Unknown,* SQLOS                          344D0000  344D4FFF  00005000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       4F610000  4F7A3FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* instapi                        48060000  48069FFF  0000a000
04/25/2007 08:20:10,spid60,Unknown,* psapi                          76B70000  76B7AFFF  0000b000
04/25/2007 08:20:10,spid60,Unknown,* comctl32                       77420000  77522FFF  00103000
04/25/2007 08:20:10,spid60,Unknown,* SHLWAPI                        77DA0000  77DF1FFF  00052000
04/25/2007 08:20:10,spid60,Unknown,* SHELL32                        7C8D0000  7D0D2FFF  00803000
04/25/2007 08:20:10,spid60,Unknown,* NETAPI32                       71C40000  71C97FFF  00058000
04/25/2007 08:20:10,spid60,Unknown,* opends60                       333E0000  333E6FFF  00007000
04/25/2007 08:20:10,spid60,Unknown,* USERENV                        76920000  769E3FFF  000c4000
04/25/2007 08:20:10,spid60,Unknown,* WS2HELP                        71BF0000  71BF7FFF  00008000
04/25/2007 08:20:10,spid60,Unknown,* WS2_32                         71C00000  71C16FFF  00017000
04/25/2007 08:20:10,spid60,Unknown,* MSWSOCK                        71B20000  71B60FFF  00041000
04/25/2007 08:20:10,spid60,Unknown,* Secur32                        76F50000  76F62FFF  00013000
04/25/2007 08:20:10,spid60,Unknown,* MSASN1                         76190000  761A1FFF  00012000
04/25/2007 08:20:10,spid60,Unknown,* CRYPT32                        761B0000  76242FFF  00093000
04/25/2007 08:20:10,spid60,Unknown,* GDI32                          77C00000  77C47FFF  00048000
04/25/2007 08:20:10,spid60,Unknown,* USER32                         77380000  77411FFF  00092000
04/25/2007 08:20:10,spid60,Unknown,* RPCRT4                         77C50000  77CEEFFF  0009f000
04/25/2007 08:20:10,spid60,Unknown,* ADVAPI32                       77F50000  77FEBFFF  0009c000
04/25/2007 08:20:10,spid60,Unknown,* MSVCP80                        7C420000  7C4A6FFF  00087000
04/25/2007 08:20:10,spid60,Unknown,* msvcrt                         77BA0000  77BF9FFF  0005a000
04/25/2007 08:20:10,spid60,Unknown,* MSVCR80                        78130000  781CAFFF  0009b000
04/25/2007 08:20:10,spid60,Unknown,* kernel32                       77E40000  77F41FFF  00102000
04/25/2007 08:20:10,spid60,Unknown,* ntdll                          7C800000  7C8BFFFF  000c0000
04/25/2007 08:20:10,spid60,Unknown,* sqlservr                       01000000  02BCEFFF  01bcf000
04/25/2007 08:20:10,spid60,Unknown,*  MODULE                          BASE      END       SIZE
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*   Access Violation occurred reading address 00000000
04/25/2007 08:20:10,spid60,Unknown,*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
04/25/2007 08:20:10,spid60,Unknown,*   Exception Address = 0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*   04/25/07 08:20:10 spid 60
04/25/2007 08:20:10,spid60,Unknown,* BEGIN STACK DUMP:
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* *******************************************************************************
04/25/2007 08:20:10,spid60,Unknown,SqlDumpExceptionHandler: Process 60 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
04/25/2007 08:20:10,spid60,Unknown,***Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0006.txt
04/25/2007 08:20:10,spid60,Unknown,Using 'dbghelp.dll' version '4.0.5'

View Replies !   View Related

---

Entreprise Manager Error Message: &"[Microsoft][ODBC SQL ServerDriver][SQL Server]Login Failed For User '#####'. The User Is Not Associatedwith A Trusted SQL Server Connection.(28000,18452)&"
Can anyone give a quick description of the meaning of this message andwhat needs to be done to get a connection.I'm running DBArtisan with SQLServer 2000 client SP4 installed.I also get the same message with MS Enterprise Manager so this iscoming out of the actual ODBC connection attempt.Thanks in advance!

View Replies !   View Related

---

Error Message: Failed To Generate A User Instance Of SQL Server. Only An Integrated Connection Can Generate A User Instance
 Hello everybody,I was configuring a SqlDataSource control using SQL Authentication mode.I first added a database file (testdb.mdf) through Solution Explorer-Add New Items. Then through Database Explorer I created a table named "info"Then while configuring  the SqlDataSource control I used the SQL Authentication mode and attached the "testdb.mdf" database file.Test Connection showed success. But when I hit the Ok button of the wizard it displayed the following error message:Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance.While configuring the  SqlDataSource control I clicked "New Connection". Under Data Source section I tried both Microsoft SQL Server and Microsoft SQL Server Database File. And in both the cases I attached a databese file(testdb.mdf).          Plz enlighten me on this.Thanks and Regards,Sankar. 

View Replies !   View Related

---

One User Unable To Access The Reports From SQL Server 2005 Reporting Server.
I have deployed some reports on the reporting server, i have noticed that every one in the domain in which the reports are published can access the reports, except one user. when he tries to access the report he got the following  error message or the blank report.

"An error occured during report processing"

"can no read the next data row for the data set dataset1".

Although this user has all the roles on the reporiting server kike browser,content manager etc.

 

i tried many things but still problem persists.

 

Can anyone tell me the exact reason for this ?

I shall be extremely thankfull.

 

 

 

View Replies !   View Related

---

I Am Getting An Error Message When I Try To Print Using Reporting Services: &&"an Error Occurred During Printing (0x80004005)&&"
I am getting an error message when I try to print using reporting services: "an error occurred during printing (0x80004005)"

View Replies !   View Related

---

Can I Add User In Reporting Services With Command Line Or Web Services
Can I add user in Reporting Services with command line or web services?

I can't find the way to add user in Reporting Services with command line or web services. Are we have another way to add user in Reporting Services by web portal ( http://<machinename>/reports ).

Thanks for all answers.

iRat

View Replies !   View Related

---

Link Server Error: Login Failed For User 'Domainuser'. (Microsoft SQL Server, Error: 18456)
 
Hi,
 
I am trying to create a linked server between 2 SQL Server 2005 boxes.
When I create the linked server I specify a login for the connection.
The strange part is that I get the following error when it goes to test the connection:
 
The test connection to the linked server failed
Login failed for user 'Domainuser'. (Microsoft SQL Server, Error: 18456)
 
 
I can use the SQL mangement studio to conenct to the database using this same login.
The login has all the server roles assigned to it also.
 
Can anyone shed some light as to what may be the problem?
 
 
Thanks,
 
 

View Replies !   View Related

---

Reporting Error
I have problem,in the reporting services.I generated a report which gives me total of 5 pages.

When I export the page to Acrobat,it shows me up with 10 pages.It pints every alternate page as blank.Here it shows 5 page of report,but alternate page is blank.And making sum of 10.

 

Please help me .

 

 

View Replies !   View Related

---

Reporting Error
Hi,

 

  How i can hide the "error: Subreport could not be shown" message when record set returns null.

In debug window actual error is :

[rsRuntimeErrorInExpression] The Value expression for the textbox €˜textbox6€™ contains an error: The query returned no rows for the data set. The expression therefore evaluates to null.

 

 

Many thanks

soha;

View Replies !   View Related

---

Login Failed For User '[USER]'. The User Is Not Associated With A Trusted SQL Server Connection.
Server Error in '/Forums' Application.

can u help me how to find a solution to this:Server Error in '/Forums' Application.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.Data.SqlClient.SqlException:
Login failed for user '"[user]"'. The user is not associated with a
trusted SQL Server connection.

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.

View Replies !   View Related

---

How Do We Determine Which User Database Tables Are Mostly Retrieved By User Or Modified By User?
 

Hi,
     Please give the T-SQL  script for this ? Thanks
 
Shanth
 
  
 

View Replies !   View Related

---