Ent Mgr. Management-CurrentActivity-Application - Error?
I'm having a problem with couple of users on our network not connecting to SQL exactly right. In the CurrentActivity window under the application column these users are not showing the authenticated usernames. Example: it should be username@computername but all that shows is @computername. These users get weird security problems that I have not been able to resolve. Our network admin is looking into it but he's not sure why these users should be any different than the rest. Any suggestions?
View Complete Forum Thread with Replies
Related Forum Messages:
Security Error When Execute Sp From An Application, But Not From SQL Management Studio.
Hello, I am facing a very odd behavior with SQL server 2005. I have a database role with specific permissions to execute only some of the stored procedures in the database. I also have a SQL login/user attached to the role. If I execute one of the stored procedures from the application (web application, with Microsoft enterprise library database block) I am getting a security error stating that I need select permission for the schema. However, If I execute the same sp with the same parameters from SQL management studio, connecting with the same SQL login as in the application I can execute the sp without any security errors. The SQL management studio is in on a different server than the targeted database. Are there any differences between executing stored procedures from SQL MS and from application when using the same SQL login? Thanks, IT
View Replies !
Web Application And Role Management In Sql Server 2005
Hi every body I'm developing a web application and i like to use the sql server 2005 role management features istead of developing a role management package in my program, I can do it on my tables and othe database items but I have no idea about using database access rights in my web pages to permit some one viewing or updating a web form... Is there any system table or system stored procedure showing access rights in my data base? or is there another idea to do this?? by Thanks Javaneh
View Replies !
User Token Is Different When SP Is Executed In Management Studio Vs Application
Hello, I have a stored procedure that outputs login token and user token information. The stored procedure has WITH EXECUTE AS CALLER specified. When I execute the stored procedure from Management Studio I get the following output from the stored procedure <login_token pid="267" sid="AQUAAAAAAAUVAAAAdbl1VI3r6l4jX2Nr0AYAAA==" name="MYDOMAINjoe" type="WINDOWS LOGIN" /> <login_token pid="2" sid="Ag==" name="public" type="SERVER ROLE" /> <login_token pid="3" sid="Aw==" name="sysadmin" type="SERVER ROLE" /> <login_token pid="257" sid="AQIAAAAAAAUgAAAAIAIAAA==" name="BUILTINAdministrators" type="WINDOWS GROUP" /> ... (more groups) <user_token pid="7" sid="AQUAAAAAAAUVAAAAdbl1VI3r6l4jX2Nr0AYAAA==" name="MYDOMAINjoe" type="WINDOWS LOGIN" /> <user_token pid="0" name="public" type="ROLE" /> <user_token pid="5" sid="AQUAAAAAAAUVAAAAdbl1VI3r6l4jX2NrCAUAAA==" name="MYDOMAINPeople" type="WINDOWS GROUP" /> <user_token pid="16" name="approleDirector" type="ROLE" /> <user_token pid="16384" name="db_owner" type="ROLE" /> When I execute the stored procedure through my application (IIS application connecting to SQLServer 2005 through SQL Native Client - not .NET) I get the following <login_token pid="267" sid="AQUAAAAAAAUVAAAAdbl1VI3r6l4jX2Nr0AYAAA==" name="MYDOMAINjoe" type="WINDOWS LOGIN" /> <login_token pid="2" sid="Ag==" name="public" type="SERVER ROLE" /> <login_token pid="3" sid="Aw==" name="sysadmin" type="SERVER ROLE" /> <login_token pid="257" sid="AQIAAAAAAAUgAAAAIAIAAA==" name="BUILTINAdministrators" type="WINDOWS GROUP" /> ... (more groups) <user_token pid="1" sid="AQUAAAAAAAUVAAAAdbl1VI3r6l4jX2Nr4QQAAA==" name="dbo" type="WINDOWS LOGIN" /> The login token is the same but the user token is dbo instead of the actual user. What am I doing wrong? Thanks.
View Replies !
Reporting Services Section Is Not Showing Under Application Management
Hi, I installed Reporting Services Add-in for Sharepoint 2007, on my Server where i have both Sharepoint 2007 and SQL Server 2005 and report Server are installed, i already installed SQL Server SP2, but in SharePoint 3.0 Central Administration under Application Management Reporting Services section is not Showing. Please let me know if anybody has the got the same issue and fix it. Thanks Ahsan
View Replies !
Different Results When Running Procedure From Management Studio Vs Application Code
I'm updating a process that recreates a large table every night. The table is the result of a bunch of nightly batch processes and holds a couple million records. In the past, each night at the end of the batch jobs the table would be dropped and re-created with the new data. This process was embodied in dynamic sql statements from an MFC C++ program, and my task is to move it to a SQL Server 2000 stored procedure that will be called from a .Net app. Here's the relevant code from my procedure: sql Code: Original - sql Code -- recreate new empty BatchTable table print 'Dropping old BatchTable table...' exec DropBatchTable --stored procedure called from old code that does a little extra work when dropping the table -- validate drop If exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BatchTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) Begin RAISERROR( 'Unable to drop old BatchTable!',0,1) WITH NOWAIT End Else Begin print 'Old BatchTable dropped.' End print 'Creating new BatchTable...' SELECT TOP 0 *, cast('' as char(3)) as Client, cast('' as char(12)) as ClientDB INTO dbo.BatchTable FROM differentDB.dbo.BatchArchives --validate create If Not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BatchTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) Begin RAISERROR( 'Unable to create new BatchTable!',0,1) WITH NOWAIT End Else Begin print 'New BatchTable Created.' End -- recreate new empty BatchTable table print 'Dropping old BatchTable table...' exec DropBatchTable --stored procedure called from old code that does a little extra work when dropping the table -- validate drop IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[BatchTable]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN RAISERROR( 'Unable to drop old BatchTable!',0,1) WITH NOWAIT END ELSE BEGIN print 'Old BatchTable dropped.' END print 'Creating new BatchTable...' SELECT TOP 0 *, CAST('' AS CHAR(3)) AS Client, CAST('' AS CHAR(12)) AS ClientDB INTO dbo.BatchTable FROM differentDB.dbo.BatchArchives --validate create IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[BatchTable]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN RAISERROR( 'Unable to create new BatchTable!',0,1) WITH NOWAIT END ELSE BEGIN print 'New BatchTable Created.' END The print statements are there because the .net app will read them in and then write them to a log file. Some of the other mechanics are there to mimic the old process. The idea is to duplicate the old process first and then work on other improvements. This works in Management studio. The .Net App reports that the old table was dropped, but when it tries to create the new table it complains that "There is already an object named 'BatchTable' in the database." I have verified that the old table is removed. Any ideas on how to fix this?
View Replies !
Service Broker Application Is Getting Error + Connection Attempt Failed With Error: '10060
hi , i am creating a service broker application between two different instance.when i am initiating a dialog from the source my message remain in the sys.transmission_queue.but its transmission_status column is empty. i attached the profiler with both source and target by including all the service broker event. in my source profiler i am getting the error like -- Connection attempt failed with error: '10061(No connection could be made because the target machine actively refused it.)'. with event Broker:connection and in the target profiler error is --This message could not be delivered because the security context could not be retrieved. with event Broker:Message Undelivarible. i have checked my port also using telnet with remotely and localy both working fine. i am using port no. 4001 and i have mentioned the port no. in the address of the route. bt still getiing the error. please help!!!!!!!!!!!
View Replies !
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 eports2cbaf422c4330628assemblydl3a890e9c0 068591f_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 eports2cbaf422c4330628assemblydl34a099978 068591f_f54cc701ReportingServicesEmailDeliveryProvider.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727mscorlib.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628assemblydl3de5a2332 0958a20_f54cc701ReportingServicesWebUserInterface.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628assemblydl3498aee86 042473c_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 eports2cbaf422c4330628assemblydl3cd47089b 0f2a80e_f54cc701Microsoft.ReportingServices.Interfaces.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628assemblydl3f180608d 0083daf_b16dc701Microsoft.ReportingServices.Diagnostics.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628assemblydl323449648 068591f_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 !
Problem With One Application With The Error:26 - Error Locating Server/instance Specified
Hello all! I have been researching this problem on the net. I have everything setup, here is the wierd part. I did a test windows application, and that application connects into my database just fine. I have SQL DEV 2005, everything is on my laptop. I have websites that I have wrote that connects fine. I have application that give me this error. Now the only thing is that I wrote this windows app on a diffrent machine, with a diffrent SQL 2005 server. I had to move everything on my laptop, so I can finish on site at the clients place. So I grabbed the project, copied it over, and opened it on my laptop. No problems. I created a new database, scripted everything from the other server, and ran those scripts on my laptop to create the tables, SP etc. Now my test application I created on my laptop, I can connect to the databse just fine with this string. <add name="TestDataGrid.My.MySettings.TestConnectionString" connectionString="Data Source=MKE01-2N92461;Initial Catalog=TestDB;Integrated Security=True" providerName="System.Data.SqlClient" /> I can also connect to the database that I brought over from the other server. Could there be somthing with the Datasets, or something like that? Any Thoughts? TIA! Rudy
View Replies !
Application Error
We are running a news paper website on Windows 2003 IIS and MSSQL 2005. I'm facing the error shown bellow. I'm not an MSSQL expert not an ASP or ASP .net developer. I need some help here to pinpoint the issue. Is it a OS / DB / MSSQL / ASP / ASP .net / Developer bug! The error Server Error in '/' Application. Transaction (Process ID 64) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. 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: Transaction (Process ID 64) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): Transaction (Process ID 64) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857466 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735078 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlDataReader.HasMoreRows() +150 System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +214 System.Data.SqlClient.SqlDataReader.Read() +9 System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue) +39 System.Data.SqlClient.SqlCommand.ExecuteScalar() +148 database.setonline(String pagetitle) +262 _Default.Page_Load(Object sender, EventArgs e) +3831 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061 Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
View Replies !
Error In Application Log
The application log keeps generating this error message and I can't seem to find any information on it. Can anyone shed some light? Event filter with query "select * from __InstanceModificationEvent within 10 where TargetInstance isa 'Win32_Service'" could not be (re)activated in namespace "//./root/Microsoft/SqlServer/ComputerManagement" because of error 0x80041010. Events may not be delivered through this filter until the problem is corrected.
View Replies !
Application Error
System always popup this message: Application popup: oprd.exe - Application Error : The application failed to initialize properly (0xc0000142). Click on OK to terminate the application.
View Replies !
Error Management
Hi everybody, I have an issue with my error management. For the moment i redirect all the row in a script componnent and then use getErrordescription(errorCode). This method is quite good. But for error on constraint in my database this not good way beacause the error message is similar to "Data violate integrity constraint" but we can't knonw which constraint. So i think that i will use the onError event. I made some test and it's good. But with my old method I know on which row on the flat file source the error happens. So my questions are : - is there a way to know on which row the error occurs inthe onError event? - is that possible to redirect row and have also the onError event? (I think it's impossible) - How can i know on which data the error come? Thanks for your reply. Christophe
View Replies !
Adventureworks Application Error
I am using ms sql server 2005 Enterprise Evaluation Edition, and I can use the other sample dtabases, like pubs, northwind, but not adventureworksI tried diffrent ways, I am very new to this, and I try before I ask, and I had to give up, Here is what I didwhen I installed adventureworks it was like 166 mb. bigAnd when I tried to use it with visual studio, every time I want to drag a table from: data connections/adventureworks, and try to veiw it in borwser it gives me an application server error, and invalid object namewith northwind database works finethen I tried executing instawdb.sql located C:Progam filesMicrosoft SQL Server90ToolsSamplesAdventureWorks OLTP, from Sql server management studio,And it finishes with errors, and is only 122 mb. bigThis line in red:Msg 4861, Level 16, State 1, Line 1Cannot bulk load because the file "C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATAAWDBAddress.csv" could not be opened. Operating system error code 3(error not found).and at the end this:DBCC SHRINKDATABASE: File ID 1 of database ID 6 was skipped because the file does not have enough free space to reclaim.last night I was thinking wether it might be my OS( usning windows xp), or server evalution editionDoes anybody know something about this?I already google search and only found one person with the same problem, but there was no solution posted
View Replies !
Server Error In '/' Application.
Hi guys, I been having a problem, I have a project in asp.net 2.0 connecting to a database in sql server 2000, which works well if I run it from the VDE 2005, but when I pass the project to the IIS it fails, it gives me this error: Server Error in '/' Application. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)Source Error: Line 15: strSql = "exec sp_UsuaAuto '" & TxtUsuario.Text & "','" & TxtContraseña.Text & "'" Line 16: Dim DA1 As New Data.SqlClient.SqlDataAdapter(strSql, CnnSql) Line 17: DA1.Fill(Dsa, "Usr") Line 18: strSql = "exec SP_SistemAuto '" & TxtUsuario.Text & "','2'" Line 19: Dim DA2 As New Data.SqlClient.SqlDataAdapter(strSql, CnnSql) I have been reviewing solutions in the forum but I haven't being able to solve the problem. Any help would be great, thanks.
View Replies !
Application Login SQL Error
I created a ASP.net 2.0 application using C# on VS2005 The application access several database on a remote SQL Server 2005I recently added Login functionalties to the application, this created a MDF in the app_data folder.Everything works fine on my local desk top... I can access my remote SQL Server 2005 and the local MDF file works fine, I can create account, login and all that fun stuffSo I Published the site to my target server:Which is the same server running the SQL Server 2005 The parts of the application that does not require login works fine, I can access the SQL server 2005 with ease..see data, update, everythingHowever when ever I try to login or create an account from the application(MDF file) I get this:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)I can only assume that the problem is with the MDF file. Can anyone point me in the right direction?Thank you Andre
View Replies !
Server Error In '/' Application
I have just upload my site to a which is going to be host the site, the thing is the site runs great on my PC. But when i login or do a search i get an error " Server Error in '/' Application" i know its something to do with the Web config as i read something on here about it but i cant find that post now. Site URl http://www.team-nat.co.uk Try the login or click on the stolen marker link and you will see the error im getting. This is my web config. <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"> <appSettings/> <connectionStrings> <add name="DatabaseConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename="C:Documents and SettingsickMy DocumentsVisual Studio 2005marker-regApp_DataDatabase.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient" /> <add name="DatabaseConnectionString1" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient" /> <add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> <add name="ConnectionString2" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|markers.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> <add name="ConnectionString3" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ews.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> <add name="ConnectionString4" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|messages.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings> <system.web> I know its something to do with the connectionStrings as its pointing to my PC and not at where it should be at the server its running on but i have spent the last 3 hours editing the web config but it does not matter what i do i cant get it to work. What am i missing here? Ps Im new to ASP. Thanks
View Replies !
SQL Error In Application Log File
Greetings,I am getting a flow of error messages:Error: 17805, Severity: 20, State: 3Invalid buffer received from client.Can anyone shed some light as to how to get rid of them or resolve anyissues that may be causing it?Any assistance would be greatly appreciated.Thank you...Regards,JS
View Replies !
Sqlmangr.exe - Application Error
Dear Friends, I am getting the error in the subject with error dialog and some instruction at downside. The instruction at "0x780011cd" referenced memorey at "0x009e99af". The Memory couldnt be "read". Click on Ok to terminate the program Click on Cancel to debug the program. Plz. help me in this regard. Mit.
View Replies !
DTS Package :MMC.exe - Application Error
Hi when i open my DTS package on DTS design , and when i go through different connection and test connection it successfully , when i cancell the step properties i got the error below and thw whole enteprise manager closes, i do not have ant problem with other dts packages except two of them which keep giving me the error below any suggestions MMC.exe - Application Error 'The instruction @ "0x10001919" referenced memory @ "0x00000004." The memory could not be "read
View Replies !
MMC Application Error - Cluster
Hi, I have installed Sqlserver 7.0 in cluster environment (Active/ passive) After installation I clicked the enterprise manager it gave an error Dr Watson mmc.exe application error. Data corrupted use Check disk. I shut down and restarted the server (node 1). when I click the enterprise manager error "not suitable file for mmc" comes. But I am able to run the query analyser. Note: I didn't start any services. Whatever the services that was running i didn't disturb. Kindly advice me reg. this asap. Thanks in advance, Anu
View Replies !
SqlWb.exe - Application Error
I've installed the SQL Client Tools. Immediately after launching the application I get this 'SqlWb.exe - application error: The application failed to initialize properly (0x80000003). Click Ok to terminate the application'. I've tried this on two different computers and get the same results. I've also installed SP2 and still get the same errors. Any ideas on how to resolve this.
View Replies !
Sqlserver.exe-Application Error
Hi All, I am trying to install Sql Server 2005 Express edition in my system.But In the middle of installation system is simply restarting.And giving following error. sqlserver.exe-Application Error The Exception unknown software exception(0xc06d007e) occured in the application at location 0x7c59bc81. I can't able find why this error is coming. Anyone please help me. Thanks in Advance
View Replies !
Server Error In '/' Application
Hi, I have created some reports and published them in a customised web site(company dashboard server). Once I click the report, it opens up with Internet Explorer provided by the company(I guess report viewer is embeded in IE). But the problem is when I try to save it in excel or pdf version, I get the following long error message. --------------------------------------------------------------------------------------------------------------------------------- Server Error in '/' Application. Execution 'qd2fh4454r0f3n550oavg22t' cannot be found (rsExecutionNotFound) 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: Microsoft.Reporting.WebForms.ReportServerException: Execution 'qd2fh4454r0f3n550oavg22t' cannot be found (rsExecutionNotFound) Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [ReportServerException: Execution 'qd2fh4454r0f3n550oavg22t' cannot be found (rsExecutionNotFound)] Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +367 Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId) +118 Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters) +101 Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +430 Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +277 Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +10 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +303 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64 Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832 --------------------------------------------------------------------------------------------- Alos if the report has more than one page, I can view only first page. It wont let me to see the second page. Can anyone help me how to fix this error? really appriciate
View Replies !
Application Failover Error
We currently have a system that uses sql server 2005 mirroring. In testing the application, we fail over the database in the middle of a 2.0 .NET web application. The failover partner is specified in the connection string. The next request to the web server results in an error page popping up with the message "A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)" This message only occurs for the first request to the web server, all subsequent requests sucessfully access the new failed over database. Thanks for any suggestions.
View Replies !
SQL Server Management Error
Hello Everyone and thanks for your help in advance. I have an installation of SQL Server 2005 Standard edition running on a Windows XP SP1. The SQL Server has been running fine for a couple of years, however, I have now encountered the error SQL Server Management Studio has encountered an error and needs to close. There have been no changes to the environment prior to this occurring. Within the event log, I see Event Type: ErrorEvent Source: .NET RuntimeEvent Category: NoneEvent ID: 1023Description:.NET Runtime version 2.0.50727.1433 - Fatal Execution Engine Error (79FFEE24) (80131506) and Event Type: ErrorEvent Source: .NET Runtime 2.0 Error ReportingEvent Category: NoneEvent ID: 1000Description:Faulting application sqlwb.exe, version 2005.90.3186.0, stamp 46bd8b58, faulting module mscorwks.dll, version 2.0.50727.1433, stamp 471ef729, debug? 0, fault address 0x000975c9. I am not really sure where to go from here. Any help on this topic is greatly appreciated.
View Replies !
Management Studio Error
When executing export data task and through the wizard to include column names within a flat file desitination and get the following error listed below. If you uncheck the box and don't include the column names it works correctly. Error - Pre-execute (Error) Messages Information 0x402090dc: Data Flow Task: The processing of file "C:Documents and Settings*Desktop est_2.txt" has started. (SQL Server Import and Export Wizard) Error 0xc0202095: Data Flow Task: Failed to write out column name for column "ClientSubGroupID". (SQL Server Import and Export Wizard) Error 0xc004701a: Data Flow Task: component "Destination - test_2_txt" (22) failed the pre-execute phase and returned error code 0xC0202095. (SQL Server Import and Export Wizard)
View Replies !
Server Error In '/website2' Application.
i have a login page and a create user page that worked fine when the aspnetdb was attached in mssql ... then i ran the aspnet_regsql.exe program on my database "web_data". then itried to change my web.,config file to reflect this change and now getting errors on both pages : Here is the error that is displayed locally... Cannot open user default database. Login failed ....seems to be same locally and on the site ... site does not give error details. Further down is my web.config file. any help would be appreciated Thanks this is the error from the newuser page after the form is filled out and the create user button is pressed: Server Error in '/website2' Application.-------------------------------------------------------------------------------- Cannot open user default database. Login failed.Login failed for user 'AESEDANjtigner'. 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: Cannot open user default database. Login failed.Login failed for user 'AESEDANjtigner'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): Cannot open user default database. Login failed.Login failed for user 'AESEDANjtigner'.] 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 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) +3629 System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() +305 System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) +105 System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +453 System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) +149 System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +17 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.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 this is my web.config file ... note the two connections strings .. one for my local host and the other for my site <?xml version="1.0"?><!-- Note: As an alternative to hand editing this file you can use the web admin tool to configure settings for your application. Use the Website->Asp.Net Configuration option in Visual Studio. A full list of settings and comments can be found in machine.config.comments usually located in WindowsMicrosoft.NetFrameworkv2.xConfig --><configuration> <configSections> <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"> <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"> <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/> <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"> <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/> <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/> <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/> <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/></sectionGroup></sectionGroup></sectionGroup></configSections> <connectionStrings> <!-- <add name="web_data" connectionString="Data Source=sql391.mysite4now.com,1433;Initial Catalog=web_data;User Id=*********;Password=******;;Integrated Security=True" providerName="SqlRoleProvider" /> --> <add name="web_data" connectionString="Data Source=JOHN-PCSQLEXPRESS;Initial Catalog=web_data;User Id=***********;Password=*******;;Integrated Security=True" providerName="SqlRoleProvider" /> </connectionStrings> <system.web> <roleManager enabled="true" defaultProvider="CustomizedRoleProvider"> <providers> <add connectionStringName="web_data" name="CustomizedRoleProvider" type="System.Web.Security.SqlRoleProvider" /> </providers> </roleManager> <membership> <providers> <add name="CustomizedMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="web_data" /> </providers> </membership> <!-- Set compilation debug="true" to insert debugging symbols into the compiled page. Because this affects performance, set this value to true only during development. --> <authorization> <allow roles="manager" /> </authorization> <!-- <roleManager enabled="true" /> --> <compilation debug="true"> <assemblies> <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/> <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/> <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/></assemblies></compilation> <!-- The <authentication> section enables configuration of the security authentication mode used by ASP.NET to identify an incoming user. --> <authentication mode="Forms" /> <!-- The <customErrors> section enables configuration of what to do if/when an unhandled error occurs during the execution of a request. Specifically, it enables developers to configure html error pages to be displayed in place of a error stack trace. <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm"> <error statusCode="403" redirect="NoAccess.htm" /> <error statusCode="404" redirect="FileNotFound.htm" /> </customErrors> --> <pages> <controls> <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> <add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/></controls></pages> <httpHandlers> <remove verb="*" path="*.asmx"/> <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> <add verb="GET,HEAD" path="ScriptResource.axd" validate="false" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/></httpHandlers> <httpModules> <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/></httpModules></system.web> <system.codedom> <compilers> <compiler language="c#;cs;csharp" extension=".cs" type="Microsoft.CSharp.CSharpCodeProvider,System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" warningLevel="4"> <providerOption name="CompilerVersion" value="v3.5"/> <providerOption name="WarnAsError" value="false"/></compiler> <compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" warningLevel="4"> <providerOption name="CompilerVersion" value="v3.5"/> <providerOption name="OptionInfer" value="true"/> <providerOption name="WarnAsError" value="false"/></compiler></compilers></system.codedom> <system.webServer> <validation validateIntegratedModeConfiguration="false"/> <modules> <remove name="ScriptModule"/> <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/></modules> <handlers> <remove name="WebServiceHandlerFactory-Integrated"/> <remove name="ScriptHandlerFactory"/> <remove name="ScriptHandlerFactoryAppServices"/> <remove name="ScriptResource"/> <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> <add name="ScriptResource" verb="GET,HEAD" path="ScriptResource.axd" preCondition="integratedMode" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/></handlers></system.webServer> <runtime> <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"> <dependentAssembly> <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/> <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/></dependentAssembly> <dependentAssembly> <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/> <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/></dependentAssembly></assemblyBinding></runtime><system.net> <mailSettings> <smtp from="Reservations"> <network host="mail.airportcoach.com" password="rawal" userName="reserve@airportcoach.com" /> </smtp> </mailSettings> </system.net></configuration>
View Replies !
Server Error In '/TutorialWebSite' Application.
in aspx page i have <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:AdventureWorksConnectionString %>" SelectCommand="SELECT * FROM Employee" ProviderName="<%$ ConnectionStrings:AdventureWorksConnectionString.ProviderName %>"></asp:SqlDataSource>in web.configI have <add name="AdventureWorksConnectionString" connectionString="Server=.SQLEXPRESS;Integrated Security=True;Database=AdventureWorks"providerName="System.Data.SqlClient" />when runing page i am getting this error. Server Error in '/TutorialWebSite' Application. Invalid object name 'Employee'. 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: Invalid object name 'Employee'.Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): Invalid object name 'Employee'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +95 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +82 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +3244 System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +52 System.Data.SqlClient.SqlDataReader.get_MetaData() +130 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +371 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1121 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +334 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +45 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +162 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +35 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +32 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +183 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +307 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +152 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2868 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +84 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +154 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +99 System.Web.UI.WebControls.GridView.DataBind() +24 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +91 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +101 System.Web.UI.Control.EnsureChildControls() +134 System.Web.UI.Control.PreRenderRecursiveInternal() +109 System.Web.UI.Control.PreRenderRecursiveInternal() +233 System.Web.UI.Control.PreRenderRecursiveInternal() +233 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4434Any idea???????????
View Replies !
Time Out Expired Error In .net Application
Hi, I have a problem in my .net application. I am executing a stored procedure from my .net application. The scope of this stored procedure is, 1.It should filter the records using several conditions(say it is Customer) 2.Using the filtered records, again some details are fetched(say it is transaction details) 3.For each and every transaction , Some of the details has to be updated in more than three tables, meanwhile the data to be updated is to be calculated (like tax amount, commision amount)which in turn calls two more stored procedures. my problem is .. if there are few records like 1000 or 2000, it is working fine... but if it exceeds like say 6000 records, i am getting Time out expired error in my application . If i catch the stored procedure exectution statement in sql profiler and execute it in Sql Query analizer , the stored procedure is executing properly but it takes nearly 6 minutes. How can i solve this problem. Please suggest me if i can work with any of the following options. 1)go for web services 2)go for windows services 3)optimize the stored procedure If any one know some better answer to solve my problem..please post it. Advance thanks bye by Durga
View Replies !
Event Viewer - Application Log Error
I keep getting the followingerrors in the Application Log every 2 minutesThe Open Procedure for service "ODBC" inDLL "C:WINNTsystem32ODBC32.DLL" failed. Performancedata for this service will not be available. Status codereturned is data DWORD 0.Followed by the error .....The local computer may not have the necessary registryinformation or message DLL files to display messages froma remote computer. The following information is part ofthe event: Error in d:mdac27sp1qfeodbccoredmperf.c(282), Access is denied.: Failed to openHKEY_LOCAL_MACHINESYSTEMCurrentControlSetServic esODBCPerformance.What Should I do to stop getting these messages. Pleasehelp.Thanks in advance.Regards,Tami
View Replies !
DTSRUN.exe Application Error Problem
Hi All,I am getting error message when Running DTS package through Scheduler.The message is"DTSRun.Exe Application error -The Instruction as 0x77f7dd66ereferenced memoryAt 0x30373534. The memory could not be written, Click OK to terminatethe Application"When same DTS package, I ran manually it works fine. I have SQL 2kwith SP3Running Win2k Advanced server with SP4.I appreciate any help!ThanksKris Patel
View Replies !
Could Not Create DTS.Application Because Of Error 0x800401F3
I am trying to run an ssis package from a classic asp web page. if I run it from the command line it works as expected. dtexec /f D:publishmypackage.dtsx however if I try to run it from the web page - I get the following error: "Could not create DTS.Application because of error 0x800401F3" I am assuming this is a permissions error - can anyone help? Can I run a dts package from classic asp?
View Replies !
Server Error In '/Reports' Application.
Hello, I am new to SQL 2005 reporting services. I get following error when I am trying to open Http://localhost/reports in IE. I have SQl 2005 developer installed on my Vista desktop. What is going on ? How can i Fix it? Thanks, Vinod Invalid URI: The Authority/Host could not be parsed. 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.UriFormatException: Invalid URI: The Authority/Host could not be parsed. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [UriFormatException: Invalid URI: The Authority/Host could not be parsed.] System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind) +1672122 System.Uri..ctor(String uriString) +17 Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode node, RSConfiguration configObject) +999 Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument() +928 Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +34 [ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.] Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +169 Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName) +64 Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location) +292 Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation) +135 Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +85 Microsoft.ReportingServices.UI.GlobalApp.Application_Start(Object sender, EventArgs e) +32 [HttpException (0x80004005): The report server has encountered a configuration error. See the report server log files for more information.] System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +3384970 System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +167 System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +270 System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext, IntPtr& errorMessage) +260 [HttpException (0x80004005): The report server has encountered a configuration error. See the report server log files for more information.] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3540923 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +69 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +669
View Replies !
Server Error In '/Reports' Application
Hi, suddenly my reporting services stopped working. Even after uninstalling SQL2005 and RS I still get the same error: Could not load file or assembly 'System.ApplicationHost, Version=7.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. 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.IO.FileNotFoundException: Could not load file or assembly 'System.ApplicationHost, Version=7.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [FileNotFoundException: Could not load file or assembly 'System.ApplicationHost, Version=7.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.] System.ServiceModel.WasHosting.MetabaseSettingsIis7.PopulateSiteProperties() +0 System.ServiceModel.WasHosting.MetabaseSettingsIis7..ctor() +54 System.ServiceModel.WasHosting.HttpModuleIis7..cctor() +29 [TypeInitializationException: The type initializer for 'System.ServiceModel.WasHosting.HttpModuleIis7' threw an exception.] [TargetInvocationException: Exception has been thrown by the target of an invocation.] System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) +0 System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) +103 System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache) +261 System.Activator.CreateInstance(Type type, Boolean nonPublic) +66 System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) +1036 System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) +114 System.Web.Configuration.Common.ModulesEntry.Create() +41 System.Web.Configuration.HttpModulesSection.CreateModules() +203 System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +781 System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +243 System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +106 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +317 I'm currently working on SQL2005 SP2 and Vista 32 ultimate. Any help would be appreciated, Bert
View Replies !
Server Error In '/Reports' Application
Hi, I just launching my report manager and this is what i get. Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: Unable to load file 'Microsoft.Web.UI.WebControls'. Source Error: Line 196:<add assembly="System.EnterpriseServices, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/> Line 197:<add assembly="System.Web.Mobile, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/> Line 198:<add assembly="*"/> Line 199:</assemblies> Line 200:</compilation> Source File: c:windowsmicrosoft.netframeworkv1.1.4322Configmachine.config Line: 198 Assembly Load Trace: The following information can be helpful to determine why the assembly 'Microsoft.Web.UI.WebControls' could not be loaded. === Pre-bind state information === LOG: DisplayName = Microsoft.Web.UI.WebControls (Partial) LOG: Appbase = file:///D:/Microsoft SQL Server/MSSQL/Reporting Services/ReportManager LOG: Initial PrivatePath = bin Calling assembly : (Unknown). === LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind). LOG: Post-policy reference: Microsoft.Web.UI.WebControls LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/reports/a14677b1/fcd14213/Microsoft.Web.UI.WebControls.DLL. LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/reports/a14677b1/fcd14213/Microsoft.Web.UI.WebControls/Microsoft.Web.UI.WebControls.DLL. LOG: Attempting download of new URL file:///D:/Microsoft SQL Server/MSSQL/Reporting Services/ReportManager/bin/Microsoft.Web.UI.WebControls.DLL. LOG: Publisher policy file is not found. LOG: No redirect found in host configuration file (C:WINDOWSMicrosoft.NETFrameworkv1.1.4322aspnet.config). LOG: Using machine configuration file from C:WINDOWSMicrosoft.NETFrameworkv1.1.4322configmachine.config. LOG: Post-policy reference: Microsoft.Web.UI.WebControls, Version=1.0.1199.31179, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300 I rebooted the server, and still have the same results... this was working fine last week. Any help would be appreciated.. Thanks,
View Replies !
Reportbuilder.application Authentication Error
This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error: PLATFORM VERSION INFO Windows : 5.1.2600.131072 (Win32NT) Common Language Runtime : 2.0.50727.42 System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200) mscorwks.dll : 2.0.50727.42 (RTM.050727-4200) dfdll.dll : 2.0.50727.42 (RTM.050727-4200) dfshim.dll : 2.0.50727.42 (RTM.050727-4200) SOURCES Deployment url : https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected: + Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed. + The remote server returned an error: (401) Unauthorized. COMPONENT STORE TRANSACTION FAILURE SUMMARY No transaction error was detected. WARNINGS There were no warnings during this operation. OPERATION PROGRESS STATUS * [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started. ERROR DETAILS Following errors were detected during this operation. * [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype) - Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed. - Source: System.Deployment - Stack trace: at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next) at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles() at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState) at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation) at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation) at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options) at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut) at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state) --- Inner Exception --- System.Net.WebException - The remote server returned an error: (401) Unauthorized. - Source: System - Stack trace: at System.Net.HttpWebRequest.GetResponse() at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next) COMPONENT STORE TRANSACTION DETAILS No transaction informtion is available. ------------------------------- Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines: Laptop -Windows XP Pro -ASP.NET Validation Tool -Visual Basic Express w/ SQL Server Express -.NET 1.1/2.0 Framework Desktop -Windows XP Home -Visual Studio 2005 Professional -.NET 1.1/2.0 Framework Server -Windows Server 2003 Enterprise -SQL Server 2005 -.NET 1.1/2.0 Framework Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!
View Replies !
Need Help ---- Server Error In '/ReportServer' Application
I created a report project with the sales report followed by the SQL Server tutorial. But when I tried to publish a report. I got the following problem: 1. The connection could not made to the report server http://machinename/ReportServer 2. Server Error in '/ReportServer' Application. Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:inetpubwwwroot' because access is denied. Source Error: [No relevant source lines] Source File: c:inetpubwwwrootweb.config Line: 0 Could anyone give me some ideas to fix this problem? Thanks
View Replies !
Error Connecting To SQL Express DB From ASP.NET 2.0 Web Application.
How do I get rid of this error message when tring to log into my web site user account stored on the default ASP.NET 2.o generated database on my local computer? Server Error in '/FundACure.org' Application. Cannot open user default database. Login failed. Login failed for user 'LANBOYASPNET'. Where "LANBOY" is the name of my computer. I am logged in as myself "LANBOYKEVIN" My web page is trying to log into the server using the name "ASPNET" which I assume is a standard ASPNET user name. I thought it was failing because I needed to grant access to this user in the server, so I added the account for the server. Same problem. So I thought I needed to create this user in my Windows XP user list. When I tried it said "this user already exists" even though it isn't displayed in the list. That is when I realized that it is a standard user established by ASP.NET. It is probably supplied in the C# code through a base class. So, how do I get this DB to connect? Is the user missing, or is it that my connection string is wrong?
View Replies !
An Error While Trying To Read .sdf File From The Pc Application ? Please Help
hi i have a problem with reading sql mobile database existed on the pc i made a sql mobile database connection with ( Add New Datasource ) and then set the datasource of dataviewgrid to display the returned dataset . at run time i have an exception said : cann't find the library with the name sqlceme.dll as i remember , can you help me solving this problem because i very need this step , please ? regards
View Replies !
Server Error In '/XCopyDeploy' Application
hi there, i'm using visual web developer express edition 2005 to make internal web site using asp.net and sql server 2005 express,sql server management studio for attaching the db(company.mdf),windows xp professional and IIS for deploying the project.the project is working fine when i run it using localhost with explorer only the default page is running but when i access the other pages which have connection with the DB i got this error Unable to open the physical file "D:XCopyDeployApp_Datacompany.mdf". Operating system error 5: "5(error not found)". An attempt to attach an auto-named database for file D:XCopyDeployApp_Datacompany.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. 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: Unable to open the physical file "D:XCopyDeployApp_Datacompany.mdf". Operating system error 5: "5(error not found)". An attempt to attach an auto-named database for file D:XCopyDeployApp_Datacompany.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): Unable to open the physical file "D:XCopyDeployApp_Datacompany.mdf". Operating system error 5: "5(error not found)". An attempt to attach an auto-named database for file D:XCopyDeployApp_Datacompany.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734963 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +41 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360 the connection string is <connectionStrings> <add name="companyConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=D:XCopyDeployApp_Datacompany.mdf;Integrated Security=SSPI;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings> the strange thing is!.when i put the port number in the path.it worked fine but this when i open the visual studio (http://localhost:1324/XCopyDeploy/vaccation.aspx) but when i closed the visual studio i got the same error!/ also, i should deploy the project on web server (windows server 2003) using same tools what should i do to fix this error.im adminstrator on my machine and the server also.
View Replies !
Error Connecting In Management Studio
Hello, I am having problems connecting to my SQL Server instance with Management Studio; basically the setup is as follows; *Single server running windows 2003 enterprise - in a workgroup not domain *SQL Server is installed on this machine *When I try and connect from the same machine using its own IP address and Windows authentication I get the 18452 error "login failed for {NULL} user" I am testing it like this because Sharepoint is failing in configuration wizard because it is connecting the same way - at least the login failure audit logs say the same. Many thanks for answers
View Replies !
SQL Server Management, Error 29506
I tried to install this evening SQL Server Management Express on my Windows Vista 32 bit Home Premium Edition + Sql server 2005 express. The problem is that at the end of the installation this error comes out: "Si è verificato un errore imprevisto durante l'installazione di questo pacchetto. Probabile problema con questo pacchetto. Il codice errore è: 29506" What could I do? Thanks Luke
View Replies !
|
TRACKER
