.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links


Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server

We are a Prtner and get both of theseas part of our Action Pack subscription.  I am also installing CRM 4.0 on our SBS STANDARD 2008 Server.  Is it possible to put both the SQL 2008 ENTERRISE R2 and SBS 2008 STANDARD on the same box?  CRM 4.0 REQUIRES SQL for the Reporting functions etc.

  I need to do this asap as our Old Server is failing daily

View Complete Post

More Related Resource Links

SQL 2008 Upgrade Standard to Enterprise: Fail

I'm trying to upgrade an existing SQL Server 2008 SP1 Standard Edition to Enterprise.  Running the enterprise edition maintenance->Upgrade Edition wizard first got me the dreaded "Invoke or BeginInvoke cannot be called on a control until the window handle has been created." Eventually, I found an entry on Connect that mentioned closing all other windows and ensuring that the installer has the focus and this got me past that error.  Now that I can run the edition upgrade through to successful completion, it's not actually doing anything. Edition still reports as "Standard" and enterprise features such as "Compress Backups" do not work. I've run the upgrade twice and restarted the system to no effect. Before I do a "Rip and Replace" does anyone have any ideas on how to actually get the edition upgrade to work? Steve G. OS:    Windows Server 2008 R2 DB:    Product: SQL Server Standard Edition (64-bit)   Version: 10.0.2531.0 P.S. Just in case someone asks, yes, I did follow the instructions located here.

2005 Enterprise upgrade to 2008 Standard?

We are currently running 2005 Enterprise Edition. Is it possible to move the database to 2008 Standard Edition?  

Slow sql-server after upgrade from SQL-Server 2005 x64 standard to SQL-Server 2008 R2 x64 enterprise


We moved our databases to new hardware today (using copy database wizard)


The new hardware should be better than the old one.

We went from 28 GB ram to 128 GB.

We went from 16 cores to 32 cores (with even more cache etc.). We also moved from external SAN with 40 disks to intern disks (8 Samsung SS805 100gb ssd slc)

                             According to our own metrics we could get twice the IO using IO m

Unable to "upgrade" SQL 2008 Enterprise to Standard Edition - Error: the credentials you provided fo


I already tried changing the logon account for SQL services and still receive the error.

Please help.

SQL Server 2008 R2 Enterprise edition -Win 7 enterprise machine


Can i load SQL server 2008 R2 enterprise edition on Windows 7 Enterprise edition 64 bit OS machine??


Is there no way to upgrade from SQL Server 2008 Standard to SQL Server 2008 Enterprise with MSDN?

There are no Product Keys for MSDN copies?  I'm in the SQL Upgrade wizard and it needs a Product Key to upgrade?

SQL 2008 Upgrade from Standard to Enterprise



Can you tell me if this upgrade from Standard SQL 2008 to SQL Enterprise 2008 using simply the product key would also work if you have an existing A/P Standard 2008 Cluster. I wish to upgrade the hosts to Enterprise SQL 2008 to avail of Asyn Mirroring.


Perspectives don't seem to recognize standard actions SSAS 2008 Enterprise


In my cube I have a standard (rowset) action. When I create a perspective (box checked for this action), It does not appear on browser context window "my standard action" or excel context window "other actions" This was a setback for us, because we need the perspective's ability to make invisible user-defined hierarchies. Has anybody else experienced this? Is this by intention or a bug?

Lance Milbouer

How can Install Office 2007 on Windows server 2008 R2 64 bit machine in WSS 3.0

I have  64 bit machine  and Windows server 2008 R2 has installed. i have successfully install WSS 3.0  , but  when i tried to install  office 2007 ,  one  error  has  come  "OS is not compatible "  i thought  it was asking  for 64 bit office  2007   and i go through the  google and R&d find no 64 bit office is available ,  i have used   excel .dll in my custom code  so my problem is that   how can  install office 2007  on 64 bot OS 2008 r2  machine .  if anyone can help   me  , please let me know . thanks in advance

Using SQL Server 2008 R2 client with Enterprise Library



I am modifying an existing application that uses SQL Server 2008 as the database and Enterprise Library 4.1 for Data Access .

What I need to do is to make it use the SQL Server 2008 R2 client to take advantage of out of the box failover capabilities.

Any idea how I can accomplish this?


Upgrade SQL server 2008 R2 from Evaluation Edition to Enterprise Edition

