An error occurred while attempting to start the service (193)

I have seen several threads on this topic but none of the solutions
mentioned work for me. I recentley uninstalled MSSQL 200 from my
machine and now I am trying to reinstall. I get this message
consistently. Any help is appreciated.
Thanks!
12:17:31 C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT\sqlstp.log" -I
MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 66094 -U sa
-P
###############################################################################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
An error occurred while attempting to start the service (193)
SQL Server configuration failed.
###############################################################################have you tried this kba?
http://support.microsoft.com/default.aspx?scid=kb;en-us;285100
"shcodip" wrote:
> I have seen several threads on this topic but none of the solutions
> mentioned work for me. I recentley uninstalled MSSQL 200 from my
> machine and now I am trying to reinstall. I get this message
> consistently. Any help is appreciated.
> Thanks!
> 12:17:31 C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT\sqlstp.log" -I
> MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 66094 -U sa
> -P
> ###############################################################################
>
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
> An error occurred while attempting to start the service (193)
> SQL Server configuration failed.
> ###############################################################################
>|||My computer name is already upercase. So this does not apply.
Olu Adedeji wrote:
> have you tried this kba?
> http://support.microsoft.com/default.aspx?scid=kb;en-us;285100
> "shcodip" wrote:
> > I have seen several threads on this topic but none of the solutions
> > mentioned work for me. I recentley uninstalled MSSQL 200 from my
> > machine and now I am trying to reinstall. I get this message
> > consistently. Any help is appreciated.
> > Thanks!
> >
> > 12:17:31 C:\Program Files\Microsoft SQL
> > Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT\sqlstp.log" -I
> > MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 66094 -U
sa
> > -P
> >
###############################################################################
> >
> >
> > Starting Service ...
> >
> > SQL_Latin1_General_CP1_CI_AS
> >
> > -m -Q -T4022 -T3659
> >
> > An error occurred while attempting to start the service (193)
> >
> > SQL Server configuration failed.
> >
> >
###############################################################################
> >
> >

An error occurred while attempting to start the service (193)

I have seen several threads on this topic but none of the solutions
mentioned work for me. I recentley uninstalled MSSQL 200 from my
machine and now I am trying to reinstall. I get this message
consistently. Any help is appreciated.
Thanks!
12:17:31 C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT\sqlstp.log" -I
MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 66094 -U sa
-P
################################################## #############################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
An error occurred while attempting to start the service (193)
SQL Server configuration failed.
################################################## #############################
have you tried this kba?
http://support.microsoft.com/default...b;en-us;285100
"shcodip" wrote:

> I have seen several threads on this topic but none of the solutions
> mentioned work for me. I recentley uninstalled MSSQL 200 from my
> machine and now I am trying to reinstall. I get this message
> consistently. Any help is appreciated.
> Thanks!
> 12:17:31 C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT\sqlstp.log" -I
> MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 66094 -U sa
> -P
> ################################################## #############################
>
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
> An error occurred while attempting to start the service (193)
> SQL Server configuration failed.
> ################################################## #############################
>
|||My computer name is already upercase. So this does not apply.
Olu Adedeji wrote:[vbcol=seagreen]
> have you tried this kba?
> http://support.microsoft.com/default...b;en-us;285100
> "shcodip" wrote:
sa[vbcol=seagreen]
################################################## #############################[vbcol=seagreen]
################################################## #############################[vbcol=seagreen]

AMD Opteron 64 & SQL 2000 32 bit

Are there any known issues with the AMD Opteron 200 Series running Windows
2003 Ent. Edition and SQL 2000 Ent in a cluster?
In a few threads I have seen remarks that SP 4 is needed, but in the feature
list of SP4 there is no mention about this.
Thanks,
JanThere's is only a 64 bit version of SQL Server 2000 for the Intel Itanium pr
ocessor. Running 32 bit
SQL Server on WOW (Windows on Windows), where Windows emulates 32 bit on 64
bit HW using the x64
processor architecture and OS wasn't supported until sp4. This link might ha
ve some details:
http://www.microsoft.com/downloads/...&displaylang=en
As for issues, I don't know. I imagine that this isn't a very common setup.
And with SQL Server 2005
out where there exists an x64 version, it might not be a common setup either
?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jan" <Jan@.discussions.microsoft.com> wrote in message
news:3F4C6DF9-5D21-4F70-AC48-7BF6EE2A14A0@.microsoft.com...
> Are there any known issues with the AMD Opteron 200 Series running Windows
> 2003 Ent. Edition and SQL 2000 Ent in a cluster?
> In a few threads I have seen remarks that SP 4 is needed, but in the featu
re
> list of SP4 there is no mention about this.
> Thanks,
> Jan

AMD Opteron 64 & SQL 2000 32 bit

Are there any known issues with the AMD Opteron 200 Series running Windows
2003 Ent. Edition and SQL 2000 Ent in a cluster?
In a few threads I have seen remarks that SP 4 is needed, but in the feature
list of SP4 there is no mention about this.
Thanks,
Jan
There's is only a 64 bit version of SQL Server 2000 for the Intel Itanium processor. Running 32 bit
SQL Server on WOW (Windows on Windows), where Windows emulates 32 bit on 64 bit HW using the x64
processor architecture and OS wasn't supported until sp4. This link might have some details:
http://www.microsoft.com/downloads/d...displaylang=en
As for issues, I don't know. I imagine that this isn't a very common setup. And with SQL Server 2005
out where there exists an x64 version, it might not be a common setup either?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jan" <Jan@.discussions.microsoft.com> wrote in message
news:3F4C6DF9-5D21-4F70-AC48-7BF6EE2A14A0@.microsoft.com...
> Are there any known issues with the AMD Opteron 200 Series running Windows
> 2003 Ent. Edition and SQL 2000 Ent in a cluster?
> In a few threads I have seen remarks that SP 4 is needed, but in the feature
> list of SP4 there is no mention about this.
> Thanks,
> Jan

AMD Opteron 64 & SQL 2000 32 bit

Are there any known issues with the AMD Opteron 200 Series running Windows
2003 Ent. Edition and SQL 2000 Ent in a cluster?
In a few threads I have seen remarks that SP 4 is needed, but in the feature
list of SP4 there is no mention about this.
Thanks,
JanThere's is only a 64 bit version of SQL Server 2000 for the Intel Itanium processor. Running 32 bit
SQL Server on WOW (Windows on Windows), where Windows emulates 32 bit on 64 bit HW using the x64
processor architecture and OS wasn't supported until sp4. This link might have some details:
http://www.microsoft.com/downloads/details.aspx?FamilyID=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
As for issues, I don't know. I imagine that this isn't a very common setup. And with SQL Server 2005
out where there exists an x64 version, it might not be a common setup either?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jan" <Jan@.discussions.microsoft.com> wrote in message
news:3F4C6DF9-5D21-4F70-AC48-7BF6EE2A14A0@.microsoft.com...
> Are there any known issues with the AMD Opteron 200 Series running Windows
> 2003 Ent. Edition and SQL 2000 Ent in a cluster?
> In a few threads I have seen remarks that SP 4 is needed, but in the feature
> list of SP4 there is no mention about this.
> Thanks,
> Jan

Always the Worker Thread

I received the following msg resulting from a backup: (partial) "increase the
maximum worker threads for the SQL Server SQLSRVR\SSDDWP_SQL2. Or decrease
the maximum number of databases to backup concurrently". There is a another
full backup at a different time of day on this server that succeeds. This
instance is on a cluster server. I do not receive this msg throughout the
day. I do have 400 or so connections throughout the day. My threads are set
to the default of 255. I have 4 CPUs in each server. How can I accommodate
this backup? Would the idea be to run the dbcc sqlperf(UMSSTATS) at the same
time the backup is occurring?
One other question on the dbcc sqlperf(UMSSTATS). So my "work queued" at 0
or 1 and idle workers should be close to the same number as num workers?
thanks
"RomM" wrote:

> I received the following msg resulting from a backup: (partial) "increase the
> maximum worker threads for the SQL Server SQLSRVR\SSDDWP_SQL2. Or decrease
> the maximum number of databases to backup concurrently". There is a another
> full backup at a different time of day on this server that succeeds. This
> instance is on a cluster server. I do not receive this msg throughout the
> day. I do have 400 or so connections throughout the day. My threads are set
> to the default of 255. I have 4 CPUs in each server. How can I accommodate
> this backup? Would the idea be to run the dbcc sqlperf(UMSSTATS) at the same
> time the backup is occurring?
>

Always the Worker Thread

I received the following msg resulting from a backup: (partial) "increase the
maximum worker threads for the SQL Server SQLSRVR\SSDDWP_SQL2. Or decrease
the maximum number of databases to backup concurrently". There is a another
full backup at a different time of day on this server that succeeds. This
instance is on a cluster server. I do not receive this msg throughout the
day. I do have 400 or so connections throughout the day. My threads are set
to the default of 255. I have 4 CPUs in each server. How can I accommodate
this backup? Would the idea be to run the dbcc sqlperf(UMSSTATS) at the same
time the backup is occurring?One other question on the dbcc sqlperf(UMSSTATS). So my "work queued" at 0
or 1 and idle workers should be close to the same number as num workers?
thanks
"RomM" wrote:
> I received the following msg resulting from a backup: (partial) "increase the
> maximum worker threads for the SQL Server SQLSRVR\SSDDWP_SQL2. Or decrease
> the maximum number of databases to backup concurrently". There is a another
> full backup at a different time of day on this server that succeeds. This
> instance is on a cluster server. I do not receive this msg throughout the
> day. I do have 400 or so connections throughout the day. My threads are set
> to the default of 255. I have 4 CPUs in each server. How can I accommodate
> this backup? Would the idea be to run the dbcc sqlperf(UMSSTATS) at the same
> time the backup is occurring?
>

Always the Worker Thread

I received the following msg resulting from a backup: (partial) "increase th
e
maximum worker threads for the SQL Server SQLSRVR\SSDDWP_SQL2. Or decrease
the maximum number of databases to backup concurrently". There is a anothe
r
full backup at a different time of day on this server that succeeds. This
instance is on a cluster server. I do not receive this msg throughout the
day. I do have 400 or so connections throughout the day. My threads are se
t
to the default of 255. I have 4 CPUs in each server. How can I accommodat
e
this backup? Would the idea be to run the dbcc sqlperf(UMSSTATS) at the sam
e
time the backup is occurring?One other question on the dbcc sqlperf(UMSSTATS). So my "work queued" at 0
or 1 and idle workers should be close to the same number as num workers?
thanks
"RomM" wrote:

> I received the following msg resulting from a backup: (partial) "increase
the
> maximum worker threads for the SQL Server SQLSRVR\SSDDWP_SQL2. Or decrease
> the maximum number of databases to backup concurrently". There is a anot
her
> full backup at a different time of day on this server that succeeds. This
> instance is on a cluster server. I do not receive this msg throughout the
> day. I do have 400 or so connections throughout the day. My threads are
set
> to the default of 255. I have 4 CPUs in each server. How can I accommod
ate
> this backup? Would the idea be to run the dbcc sqlperf(UMSSTATS) at the s
ame
> time the backup is occurring?
>