Error 3926 , Server Failed To Resume Transaction

Aug 22, 2007

In a high load asp.net environment,  I am getting an error. 
The transation active in this session has been committed  or aborted by another session.
Here is the code , I am getting error. 1 object returnObject = null;
2 SqlTransaction sqlTrans = null;
3 try
4 {
5 //Getting new SqlConnection
6 comm.Connection = GetConnection();
7 //Opening connection
8 OpenConn(comm.Connection);
9 //beginning transaction
10 sqlTrans = comm.Connection.BeginTransaction( IsolationLevel.ReadCommitted );
11 //setting transaction to SqlCommand object
12 comm.Transaction = sqlTrans;
13 //executing operation
14 returnObject = comm.ExecuteScalar();
15 //trying to commit.
16 sqlTrans.Commit();
17
18
19 }
20 catch (SqlException sex)
21 {
22 if (sqlTrans != null)
23 {
24 sqlTrans.Rollback();
25 }
26 }
27 finally
28 {
29 comm.Connection.Close();
30 }
  Could you please explain , am I doing smthg wrong ?

View 5 Replies


ADVERTISEMENT

SQLException The Server Failed To Resume The Transaction

Mar 24, 2008



Hello-

A customer has reported getting the following excpetion in our logs, and I have never seen it before and wanted to see if there was any insight you could provide to understand when you throw this exception.

The process is a "purging" process- it just executes a sequence of DELETE statements that should be fairly simple (delete a number of records from a table and CHECK some constraints, no cascading), after the sequence it commits. All of this occurs on the same connection. We use c3p0 for connection pooling.

Here is the exception:

2008-03-22 08:30:08,699 WARN impl.NewPooledConnection : [c3p0] A PooledConnection that has already signalled a Connection error is still in use!
2008-03-22 08:30:08,699 WARN impl.NewPooledConnection : [c3p0] Another error has occurred [ com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:9f00000002. ] which will not be reported to listeners!
com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:9f00000002.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:855)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)
at $Proxy15.rollback(Unknown Source)
at

View 3 Replies View Related

The Server Failed To Resume The Transaction. Desc:d200000003

Apr 18, 2007

Hi,

We recently migrated our application from SQL Server 2000 to SQL Server 2005 and we also migrated from WAS5 to WAS6.

We are getting the following exception when we call any of the stored procedures.

The server failed to resume the transaction. Desc200000003.

Basically we call these stored procedures frequently using the Java thread scheduler.

We didnt face any problem when we use IBM drivers

I guess this is the problem with the drivers.We use JDBC 2005 driver Version 1.1.

But we didnt face this problems when we use JDBC 2000 driver when we used to connect to SQL Server 2000

The Microsoft says that it has fixed the date problems as well as the transaction problems in the version 1.1.But still are facing the issues.

Can anyone of you please help me in getting the solution for the same?

View 4 Replies View Related

VB.NET Login (SQL Server 2005) Error: Communication With The Underlying Transaction Manager Has Failed

Mar 4, 2008

Hi all,I am trying to setup a VB.Net development environment on my desktop for one of the application which was already in the production for couple of years (some unknown contractor(s) developed and maintained it so far). The application works fine on the web.Visual Studio 2005, .Net 2.0, SQL 2000, SQL Server 2005 were installed on my desktop. When I try to build the entire application/solution in the debug mode (i.e., with http://localhost/), build succeeds and I could get to the login.aspx. When I try to login, I am getting an error in the Visual Studio at the following code;connection = New SqlConnection(connectionString)
connection.Open()
 saying "Communication with the underlying transaction manager has failed", "System.Transactions.TransactionManagerCommunicationException was unhandled by user code". And the web browser displays the following error "Error HRESULT E_FAIL has been returned from a call to a COM component".     When I try to connect the SQL Server 2005 with the same ConnectionString attributes by going to Tools>Connect to Database, it works fine. But, through application connection.Open() giving above errors.     I have set the MSDTC properties (i.e., under Component Services>MyComputer Properties>Security Configuration) as below:-Enabled Network DTC Access, Allow Remote Clients, Allow Remote Administration, Allow Inbound, Allow Outbound, No Authentication required - selected, Enabled XA Transactions...& DTC Logon Account is "NT AUTHORITYNetworkService".Please help.Thanks in advance,Chandra 

View 3 Replies View Related

How Do I Achieve - In SQL - Something Like On Error Resume Next In VB?

Oct 2, 2007

Often when I write a stored procedure, I encounter a situation where
it will be really convenient if I can ignore an error and continue the execution
of next SQL statement, especially when I know what kind of error it will generate.
It's just like the effect of "On Error Resume Next" in VB.

Does anyone have any idea or have some knowledge to share?
I would really appreciate.

I am using SQL Server 2005 and SQL Server 2000. Thanks.

Chris

View 5 Replies View Related

Resume Execution After Error

Nov 21, 2006

Hi,

I have a stored procedure containing iterating cursor in which iam inserting records in a table. My problem is that whenever any data mismatch occurs whole process gets stops. I want it should skip that error record and continue with next iteration. Like on error resume next in vb. Please suggest.

View 5 Replies View Related

Login Failed Error During Transaction Log Backup

Aug 11, 2002

Hi,

My application returns the following error when a SQL call is made during a transaction log backup.
Cannot open database requested in login 'login_name'. Login fails.

Has anyone come accross this problem before? or maybe worked around it?

Cheers

Luke

View 1 Replies View Related

Error: The Connection Manager Failed To Defect From The Transaction.

Aug 3, 2007



Does anybody know what it means?
The context is: a package with a single Data Flow finishes with this error: [Connection manager "xxx"] Error: The connection manager failed to defect from the transaction.
All components inside the data flow reports a successfull green status, however the DataFlow Task remains yellow for a long time, when suddenly the package stops with the above message. Another information is that the table remains locked during package execution (a select on that table does not complete...). This is a serious issue, and I couldnt find any relevant information about that. Thanks in advance.



View 4 Replies View Related

How To Achieve On Error Resume Next Login In SSIS For Loop

Apr 5, 2006

Hello All,

I am developing a package using SSIS which needs to do the following.

1. Read all flat file from a folder. I am doing this using For Loop task. I know the total number of files in that folder hence I am setting the loop counter = file count.

2. The next step is to import the data from flat file to SQL server destination table using data flow task.

3. Upon successful completion of data flow task there are some other tasks like SQL to do some checks/validation on the data, export it to another tables.

Upon successful completion of step 3 the iteration goes to next file.

I want to achieve the following

IF step 2 has error (for example corrupt file or incomplete data), I want to fail data transfer completely, skip step 3, and go to step 1 for next available file and do rest.

How do I do this in SSIS?

Thanks for your help.

SGK

View 1 Replies View Related

Implementing Transaction In SSIS Package - [Execute SQL Task] Error: Failed To Acquire Connection &&<ConnectionName&&>.

Jun 30, 2006

I have a simple SSIS package with three "Execute SQL Tasks". I am using ADO.Net Connection to execute SPs on a DB server.

When I execute this package It works fine. So far so good.

Now, I need to implement transation on this package. And problem starts now onwards. When I try to execute package after setting TransationOption = Required for the Sequence container which contains all the tasks, I get following error.

[Execute SQL Task] Error: Failed to acquire connection "NYCDB0008.Export". Connection may not be configured correctly or you may not have the right permissions on this connection.

"NYCDB0008.Export" is the name of the ADO.Net connection. I have been hunting for any solution but all in vain. I have tried changing all DTC settings on the dev as well as Database server.

Please respond if anyone has any solution.

Thanks!

Anand

View 24 Replies View Related

Login Failed For User - Token Based Server Access Validation Failed With Infrastructure Error

Sep 9, 2015

Many a times see the below error in SQL Error log.

Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]

Is this something to do here?

Note: If I run the below statement I know that the SQL Error log entry will go off, but wanted to know the real significance of this error?

CREATE LOGIN [NT AUTHORITYANONYMOUS LOGON] FROM WINDOWS

View 1 Replies View Related

How To Store Resume And Cover Letter Into SQL Server?

Jun 6, 2005

Hi,
    I am trying to create an asp.net web recruiting application for HR, which will give the users the ability to both copy/paste the Resume and cover letter in textbox and upload resume and cover letter, then submit it (which will be saved into SQL Server 2000 table). 
I am thinking to save Resume and cover_letter as Image data type columns in SQL Server. 
.  Can someone give me a direction about how to save the uploaded resume and cover letter to table and if it's the easiest way to do it?
.  What to deal with different formats of uploaded resumes?  I hope to limit to only Word or HTML
.  Since I also give user another option - copy/paste the resume and coverletter into a textboxes.  Can I simply save the copy/paste resume and cover letter into text field column?  Later, say, if any HR recruiter retrieve the text from database, will it concatonates everything together without line break?
Any ideas is appreciated.

View 8 Replies View Related

Error 8525: Distributed Transaction Completed. Either Enlist This Session In A New Transaction Or The NULL Transaction.

May 31, 2008

Hi All

I'm getting this when executing the code below. Going from W2K/SQL2k SP4 to XP/SQL2k SP4 over a dial-up link.

