Error 1203

I am running a script on a schedule and I get this error quite often:

Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000] (Error 0) Process ID ## attempted to unlock a resource it does not own: OBJECT: ## . Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator. [SQLSTATE HY000] (Error 1203)

If I keep rerunning the transaction, it will eventually succeed. I am running SQL Server 2005 with SP1 installed. Does anyone know what this means and what would cause it to fail sometimes and succeed other times?

Thanks

This often indicates some sort of corruption in your database. See BOL topic below for more details:

http://msdn2.microsoft.com/en-us/library/aa337285.aspx

|||

It does not appear to be any sort of corruption. The DBCC CHECKDB returned no errors. Are there any other things that could cause this besided database corruption?

Thanks.

|||In that case, you will have to contact PSS to open a case so they can investigate further. This can also be due to a bug in SQL Server lock manager code caused by your workload/configuration. Btw, if you haven't applied the latest service pack of SQL Server (SP1) and the cumulative hotfix please do that first to see if you can repro the problem.

error 1069

I am receiving the following error:
An error 1069 - (The service did not start due to a logon
failure) occurred while peforming the service operation
on the MSSQLServer service.
Any suggestions?Check the password for the account that the SQL Server Service is using.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Haas" <h_widemond@.hotmail.com> wrote in message
news:cf1d01c4104b$22447580$a001280a@.phx.gbl...
> I am receiving the following error:
> An error 1069 - (The service did not start due to a logon
> failure) occurred while peforming the service operation
> on the MSSQLServer service.
> Any suggestions?

Error '0x8000ffff' occurred during full-text index population

I have a nightly job scheduled by the SQL Agent scheduler to run full-text
creations nightly, and I have noticed that the following error message
appears during the process of trying to index a number of tables (but not
all).
can someone please provide some advice as to what might be causing this
error to occur - and what I should be looking at to resolve this issue.
Regards
Andy MBCS CITP
Andy,
Do the SQL logs report any more information, or the Windows Event Logs?
Error '0x8000FFFF' (2147549183) often means "Unexpected failure", so
additional information from the logs might help.
RLF
"Andy Knott" <AndyKnott@.discussions.microsoft.com> wrote in message
news:DC3B2B34-7A26-44F0-B75E-E02ADD4CE07C@.microsoft.com...
>I have a nightly job scheduled by the SQL Agent scheduler to run full-text
> creations nightly, and I have noticed that the following error message
> appears during the process of trying to index a number of tables (but not
> all).
> can someone please provide some advice as to what might be causing this
> error to occur - and what I should be looking at to resolve this issue.
>
> --
> Regards
> Andy MBCS CITP
|||Russell
Unfortuanately the event logs tell me to look at the full crawl logs - and
it is the full crawl logs which have this error code contained within them.
If, as you suggest the code is a non specific one, how on earth am I going
to track down what is causing the error to be thrown in the first place!!
Thanks for your response - any other suggestions very welcome
Regards
Andy
Regards
Andy MBCS CITP
"Russell Fields" wrote:

> Andy,
> Do the SQL logs report any more information, or the Windows Event Logs?
> Error '0x8000FFFF' (2147549183) often means "Unexpected failure", so
> additional information from the logs might help.
> RLF
> "Andy Knott" <AndyKnott@.discussions.microsoft.com> wrote in message
> news:DC3B2B34-7A26-44F0-B75E-E02ADD4CE07C@.microsoft.com...
>
>
|||Andy,
I scoured my various crawl logs to see if I ever got the same message, but I
have not. I see that missing iFilters are an 'expected' error and are
reported on properly, etc, etc. through the problems that came to my mind.
Do the files that produce these errors remain the same from day to day? Do
they share any characteristic in common, such as file type, length of file
name, directory nesting, embedded bitmaps, etc? I have not a clue as to
what is wrong, but any information that gives a hint would help.
RLF
"Andy Knott" <AndyKnott@.discussions.microsoft.com> wrote in message
news:94FF8204-9A4F-4841-BF8E-CF7724E1EAAF@.microsoft.com...[vbcol=seagreen]
> Russell
> Unfortuanately the event logs tell me to look at the full crawl logs - and
> it is the full crawl logs which have this error code contained within
> them.
> If, as you suggest the code is a non specific one, how on earth am I going
> to track down what is causing the error to be thrown in the first place!!
> Thanks for your response - any other suggestions very welcome
> Regards
> Andy
> --
> Regards
> Andy MBCS CITP
>
> "Russell Fields" wrote:
|||Please see the following article from Microsoft.
http://support.microsoft.com/default.aspx/kb/243349
"Russell Fields" wrote:

