Error 17883

I am getting the following error: Error 17883 on my new sql server. I am looking everywhere on the net, put I cannot find a way to resolve this issue. Does anyone know what causes this, and possibly how to fix it. Thanks for the help in advance.The 17883 error message was added to SQL Server 2000 Service Pack 3 (SP3). The error message draws attention to a problematic situation with SQL Server schedulers. The error message indicates that some resource is not appropriately yielding the SQL Server scheduler. This causes the non-yielding thread to run for extended periods of time, thereby starving other threads on that SQL Scheduler. The server may also become unresponsive. For additional information about this error, click the following link

http://support.microsoft.com/default.aspx?scid=kb;en-us;810885|||Thanks for the info. By the way, do you know how to resolve this issue?|||Please read!

http://support.microsoft.com/default.aspx?scid=kb;en-us;810885

Error 1612 - can't get Express installed

I have done all I can to resolve this on my own and would really appreciate any help anyone can give me. I have run uninstall utilities, followed a few MSDN reinstall methods, but all roads lead back to this vicious cycle:

The install hangs trying to install the prereq Microsoft SQL Server 2005 Setup Support Files with Error 1612. So I try to uninstall the Support files using Add/Remove..but the Windows Installer looks for "Microsoft SQL Server Native Client" disk, which of course I don't have because I install from downloads from Microsoft.

That's the very short version. I've got a ton of hours reading help groups, MSDN, trying everything.

I have posted the error log file below. Thanks in advance.

