.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

SQL Server 2005 on Windows 2008 R1/R2 64bit

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server


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).



View Complete Post

More Related Resource Links

Management Studio sql 2005 Express on Windows Server 2008 r2

Hi , i have install a application that use sql server express 2005 on a server with OS windows server 2008 r2. My question is how to make automatic backup of my database , because i cant install SQL Server 2005 Management Console on my server .   Please help me Thanks

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

SQL Server 2005 installation on windows 2008 cluster error


I am trying to install SqlServer 2005 on windows 2008 cluster with domain controller. Installation fails on the second node while trying to set registry settings for server network libraries. Attached error message and output from error log. Can somebody suggest any solutions.



TITLE: Microsoft SQL Server 2005 Setup

Failed to set registry settings for server network libraries. The action is SetDefaults. The error is 11004 (The requested name is valid, but no data of the requested type was found.


Func Name='LaunchFunction'>
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_SetServerSSNLDefaults
PerfTime Start: Do_SetServerSSNLDefaults : Fri Sep 24 17:45:31 2010
<Func Name='Do_SetServerSSNLDefaults'>
Setting server network settings for instance name MSSQLSERVER, instance id MSSQL.1
Failed to set registry settings for server network libraries. The action: SetDefaults Error: 11004
        Error Code: 0x80072afc (11004)
Windows Error Text: The requested name is valid, but no data of the requested type was found.
  Source File Name: sqlca\nlregca.cpp
Compiler Ti

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 (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?




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 = '

Need the help while installing the MS SQL 2005 Express edition on windows 2008 server.



I want to install MS SQL 2005 Exp. edition in windows server. For that I had already downloaded the SP2 MS SQL 2005 exp. edition from Microsoft web site. I am geeting error while trying to install SQL: "The SQL service failed to strat . For more information see the SQL server books online topics, "How to view SQL server 2005 setup log files and starting SQL server manually." Our Server configuration is windows 2008 R2 with 32 bit prcessor.

Before that i had install the same but SQL Server Management Studio icon is not showing, so I unstalled SQL and then trying to fresh installation.

Please help me to resolve this issues.

Thanks in advance.


SQL server 2005 SP3 installation on windows server 2008 64 bit


Hi Guys, I was using SQL server 2008 64 bit with my application on windows server 2008 64 bit and all was working fine; then i decided to test SQL server 2005 SP3 64 bit to install on server 2008 64 bit, for this i first uninstalled SQL server 2008 64 bit and then downloaded the SQL server 2005 SP3 from the following address:


and after downloading this exe i started the installation and as soon the installation started i got the following display message that:

"this machine does not have the product that matches this installation package"

The link from where i have downloaded the SQL server 2005 SP3 64 bit file says that ti supports windows server 2008. I am using windows server 2008 Enterprise 64 bit having .NET framework 3.5SP1..

How to make my vs.net 2005 built application run on 64bit windows server?

I have a problem with my application, i can't make it run in a 64 bit windows server 2003. My App use to communicate to a finger print scanner device which listens to device events and automatically transfers device logs to a database.

This app use to run smoothly in a 32bit windows (my development env is xp sp2 using vs.net 2005 and .net 2.0 framework). But when i tried to install it on a 64 environment everything went wrong. The app returns a CLSID exception in which it can't find the specified reference.

I have already encountered and fixed this exception in a 32bit windows environment but it really freaks me out seeing my app stucked in a 64bit environment.

Any ideas on how I can fix my problem is greatly appreciated!
Thank you in advance..

SQL 2005/2008 on Windows Server 2008 R2 cluster - Service only starts when account is local admin


I have a single node Windows Server 2008 R2 cluster configured with SQL Server 2008 Enterprise Edition installed as a clustered instance.

I am having an issue where the SQL Server service will only start using TCP/IP when the service account is a member of the local admins group. To get SQL to install I had to add the sql server service account to the local admins group.

I have configured group policy with the permissions required for SQL Server 2008 and this is correctly applied to the node.

Errorlog shows the following...

Error: 26054, Severity: 16, State: 1.
2010-05-05 15:23:41.98 Server      Could not find any IP address that this SQL Server instance depends upon.  Make sure that the cluster service is running, that the dependency relationship between SQL Server and Network Name resources is correct, and that the IP addresses on which this SQL Server instance depends are available.  Error code: 0x5.

2010-05-05 15:23:41.98 Server      Error: 17182, Severity: 16, State: 1.
2010-05-05 15:23:41.98 Server      TDSSNIClient initialization failed with error 0x5, status code 0xa. Reason: Unable to initialize the TCP/IP listener. Access is denied.

2010-05-05 15:23:41.98 Server      Error: 17182, Severity: 16

Compatibility issues between Microsoft Visual Studio 2005 and Windows Server 2008 R2


Dear sirs,

When I was installing SQL Server 2005 64 bit on Windows Server 2008 R2, I received a notice informing the software Microsoft Visual Studio 2005 has known compatibility issues with this version of Windows.

So how can I get around these problems?

I need to use Visual Studio 2005 to create the Integration Services packages.

Also, I need to migrate directories of Integration Services packages from a server with SQL Server 2005 32 bit on Windows Server 2003 32 bit for a server with SQL Server 2005 64 bit on Windows Server 2008 R2. How can I proceed to do this?

Thanks in advance.

Jose Luiz

Sql server Management studio 2005 64 bit connection failed on windows server 2008 R2


Recently i have installed windows server 2008(64 bit) now  i host to run virtual directory with database on local host. for that purpose i installed Sql server managemnet studio express (64 bit) and SqlExpress.exe (32 bit) based on information given internet .

Now i make Virtual directory successfully but not able to login into application(build on visual studio 2005 with framework 2.0) , so that database connection not working

I used following connectstring in web config file

    <add name="ConnectionString" connectionString="Data Source=./SqlExpress;Initial Catalog=Ecohomes;Integrated security = True; " providerName="System.Data.SqlClient"></add>


Word Automation Issue in Windows Server 2008 Hosting



The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

Word Automation in sample ASP.NET(C#) application.

I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.

When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

Data: System.Collections.ListDictionaryInternal
Message: Word has encountered a problem.
Source: Microsoft Word

The code gets failed in the following line:

ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line

I cannot able to proceed further. Can anybody please help me in solving this issue?

Thank you.

With Regards,


No ASPNET User in Windows Server 2008?


I have been looking everywhere online regarding this, but have not found a clear answer.


I have an ASP.Net app running on Windows Server 2008, it's basically a reporting app using Crystal Reports. I have encountered a roadblock in regards to rendering some pages. When I run the app in Visual Studio(on the same 2008 machine) everything works perfectly. Yet when I publish it and run it live the reports will not display correctly, I get a message saying Failed to render page.


I looked this error up in the Crystal Reports website and the fixes they have there refer to giving the windows "aspnet" user full access rights to certain folders on the machine. I would be happy to do this, however there is no aspnet user in Windows Server 2008.


I installed the server and set its role to be Web Server. I also checked all the options regarding ASP.Net and IIS 6 compatibility. Yet there is no ASPNET username anywhere.


Did I set the server up wrong? or do I have to do something within ASP.Net to  create this user and then give it rights? 

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