Hello SQL Support group, I have SQl server 2008 R2 installed on a Win 2003 R2 and it is for our SharePoint and Project server 2007 environment. Today I noticed that we have only 75 days left! Seems like we installed it on evaluation mode. Here what we have on Helpàabout : Microsoft SQL Server Management Studio Complete (expires in 75 days)    10.50.1352.12 We do have MSDN account, and we have the KEY that comes with the SQL server 2008 R2 enterprise. We would like to assign the key to our SQl server ( we want to have enterprise edition). It is in a production environment now. I would like to know how we can do it  with minimum of down time. I found this link: http://blogs.technet.com/b/sqlman/archive/2010/03/16/sql-server-2008-upgrading-to-standard-enterprise-edition-from-evaluation-edition.aspx On the internet, but doesn’t say anything that we are losing any data after upgrade or not. Please let us know the best way to assign the key, and if it has any impact in our data. Thanks Bahram  

Was installing SQL 2008 Enterprise last night via RDP. When I came in this morning, I was disconnect

When I opened a connection, the old connection was gone, perhaps a reboot? I am able to connect to the instance from the server and create a table  and query a DB.  I am however unable to connect to the Instance from my 2005 client. How can I tell the install was successful? Looking in the event logs and not seeing anything around the time it would have completed. Additionally: I checked and Remote connections is enabled. TCP and Pipes are enabled. SQL Browser is stopped,when attempt to access to start that I get an error: The service cannot be started, either because it is disabled or because it has no enabled devices asssociated with it [0X80070422] I can't telnet into 1433 on the server.. might be firewall. Do I really need to open that manually? My client is SQL 2005, I believe I've connect to sql 2008 DBs. Should I upgrade the client on my client? I attempted to stop and start the instance. when I started it I got this mess: Server stack trace:    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.FindObjectExplorerFrame()    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.GetObjectExplorer(Boolean activateWindow)    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ShowError(Exception e)    at Microsoft.SqlServer.Management.UI.

Cannot install SQL 2008 Enterprise edition

Hello , i am trying to install SQL 2008 Enterprise edition (trial) on my computer and i reached a stage of installation progress which showed the failure of the Analysis, Reporting, Integration, and Business intelligence. This is showing all failed, so what do i do?  

No connection to SQL 2008 Enterprise with Nav2009 Classic

Hello everyone, I have a Problem to connect a Demo-Nav2009 with a SQL Server 2008. On the Server (native) it goes without problems. But if I try to connect from a Nav 2009 Classic-Client I get this Error: "The SQL server cannot be found. Try again later or contact your system administrator" I opend the Ports in the Firewall from the SQL-Server and started the SQL-Browser. But it do not work. I hope that anyone can help me. Thanks in advance for the fast help.   MFG Schany.

Move (detach/attach) db from 2008 Enterprise to 2008 Express

Hello I just thought about this question. Is it possible to create a database on a SQL 2008 Enterprise edition and move it to a SQL 2008 Express edition or would i run into the same version problems as when moving from 2008 to 2005? The reason for this is that i have a virtual Dev environment that has SQL 2008 Enterprise edition installed and now i get a project that is to run on SQL 2008 Express. It would be nice if i could skip installing the express edition and work against the Enterprise edition until deployment. Thanks ps. wasn't sure if this was the right forum to post this in. Please let me know if there was a more appropriate place for this.

Upgrade to SQL 2008 R2 Enterprise fails

Trying to upgrade one of my SQL 2008 SP1 Enterprise (v 10.0.2531.0) edition to SQL 2008 R2 Enterprise, the OS is Windows Server 2008 (x64) SP1.  The process fails with no explanation beyond this:   Description:   SQL Server 2008 R2 Setup has encountered an error.   Problem signature:   Problem Event Name: SQL100MSI   Problem Signature 01: 10.50.1600.1   Problem Signature 02: Unknown   Problem Signature 03: SqlSupport.msi   Problem Signature 04: 0x162A16FE   Problem Signature 05: 0x1645   Problem Signature 06: Install_SqlSupport   OS Version:      6.0.6001.   Locale ID:           1033   Additional information about the problem:   LCID:    1033 I tried running the installation through Remote Desktops with Administrator login and also through Remote Desktop Connection with Administrator login, I got the same error each time.  There are no users connected to the database.  The installation is English. I have viewed the thread on Connect and it is not applicable as I'm running an English installation, not Italian and I am using the Administrator login. I saw another on another thread where they

Can't install SQL Server 2008 Enterprise on Windows 2008 Enterprise

A new fresh Windows 2008 installed and install all avaliable updates. Then install SQL server 2008, it firstly install some update too. Then reboot and run setup.exe again, it always give me the following message:Managed SQL Server Installer has stopped workingWhat's wrong with it? how to solve this issue?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend