1
vote
1answer
2k views

The package failed to load due to error 0xC0011008 Error Loading from XML

Environment: Windows Server 2008 SP2 Enterprise Edition 64-bit SQL Server 2008 SP3 Standard Edition 64-bit Previously had SQL Server 2005 Developer Edition 32-bit Integration Services. That has now ...
2
votes
2answers
612 views

SQL Server install on 64 bit Windows 7 installing as 32 bit

I am attempting to install SQL Server 2008 R2 on a new 64 bint Windows workstation. I wish to install the 64 bit version and am using this iso file: ...
2
votes
1answer
291 views

In-Place Upgrade of 64-bit OS and 32-bit SQL Server to 64-bit SQL Server - Is it possible?

Not sure if this is possible, or what the steps are if it is. We have a server running Windows Server 2003 R2 64-bit as the OS, and SQL Standard Edition 2005 32-bit. I have been tasked to upgrade ...
2
votes
2answers
4k views

SQL Server R2 different versions on x86 and x64?

I have the latest SQL Server 2008 R2 installed on a W2K8 server. The version number says "10.50.1600". My problem is that my backup fails to restore on the x64 machine. I downloaded and installed the ...
4
votes
2answers
15k views

How to install Oracle OLE drivers for use in SQL Server 2008 R2 x64

As per standard procedure we've been using for years for previous versions of both Oracle and SQL Server, I have installed Oracle's latest ODAC package, which includes the Oracle OLE driver onto our ...
3
votes
2answers
216 views

Should SQL Server 2008 only be run on Server 2008 R2 (64 bit)?

Today I was told that SQL Server 2008 is supposed to be run on Server 2008 R2 (64 bit). Is this true? And if so, can anyone explain why? Our development instances are running on 32-bit systems. I ...
0
votes
1answer
302 views

MSDE - Connection working in osql, but not DSN

This is on a VPS 64bit machine. I've installed MSDE fine. I've created a user. I can connect via OSQL osql -Uwwwcubeuser -Psecret I can run a select * from module Problem: I can't connect via a ...
1
vote
2answers
889 views

SqlServer 2000 enterprise (32bit) running on WinServer 2003 enterprise (64-bit). How to see more memory?

have a server running windows 2003 enterprise edition 64-bit and this server has 18GB of Ram. I am running Sql Server 2000 enterprise edition (32-bit) on it. Sql server is only using 4GB of RAM. I ...
0
votes
2answers
198 views

Running 32 bit SQL Server 2005 on 64 bit Windows Server?

If I have a 32 bit version of SQL Server 2005 running on a 64 bit Windows Server does the max amount of memory avail. the SQL Server process increase from 2gb to 4gb. In reading this blog entry by ...
3
votes
2answers
310 views

Justifying a memory upgrade, take 2

Previously I asked a question on what metrics I should measure (e.g. before and after) to justify a memory upgrade. Perfmon was suggested. I'd like to know which specific perfmon counters I should ...
2
votes
0answers
466 views

SQL CLR not properly enabling

We have a SQL server running SQL 2005 Workgroup 64 bit (9.0.4273), on Windows 2003 server 64 bit. We have run sp_configure and reconfigured the server which indicates that the clr is now enabled. ...
3
votes
2answers
188 views

SQL Server Maximum RAM

I have a server running Windows 2003 Enterprise (x86) and SQL Server 2005 Enterprise SP. The sqlserver process currently consumes aorund 1.6GB of memory although there is around 12GB in the sever ...
3
votes
3answers
2k views

Install Sql Server Developer Edition 32-bit (or Enterprise Edition) on Windows 7 Home Premium 64-bit

Is there any work around to Successfully install SQL server 2008 32-bit on Windows 7 Home premium 64-bit ? If this is the case I first installed VS 2008 SP 1 on my machine and when I click on ...
0
votes
1answer
279 views

Access SQL Server 2000 from Win2008 x64

I just tried installing the SQL Server 2000 client tools on a new Win2008 R2 server (being used for development and testing) using the "standard" install CD. It can't proceed because SQL 2000 isn't ...
2
votes
6answers
4k views

Why am I getting this 500 error from IIS?

I'm running PHP 5.3.1 on IIS 7.5 on Windows 7 Ultimate x64. I've been trying to make PHP connect to my local installation of SQL Server 2008 Express over ODBC using ADODB. At first I had trouble ...
3
votes
8answers
3k views

MemCached on Windows x64

This question has previously been asked, but that was a year ago and I wanted to know if there had been any developments since then. Basically we'd like to use a MemCached Server on a Windows Server ...
1
vote
2answers
705 views

SQL Server wont start on my 64-bit virtualization slice

I have installed SQL server 2008 express on a 64-bit virtual box and the service wont start. Looking at the event log I get: Could not create tempdb. You may not have enough disk space ...
1
vote
1answer
676 views

SQLServer 2008 BIDS On Windows 7 - 64bit

I am trying to install Sql Server 2008 Business Intelligence Development Suite on VS2008 in a Windows 7 (64bit) machine. The installer is aborting with an unspecified error for which I have not been ...
1
vote
4answers
2k views

Should I disable Jumbo Packets on iSCSI network?

Let's say we have a SQL Server 2000 box that houses our main database engine. We added an iSCSI SAN and now that server has a one card connected to the regular network and one card connected to the ...
5
votes
2answers
2k views

How can I use powershell scripting to change SQL Server Aliases?

I have an x64 machine that regularly needs about 10 aliases changed in the SQL Server Client Network Utility (cliconfig) for both the x64 and x86 sides of the registry. Is there a way I could do this ...
2
votes
3answers
502 views

Performance of Locked Pages v Native memory on 64 bit SQL2005/2008

I understand that setting the lock pages in memory privilege to the service account housing SQL2005/2008 services on a 64 bit system uses the AWE API and effectively stops SQL's buffer pool from being ...
2
votes
10answers
597 views

SQL2005 vs SQL2008

We are investigating replacing an existing SQL2000 server on Windows2003 (32Bit) with new hardware and a newer version. We are looking at an application that requires at least SQL2005, but will run ...