If I take away the begin tran and commit it works, but of course, if one statement fails I want a rollback. I'm executing this from a Delphi app, but I get the same from Qry Analyser.

I've tried both with and without the Set XACT . . ., and also tried with Set Implicit_Transactions off.

set XACT_ABORT ON
Begin distributed Tran
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.TRANSACTIONMAIN
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.TRANSACTIONMAIN
set REPFLAG = 0 where REPFLAG = 1 and DONE = 1
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.WBENTRY
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.WBENTRY
set REPFLAG = 0 where REPFLAG = 1
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.FIXED
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.FIXED
set REPFLAG = 0 where REPFLAG = 1
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.ALTCHARGE
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.ALTCHARGE
set REPFLAG = 0 where REPFLAG = 1
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.TSAUDIT
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.TSAUDIT
set REPFLAG = 0 where REPFLAG = 1
COMMIT TRAN


It's got me stumped, so any ideas gratefully received.Thx

View 1 Replies View Related

Fix - Enlist Operation Failed: SQL Server Could Not Register With Microsoft Distributed Transaction Coordinator (MSDTC)

Mar 13, 2008

Distributed transactions were happily running between our SQL servers and then we installed Windows 2003 Server SP2 and all of a sudden we got this nice error message when attempting a remote data update via linked servers. I couldn't even run "BEGIN DISTRIBUTED TRANSACTION" without getting the error message. The full error message is:

"Enlist operation failed: 0x8004d00e(XACT_E_NOTRANSACTION). SQL Server could not register with Microsoft Distributed Transaction Coordinator (MSDTC) as a resource manager for this transaction. The transaction may have been stopped by the client or the resource manager."

Apparently, SP2 disables network DTC access (how nice, I feel more secure knowing that my data can't be updated remotely anymore).

Solution:

From Control Panel | Add or Remove Programs | Add Remove Windows Components
Select "Application Server" and click the "Details" button
Check "Enable network DTC access" and click OK for however many prompts it takes to apply the changes.

****NOTE**** this change WILL SHUT DOWN SQL SERVER so plan accordingly (this would have been handy to know in advance since I ran it in the middle of the workday and everyone got disconnected).

Hope this helps!

View 2 Replies View Related

Link Server Error: Login Failed For User 'Domainuser'. (Microsoft SQL Server, Error: 18456)

Oct 18, 2007


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 5 Replies View Related

Test Connection Failed Because Of Error Initializing Provider. The HTTP Server Returned The Following Error : Not Found

May 26, 2008



Hi All,

I am using windows 2003 server and i have installed SSAS 2005 and configured http request for AS 2005 with this below url : http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx. I had tried all the possiblities given in this url. But i am getting like "Test connection failed because of error initializing provider. The HTTP Server returned the following error : Not found" when i create udl file. Moreover i have installed MSOLAP 3.0 and OLAP 9.0 provider and MSXML 6.0 Parser.

Can you anyone please provide solution for this?

Thanks in advance,
Anand Rajagopal

View 1 Replies View Related

MS SQL Server Maintenance Plan Failed: Error Code 0x534. [SQLSTATE 42000] (Error 15404))

May 3, 2008



hello,

we have changed the name of MS SQL server 2005 from XYZ to ABC using


sp_dropserver <old_name>

GO

sp_addserver <new_name>, local

GO


Now our maitenance plan is getting failed we are not able to execute backup jobs we are getting following error


Date 03.05.2008 16:00:00
Log Job History (ADM_AdminDB_TP_Backup.Subplan_1)

Step ID 0
Server ABC
Job Name ADM_AdminDB_TP_Backup.Subplan_1
Step Name (Job outcome)
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
The job failed. Unable to determine if the owner (XYZSQLServer) of job ADM_AdminDB_TP_Backup.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user 'XYZSQLServer', error code 0x534. [SQLSTATE 42000] (Error 15404)).

please help us in this issue

View 13 Replies View Related

Failed Transaction Log

Sep 27, 2007

Hi,

I am using SQL server 2000 and I created a maintenance plan. I started the jobs manually for the first time to see if everything will do as it's supposed to do before the scheduel takes place.

The DB backup are successful. When I start the Transaction Log backup job it returns failed. But when I look on the actual server ine the default directory the transaction logs are there with the current date and time.

Why do I always get a failed message. It says in the job history - The job failed. The job was invoved by user xxxxx. The last step to run was step 1(step 1).

Does anyone have an idea why I get this message. Also it says that is notified me by net send and it never does.

View 13 Replies View Related

