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
>

Can't preview report after convert to 2005 with <CodeModule> [rsErrorLoadingCodeModule]

I have a .rdl file which I opened in visual studio 2005. I answered Yes to the prompt Microsoft Report Designer. . . Do you want to convert this file? [Yes] Then I saved the file.

The issue is when I am in Visual Studio and click on the Preview tab, I get the following error:

[rsErrorLoadingCodeModule] Error while loading code module: ‘x.ReportDefinitionsHelper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'AdvancedMD.Report.ReportDefinitionsHelper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.

There was a <CodeModule> which existed prior to the conversion and the preview worked fine.

I tried to re-add the reference by clicking on the Layout tab then go to the report properties tab. Then, under references I clicked on the collection and browsed to the file which I wanted to reference and clicked ok, but I still get the error above when I click on the Preview tab. I tried to remove the reference save then come back in and add it again, but it still gives the error above.

The file I am trying to add to <CodeModule> (x.ReportDefinitionsHelper) references the following:

System

System.Data

System.Xml

Any help would be greatly appreciated.

Thanks

(I can load the .rdl to reporting services 2005 and go into Reporting Services Manager and view the report without any issues.)

I just had to move the file I was referenceing to the following location:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

|||This solved the problem for me too. I have part of the VS2005 installed on my D: drive instead of the C: drive. But regardless of this I think it is strange that we have to put our own dll's in the MS directories. I would like to have them in my own project files. I think it is a bug since the VS2005 has a project structure, and it seems this does not fit in.|||

I had the same problem and however I have installed VS2005 in C: so that isn't the problem... the solution for me, as for TMK and Jelle, has been to put my dll in:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

What i would like to know is the reason because of we have to put our dlls in that directory if in our references we specified another directory...

Can anyone explain it to us?

Can't preview report after convert to 2005 with <CodeModule> [rsErrorLoadingCodeModul

I have a .rdl file which I opened in visual studio 2005. I answered Yes to the prompt Microsoft Report Designer. . . Do you want to convert this file? [Yes] Then I saved the file.

The issue is when I am in Visual Studio and click on the Preview tab, I get the following error:

[rsErrorLoadingCodeModule] Error while loading code module: ‘x.ReportDefinitionsHelper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'AdvancedMD.Report.ReportDefinitionsHelper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.

There was a <CodeModule> which existed prior to the conversion and the preview worked fine.

I tried to re-add the reference by clicking on the Layout tab then go to the report properties tab. Then, under references I clicked on the collection and browsed to the file which I wanted to reference and clicked ok, but I still get the error above when I click on the Preview tab. I tried to remove the reference save then come back in and add it again, but it still gives the error above.

The file I am trying to add to <CodeModule> (x.ReportDefinitionsHelper) references the following:

System

System.Data

System.Xml

Any help would be greatly appreciated.

Thanks

(I can load the .rdl to reporting services 2005 and go into Reporting Services Manager and view the report without any issues.)

I just had to move the file I was referenceing to the following location:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

|||This solved the problem for me too. I have part of the VS2005 installed on my D: drive instead of the C: drive. But regardless of this I think it is strange that we have to put our own dll's in the MS directories. I would like to have them in my own project files. I think it is a bug since the VS2005 has a project structure, and it seems this does not fit in.|||

I had the same problem and however I have installed VS2005 in C: so that isn't the problem... the solution for me, as for TMK and Jelle, has been to put my dll in:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

What i would like to know is the reason because of we have to put our dlls in that directory if in our references we specified another directory...

Can anyone explain it to us?

cant load rep mgr without user + pass prompt ?

When loading Report Manager on the hosting Rep Service machine i cant access
any options without a password + user. I cant get any to work.
When setting up Rep Services in every option possible i defiend a local
service account at first. I then uninstalled the software and installed
again users the domain admin account.
Any idea why i cant login to the manager options ?
Thanks
Scotti needed to login as localhost/administrator.....there is hope yet.