> Andy,
> I scoured my various crawl logs to see if I ever got the same message, but I
> have not. I see that missing iFilters are an 'expected' error and are
> reported on properly, etc, etc. through the problems that came to my mind.
> Do the files that produce these errors remain the same from day to day? Do
> they share any characteristic in common, such as file type, length of file
> name, directory nesting, embedded bitmaps, etc? I have not a clue as to
> what is wrong, but any information that gives a hint would help.
> RLF
> "Andy Knott" <AndyKnott@.discussions.microsoft.com> wrote in message
> news:94FF8204-9A4F-4841-BF8E-CF7724E1EAAF@.microsoft.com...
>
>

error :40 pls help ASAP

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)

I am using SQL server Express 2005 on my local machine. And ASP.net 2.0 with C#.

SQL Server does not allow remote connections by default, if you want to connect remotely you will have to enable this feature. See the Screencast on my site for more information how to do this.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Note that the OP indicates that he is running it locally... Which is odd that it would be treating a local connection as remote.

Check the protocols under the SQL configuration tool and make sure named pipes isn't disabled.

|||Yes, I did enble all the features in SQL server Express, it allws remote conenction , TCP/IP and pipes,. I searched this problem here and did all the necessary things.
Still I get this error , please help . If I use my connection string from WEB.config i get following error

"............................................................................

Object reference not set to an instance of an object.

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.NullReferenceException: Object reference not set to an instance of an object. ................

and if I use my connection string in code , I get above error #40.

Please help.

My connection string in code look like this :

string connstr = "server=localhost; uid=myusername; pwd=mypassword; database=dabatabasename";

Please help ASAP.

thanks

|||

Your connection string is wrong, if you are using SQLServer Express, you will have to point to the Express instance:

string connstr = @."server=localhost\SQLExpress; uid=myusername; pwd=mypassword; database=dabatabasename";

Jens K. Suessmeyer

http://www.sqlserer2005.de

|||HI,

Thanks for the reply, I have modified conection String and it works ,

But I still not able to get it work from WEB.CONFIG file , Could you tell me what is the settings of WEB.CONFIG file for ASP.NET 2.0 . How can I get value of my connection String from WEB.CONFIG file.

Thanks,
|||

Could you please post the part of the connection string (if you use SQL Server authentication you can obfuscate the part with the password / username)

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||HI Jens,

Here is the code of my connection string:

string connstr = "server=serverName\\SQLEXPRESS; Provider=SQLOLEDB; uid=myusername; DRIVER=SQL Native Client; pwd=mypasswd; database=MyDatabaseName";

This works rightnow , if I use in each pages.

Please let me kow how can I put in WEB.config file and use it in my all ASP pages.

|||

Did you make sure that you wont need the double \ in the web-config file ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||HI,

My problem is I am not able to get a value of Any varialbles of Web.config file.

I need to know how to get a value of any varialbes from WEB.CONFIG file.

Jatin.
|||

The web.config file is part of your ASP.NET application, you would be better off asking this question in a forum target at Visual Web Developer Express rather that SQL Server. The web.config file is not part of SQL Express and most the folks in this forum don't use VWD.

Mike

|||

Any updates on that ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||HI,

I have not posted yet on ASP.NET site. could you give me web address for that forum?

Jatin.

error :40 pls help ASAP

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)

I am using SQL server Express 2005 on my local machine. And ASP.net 2.0 with C#.

SQL Server does not allow remote connections by default, if you want to connect remotely you will have to enable this feature. See the Screencast on my site for more information how to do this.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Note that the OP indicates that he is running it locally... Which is odd that it would be treating a local connection as remote.

Check the protocols under the SQL configuration tool and make sure named pipes isn't disabled.

|||Yes, I did enble all the features in SQL server Express, it allws remote conenction , TCP/IP and pipes,. I searched this problem here and did all the necessary things.
Still I get this error , please help . If I use my connection string from WEB.config i get following error

"............................................................................

Object reference not set to an instance of an object.

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.NullReferenceException: Object reference not set to an instance of an object. ................

and if I use my connection string in code , I get above error #40.

Please help.

My connection string in code look like this :

string connstr = "server=localhost; uid=myusername; pwd=mypassword; database=dabatabasename";

Please help ASAP.

thanks

|||

Your connection string is wrong, if you are using SQLServer Express, you will have to point to the Express instance:

string connstr = @."server=localhost\SQLExpress; uid=myusername; pwd=mypassword; database=dabatabasename";

Jens K. Suessmeyer

http://www.sqlserer2005.de

|||HI,

Thanks for the reply, I have modified conection String and it works ,

But I still not able to get it work from WEB.CONFIG file , Could you tell me what is the settings of WEB.CONFIG file for ASP.NET 2.0 . How can I get value of my connection String from WEB.CONFIG file.

Thanks,
|||

Could you please post the part of the connection string (if you use SQL Server authentication you can obfuscate the part with the password / username)

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||HI Jens,

Here is the code of my connection string:

string connstr = "server=serverName\\SQLEXPRESS; Provider=SQLOLEDB; uid=myusername; DRIVER=SQL Native Client; pwd=mypasswd; database=MyDatabaseName";

This works rightnow , if I use in each pages.

Please let me kow how can I put in WEB.config file and use it in my all ASP pages.

|||

Did you make sure that you wont need the double \ in the web-config file ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||HI,

My problem is I am not able to get a value of Any varialbles of Web.config file.

I need to know how to get a value of any varialbes from WEB.CONFIG file.

Jatin.
|||

The web.config file is part of your ASP.NET application, you would be better off asking this question in a forum target at Visual Web Developer Express rather that SQL Server. The web.config file is not part of SQL Express and most the folks in this forum don't use VWD.

Mike

|||

Any updates on that ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||HI,

I have not posted yet on ASP.NET site. could you give me web address for that forum?

Jatin.

error :40 pls help ASAP

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)

I am using SQL server Express 2005 on my local machine. And ASP.net 2.0 with C#.

SQL Server does not allow remote connections by default, if you want to connect remotely you will have to enable this feature. See the Screencast on my site for more information how to do this.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Note that the OP indicates that he is running it locally... Which is odd that it would be treating a local connection as remote.

Check the protocols under the SQL configuration tool and make sure named pipes isn't disabled.

|||Yes, I did enble all the features in SQL server Express, it allws remote conenction , TCP/IP and pipes,. I searched this problem here and did all the necessary things.
Still I get this error , please help . If I use my connection string from WEB.config i get following error

"............................................................................

Object reference not set to an instance of an object.

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.NullReferenceException: Object reference not set to an instance of an object. ................

and if I use my connection string in code , I get above error #40.

Please help.

My connection string in code look like this :

string connstr = "server=localhost; uid=myusername; pwd=mypassword; database=dabatabasename";

Please help ASAP.

thanks

|||

Your connection string is wrong, if you are using SQLServer Express, you will have to point to the Express instance:

string connstr = @."server=localhost\SQLExpress; uid=myusername; pwd=mypassword; database=dabatabasename";

Jens K. Suessmeyer

http://www.sqlserer2005.de

|||HI,

Thanks for the reply, I have modified conection String and it works ,

But I still not able to get it work from WEB.CONFIG file , Could you tell me what is the settings of WEB.CONFIG file for ASP.NET 2.0 . How can I get value of my connection String from WEB.CONFIG file.

Thanks,
|||

Could you please post the part of the connection string (if you use SQL Server authentication you can obfuscate the part with the password / username)

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||HI Jens,

Here is the code of my connection string:

string connstr = "server=serverName\\SQLEXPRESS; Provider=SQLOLEDB; uid=myusername; DRIVER=SQL Native Client; pwd=mypasswd; database=MyDatabaseName";

This works rightnow , if I use in each pages.

Please let me kow how can I put in WEB.config file and use it in my all ASP pages.

|||

Did you make sure that you wont need the double \ in the web-config file ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||HI,

My problem is I am not able to get a value of Any varialbles of Web.config file.

I need to know how to get a value of any varialbes from WEB.CONFIG file.

Jatin.
|||

The web.config file is part of your ASP.NET application, you would be better off asking this question in a forum target at Visual Web Developer Express rather that SQL Server. The web.config file is not part of SQL Express and most the folks in this forum don't use VWD.

Mike

|||

Any updates on that ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||HI,

I have not posted yet on ASP.NET site. could you give me web address for that forum?

Jatin.

error

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) (Microsoft SQL Server, Error: 53)This error is mainly based ont he fact that SQL Server disables remote connections by default. If you are not sure how to switch remote conenctions on, refer to the screencast on my site for a detailed explanation.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

If the webcast doesn't solve your problem, you can check out:

http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx

it has a great deal of information on how to debug connectivity issues. In fact, if you search for a bit of your error string in their search box there, you should come up with quite a few blogs on configuration issues that can cause this problem and how to resolve them.

I hope this helps,

John