April CTP:error when attaching db and when creating file in filegroup

Hi.
I'm using SQL Server 2005 beta 2 April CTP:

I am always getting this error while trying to attach a database and even when I try to create a file in a filegroup for table partitioning.

Error:

The file "<filename> " is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

is it a security problem?

Thanks
Christina

I found out that it will not accept a file if it is not found under the
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
folder.

|||I saw the same thing but is that the expected behavior. Can we not create database with database files any where on the hard drive.|||

I am not aware of such requirement, but based on your error message
I think your file is compressed (or is placed on compressed disk or folder)

Could you please check it. Click on the file property and go to Advance attributes to see if

"Compress contents to save disk space" is activated (checked).

Do the same for the file folder. If this is the case, please deactivate it.

SQL Server supports compressions with some limitations

(see Using NTFS Compression with Read-Only Secondary Filegroups and Read-Only Databases under Read-only filegroups in BOL)

Thanks

Mirek

|||Christina -
Did you have a chance the check if your file is using compressed media?
Thanks
Mirek|||Dear Mirek,
Thanks for your input.
I just tried it and as u said, it worked.

Regards,
Christina

April CTP superkey oddity

I've set up a table with a superkey composed of a uniqueidentifier column and a varchar column. The uniqueidentifier column is not set to be a row GUID. When I try to add a new row with a duplicate uniqueidentifier value but different varchar value, I am told it violates the IX uniqueness constraint. I can't figure out what's wrong with this since it looks valid to me. Thanks in advance for suggestions.

JoshJust an FYI- I dropped the table and recreated it as I did before and everything went as expected!

Josh

April CTP installation failed

I've already installed VSTS 2005 Beta2 and I try to install workstation components of April CTP. What should I try to pass th error?
The error is at the end of installation:

Failed to generate type library 'C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.tlb' for 'Microsoft.SqlServer.MSMQTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'.
System.EnterpriseServices

Server stack trace:
at System.EnterpriseServices.RegistrationDriver.InstallAssembly(RegistrationConfig regConfig, Object obSync)

at System.EnterpriseServices.RegistrationHelperTx.InstallAssemblyFromConfig(RegistrationConfig& regConfig, Object sync)

at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target, Boolean fExecuteInContext)

at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

Exception rethrown at [0]:
at System.EnterpriseServices.RegistrationThreadWrapper.PropInstallResult()

at System.EnterpriseServices.RegistrationHelper.InstallAssemblyFromConfig(RegistrationConfig& regConfig)

at System.EnterpriseServices.RegistrationHelper.InstallAssembly(String assembly, String& application, String partition, String& tlb, InstallationFlags installFlags)

at System.EnterpriseServices.RegistrationHelper.InstallAssembly(String assembly, String& application, String& tlb, InstallationFlags installFlags)

at Microsoft.SqlServer.Setup.SetupHelper.InstallAssembly(String AssemblyName)
End of Log is:
--
MSI (s) (00:10) [20:06:56:332]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI1A4.tmp, Entrypoint: CommitTransaction
05/17/05 20:06:56 DDSet_Status: LANGID: 1049
05/17/05 20:06:56 DDSet_Entry: CommitTransaction started
05/17/05 20:06:56 DDSet_Status: LANGID: 1049
05/17/05 20:06:56 DDSet_Entry: CMsHelpObject constructor
05/17/05 20:06:56 DDSet_Status: LANGID: 1049
05/17/05 20:06:56 DDSet_Entry: CHelpCrypto constructor
05/17/05 20:06:56 DDSet_Exit: CHelpCrypto destructor
05/17/05 20:06:57 DDSet_Status: CommitTransaction()->IHxRegisterSession::CommitTransaction() returned 0.
05/17/05 20:06:57 DDSet_Status: CommitTransaction()->{90032DD0-ABEE-4424-AC1E-B076BDD4E350} was successfully committed.
05/17/05 20:06:57 DDSet_Exit: CMsHelpObject destructor
05/17/05 20:06:57 DDSet_Exit: CommitTransaction ended
MSI (s) (00:4C) [20:06:57:707]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI1A5.tmp, Entrypoint: Do_sqlAssemblyRegSvcs
<Func Name='LaunchFunction'>
Function=Do_sqlAssemblyRegSvcs
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlAssemblyRegSvcs
PerfTime Start: Do_sqlAssemblyRegSvcs : Tue May 17 20:06:59 2005
<Func Name='Do_sqlAssemblyRegSvcs'>
Unable to install .NET Framework Service C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll
<EndFunc Name='Do_sqlAssemblyRegSvcs' Return='1603' GetLastError='14007'>
PerfTime Stop: Do_sqlAssemblyRegSvcs : Tue May 17 20:07:55 2005
Gathering darwin properties for failure handling.
Error Code: 1603
MSI (s) (00!3C) [20:08:07:770]: Product: Microsoft SQL Server 2005 Tools CTP -- Error 29635. The setup has encountered an unexpected error while Installing .NET Frameworks Assemblies. The error is : .

Error 29635. The setup has encountered an unexpected error while Installing .NET Frameworks Assemblies. The error is : .

<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='14007'>
Doing Action: Do_sqlAssemblyRegSvcs
PerfTime Start: Do_sqlAssemblyRegSvcs : Tue May 17 20:08:07 2005
--

I am encountering the same error. Does anyone have a solution?

Thx.|||Hi,

I believe that this link can help http://lab.msdn.microsoft.com/vs2005/get/vsbeta2installissues/default.aspx

regards
Nilton

|||Hi,
I ignored the error and the rest of the install proceeded fine. I did have problems with launching Management Studio(see my post here).

These issues may or may not be related. I got this error (the one you refer to) when installing from a copy of the DVD handed out at a seminar. The funny thing is , when i installed from the ISO, i didnt get the error but management studio didnt launch either.

Did you Abort or Ignore the error? Try IGNORE and see what happens?

HTH

Cheers
Benjy|||Actually I really have ignored the error and tools were installed.
Management Studio cannot run. It tries to send an error report to Microsoft. Other tools work fine.
Some info about error can be found in the Application log:

sqlwb.exe, 2000.90.1116.0, msenv.dll, 8.0.50215.44, 0x000a209e.

Error of application ..., version ..., module ..., version ..., address ...

I don't have any workaround. Try to reinstall didn't help.

WBR,
Stone

April 2005 CTP On Virtual PC 2004

Hello, I have installed the SQL Server 2005 april CTP on a Virtual PC running Win2003 standard edition. The Management Studio appears to be corrupted and it says that "no such interface supported". This happens only on the VPC. On the main workstation running XP the Management Studio is fine.

The same issue arises with the ISO i downloaded from MSDN as well as a copy of the DVD given out at a MS developer event in Reading, U.K recently.

Does this ring a bell with anyone? has this surfaced for anyone else?

TIA
BenjyFor a faster response I suggest you post this to the SQL Server Tools General forum.

Dan

Apply SP2 after applying CTP?

Should I apply SP2 even though I have already installed the community preview?

Yes, I'd suggest that you apply the released SP2 on top of the CTP. There were several fixes that were included in the released version.

Thanks,
Sam Lester (MSFT)