Error when trying to change server settings

I am trying to connect to a SQL Server machine using SQL security instead of integrgated security. However, the server was setup initially to use only integrated security. When I right click on the server and select properties, I get this error:

Error 0: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 5(Access is denied.).

I googled this error but could not find a single solution. The dll will not register with regsvr32. Do I need to repair SQL Server and then re-run the latest service pack, or is there a simple solution?

Thanks,Books Online

How to set up Mixed Mode security (Enterprise Manager)
To set up Mixed Mode security

Expand a server group.

Right-click a server, and then click Properties.

Click the Security tab.

Under Authentication, click SQL Server and Windows.

Under Audit level, select the level at which user accesses to Microsoft® SQL Server? are recorded in the SQL Server error log:
None causes no auditing to be performed.

Success causes only successful login attempts to be audited.

Failure causes only failed login attempts to be audited.

All causes successful and failed login attempts to be audited.

See Also

Authentication Modes
------

Does that help?|||Thanks. I understand how to setup mixed mode security, but the problem appears to be a dll called xpstar.dll which throws an error when I right click on the server icon and select properties. I wanted to know if there was a fix for this short of reinstalling.

When I right click on the server icon in server explorer and select properties, I get this error:

Error 0: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 5(Access is denied.).

I googled this error but could not find a single solution. The dll will not register with regsvr32. Do I need to repair SQL Server and then re-run the latest service pack, or is there a simple solution?|||No answers, just questions.

What version & service pack of SQL Server are you running?

Have you checked the event log to see if you can find any further information?

Terri|||Hello Terri,

It is SQL Server 2000 and should have service pack 3 installed.

There are no errors in the event log related to SQL Server.|||Is there anything in the SQL Server Logs?

Terri|||Unfortunately not.

Also, I reapplied Service Pack 3 and it did not fix the problem.

I have SQL on a development machine. If I right click on the local server instance and then select properties, the Server properties dialog appears. If I select the server, I get an error. At first, I thought it was the development machine, but unfortunately the same thing happens when I try this directly on the server. I am at a loss of what to do short of backing up the databases, uninstalling SQL, reinstalling SQL, and then restoring the databases. The SQL installation does not have a repair option - do you know what would happen if I installed SQL over the existing SQL?

Thanks,

Error when running SQL Job

I get an Event ID: 40961 when running a job in SQL the error message is as follows;
The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
The job is run on another server and is trying to hit the server listed above.
There are a few related knowledge base articles and several
reasons for the error listed at this site:
http://www.eventid.net/display.asp?e...aS rv&phase=1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:

>I get an Event ID: 40961 when running a job in SQL the error message is as follows;
>The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
>The job is run on another server and is trying to hit the server listed above.

Error when running SQL Job

I get an Event ID: 40961 when running a job in SQL the error message is as f
ollows;
The Security System could not establish a secured connection with the server
MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was availab
le.
The job is run on another server and is trying to hit the server listed abov
e.There are a few related knowledge base articles and several
reasons for the error listed at this site:
1" target="_blank">http://www.eventid.net/display.asp?...phase=
1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I get an Event ID: 40961 when running a job in SQL the error message is as
follows;
>The Security System could not establish a secured connection with the serve
r MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was availa
ble.
>The job is run on another server and is trying to hit the server listed above.[/vbc
ol]sql

Error when running SQL Job

I get an Event ID: 40961 when running a job in SQL the error message is as follows
The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available
The job is run on another server and is trying to hit the server listed above.There are a few related knowledge base articles and several
reasons for the error listed at this site:
http://www.eventid.net/display.asp?eventid=40961&eventno=1398&source=LsaSrv&phase=1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:
>I get an Event ID: 40961 when running a job in SQL the error message is as follows;
>The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
>The job is run on another server and is trying to hit the server listed above.

Error Starting Full text search service

I am tryin to start MS search service on the server and getting this error :
1307 0x051B This security ID may not be assigned as the owner of this object.
Please help.
Anoop,
Sorry, for the late reply, as I only saw this today...
Is the "Microsoft Search" service still throwing the below error? What
account have you assigned to start this service? If you have any other
account other than the system account (LocalSystem), then re-set this
service to use the system account (LocalSystem) and then stop and re-start
the service and confirm that you are no longer getting the below error.
If after changing the startup account to LocalSystem, you are still getting
the below error, could you check the contents of SearchSetup.log (usually
located under C:\WINNT\ or C:\WINDOWS) and post any related installation
errors.
Thanks,
John
"Anoop" <Anoop@.discussions.microsoft.com> wrote in message
news:BC851143-57DE-4182-8C9B-FC064EC63FEA@.microsoft.com...
> I am tryin to start MS search service on the server and getting this error
:
> 1307 0x051B This security ID may not be assigned as the owner of this
object.
> Please help.

Error setting up Custom Security Extension

