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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

SQL Server Product key or CD Key

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

Hi,

Do we need sql server 2005 standard edition product key while installing new instance. Right now we have two node cluster, sql server 2005 standard edition already installed. We will build two standalone servers, reinstall sql sever 2005 standard edition as standalone, move databases and other objects from netbackup.

I recently install sql server 2005 standard edition as named instance on one of our computer and used software purchased by our company. During installation it takes product key automatically and I did not enter. So I just want to know do we need product key for this new installation.

Thanks




View Complete Post


More Related Resource Links

Health Analyzer reports "Product / patch installation or server upgrade required." and I can't seem

  
The text of the error is: On server SHAREPOINTSERVER, once all required products and/or patches are installed, perform an upgrade by either running PSConfigUI.exe or by executing the command "PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures". If a former upgrade attempt has failed, you may need to resolve upgrade specific issues before attempting upgrade again. Refer to the upgrade status page (http://sharepointserver:XXXX/_admin/UpgradeStatus.aspx) for information about current and prior upgrade attempts, and to determine issues that may be preventing upgrade from succeeding. For more information about this rule, see "http://go.microsoft.com/fwlink/?LinkID=142700". So I went to the server in question and ran the command line quoted in the error message and then I get this error back: Configuration of SharePoint Products failed. Configuration must be performed before you use SharePoint Products. For further details, see the diagnostic log located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\1 4\LOGS\PSCDiagnostics_....log and the application event log. So fine, I look into the event log and get this: Failed to initiate the upgrade sequence. An exception of type System.IO.IOException was thrown. Additional exception information: Access to the path 'C:\ProgramData\Microsoft\SharePoi

Product / Patch installation or server upgrade required in Health Reporting area

  
Via PSCDiag Log I get ERR Task upgrade has failed with an unknown exception ERR Exeception: Microsoft.SharePoint.Upgrade.SPUpgradeException: Action 4.0.14.0 of Microsoft.SharePoint.Upgrade.SPIiswebsSitewssSequence Failed--->System.DirectoryServices.DirectoryServicesCOMException (0x80070003): The system cannot find the path specified.

Product Key for SQL Server 2008 R2

  
Hi All, I'm attempting to install SQL Server 2008 R2 from the disk I received as part of my latest MSDN shipment (Disc 5003), and am being prompted for a product key.  However when I attempt to acquire a product key from subscriber downloads, I'm told that SQL Server 2008 R2 is pre-pidded.  So I am effectively unable to install except in evaluation mode.  Any ideas as to why? Thanks for any input, Steve

Trial period for this product is about to expire Search Server 2010 Express

  
Hi Everyone, I know this is the Forum for SharePoint 2010 but because Search Server Express 2010 builds on SharePoint and I do not find a Search Server Express Forum I will ask my question: After successful install of Search Server Express I got this Error Trial period for this product is about to expire. But Search Server Express is Free and I do not have any Product Key! I hope someone can help me. Best regards domschi  

Install return code for product 'SQL Server Express 2008 R2' is Failure

  
I have winXP sp3. When i tried to install SQL Sever 2008 R2 through Web patform installer I got this error: DownloadManager Information: 0 : Loading product xml from 'https://go.microsoft.com/fwlink/?LinkId=193533' DownloadManager Information: 0 : Product manager downloading: https://go.microsoft.com/fwlink/?LinkId=193533 DownloadManager Information: 0 : Remote file has not changed, using local cached file:C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Web Platform Installer\-231145492.xml.temp DownloadManager Information: 0 : Loading product xml from 'https://www.microsoft.com/web/webpi/2.0/WebApplicationList.xml' DownloadManager Information: 0 : Product manager downloading: https://www.microsoft.com/web/webpi/2.0/WebApplicationList.xml DownloadManager Information: 0 : Remote file has not changed, using local cached file:C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Web Platform Installer\-1221301405.xml.temp DownloadManager Information: 0 : Filtering by majorOS: 5, minorOS: 1, majorSP: 3, minorSP: 0, productType: 1, architecture: x86 DownloadManager Information: 0 : Filtering by majorOS: 5, minorOS: 1, majorSP: 3, minorSP: 0, productType: 1, architecture: x86 DownloadManager Information: 0 : Adding product SQL Server Express 2008 R2 (SQLExpress) to cart DownloadManager Information: 0 : Product 'SQLE

How to install SQL-Server 2008 product key after evaluation time is over

  

Hi all,

 

in my SQL-Server 2008  installation (from de_sql_server_2008_r2_express_with_advanced_services_edition_november_ctp_x64_455228)the server is not running anymore. Apparently the evaluation time (180 days) is over and we seem not to have put in the product key. At least this is the error message I am getting.

Unfortunately, I can not find the actual tool or application to put in the product key.

 

Could anybody please help and let me know what I have to do to put the key in.

Thank you very much in advance !


Can not find TUTORIAL directory after downloading the "SQL Server 2008R2 product code samples" pack

  
Any ideas on how to optain the TUTORIAL directory that should be in C:\Program Files\Microsoft SQL Server\100\Tools\Samples? I installed the 2008R2 product samples package several times? What is up with it?

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the installatio

  

Hi,

 

While I am trying to install SQL server 2005 I get the following message - "Machine does not have a product that matches the installation package". The installation does not occur.

 

I am using Windows 2000 Professional SP4 and using 32 bit installer - SQLServer2005SP2-KB921896-x86-ENU.exe

 

Help would be appreciated... thanks.

 

Regards,

Ravindranath Kini


call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter

Determine whether Forms Server is installed on a server

  
Check whether the Microsoft.Office.InfoPath.Server.dll and FormServer.aspx files are installed on the server.
Categories: 
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