=== Verbose logging started: 1/25/2007 21:01:41 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: c:\6b4bf5519a6c349936f69599\setup.exe ===
MSI (c) (2C:64) [21:01:41:265]: Resetting cached policy values
MSI (c) (2C:64) [21:01:41:265]: Machine policy value 'Debug' is 0
MSI (c) (2C:64) [21:01:41:265]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (c) (2C:64) [21:01:41:265]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (2C:64) [21:01:41:265]: Grabbed execution mutex.
MSI (c) (2C:64) [21:01:41:281]: Cloaking enabled.
MSI (c) (2C:64) [21:01:41:281]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (2C:64) [21:01:41:281]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (98:90) [21:01:41:296]: Grabbed execution mutex.
MSI (s) (98:E4) [21:01:41:296]: Resetting cached policy values
MSI (s) (98:E4) [21:01:41:296]: Machine policy value 'Debug' is 0
MSI (s) (98:E4) [21:01:41:296]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (s) (98:E4) [21:01:41:296]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (98:E4) [21:01:41:296]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (98:E4) [21:01:41:296]: User policy value 'DisableMedia' is 0
MSI (s) (98:E4) [21:01:41:296]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Looking for sourcelist for product {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Adding {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Now checking product {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Media is enabled for product.
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Source with value name '1' is blank
MSI (s) (98:E4) [21:01:41:296]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Processing net source list.
MSI (s) (98:E4) [21:01:41:296]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Processing media source list.
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 2203 2: 3: -2147287037
MSI (s) (98:E4) [21:01:41:312]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:312]: SOURCEMGMT: Processing URL source list.
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1706 2: 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:312]: SOURCEMGMT: Failed to resolve source
MSI (s) (98:E4) [21:01:41:312]: MainEngineThread is returning 1612
MSI (c) (2C:64) [21:01:41:312]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (2C:64) [21:01:41:312]: MainEngineThread is returning 1612
=== Verbose logging stopped: 1/25/2007 21:01:41 ===

hi,

jklegseth wrote:

I have done all I can to resolve this on my own and would really appreciate any help anyone can give me. I have run uninstall utilities, followed a few MSDN reinstall methods, but all roads lead back to this vicious cycle:

The install hangs trying to install the prereq Microsoft SQL Server 2005 Setup Support Files with Error 1612. So I try to uninstall the Support files using Add/Remove..but the Windows Installer looks for "Microsoft SQL Server Native Client" disk, which of course I don't have because I install from downloads from Microsoft.

try manually installing SQL Native Client before the SQLExpress installation by running the relative package (half the page down)

regards

|||

Hi Andrea,

I tried what you suggested. Here is what happens.

- I get a warning that "A lower version of this product has been detected on your stystem. Would you like to upgrade your existing installation?"

- I click Yes

- Install seems to go fine -- it shows me what will be installed, etc., until I get a window saying, "Insert the 'Microsoft SQL Native Client' disk and click OK.

|||

Update: Using Windows Install Cleanup I was able to get past the Native error. I think there was a registry entry for Native install that was no longer valid. I got through the SQL install only to have a new problem. Now, during the installation System Configuration Check I pass 14 of 15 tests. I get a warning for Com Plus Catalog Requirement.

The warning message is: "Com Plus Catalog Requirement (Warning), Messages: If SQL Server Setup fails, Setup will roll back....For more information, see How to: Work Around Com+ Check Failure in SQL Server Setup."

I followed the steps in that KB article but when I add Component Services in the Console and click on Com+ Applications, I get an error: "ERror Code 8004E00F - COM+ was unable to talk to the Microsoft Distributed Transaction Coordinator.

So I looked that up and found various articles but none that seemed to apply directly to my problem.

If I continue the SQL Server setup and ignore the warning, I get a successful install of Setup Support Files, VSS WRiter, Backwards Compatability, but get failed warnings on all the of the SQL Express 2005 components. I'm once again stumped. Any ideas?

Thanks for your help.

|||

Update #2

I was to get past the above issue by following the steps at http://www.pcreview.co.uk/forums/thread-1596796.php. MSXML6 then failed during SQL Server install, so I removed it and reinstalled it. I am very close now. The error I now get is: "An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name" I have followed the steps at http://blogs.msdn.com/astebner/archive/2005/12/08/501885.aspx but this has not resolved the. I can't believe how much time I've spent on this, but maybe this error is one you have encountered? I will keep searching and posting here so others with this issue can find help. If you have any ideas I would appreciate it.

error 15004: Name cannot be NULL'

Hi,
I am tring to create a pull subscription from a server and
receiving an error '15004: Name cannot be NULL'. Is any
one knows hot to resolve this issue? Please help me.
Thanks,
Ping
Please see my reply in the Replication group.
Paul Ibison
sql

Error 13

I got an error 13 "Cannot resolve collation conflict for
equal to operation"
when trying to run some tasksThat means, you are trying to compare two character columns in your query,
but those columns are of different collations and hence the error.
Unless there's a good reason, all columns in the database should be of the
same collation. If you do need to have a different collation, then you need
to take care of that situation using the COLLATE keyword, in your queries.
if you run sp_help on the tables in question, you will see what collations
are being used by the table columns.
Look up SQL Server Books Online for more informaiton on collations and
COLLATE.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"krasi" <krkrastev@.tbicredit.bg> wrote in message
news:01f901c3de73$64587570$a001280a@.phx.gbl...
I got an error 13 "Cannot resolve collation conflict for
equal to operation"
when trying to run some tasks

Error 13

I got an error 13 "Cannot resolve collation conflict for
equal to operation"
when trying to run some tasksThat means, you are trying to compare two character columns in your query,
but those columns are of different collations and hence the error.
Unless there's a good reason, all columns in the database should be of the
same collation. If you do need to have a different collation, then you need
to take care of that situation using the COLLATE keyword, in your queries.
if you run sp_help on the tables in question, you will see what collations
are being used by the table columns.
Look up SQL Server Books Online for more informaiton on collations and
COLLATE.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"krasi" <krkrastev@.tbicredit.bg> wrote in message
news:01f901c3de73$64587570$a001280a@.phx.gbl...
I got an error 13 "Cannot resolve collation conflict for
equal to operation"
when trying to run some tasks

Error 1068

Dear friends hi,
I read the articles you mentioned, and as I understood,
the resolution is:
(To resolve the problem, use these steps:
Change the startup account of both the MSSQLSERVER and
SQLServerAgent to use the Local System account.
Restart the computer. )
As I told you before, the problem is that I can not start
the 'SqlServer' and 'SqlServer agent', so I cann't go and
change the startup account. I don't know, I may be
confused, but I just encountered this Error (Error 1068)
while starting up the SQLServer.
Thanks for any suggestion in advance,
Mattew

>--Original Message--
Mattew,
Hmmm. Probably means that something changed. Here is
one KB article. Does
it apply?
http://support.microsoft.com/default.aspx?scid=kb;en-
us;307288
A more general article (non-SQL Server) on the topic:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;827328
Russell Fields
"Mattew" <anonymous@.discussions.microsoft.com> wrote in
message
news:19d5001c44d8c$610cb740$a401280a@.phx
.gbl...
Hi,
I'm getting the following error message:
(
Could not start the SQLServerAgent Serviceon local
computer
Error 1068 : The dependency service or group failed to
start
)
This server is a subscriber in a transactional
replication and it was working until yesterday.
Does anybody have a solution.
Thanks in advance.Hi,
Steps to change the service startup account:-
1. Go to control panel -- Administrative - tools
2. Double click in services icon
3. Select and double click the MSSQL Server Service
4. In the "Log on " tab, Check the this account
5. There you verify the OS user name
6. If the user name is correct , re- enter the password and confrim password
once again
7. CLick OK
8. Start the Service
Do the above steps for SQL Agent Service as well.
Note:
ON each password change you have to do the above steps. The best
recommendation to have a user name for MSSQL server Service startup which do
not chage password frequently or no password expiry is set.
Thanks
Hari
MCDBA
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:1a4a701c44e42$10919180$a401280a@.phx
.gbl...
> Dear friends hi,
> I read the articles you mentioned, and as I understood,
> the resolution is:
> (To resolve the problem, use these steps:
> Change the startup account of both the MSSQLSERVER and
> SQLServerAgent to use the Local System account.
> Restart the computer. )
> As I told you before, the problem is that I can not start
> the 'SqlServer' and 'SqlServer agent', so I cann't go and
> change the startup account. I don't know, I may be
> confused, but I just encountered this Error (Error 1068)
> while starting up the SQLServer.
> Thanks for any suggestion in advance,
> Mattew
>
> Mattew,
> Hmmm. Probably means that something changed. Here is
> one KB article. Does
> it apply?
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;307288
> A more general article (non-SQL Server) on the topic:
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;827328
> Russell Fields
> "Mattew" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:19d5001c44d8c$610cb740$a401280a@.phx
.gbl...
> Hi,
> I'm getting the following error message:
> (
> Could not start the SQLServerAgent Serviceon local
> computer
> Error 1068 : The dependency service or group failed to
> start
> )
> This server is a subscriber in a transactional
> replication and it was working until yesterday.
> Does anybody have a solution.
> Thanks in advance.|||OMG. What a horrible message to come in to work to!
I just read about changing the startup account in CPanel.
The only thing I would want to toss in is that if you
make login changes at the CPanel level, rather then
Enterprise Mgr, you will have a ton o' problems related
to reg entries and internal stuff.
To sidestep that, if you ARE able to get the server
started using a CPanel change, can you then go into EM
and change it in there under your server's
properties/security page? Kind of a "redundant change?"
ML

>--Original Message--
>Hi,
>Steps to change the service startup account:-
>1. Go to control panel -- Administrative - tools
>2. Double click in services icon
>3. Select and double click the MSSQL Server Service
>4. In the "Log on " tab, Check the this account
>5. There you verify the OS user name
>6. If the user name is correct , re- enter the password
and confrim password
>once again
>7. CLick OK
>8. Start the Service
>Do the above steps for SQL Agent Service as well.
>Note:
>ON each password change you have to do the above steps.
The best
>recommendation to have a user name for MSSQL server
Service startup which do
>not chage password frequently or no password expiry is
set.
>Thanks
>Hari
>MCDBA
>
>
>"Mattew" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1a4a701c44e42$10919180$a401280a@.phx
.gbl...
start[vbcol=seagreen]
and[vbcol=seagreen]
1068)[vbcol=seagreen]
>
>.
>

Error 1068

Dear friends hi,
I read the articles you mentioned, and as I understood,
the resolution is:
(To resolve the problem, use these steps:
Change the startup account of both the MSSQLSERVER and
SQLServerAgent to use the Local System account.
Restart the computer. )
As I told you before, the problem is that I can not start
the 'SqlServer' and 'SqlServer agent', so I cann't go and
change the startup account. I don't know, I may be
confused, but I just encountered this Error (Error 1068)
while starting up the SQLServer.
Thanks for any suggestion in advance,
Mattew
>--Original Message--
Mattew,
Hmmm. Probably means that something changed. Here is
one KB article. Does
it apply?
http://support.microsoft.com/default.aspx?scid=kb;en-
us;307288
A more general article (non-SQL Server) on the topic:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;827328
Russell Fields
"Mattew" <anonymous@.discussions.microsoft.com> wrote in
message
news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
Hi,
I'm getting the following error message:
(
Could not start the SQLServerAgent Serviceon local
computer
Error 1068 : The dependency service or group failed to
start
)
This server is a subscriber in a transactional
replication and it was working until yesterday.
Does anybody have a solution.
Thanks in advance.Hi,
Steps to change the service startup account:-
1. Go to control panel -- Administrative - tools
2. Double click in services icon
3. Select and double click the MSSQL Server Service
4. In the "Log on " tab, Check the this account
5. There you verify the OS user name
6. If the user name is correct , re- enter the password and confrim password
once again
7. CLick OK
8. Start the Service
Do the above steps for SQL Agent Service as well.
Note:
ON each password change you have to do the above steps. The best
recommendation to have a user name for MSSQL server Service startup which do
not chage password frequently or no password expiry is set.
Thanks
Hari
MCDBA
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:1a4a701c44e42$10919180$a401280a@.phx.gbl...
> Dear friends hi,
> I read the articles you mentioned, and as I understood,
> the resolution is:
> (To resolve the problem, use these steps:
> Change the startup account of both the MSSQLSERVER and
> SQLServerAgent to use the Local System account.
> Restart the computer. )
> As I told you before, the problem is that I can not start
> the 'SqlServer' and 'SqlServer agent', so I cann't go and
> change the startup account. I don't know, I may be
> confused, but I just encountered this Error (Error 1068)
> while starting up the SQLServer.
> Thanks for any suggestion in advance,
> Mattew
> >--Original Message--
> Mattew,
> Hmmm. Probably means that something changed. Here is
> one KB article. Does
> it apply?
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;307288
> A more general article (non-SQL Server) on the topic:
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;827328
> Russell Fields
> "Mattew" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
> Hi,
> I'm getting the following error message:
> (
> Could not start the SQLServerAgent Serviceon local
> computer
> Error 1068 : The dependency service or group failed to
> start
> )
> This server is a subscriber in a transactional
> replication and it was working until yesterday.
> Does anybody have a solution.
> Thanks in advance.|||OMG. What a horrible message to come in to work to!
I just read about changing the startup account in CPanel.
The only thing I would want to toss in is that if you
make login changes at the CPanel level, rather then
Enterprise Mgr, you will have a ton o' problems related
to reg entries and internal stuff.
To sidestep that, if you ARE able to get the server
started using a CPanel change, can you then go into EM
and change it in there under your server's
properties/security page? Kind of a "redundant change?"
ML
>--Original Message--
>Hi,
>Steps to change the service startup account:-
>1. Go to control panel -- Administrative - tools
>2. Double click in services icon
>3. Select and double click the MSSQL Server Service
>4. In the "Log on " tab, Check the this account
>5. There you verify the OS user name
>6. If the user name is correct , re- enter the password
and confrim password
>once again
>7. CLick OK
>8. Start the Service
>Do the above steps for SQL Agent Service as well.
>Note:
>ON each password change you have to do the above steps.
The best
>recommendation to have a user name for MSSQL server
Service startup which do
>not chage password frequently or no password expiry is
set.
>Thanks
>Hari
>MCDBA
>
>
>"Mattew" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1a4a701c44e42$10919180$a401280a@.phx.gbl...
>> Dear friends hi,
>> I read the articles you mentioned, and as I understood,
>> the resolution is:
>> (To resolve the problem, use these steps:
>> Change the startup account of both the MSSQLSERVER and
>> SQLServerAgent to use the Local System account.
>> Restart the computer. )
>> As I told you before, the problem is that I can not
start
>> the 'SqlServer' and 'SqlServer agent', so I cann't go
and
>> change the startup account. I don't know, I may be
>> confused, but I just encountered this Error (Error
1068)
>> while starting up the SQLServer.
>> Thanks for any suggestion in advance,
>> Mattew
>> >--Original Message--
>> Mattew,
>> Hmmm. Probably means that something changed. Here is
>> one KB article. Does
>> it apply?
>> http://support.microsoft.com/default.aspx?scid=kb;en-
>> us;307288
>> A more general article (non-SQL Server) on the topic:
>> http://support.microsoft.com/default.aspx?scid=kb;en-
>> us;827328
>> Russell Fields
>> "Mattew" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
>> Hi,
>> I'm getting the following error message:
>> (
>> Could not start the SQLServerAgent Serviceon local
>> computer
>> Error 1068 : The dependency service or group failed to
>> start
>> )
>> This server is a subscriber in a transactional
>> replication and it was working until yesterday.
>> Does anybody have a solution.
>> Thanks in advance.
>
>.
>

Error 1068

Dear friends hi,
I read the articles you mentioned, and as I understood,
the resolution is:
(To resolve the problem, use these steps:
Change the startup account of both the MSSQLSERVER and
SQLServerAgent to use the Local System account.
Restart the computer. )
As I told you before, the problem is that I can not start
the 'SqlServer' and 'SqlServer agent', so I cann't go and
change the startup account. I don't know, I may be
confused, but I just encountered this Error (Error 1068)
while starting up the SQLServer.
Thanks for any suggestion in advance,
Mattew

>--Original Message--
Mattew,
Hmmm. Probably means that something changed. Here is
one KB article. Does
it apply?
http://support.microsoft.com/default.aspx?scid=kb;en-
us;307288
A more general article (non-SQL Server) on the topic:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;827328
Russell Fields
"Mattew" <anonymous@.discussions.microsoft.com> wrote in
message
news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
Hi,
I'm getting the following error message:
(
Could not start the SQLServerAgent Serviceon local
computer
Error 1068 : The dependency service or group failed to
start
)
This server is a subscriber in a transactional
replication and it was working until yesterday.
Does anybody have a solution.
Thanks in advance.
Hi,
Steps to change the service startup account:-
1. Go to control panel -- Administrative - tools
2. Double click in services icon
3. Select and double click the MSSQL Server Service
4. In the "Log on " tab, Check the this account
5. There you verify the OS user name
6. If the user name is correct , re- enter the password and confrim password
once again
7. CLick OK
8. Start the Service
Do the above steps for SQL Agent Service as well.
Note:
ON each password change you have to do the above steps. The best
recommendation to have a user name for MSSQL server Service startup which do
not chage password frequently or no password expiry is set.
Thanks
Hari
MCDBA
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:1a4a701c44e42$10919180$a401280a@.phx.gbl...
> Dear friends hi,
> I read the articles you mentioned, and as I understood,
> the resolution is:
> (To resolve the problem, use these steps:
> Change the startup account of both the MSSQLSERVER and
> SQLServerAgent to use the Local System account.
> Restart the computer. )
> As I told you before, the problem is that I can not start
> the 'SqlServer' and 'SqlServer agent', so I cann't go and
> change the startup account. I don't know, I may be
> confused, but I just encountered this Error (Error 1068)
> while starting up the SQLServer.
> Thanks for any suggestion in advance,
> Mattew
> Mattew,
> Hmmm. Probably means that something changed. Here is
> one KB article. Does
> it apply?
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;307288
> A more general article (non-SQL Server) on the topic:
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;827328
> Russell Fields
> "Mattew" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
> Hi,
> I'm getting the following error message:
> (
> Could not start the SQLServerAgent Serviceon local
> computer
> Error 1068 : The dependency service or group failed to
> start
> )
> This server is a subscriber in a transactional
> replication and it was working until yesterday.
> Does anybody have a solution.
> Thanks in advance.
|||OMG. What a horrible message to come in to work to!
I just read about changing the startup account in CPanel.
The only thing I would want to toss in is that if you
make login changes at the CPanel level, rather then
Enterprise Mgr, you will have a ton o' problems related
to reg entries and internal stuff.
To sidestep that, if you ARE able to get the server
started using a CPanel change, can you then go into EM
and change it in there under your server's
properties/security page? Kind of a "redundant change?"
ML

>--Original Message--
>Hi,
>Steps to change the service startup account:-
>1. Go to control panel -- Administrative - tools
>2. Double click in services icon
>3. Select and double click the MSSQL Server Service
>4. In the "Log on " tab, Check the this account
>5. There you verify the OS user name
>6. If the user name is correct , re- enter the password
and confrim password
>once again
>7. CLick OK
>8. Start the Service
>Do the above steps for SQL Agent Service as well.
>Note:
>ON each password change you have to do the above steps.
The best
>recommendation to have a user name for MSSQL server
Service startup which do
>not chage password frequently or no password expiry is
set.
>Thanks
>Hari
>MCDBA
>
>
>"Mattew" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1a4a701c44e42$10919180$a401280a@.phx.gbl...
start[vbcol=seagreen]
and[vbcol=seagreen]
1068)
>
>.
>

error 0xC0202092 - what is it?

Pardon, can someone tell me how to resolve and "error 0xC0202092" ?
I am trying to import a text file, with "" as the field text qualifier.
Thanks,
`LeAlright, I have narrowed the error, but not the solution.

The problem occurs when importing a text file using TEXT DELIMITERS.

Specifically, imagine these two records (Text qualifier of "" and field delimeter of "|"):

"Row 1"|"Hello Nurse"|"Goodbye"
"Row 2"|"Hello Jenna"|"Goodbye"

In the 2nd row, there are several spaces after the word "Goodbye". These spaces are causing the import problem!

This error does not appear in SQl Server 2000!

Anyone have a solution?

`Le

Error 0: This server has been disconnected

Hi all,
I'm having a problem with an SQL Server that I'm working
with and I haven't been able to find any information on
how to resolve it. I am able to log in to the the SQL
Server via Enterprise Manager and on the server, there are
around 10 - 15 databases.
I can log in to all the databases but one database takes
some time to access. When I click on Tables to view all
the tables that are in that particular database, it takes
additional time to load and I end up getting the following
error: "Error 0: This server has been disconnected. You
must reconnect to perform this operation". This problem
does not occur with any other databases on the server and,
even though it says I must reconnect, I don't have to in
order to access the other databases.
The owner of the database freed up about 40 GBs of space.
He also defragged the database and shrinked it but there
has been no change. He is able to access the database
without any problems although, before freeing up the
space, he also received the same error when trying to add
a row to a table.
The only solution that I found, aside from defragging, was
to delete the Registration in Enterprise Manager and the
Alias in the Client Network Utility and then re-enter that
information. I tried that and it didn't work. Does anyone
know why this error is occurring and how it can be fixed?I'm not sure how helpful a defragmentation will help against a file in use.
What I'd do (after backup the database) is first check who is in the user
list for that database. You might want to use the sp_change_users_login
auto_fix,<your sql login> on that database to make sure nothing got
disassociated.
Number two, I'd do an sp_who while you were trying to connect to the
database and check the SQL errorlog (either through enterprise manager or
the Logs folder which is usually where the database files are).
Number three, I'd run a DBCC CHECKDB (<database_name> ) You can specify
REPAIR_FAST as the option, it will do a minor check. Then try a
REPAIR_REBUILD before trying anything that might lose data. Make sure the
database is in single user mode (set under properties for the database in
enterprise manager)
Lastly, if you really want to try defragmentation, try detaching the
database or taking it offline first so the files aren't in use. Then try
reattaching/bringing the database online afterwards.
Good luck.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Jeff T. Severson" <jseverson@.jtsdesign.com> wrote in message
news:005c01c3d150$717c5b70$a301280a@.phx.gbl...

quote:

---

> Hi all,
> I'm having a problem with an SQL Server that I'm working
> with and I haven't been able to find any information on
> how to resolve it. I am able to log in to the the SQL
> Server via Enterprise Manager and on the server, there are
> around 10 - 15 databases.
> I can log in to all the databases but one database takes
> some time to access. When I click on Tables to view all
> the tables that are in that particular database, it takes
> additional time to load and I end up getting the following
> error: "Error 0: This server has been disconnected. You
> must reconnect to perform this operation". This problem
> does not occur with any other databases on the server and,
> even though it says I must reconnect, I don't have to in
> order to access the other databases.
> The owner of the database freed up about 40 GBs of space.
> He also defragged the database and shrinked it but there
> has been no change. He is able to access the database
> without any problems although, before freeing up the
> space, he also received the same error when trying to add
> a row to a table.
> The only solution that I found, aside from defragging, was
> to delete the Registration in Enterprise Manager and the
> Alias in the Client Network Utility and then re-enter that
> information. I tried that and it didn't work. Does anyone
> know why this error is occurring and how it can be fixed?

---

|||Andy,
Thank you for this information. I've passed it on to the database
administrator and we'll see how it works out.
Thanks again,
Jeff T. Severson
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

Error "Cannot resolve the collation conflict between"

I'm getting the following errors when trying to execute the following script on the server, its part of the standard asp.net membership and roles, anybody have any ideas how I get get round this?

Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 50
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 58
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 84
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 92
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

/****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles] Script Date: 05/20/2007 11:23:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @.statement = N'
CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]
@.ApplicationName nvarchar(256),
@.UserNames nvarchar(4000),
@.RoleNames nvarchar(4000)
AS
BEGIN
DECLARE @.AppId uniqueidentifier
SELECT @.AppId = NULL
SELECT @.AppId = ApplicationId FROM aspnet_Applications WHERE LOWER(@.ApplicationName) = LoweredApplicationName
IF (@.AppId IS NULL)
RETURN(2)

DECLARE @.TranStarted bit
SET @.TranStarted = 0

IF( @.@.TRANCOUNT = 0 )
BEGIN
BEGIN TRANSACTION
SET @.TranStarted = 1
END

DECLARE @.tbNames table(Name nvarchar(256) NOT NULL PRIMARY KEY)
DECLARE @.tbRoles table(RoleId uniqueidentifier NOT NULL PRIMARY KEY)
DECLARE @.tbUsers table(UserId uniqueidentifier NOT NULL PRIMARY KEY)
DECLARE @.Num int
DECLARE @.Pos int
DECLARE @.NextPos int
DECLARE @.Name nvarchar(256)
DECLARE @.CountAll int
DECLARE @.CountU int
DECLARE @.CountR int

SET @.Num = 0
SET @.Pos = 1
WHILE(@.Pos <= LEN(@.RoleNames))
BEGIN
SELECT @.NextPos = CHARINDEX(N'','', @.RoleNames, @.Pos)
IF (@.NextPos = 0 OR @.NextPos IS NULL)
SELECT @.NextPos = LEN(@.RoleNames) + 1
SELECT @.Name = RTRIM(LTRIM(SUBSTRING(@.RoleNames, @.Pos, @.NextPos - @.Pos)))
SELECT @.Pos = @.NextPos+1

INSERT INTO @.tbNames VALUES (@.Name)
SET @.Num = @.Num + 1
END

INSERT INTO @.tbRoles
SELECT RoleId
FROM dbo.aspnet_Roles ar, @.tbNames t
WHERE LOWER(t.Name) = ar.LoweredRoleName AND ar.ApplicationId = @.AppId
SELECT @.CountR = @.@.ROWCOUNT

IF (@.CountR <> @.Num)
BEGIN
SELECT TOP 1 N'''', Name
FROM @.tbNames
WHERE LOWER(Name) NOT IN (SELECT ar.LoweredRoleName FROM dbo.aspnet_Roles ar, @.tbRoles r WHERE r.RoleId = ar.RoleId)
IF( @.TranStarted = 1 )
ROLLBACK TRANSACTION
RETURN(2)
END

DELETE FROM @.tbNames WHERE 1=1
SET @.Num = 0
SET @.Pos = 1

WHILE(@.Pos <= LEN(@.UserNames))
BEGIN
SELECT @.NextPos = CHARINDEX(N'','', @.UserNames, @.Pos)
IF (@.NextPos = 0 OR @.NextPos IS NULL)
SELECT @.NextPos = LEN(@.UserNames) + 1
SELECT @.Name = RTRIM(LTRIM(SUBSTRING(@.UserNames, @.Pos, @.NextPos - @.Pos)))
SELECT @.Pos = @.NextPos+1

INSERT INTO @.tbNames VALUES (@.Name)
SET @.Num = @.Num + 1
END

INSERT INTO @.tbUsers
SELECT UserId
FROM dbo.aspnet_Users ar, @.tbNames t
WHERE LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @.AppId

SELECT @.CountU = @.@.ROWCOUNT
IF (@.CountU <> @.Num)
BEGIN
SELECT TOP 1 Name, N''''
FROM @.tbNames
WHERE LOWER(Name) NOT IN (SELECT au.LoweredUserName FROM dbo.aspnet_Users au, @.tbUsers u WHERE u.UserId = au.UserId)

IF( @.TranStarted = 1 )
ROLLBACK TRANSACTION
RETURN(1)
END

SELECT @.CountAll = COUNT(*)
FROM dbo.aspnet_UsersInRoles ur, @.tbUsers u, @.tbRoles r
WHERE ur.UserId = u.UserId AND ur.RoleId = r.RoleId

IF (@.CountAll <> @.CountU * @.CountR)
BEGIN
SELECT TOP 1 UserName, RoleName
FROM @.tbUsers tu, @.tbRoles tr, dbo.aspnet_Users u, dbo.aspnet_Roles r
WHERE u.UserId = tu.UserId AND r.RoleId = tr.RoleId AND
tu.UserId NOT IN (SELECT ur.UserId FROM dbo.aspnet_UsersInRoles ur WHERE ur.RoleId = tr.RoleId) AND
tr.RoleId NOT IN (SELECT ur.RoleId FROM dbo.aspnet_UsersInRoles ur WHERE ur.UserId = tu.UserId)
IF( @.TranStarted = 1 )
ROLLBACK TRANSACTION
RETURN(3)
END

DELETE FROM dbo.aspnet_UsersInRoles
WHERE UserId IN (SELECT UserId FROM @.tbUsers)
AND RoleId IN (SELECT RoleId FROM @.tbRoles)
IF( @.TranStarted = 1 )
COMMIT TRANSACTION
RETURN(0)
END
'
END
GO

ThanksThis is because the collations are not consistent across the database tables and the tables that have been created.

Try adding the COLLATE to your insert queries.

something like
INSERT INTO @.tbUsers
SELECT UserId COLLATE SQL_Latin1_General_CP1_CI_AS
FROM dbo.aspnet_Users ar, @.tbNames t
WHERE LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @.AppId
or
INSERT INTO @.tbUsers
SELECT UserId COLLATE Latin1_General_CI_AS
FROM dbo.aspnet_Users ar, @.tbNames t
WHERE LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @.AppId

coz i really dont know which one is conflicting.....i mean which collation|||Yes your right the db and the table fields have different collation values but I don't understand how to change this as this was installed by .net, Can I change this and will it have any impact, Its funny because I've scripted the db from my dev machine and its working fine and now that I'm trying to create it on my host .. Wierd

ERROR - Subscription Failure (Please Help!)

The report subscription is returning the following error message.
How should I resolve this issue?
However, according to the Job executed, the process was successful but the
report manager is displaying the following.
ERROR:
Failure sending mail: The report server has encountered a configuration
error. See the report server log files for more information.
Also, the event viewer is displaying the following error message well.Also, the event viewer is displaying the following error message well.
User: NT AUTHORITY\SYSTEM
Computer: REPORTSERV
Event Type: Failure Audit
Event Source: Security
Event Category: Logon/Logoff
Event ID: 529
Date: 11/30/2005
Time: 10:49:03 AM
User: NT AUTHORITY\SYSTEM
Computer: REPORTSERV
Description:
Logon Failure:
Reason: Unknown user name or bad password
User Name:
Domain:
Logon Type: 3
Logon Process: Authz
Authentication Package: Kerberos
Workstation Name: REPORTSERV
Caller User Name: NETWORK SERVICE
Caller Domain: NT AUTHORITY
Caller Logon ID: (0x0,0x3E4)
Caller Process ID: 5928
Transited Services: -
Source Network Address: -
Source Port: -
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"Terry" wrote:
> The report subscription is returning the following error message.
> How should I resolve this issue?
> However, according to the Job executed, the process was successful but the
> report manager is displaying the following.
> ERROR:
> Failure sending mail: The report server has encountered a configuration
> error. See the report server log files for more information.
> Also, the event viewer is displaying the following error message well.
>
>