I am trying to set up a custom security extension. I've followed the setup
from the msdn article as well as the Microsoft Reporting Services in Action
sample. I keep getting an error when I try to start the ReportServer Service
after changing the config file. Can anyone help?
Thanks in Advance!
P.S. I looked in the log file and this looks like the first error:
ReportingServicesService!library!4!6/28/2005-16:21:10:: i INFO: Counter not
created. Category: RS Windows Service, Counter: Active Database Connections,
Instance: MSSQLSERVER. Error Message: Counter 'active database connections'
does not exist in category 'rs windows service'.Scott,
here I will suggest to restore original config files and reconfigure
them. Else please send me file, I will try to fig out the problem.
Mahesh

Error security level explanation please.

Hi
Why would this error stop the execution of my Stored procedure.
Server: Msg 8501, Level 16, State 3, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server '
Server1' is
unavailable.
I thought that only errors with level 20 to 25 did that.
IanHi,
Read these about error handling:
http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html
Check XACT_ABORT setting...
"Ian" <ian@.NoWhere.com> wrote in message
news:%23ZcyUFpiEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi
>
> Why would this error stop the execution of my Stored procedure.
> Server: Msg 8501, Level 16, State 3, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server
1'
is
> unavailable.
> I thought that only errors with level 20 to 25 did that.
>
> Ian
>|||You had batch abort... There is not much documentation from MS on these
kinds of things, but Erland Sommerskog's articles that the previous
respondent points to is the best information available anywhere on the
subject. (Thanks Erland.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ian" <ian@.NoWhere.com> wrote in message
news:%23ZcyUFpiEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi
>
> Why would this error stop the execution of my Stored procedure.
> Server: Msg 8501, Level 16, State 3, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server
1'
is
> unavailable.
> I thought that only errors with level 20 to 25 did that.
>
> Ian
>|||Thanks heaps.
"Ian" <ian@.NoWhere.com> wrote in message
news:%23ZcyUFpiEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi
>
> Why would this error stop the execution of my Stored procedure.
> Server: Msg 8501, Level 16, State 3, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server
1'
is
> unavailable.
> I thought that only errors with level 20 to 25 did that.
>
> Ian
>

Error security level explanation please.

Hi
Why would this error stop the execution of my Stored procedure.
Server: Msg 8501, Level 16, State 3, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server1' is
unavailable.
I thought that only errors with level 20 to 25 did that.
Ian
Hi,
Read these about error handling:
http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html
Check XACT_ABORT setting...
"Ian" <ian@.NoWhere.com> wrote in message
news:%23ZcyUFpiEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi
>
> Why would this error stop the execution of my Stored procedure.
> Server: Msg 8501, Level 16, State 3, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server1'
is
> unavailable.
> I thought that only errors with level 20 to 25 did that.
>
> Ian
>
|||You had batch abort... There is not much documentation from MS on these
kinds of things, but Erland Sommerskog's articles that the previous
respondent points to is the best information available anywhere on the
subject. (Thanks Erland.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ian" <ian@.NoWhere.com> wrote in message
news:%23ZcyUFpiEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi
>
> Why would this error stop the execution of my Stored procedure.
> Server: Msg 8501, Level 16, State 3, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server1'
is
> unavailable.
> I thought that only errors with level 20 to 25 did that.
>
> Ian
>
|||Thanks heaps.
"Ian" <ian@.NoWhere.com> wrote in message
news:%23ZcyUFpiEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi
>
> Why would this error stop the execution of my Stored procedure.
> Server: Msg 8501, Level 16, State 3, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server1'
is
> unavailable.
> I thought that only errors with level 20 to 25 did that.
>
> Ian
>

Error security level explanation please.

Hi
Why would this error stop the execution of my Stored procedure.
Server: Msg 8501, Level 16, State 3, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server1' is
unavailable.
I thought that only errors with level 20 to 25 did that.
IanHi,
Read these about error handling:
http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html
Check XACT_ABORT setting...
"Ian" <ian@.NoWhere.com> wrote in message
news:%23ZcyUFpiEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi
>
> Why would this error stop the execution of my Stored procedure.
> Server: Msg 8501, Level 16, State 3, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server1'
is
> unavailable.
> I thought that only errors with level 20 to 25 did that.
>
> Ian
>|||You had batch abort... There is not much documentation from MS on these
kinds of things, but Erland Sommerskog's articles that the previous
respondent points to is the best information available anywhere on the
subject. (Thanks Erland.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ian" <ian@.NoWhere.com> wrote in message
news:%23ZcyUFpiEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi
>
> Why would this error stop the execution of my Stored procedure.
> Server: Msg 8501, Level 16, State 3, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server1'
is
> unavailable.
> I thought that only errors with level 20 to 25 did that.
>
> Ian
>|||Thanks heaps.
"Ian" <ian@.NoWhere.com> wrote in message
news:%23ZcyUFpiEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi
>
> Why would this error stop the execution of my Stored procedure.
> Server: Msg 8501, Level 16, State 3, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server1'
is
> unavailable.
> I thought that only errors with level 20 to 25 did that.
>
> Ian
>