1. The Workgroup Edition comes with Windows SBS Server/Premium. However the docs for SQL/Server 2005 say not to install it on a Domain Controller. What does this mean--buy a separate box for the SQL Server software? If so with which OS?
2. If we get Windows SBS Standard, could we just install/download SQL Express on that Server? Even if it's a Domain Controller?
2. If a client is running an app on SQL Server 7, and wants to upgrade to 2005 (3-5 simultaneous uses of a DB about 1GB), which edition should we get?
I have the SQL Server 2005 Enterprise Edition CD and have succesfully installed this on my desktop.
When I install this on my Laptop the version is 2000(print @@version) is only Desktop version (2gb db limit!)....
Any ideas on why the full enterprise edition is not installing on the laptop?!!
Version on my Desktop: MICROSOFT SQL SERVER 2005-9.00.1399.06 (INTEL X86) OCT 14 2005 00.33.37 1988-2005 microsoft corp enterprise edition on windows NT 5.2 (build 3790-service pack)
Version on my laptop: MICROSOFT SQL SERVER 2000-8.00.2039(INTEL X86) May 14 2005 23:18:38 Copyright (c) 1988-2005 Microsoft Corporation desktop engine on windows NT 5.1 (build 2600: service pack 2)
The Laptop spec is: Intel 1.66Ghz, 1 Gb Ram, 50 Gb HDD, Windows XP SP2
The Desktop spec is: Intel 2.8 Ghz Dual Core, 2 Gb Ram, 320 Gb HDD, Windows XP SP2
Both SQL Server 2005 versions are installed from the same CD so why would there be a difference?
I understand that you cannot have Enterprise edition on XP but it has installed on the desktop, not the laptop???
I've developed and tested an application that utilizes the standard (.SQLEXPRESS, not user instance) instance of SQL Server 2005 Express. I'd like to be able to say that my solution will operate on any of the 32-bit SQL Server editions (Express, Workgroup, Standard, Developer, Enterprise).
I've found anecdotal comments from people saying that SQL Express is a subset of the other versions. However, in order to truly validate my "any edition" claim, I need to either:
a) Install and test my solution with all editions of SQL Server, or
b) Provide a justification for saying: "If it works on SQL Express, it'll work with the other editions".
Does anyone know if there is some official documentation somewhere that affirms the functional equivalence of the editions?
Is there documentation that states that each SQL Server edition is compiled from the same codebase?
Does the x64 version of SQL Server 2005 June CTP contain 64-bit versions of the SQL Server ODBC Driver and the OLE DB Provider? I am not interested in the .NET Managed Provider here, just the legacy ODBC and OLE DB drivers, and only 64-bit versions of those.
My understanding is that at installation of all but the Express edition, there is no choice but to have VS2005 installed as well. If this is true, can VS 2005 at least be uninstalled after a different debugger is enlisted?
There are numerous posts regarding this error when installing SQL Server 2005 on Windows Vista RTM thus I am starting a new thread in order to get resolution one way or another:SQL Server Setup failed to execute a command for server configuration. The error was [SQL Native Client]Windows user or group "USERNAMESQLServer2005MSFTEUser$USERNAME$MSSQLSERVER" not found. Check the name again... The error occurs when installing SQL Server 2005 Developer Edition, SQL Server Express SP1, SQL Server Express SP2 CTR (with or without the SP2 Toolkit package installed beforehand). The error occurs with or without UAC.
The installation then fails. Please advise if you have any insights. SQL Server Express SP2 CTR was announced as a workable version for Vista... note that this is not the case.
I am attempting to insert information from Visual Web Developer 2005 using either the Gridview or Datalist controls into a SQL Server 2005 database and get stuck when defining the custom statement.When I enter the text within the insert tab, the <next> button remains greyed out, preventing me from continuing to the next page.If I copy the same text into the select tab, then I can continue with the wizard, however this raises other problems which may or may not be related (multiple insertions of the data into the SQL Server database table - possibly due to postback functions). I would rather use insert to confirm that my second problem is not because I am using the wrong option.My question is:Should I be able to use the insert function within VWD express or is this only available within the standard/pro editions?
Is it required to have all the three machines with Enterprise Editions? OR Can we install SQL Developer Edition on both DEV and TEST and have Enterprise Edition on production?
1) Which version of sql server do I need to be able to install it on my local win xp pro? At present there is no server. I guess the answer is standard edition and not the enterprise, right?
2) At present I have the enterprise edition CDs. If I install the Enterprise edition then does that mean on my xp pro I will have standard edition?
We are having 2012 Enterprise Edition,If I installed the Express Edition in other Client system is it possible to connect the Server system by using Express Edition....And Can we Connect the other server editions like Enterprise,Standard..etc by Express edition...
The advanced transforms only available with Enterprise edition:
Data Mining Training Destination Data Mining Query Component Fuzzy Grouping Fuzzy Lookup Term Extraction Term Lookup The advanced tasks only available with Enterprise edition:
Data Mining Query Task
Now what does all of those terminologies mean above? We are trying to determine if we need to really invest in the enterprise edition for the integration services. The information I got came from:
Hi My project is in .NET 2003 i.e. framework 1.1 and database in SQLServer 2000. But the reports have been developed using SQLServer 2005 Reporting Services. Now when I am trying to deploy them through deployment project of .NET its giving me following error:"Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services. Now I am really confused with this. Can any one please guide me regarding this ASAP. Thanks, Falguni
Hi, I need to know what is the exact difference between different Editions of SQL 7. Cost of SQL 7 Enterprise Edition is 5 times that of Developer's Edition of SQL 7. Also there is other edition called Standard Edition. At least i would like to know where can i get this information immidiately.
I have the SQL Server 2005 Enterprise Edition CD and have succesfully installed this on my desktop.
When I install this on my Laptop the version is 2000(print @@version) is only Desktop version (2gb db limit!)....
Any ideas on why the full enterprise edition is not installing on the laptop?!!
Version on my Desktop: MICROSOFT SQL SERVER 2005-9.00.1399.06 (INTEL X86) OCT 14 2005 00.33.37 1988-2005 microsoft corp enterprise edition on windows NT 5.2 (build 3790-service pack)
Version on my laptop: MICROSOFT SQL SERVER 2000-8.00.2039(INTEL X86) May 14 2005 23:18:38 Copyright (c) 1988-2005 Microsoft Corporation desktop engine on windows NT 5.1 (build 2600: service pack 2)
The Laptop spec is: Intel 1.66Ghz 1 Gb Ram 50 Gb HDD Windows XP SP2
Both SQL Server 2005 versions are installed from the same CD so why would there be a difference?
I am starting a class on SQL Server, and my school wants me to builddb's either on campus or remotely at my home connecting to their SQLServer Enterprise.Will I be okay to use Developer Edition at home to connect with anEnterprise-licensed SQL Server on campus, to build databases,sprocs, .net apps that connect to the database stored on my school'sserver?I would rather avoid the Express edition.thanks
hello all, has anyone attempted (or succesfully implemented) a solution using Standard Edition, **as a replacement** for Enterprise Edition, in a multi-partition environment?
I believe one can use external partitions in SSAS to draw data from SQL Server, I'm not sure if that's a feature that works with the Standard Ed. of SSAS.
Namely, I'd like to see if I can use a setup of 4 installs of SQL Server, Standard Edition, and use that as a feed data into SSAS Standard Edition, and save some money on licensing (probably at a cost of increased maintenance). I know that the Enterprise version also has some enhanced analytics functions and other cool stuff so that'll be lost as well, with this potential setup.
My inclination is that to use external/Remote Partitions one would still need to use the Enterprise Edition, making this the only choice, for large cube builds -- but I may be wrong.
I just used the SSIS Import and Export Wizard to copy 50+ tables from SS05 to SS2K.
I found that the wizard created a package that I could not figure out how to edit, e.g., to change whether or not it had to CREATE a table, or just use an existing one. (I created some problems by manually editing the receiving table names to be ones that already existed -- but the original names it had did not exist, so it knew it had to create them. What I should have done, and eventually ended up doing, was scroll through my list of tables in the "receiving" box; I just figured editing the name would be faster, not realizing what problems I would create for myself.)
Anyhow, now that I see the complex package that the wizard creates, with a LOOP over the 50+ tables, I would like to know how/where in the package it is storing the information about the tables to copy.
Basically the wizard creates the following Control Flow tab entries (in processing sequence order):
an Execute SQL Task: NonTransactableSql an Execute SQL Task: START TRANSACTION a Sequence Container: Transaction Scoping Sequence, which contains an Execute SQL Task: AllowedToFailPrologueSql an Execute SQL Task: PrologueSql a Foreach Loop Container, which contains a Transfer Task with an icon I did not notice in the Toolbox an Execute Package Task: Execute Inner Package an Execute SQL Task: EpilogueSql an "on success" arrow to an Execute SQL Task: COMMIT TRANSACTION an Execute SQL Task: PostTransaction Sql an "on failure" arrow to an Execute SQL Task: ROLLBACK TRANSACTION an Execute SQL Task: CompensatingSql
Where, and how, can I look within this package to see the details about the tables I am transferring? I see that one of the Connection Managers is "TableSchema.XML" -- but it points to a temporary file on my hard drive, that I presume is populated by the package. Where does it get its information?
This is certainly much more complex than the package I would have written, based on my limited knowledge of SSIS. I would have been inclined to create 50+ Data Flow tasks, one for each table.
So now I'm trying to understand why the Wizard created this more-complex package.
Any help will be appreciated, including references to non-Microsoft books/websites/etc.
We are going to use database mirroring and database snapshots for reporting. The principal server runs SQL Server 2005 Standard Edition and mirror (reporting) runs SQL Server 2005 Enterprise Edition (64-bit). I failed to setup database mirroring trough GUI using SQL Server Management Studio and got this error: This mirroring configuration is not supported. Because the principal server instance, <server_name>, is Standard Edition, the mirror server instance must also be Standard Edition. But when I use T-SQL commands I was able to setup database mirroring and it works OK so far. SQL BOL says that one of requirements for database mirroring is to use the same SQL Server editions but I am wondering if it works trough T-SQL why MS mention it in the requirements list, also is totally unsupported by MS?
I have been given the "Performance and Scalability Guide" for Forefront Client Security by one of our representatives from Microsoft. The document is listed as published in July 2007, so I apparently can not supply a link. The document makes a couple of hard to swallow claims, though. One of these is this:
The sizing differences between SQL Server Standard Edition and SQL Server Enterprise edition are due to the differences in the index sizes between the two editions. I have to say I do not buy this. Can anyone disillusion me, or give me a link to anything that even implies this? I have not found anything to prove or disprove this, as yet.
Another oddity in this document is that FCS will not support 64 bit SQL Server, but encourages the use of AWE and /3GB. I can not believe there are functionality differences between the two, unless their database performance is negatively impacted by the 64 bit architecture (naturally the document is silent on why they do not support 64 bit).
Anyway, the questions are does the quote above actually hold any water? And would 64 bit SQL server cause functionality problems, other than performance problems?
Hi All, Use Case1: Just wanted to know if there is something like multiple cascade delete option in SqlServer 2005. My table structure is similar to what is given below
create table test ( id int PRIMARY KEY, tname nvarchar(55))
create table childTest ( id1 int REFERENCES test(id) on delete cascade, id2 int REFERENCES test(id) on delete cascade, tname nvarchar(55))......
The above creation fails for childTest since both id1 and id2 reference test with ondelete cascade.
As per Books online: The series of cascading referential actions triggered by a single DELETE or UPDATE must form a tree containing no circular references. No table can appear more than once in the list of all cascading referential actions that result from the DELETE or UPDATE.
Doesn't look like a circular reference here. Wanted to confirm if it is because test is being referenced twice in the childtable.
My requirement is if a row is deleted from test, it should delete matching rows from childTest(id1 and id2). Since delete cascade is not being allowed for both columns , I have to handle the delete in id2.
Use Case2: Also can I have INSTEAD OF DELETE and Cascade delete on the same table? I have a cascade delete from table1 to table2. which means when any row from table1 is deleted corresponding rows from table2 are deleted. and on table2 I would like to have an instead of delete where I would like to delete rows from another table say table3.
During customer engagement, I was told that there are Microsoft add-on to be installed on SQL 2005 and the SQL 2005 can be simulated as SQL 2000, SQL 2000 SP4, SQL 7.0 in different SQL instances.
Hi, i just need some help?? just some info?is it TRUE that SQL Server 2005 Express Edition (free) is capable ONLY of SINGLE user?i mean if i have a data driven page, if someone is using or editing the data in my page, does no one can access my data base simultaneously??i hope you could enlighten my mind, thanks
I currently have three SQL Server instances installed on my notebook. One is v8, which I believe is used by an accounting application. The other two are as follows:-
SQL Server MSSMLBIZ
SQL Server SQLEXPRESS
The second one (SQLEXPRESS) fails to start generating the following error:-
The SQL Server (SQLEXPRESS) service terminated with service-specific error 17058 (0x42A2).
Other services listed in SQL Server Configuration Manager are:-
SQL Server Integration Services - which runs apparently normally.
SQL Server Analysis Services (MSSQLSERVER)
SQL Server Reporting Services (MSSQLSERVER)
SQL Server Browser
The last thre of these are run under LocalSystem.
I have been trying to install the SQLServer SP2 to the SQLEXPRESS instance for some number of days now, but each time it runs, it fails to install.
I am beginning to wonder if there is a sequence of installation for each of the above instances that should be followed. Can anyone give me any suggestions, or answers to the above problems?
Hi, I am having a bit of hassle with trying to enter details to multiple tables in SQL Server 2005. I have four tables, an Attendance Table (AttendanceID(PK Identity specific), MembershipNo, Date) Resistance Table (ResistId(PK Identity specific), Weight , Reps, Sets) Aerobics Tables(AerobicsID(PK Identity specific), MachineID, Intensity, Time) and a linking table for all of them.... ExerciseMaster(AttendanceID,ResistanceID,AerobicsI D)
My problem is that I can insert data to each specific table by itself using seperate insert statements.....eg....
//insert an attendance record to the attendance table string userID;
userID = Session["User"].ToString();
SqlDataSource pgpDataSource = new SqlDataSource(); pgpDataSource.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionStringLogin"].ToString();
finally { pgpDataSource = null; } //same code as above for the resistance table
However, i am facing the problem where this does not populate the link table(ExerciseMaster) with any information as i am unable to write the relevant IDs into the table that have been auto generated by SQL Server for each of the subTables. I have read several forums where they recommend using something called @@IDENTITY but i have no idea how or where to use this in order to fill my exercise table... Any help would be so much appreciated.... Also, hopefully what i have said all makes sense and someone will be able to help me...oh and one more thing...this is an ASP.NET page coding in C# Cheers Scotty
We just upgraded from SQL Server 2000 to 2005. In the past, when I ran the import/export wizard to copy multiple tables from one database to another with SQL Server 2000, I had no problem. Now when I used the import/export wizard to copy multiple tables with SQL Server 2005, I kept getting an error. For example, when copied three tables, the first table might be copied fine and I got an error with the second table and the whole thing stop. Sometimes I could copy two tables. However, when I ran the import/export wizard to copy each table one at a time, it worked.
The error that I got was "Cannot insert duplicate key in object..." I selected the options to "Delete rows in existing destination tables", and "Enable identity insert". What am I doing wrong?
My client has a server running MS 2003 Server for Smal Business Server, and it has SQL Server Express 2005 installed (I believe it is installed 3 times, as part of SharePoint, Veritas Backup Exec and ACT! applications).
I am trying to implement an application that uses SQL Server 2000, but the Server 2003 SBS does not support that version. So I need to launch an additional instance of SQL Server Exp 2005.
To do so, do I need to download and install SQL Server Express 2005 software again? Or can I just run SQLSVR.exe from an existing instance, but with a different instance name (sqlservr.exe -s<InstanceName>?
The reason I need another instance is that these existing instances limit DDL statements.
I am new to this and compare it to launching MS Word multiple times - you don't need to reinstall Word to run it multiple times.
Is launching from the command line a bad idea - and if it is, what is the better way to ensure that it launches under the local system context a service?
Thanks in advance for any help and insights. It is much appreciated.
I am trying to figure out how to use the select maximum command in SQL Server 2005. I have already created a database and I have it populate it with multiple fields and multiple records. I Would like to create a new column or field which contains the maximum value from four of the fields. I have already created a column and I am trying to figure out how to use a command or SQL statement which is entered into the computed equation or formula in the properties for this field/column.
Any help you can provide will be greatly appreciated!
We have a need to have separate password policies for different groups of logins. For example: Those IDs that have greater privileges should be rquired to have more complex passwords that expire more frequently than IDs with lesser privileges.
It appears to me that SQL Server pulls the password policy from the default Active Directory domain group. Is there a way to create/utilize multiple policies for SQL Server authenticated IDs?
Hi, I just developed a ASP.NET website with SQL Server 2005 as database. I am having connection crash problem when multiple user click on same link to fetch data from the database. If users click on different links or there is few seconds of time gap between the data access, then it works fine. But the connections crash problem only occurs when 2 or more users click same link at same time. I am using the following kind of Datalayers to access the data from database: public static ContentInformation GetContentForUpdate(int ContentId) { ContentInformation result = new ContentInformation(); ; SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.Connection = Connection; command.CommandText = "Content_GetContentForUpdate1"; SqlParameter parameter = new SqlParameter("@ContentId", SqlDbType.Int); parameter.Direction = ParameterDirection.Input; parameter.Value = ContentId; command.Parameters.Add(parameter); try { command.Connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read()) { // read the data } reader.Close(); } catch (SqlException ex) { Trace.TraceError(ex.Message); throw ex; } finally { command.Connection.Close(); } return result; } I would be really grateful if someone can help me out with this problem. Waiting for the soonest reply. Thanks.
