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

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

CU for SQL Server 2008 R2 64bit

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

Hi all

I know there no SP released for "SQL Server 2008 R2  64bit",but there are CU(hotfixes) are released,I went those sites and I observed that  for Platfrom X86(till now I am assuming this 32 bit),

Please some body confirm...Is it ok can I run this hotfixes to SQL Server 2008 R2 64 bit ?


Thanks in Advance



View Complete Post

More Related Resource Links

Error while trying to register DLLs for Microsoft Jet on Windows Server 2008 R2 64bit

Hello! I'm having issues with importing Excel spreadsheets into Microsoft SQL Server 2005 on a Windows Server 2008 R2 64bit server.  After browsing the web, it appears that the problem is with the DLL's used by Microsoft Jet.  I've thus attempted to re-register these DLL's.  However, I am receiving the following results. c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjetoledb40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjet40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjint40.dllThe module "msjint40.dll" was loaded but the entry-point DLLRegisterServer was not found c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjter40.dllThe module "msjter40.dll" was loaded but the entry-point DLLRegisterServer was not found c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjtes40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\mswstr10.dllThe module "mswstr10.dll" was loaded but the entry-point DLLRegisterServer was not found I've set the application pool for this site to use 32bit.  Please note that due to my role on the team, other options such as using ACE are not available to me, unless I can prove that I've exhausted all other options. Thoughts? Thanks,Mike

Can't enable filestream on SQL Server 2008 Express 64bit under Win 7(64 bit WOW)

I have a newbie question.  I am running Win7(64 bit WOW). I installed SQL Server 2008 Express R2 (64 bit), but when I go to enable filestream, it reports that my edition of SQL Server does not support filestream.  I thought that the 64 bit edition would.  It says to install SQL Server 2008 64 bit.  Am I correct that that is not a free download?  Do I have any other options?

Upgraded to SQL Server 2008 Express R2 64bit and now all my VS2010 db apps won't run

I am running WIN764bit, VS2010 and just "upgraded" from SQL server 2005 to SQL Server 2008 Express R2 64 bit.  When I went back into VS2010 and tried to run and test several database apps that I have developed, I find that I keep getting the error "Failed to generate a user instance of SQL server due to a failure in starting the process for the user instrance".  I have read a lot of threads here but I am not getting anywhere.  I can create a new SQL Server database, but can't find any of my existing .dbo connections and can't open any of the .mdf's from within Server Explorer (VS2010).  Any ideas? BTW the install went fine. And I have User Instance set to True in VS2010.

Upgrading SQL Server 2008 Developer 64bit to R2 64 bit

Is there an upgrade download for Upgrading SQL Server 2008 Developer 64bit to R2 64 bit?  Where do I find it?

Visaul studio 2010 has problems with sql server 2008 R2 64bit

Visaul studio 2010 has problems with sql server 2008 R2 64bit or it's my idea?because icant create a new database in my asp.net web site  it says to  go and download it

Help deploying Windows Service to 64bit Server usinf Visual Studio 2008 Setup Project?

I have a Windows Service I created a while back for our Win2003/2008 32bit Servers, written in Visual Studio 2008, deployed via a VS2k8 Setup Project.  Everything works great, installs fine, and runs as it should.  There is no platform dependent code, it's all straight-up .Net Framework stuff, so we thought it should deploy to a Win2008 64bit Server just fine.  But this seems not to be the case.

When I try to install the Service as is on the 64bit machine, the service and associated DLL's are installed to the "C:\Windows\SysWOW64" folder, but when you right click the Service itself and look at the properties, it is trying to find the .exe file in the "C:\Windows\System32" folder. This difference prevents the service from running, obviously.

If I change the Setup Project settings, set the Target Platform to "x64" and change in the File System screen to use the "System (64-bit) Folder" placing the files in there and re-run the setup.exe on the server.... now the files are correctly installed to the "C:\Windows\System32" folder, but the Service itself is not 'installed', that is it *does not* show up in the Services Manager.

Just for the giggles of it I tried to manually install the service using 'installutil.exe' in the .Net Fra

SQL Server 2008 R2 Express 64bit Linked Server


Windows Server 2008 R2 Standard 64bit.
Sql Server 2008 R2 Express with Advanced Services 64bit.

I am converting an Access 2000 database to SQL Server. I developed a script that creates a linked server to import the data into SQL Server and manipulate it into the new structure. All works well on my 32 bit developement machine.

We just had the above new server built. The linked server is created without error, but trying to access the data in the Access database results in the error

'OLE DB provider Microsoft.Jet.OLEDB.4.0 cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode."

 In searching, it seems that there is no 64 bit provider for jet.

Once the new system is up and running, the application also requires some regular imports of Access and Excel files, so this is not a one-time problem.

I can convert all Access and Excel files to 2007 version (ACE) if needed. However, I did try adding a linked server using the ACE provider and got the following error when trying to access the linked server

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered. (Microsoft SQL Server, Error: 7403)

What are my options?

Do I need to uninstall 64bit SQL and install 32bit?


Sql Server 2008 (64bit) on Windows Server 2008 with a connection to Oracle 10g (64bit)



I know there are similar questions posed but none that provided a solution to my particular problem.

I am upgrading a SSIS package from Sql Server 2005 (32bit) to Sql Server 2008 (64bit) on Windows Server 2008 R2. It worked on the Sql Server 2005 machine. This package connects to an Oracle 10g (64bit) database.

The Oracle 11g client and networking tools are installed (by the Oracle DBA). I tested my connection on the sql server 2008 machine using SqlPlus and doing a tnsping. I can also create a Windows ODBC datasource connection to the Oracle 10g database.

The package executes properly on my local computer XP (32bit) running bids 2008.

The package fails on the server in SSIS. I need to be able to schedule the package in a job so it must run in SSIS.

I have also tired to create a connection manager to the Windows ODBC oracle connection without success. It is blank and does not allow me to select or refresh to view the Windows ODBC datasources.

Any assistance would be greatly appreciated. I have seen other forums where installing the Oracle 11g ODAC and Oracle Developer Tools for Visual Studio might assist in creating the package. But I need assistance in running the package from SSIS and not BIDS.






MOSS2007 (64Bit), Windows Server 2008 (64Bit) & Crystal Reports 2008


Hi guys,

at the moment i stuck at the following problem:
I try to call a Crystal Report (designed with Crystal Reports 2008 SP3) from my SharePoint aspx-page. In my 32-Bit Development-Eviroment everything works fine, but now i'm trying to deploy the solution to a MOSS207 64-Bit enviroment (Windows Server 2008 64Bit, IIS7, MOSS 64Bit).

When i try to call the report i get the following error message:
Exception Details: CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: An error has occurred while attempting to load the Crystal Reports runtime. Either the Crystal Reports registry key permissions are insufficient, or the Crystal Reports runtime is not installed correctly. Please install the appropriate Crystal Reports redistributable (CRRedist*.msi) containing the correct version of the Crystal Reports runtime (x86, x64, or Itanium) required. Please go to http://www.businessobjects.com/support for more information.

I've asked SAP for a solution of this problem and got back two possible ways to solve this problem:
1. Compile the application in 32-Bit mode -> this does not work with SharePoint (Error: Can't find assambly)
2. Run the Web Application in 32-Bit mode -> this does nit work with SharePoint (In

Windows Server 2008 32 and 64bit and Active Directory


By any chance do you if it is recommended to have Sharepoint 2010 and
Active Directory on the same windows 2008 server? Or they have to be on separate servers?

Also, do you know if Windows 2008 32 bit have any conflict communicating
with Windows server 2008 64bit?




SQL Server 2005 on Windows 2008 R1/R2 64bit



Please advise where can I find the product compatibility matrix for SQL Server? I need to know if SQL Server 2005 (64bit) is certifed on Windows server 2008 R1/R2 (64 bit).



How to Import Excel Data into SQL Server 2008(64 bit) Using SQL Query (in Windows Server 2008 64bit

I am developing VB .Net application in Visual Studio 2008(64bit), SQL Server 2008(64bit) and Windows Server 2008(64bit) environment.

I need to import an Excel and Flat files data into SQL Server database using SQL Query. I tried a lot with the following SQL Queries directly with SQL Server Management Studio,

1. SELECT * INTO  dbo.ExcelImportTest FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D:\PTPLDCT\DCT Test Datasource\DCT_Excel_Test_Sample_1.xls',
'select * from [Sheet1$]')

While executing i got an error as below,

Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

2. I have also tried with MSDASQL provider,

Select * from openrowset('MSDASQL','Driver={Microsoft Excel Driver (*.xls)};
Dbq=DCT_Excel_Test_Sample_1.xls;DefaultDir=D:\PTPLDCT\DCT Test Datasource\', 'Select * from [Sheet1$]')

Then i encountered the following error,

OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".

3. Finally i have tried the Query with Linked Server,

EXEC sp_addlinkedserver @server = '

can we install SQL Server 2008 R2 - 64bit on Window Server 32bit?

can we install SQL Server 2008 R2 - 64bit on Window Server 32bit?

Sql Server 2008 Tutorials

This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.

Error upgrading SQL Server 2008


i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

sql server 2008 adventureworks database


dear Friends

For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008. 

And the query is 

-- MERGE Statement
USE AdventureWorks2008
MERGE INTO	Sales.SalesOrderDetailHistory AS SODH
USING Sales.SalesOrderDetail AS SOD
ON SODH.SalesOrderID = SOD.SalesOrderID
AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID
INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, Cancelled)
VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, DEFAULT)
UPDATE SET SOHD.Cancelled = 'True'
OUTPUT $action , inserted.* ;	

Please help me to overcome this issue and let me know where can I download that database too.

Thanking you

happy Coding

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