TRANSACTIONS In SSIS (error: The ROLLBACK TRANSACTION Request Has No Corresponding BEGIN TRANSACTION.

Nov 14, 2006

I'm receiving the below error when trying to implement Execute SQL Task.

"The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION." This error also happens on COMMIT as well and there is a preceding Execute SQL Task with BEGIN TRANSACTION tranname WITH MARK 'tran'

I know I can change the transaction option property from "supported" to "required" however I want to mark the transaction. I was copying the way Import/Export Wizard does it however I'm unable to figure out why it works and why mine doesn't work.

Anyone know of the reason?

View 1 Replies View Related

Failed Transaction Log Backups

Feb 6, 2000

SQL 7 SP1 NT 4.0 SP5

I created a backup plan for transaction logs only to run every 30 minutes. It works great for all databases except the Master and my main database scdb_v2.

The routine backups up the other 3 databases with no issue.

Why is this happening ?

Thanks,

Craig Somberg
mailto:csomberg@stageone.com

View 3 Replies View Related

Transaction Log Backup Failed

Mar 9, 2004

Hi all,
SQl server 7

I have a job to run every six hours to take the transaction log backup.
but the job has failed.
when viewed through view job history its giving the below error msg.

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

I tried starting the job but its failing with the same error msg.

pls help.

TIA

View 8 Replies View Related

Transaction Log Backup Failed!!!

Apr 12, 2004

Hi All,
Greetings,

SQL Server 7,

I have scheduled transaction log backup for every 6 hours.
the scheduled job ran as per scheldue at 12pm but its giving error

The job failed. The Job was invoked by User comcreation. The last step to run was step 1 (Step 1).

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

there is enough space in the drive where transaction log backup
is stored

Please help me.

View 8 Replies View Related

Sqlmaint.exe Failed. [SQLSTATE 42000] (Error 22029). The Step Failed.

Jan 3, 2001

I get the following error when I try to run my scheduled job.
sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.


Any ideas Thanks in advance
Reddy

View 1 Replies View Related

Package Failed : Failed To Decrypt Protected XML Node DTS:Password With Error

Apr 21, 2008

Dear all,

I've built SSIS package and made a job to execute it automatically but it always returns an error. The job returns OK but when we looked at the Log File viewer, it conatins this error log :

Key not valid for use in specified state

Failed to decrypt protected XML node "DTS Password" with error

What's wrong with the package ?
Thanks in advance.


Best regards,

Hery

View 22 Replies View Related

Log Shipping Failure Sqlmaint.exe Failed. [SQLSTATE 42000] (Error 22029). The Step Failed.

Sep 13, 2001

I have log shipping set up between 2 SQL 2000 SP1 Servers on Win 2000. The db is small 10 meg, and when the restore job on the backup server fails I am getting "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed." as the message, the maint paln on the primary server show no error. Anyone seen this before? The restore has worked 3 out of 5 times

View 2 Replies View Related

Executed As User: CONNECTSRVmyadmin. Sqlmaint.exe Failed. [SQLSTATE 42000] (Error 22029). The Step Failed.

Feb 29, 2008

Hi all help needed from your End.

I have a re-indexing stored procedure,yester day night it got failed
"Executed as user: CONNECTSRVmyadmin. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."
what may be the reason..



View 4 Replies View Related

SQL Server 2000 And Transaction Log Error

Jul 20, 2005

Hi All:I am getting an error when trying to open a recordset in SQL Server 2000.The error states that the transaction log is full. Is there any way I canclear out or empty the transaction log, or get rid of it alltogether as itis not really needed?Any help would be appreciated.Thanks and regards,Ryan

View 1 Replies View Related

SQL Server Transaction Error 34000000d0

Jun 14, 2007

Hi,

any idea what this error indicates (needed a restart of SQL Server to solve) or where I can find information on this error code ?

com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:34000000d0.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
at de.siemens.icn.hipath.dls.server.db.LoggablePreparedStatement.executeQuery(LoggablePreparedStatement.java:207)
at de.siemens.icn.hipath.dls.server.db.DlsDBAccess.accessHelper(DlsDBAccess.java:510)
at de.siemens.icn.hipath.dls.server.db.DlsDBAccess.access(DlsDBAccess.java:675)
at de.siemens.icn.hipath.dls.server.db.DlsDBAccess.access(DlsDBAccess.java:636)
at de.siemens.icn.hipath.dls.server.db.DlsDBFetch.fetchDlsObjects(DlsDBFetch.java:977)
at de.siemens.icn.hipath.dls.server.db.DlsDBSelect.fetchDlsObjects(DlsDBSelect.java:1004)
at de.siemens.icn.hipath.dls.server.common.DlsLoggerServer$AlarmTask.run(DlsLoggerServer.java:427)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)


Regards
Georg

View 1 Replies View Related

Transaction Log Failed To Auto Extend

Sep 6, 2001

Hi

Had a weird error yesterday, can anybody shed any light on it.

I got the following error in a SQL 7(sp2) database.
'The log file for database 'IT2PROD' is full. Back up the transaction log for the database to free up some log space..
Error: 9002, Severity: 17, State: 2'

The Transaction Log has unrestricted file growth and auto grow file set and the disk has over 20gb of free space.

The only explanation I can think of is that the Log tried to extend during the hourly backup. Would this cause the above error ??? The backup file is usually about 80mb but was over 300mb when this happened.

Any ideas ????

Thanks in advance

Gary

View 4 Replies View Related

Scheduled Transaction Log Backup Failed

Aug 16, 2006

Hi Greeting,


Sql sever7
OS winNT

We have scheduled transaction log backup for user database to run every one hour. Now the transaction has failed. it gives out put

[12] Database oas: Delete Old Backup Files...
Unable to delete file E:mssql7 logsoasoas_tlog_200608111300.TRN. 0 file(s) deleted.

When we try to delete the file manully, we get alert message "can not delelte the file as it is in use."

Please suggest how to solve this.


Awating for reply

Thanks in Advance
Adil

View 1 Replies View Related

Package Hourly Transaction Log Failed.

Mar 27, 2008

Any thoughts as to why I get this error, every hour. How do I fix it?
Be gentle I'm a SQL novice.

Error reported in the Application Event Log.

Package "Hourly Transaction Log" failed.

OS: Windows Ser_2003_sp1
Source: SQLISPackage
Category: None
Type: Error
Event ID: 12291
File Name dtsmsg.rll
File Version: 2005.90.3042.0
Product Name: Mic SQL Server.
Product Version: 9.0.3042.
Time 3:00:01 PM
Type: Error

View 4 Replies View Related

Server Error - Login Failed - Plz Help

May 10, 2004

I wrote a code to check and validate the username and password against the database and redirect the user based on the user flag as follows:

Dim MyConnection As SqlConnection
Try
If Page.IsValid Then
Dim strUsername As String = txtUsername.Text
Dim strPassword As String = txtPassword.Text
Dim DS As DataSet

Dim MyCommand As SqlDataAdapter

Dim SelectCommand As String = "select userid, flag from employees where username = @login and password = @password"

MyConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;" & _
"Initial Catalog=rfd;")
MyCommand = New SqlDataAdapter(SelectCommand, MyConnection)

MyCommand.SelectCommand.Parameters.Add(New SqlParameter("@login", SqlDbType.Char, 10))
MyCommand.SelectCommand.Parameters("@login").Value = strUsername

MyCommand.SelectCommand.Parameters.Add(New SqlParameter("@password", SqlDbType.Char, 10))
MyCommand.SelectCommand.Parameters("@password").Value = strPassword

DS = New DataSet

MyCommand.Fill(DS)
'MyConnection.Close()

If DS.Tables(0).Rows.Count = 1 Then
Dim flag As String = DS.Tables(0).Rows(0)("flag")
Dim id As Integer = DS.Tables(0).Rows(0)("userid")

Session.Add("flag", flag)
If flag = "u" Then
Session.Add("userid", id)
Session.Add("Page", "user")
Response.Redirect("user_index.aspx")
ElseIf flag = "pl" Then
Session.Add("userid", id)
Session.Add("Page", "pl_index")
Response.Redirect("PL_index.aspx")
End If
Else
msg1.Style("color") = "red"
msg1.Text = "Username or Password incorrect: Please Try again"
End If
End If
Finally
Session.Timeout = 10
MyConnection.Close()
End Try

End Sub

However, when I run it, it points as the line " MyCommand.Fill(DS)" and said Server Error - Login failed for user/aspnet. Where should look and what should I ckeck? Please help me !

View 4 Replies View Related

Server Error - Login Failed

Jun 22, 2004

Level: beginner!

What is wrong?

Login failed for user 'DEBBY-76GXHEASPNET'.
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 'DEBBY-76GXHEASPNET'.

Source Error:


Line 90:
Line 91: If Not Page.IsPostBack Then
Line 92: Da_leerlingen.Fill(Ds_leerlingen1)
Line 93: Dg_leerlingen.DataBind()
Line 94:


Source File: c:inetpubwwwrootWebApplication3WebForm1.aspx.vb Line: 92

Stack Trace:


[SqlException: Login failed for user 'DEBBY-76GXHEASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
WebApplication3.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootWebApplication3WebForm1.aspx.vb:92
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731


Thanks

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved