Cant start SQL 2005 with /T 1400.

Howdy all. Im trying to start up SQL 2005 with /T 1400. From the command
prompt I:
sqlservr.exe -s development\mysql2k5 -T 1400
(also tried /T 1400)
and I get:
Application popup: SQL Server : Your SQL Server installation is either
corrupt or has been tampered with (Error: Instance name exceeds maximum
length.). Please uninstall then re-run setup to correct this problem
I've been trying lots of variations of this, as well as adding the -T to the
end of the startup parameters in the Config Manager. I know that the message
is bogus because I can run this instance of SQL from the Config Manager
without the -T.
Any ideas?
TIA, ChrisRSpecify only the instance name on the command prompt parameter:
sqlservr.exe -s mysql2k5 -T 1400
Also, you don't need trace flag 1400 once you install SQL 2005 SP1.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"ChrisR" <ChrisR@.noEmail.com> wrote in message
news:%235OcHtmkGHA.4044@.TK2MSFTNGP03.phx.gbl...
> Howdy all. Im trying to start up SQL 2005 with /T 1400. From the command
> prompt I:
> sqlservr.exe -s development\mysql2k5 -T 1400
> (also tried /T 1400)
> and I get:
> Application popup: SQL Server : Your SQL Server installation is either
> corrupt or has been tampered with (Error: Instance name exceeds maximum
> length.). Please uninstall then re-run setup to correct this problem
> I've been trying lots of variations of this, as well as adding the -T to
> the
> end of the startup parameters in the Config Manager. I know that the
> message
> is bogus because I can run this instance of SQL from the Config Manager
> without the -T.
> Any ideas?
> TIA, ChrisR
>|||Hi,
Do you need to enable trace flag 1400 to turn on Database Mirroring? That is
no longer needed if you apply Service Pack 1. I would recommend to try SP1
instead.
Ben Nevarez, MCDBA, OCP
Database Administrator
"ChrisR" wrote:
> Howdy all. Im trying to start up SQL 2005 with /T 1400. From the command
> prompt I:
> sqlservr.exe -s development\mysql2k5 -T 1400
> (also tried /T 1400)
> and I get:
> Application popup: SQL Server : Your SQL Server installation is either
> corrupt or has been tampered with (Error: Instance name exceeds maximum
> length.). Please uninstall then re-run setup to correct this problem
> I've been trying lots of variations of this, as well as adding the -T to the
> end of the startup parameters in the Config Manager. I know that the message
> is bogus because I can run this instance of SQL from the Config Manager
> without the -T.
> Any ideas?
> TIA, ChrisR
>
>|||Thank you both.
"ChrisR" <ChrisR@.noEmail.com> wrote in message
news:%235OcHtmkGHA.4044@.TK2MSFTNGP03.phx.gbl...
> Howdy all. Im trying to start up SQL 2005 with /T 1400. From the command
> prompt I:
> sqlservr.exe -s development\mysql2k5 -T 1400
> (also tried /T 1400)
> and I get:
> Application popup: SQL Server : Your SQL Server installation is either
> corrupt or has been tampered with (Error: Instance name exceeds maximum
> length.). Please uninstall then re-run setup to correct this problem
> I've been trying lots of variations of this, as well as adding the -T to
the
> end of the startup parameters in the Config Manager. I know that the
message
> is bogus because I can run this instance of SQL from the Config Manager
> without the -T.
> Any ideas?
> TIA, ChrisR
>