Friday, March 30, 2012

Microsoft SQL Server 2005 Enterprise Evaluation Edition

I have installed Microsoft SQL Server 2005 Enterprise Evaluation Edition. The file size is now 4035. When I tried to add new data file name,I am getting the below error.

In the below site it says that there is no limit on the size but Iam still getting the problem

http://www.microsoft.com/downloads/details.aspx?familyid=6931fa7f-c094-49a2-a050-2d07993566ec&displaylang=en
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Pls can any one help me.

Alter failed for database 'test'. (Microsoft.SqlServer.Smo)

An exception occured while executing a Transact-SQL statement or batch(Microsoft.SqlServer.ConnectionInfo)

Create DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096MB per database (Microsoft SQL Server, Error:1827)Seems that you instaleld SQL Server Express edition. The limitation mentioned applies to this edition. Run the SELECT @.@.VERSION on the machine you are using command.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I did run select @.@.version on my machine, please find below the result of it

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

Please help

|||

Hi,

so you either did not have Enterprise edition installed, or connected to the wrong instance.

HTH, Jens K. Suessmeyer.


http://www.sqlserver2005.de

No comments:

Post a Comment