4gigs RAM, 32bit, /PAE And AWE In SQL Question

Mar 4, 2008


Same server:


Windows 2003 R2 SP2 (32bit)
SQL 2005 SP2
4gigs of Hot-Add RAM
WSUS 3.0 SP1
SCCM 2007

I've had nothing but issues on this server until I came across the articles about using /PAE in the boot.ini to correct the 4gig RAM issues, then read that /PAE can corrupt your database.

I then enabled AWE on the SQL 2005 server using the RAM range of 1gig-4gigs.

Since this, I am seeing errors in the Application Event log on the server that states SQL is not ready to accept client connections.

So, before I go any further with this build, it this something I should be concerned about ?

Thx !
MarcusDOI.gov

View 3 Replies


ADVERTISEMENT

All 32bit Connections Freeze...

Mar 2, 1999

I'm very new to SQL servers. We're running SQL 6.5-SP4 and have three applications using different databases on the server (NT4-SP3).

App 1. Written in PowerBuilder using 32bit DB_LIB, NWLink IPX/SPX.
App 2. Written in VFP 5.0a using ODBC32, NWLink IPX/SPX
App 3. Written in VB using ODBC16, NWLink IPX/SPX

Something happens, which freezes all 32bit connections and prevents any other 32bit connects. Which means I can't get Enterprise Manager to connect! This does not affect the ODBC16 clients?!?!

So far the only way, I have found, to clear and fix is to get all 32bit users out of their apps and the server becomes available again. There's got to be something to prevent this, any ideas? Is there a way to trace this to find the culprit?

Thank you for any and all help,

Jim
<jpeppercorn@jhcb.com>

View 3 Replies View Related

SQL 32bit DB To A SQL X64bit DB Server

Nov 16, 2007

I am going to test the migration of a 32bit SQL 2005 database to a SQL 2005 x64bit database server. Has anyone tried this? What can I expect? Will it work? Is there anythi I need to do?

I was just going to detach the 32bit DB, copy yhe files to the 64 bit server and reattach it.

Thanks

View 6 Replies View Related

SQL 2k5 Failover From 64bit To 32bit

Aug 30, 2007

I'm sure this has been discussed in the forums before, but I'll ask anyways. I'm replacing our GP server next year to one that will run SQL2k5 64-bit. The current server is only capable of 32bit SQL. I know with some databases changing from x64 to x32 is a bad idea...will SQL Server support it?

Thanks

View 3 Replies View Related

Xp_cmdshell Executing 32bit Exe On SQL X64

Jan 11, 2008

Here is a post to the MSDN forums that I have not been able to resolve:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2663783&SiteID=1

Anyone here have any ideas?

View 6 Replies View Related

How Do You Find Out Whether PC Is 32bit Or 64bit

Dec 24, 2005

I would like to install MS SQL Management Express, and I would like to make sure I am downloading the right files.

Could you tell me how I can find out whether my PC is 32bit or 64bit?

Many thanks

W aka Gauguin

View 3 Replies View Related

Log Shipping 64bit --&&> 32bit

Sep 18, 2007



Hi All

Can I use Log shipping From 64bit to 32bit in SQL Server2000?

Thanks~

View 1 Replies View Related

SSIS 32Bit Or 64Bit

Dec 28, 2007

Having looked at the complexities of transforming data from Oracle in a 64Bit Environment to SQL 2005, will SSIS 2008 run nativley in 64Bit. I understand that SSIS 2005 ran in 32Bit, even when in a 64Bit environment, causing great issues in accessing Oracle. Oracle released an update to compensate for this, however can someone please clarify whether SQL 2008 will have the same issues, or will SSIS 2008 be able to speak with Oracle on a 64Bit level.
Regards

View 3 Replies View Related

32bit Sql2005 And 64bit2005 ..[urgent]

May 14, 2008

Hi all:

advance thanks for ur help..

i need to know what could be the differnet , when use BIGint datatype at 32bit sql2005 and 64bitsql2005??

can i know benefits of bigint if i use at 32bit and 64bit sql2005??

waiting for your valuable reply..

thanks!
Mk..

View 3 Replies View Related

How To Change 32bit To 64bit Using SqlServer2005

May 26, 2008

I m swagatika and working on a s/w company.I am facing some problem in MS SqlServer2005.

my problem is:-

My project is running on SqlServer2005 which is 32 bit support.
But i want to change my project on SqlServer2005 which will be support to 64 bit .
What are the steps i follow to change 32 bit to 64 bit.

can anybody help me?

View 4 Replies View Related

SQL Server 2005 32bit-vs-64bit

Apr 24, 2007

This may seem like a completely foolish question, but is there any issue in using the 32bit workstation components (on XP) to connect to the 64bit server-side components? New to SQL2K5 and never had any issues using the 2K workstation/server components together.

Thank you!

View 3 Replies View Related

SQL 2005 32bit Upgrade To 64bit Possible?

Nov 7, 2007

Just curious if it's possible, and supported, to upgrade SQL 2005 from32bit to 64bit. This is on top of Windows 2003 64bit. Trying to getthe proper supported config for OM2k7 without blowing everything away.Thanks,JDP

View 1 Replies View Related

32bit Admin Tools When The Only Media You Have Is 64 Bit

Jun 13, 2006

We have jumped straight to 64 bit SQL 2005 with no 32 bit 2005 inbetween.

However this means the tools we have cannot be installed on windows XP/2000 32 bit.

Is there some way to get the 32 bit tools as it appears strange that 32 bit tools were not provided for remote access.

Cheers

Julian

View 6 Replies View Related

Principal 64Bit- Member On 32Bit

Dec 14, 2006

Hi all,
I've got two VLDBs on 64bit hardware platform + 64Bit-W2003K Std R2 + 64Bit SQL2005 Std Edition.
If I set this guy up as the Principal, can I have the standby/member on 32Bit HW + 32Bit W2003 Std + 32Bit SQL2005?

Will this actually work?

Regards,
Uday Shivamurthy

View 4 Replies View Related

Connecting 32bit ASP To 64 Bit SQL Server 2005

Mar 17, 2007

issue:



i have an ASP-Application running fine with both SQL Server 2000 and SQL 2005 (both 32 bit)



Now i have to attach a 64bit SQL-Server.



I have a problem with the connection:



This one runs fine with sql 2005 32bit

<%set myConn = Server.CreateObject("ADODB.Connection")

myConn.open "driver={SQL Native Client};server=<servername>;database=<dbname>;uid=<uid>;pwd=<pwd>" %>



but not with the 64-bit server:

ADODB.COnnection error "800a0ea9". Provider is not specified and there is no standard provider.



ok, i did some research and came up with the following:

<%set myConn = Server.CreateObject("ADODB.Connection")

myConn.open "PROVIDER=SQLOLEDB;DATA SOURCE=<serverip>,<serverport>;database=<dbname>;uid=<uid>;pwd=<pwd>" %>

thats fine, now i get a connect.



Unfortunately, this provider seems to behave different to the one i use in 32bit :



Lets say i have a stored procedure"



create spName as

select * from mytable



when i execute the following



<%sqlstr = "exec spname"

set myRecSet = CreateObject("ADODB.Recordset")

myRecSet.open SQLStr, myConn

response.write(myRecSet(0)) %>

it gives the first value of the first row with the Connection to a 32bit SQL-Server

but myRecSet seems to be empty on my 64bit SQL Server the response.write leads to an error message.



As far as i understand this, the provider used when connecting to a 32bit Server returns the records selected by the last row of the stored procedure into the recordset, but the provider when connecting to a 64bit server does not return these results.



What can i do, if i dont want to rewrite my asp-programming. I hope somebody has the correct naming / syntax for an connection string which allows me to connect my asp-application to the 64bit SQLServer which behaves like the "old" one for 32bit.



I hope my comments are clear enough - english is obviously not my mother-tongue - and somebody can give me a hint.



Thanks,



Heinrich







View 5 Replies View Related

64bit Server 32bit Client

Apr 19, 2006

I installed SQL 2005 on a 64bit server. Can I still use enterprise studio on a 32bit client machine?

The install CD's are 64bit and when I try to find the enterprise studio to install on my 32bit machine i get an error. Is there a place to download the 32bit enterprise studio? What are my options here?

Thanks in advance.

Mike

View 1 Replies View Related

SQL Agent Executing 32bit Code

Jan 10, 2008

There is no SQL Agent forum so if this isn't the correct place please move this post.

Windows 2003 R2 x64 with SQL Server x64.

One of the steps in a SQL job I have setup requires me to run an exe. I can run this exe from the command line or by double-clicking it on this same server but when running it from a SQL job it does not run, the job just has the status 'executing' but does not do anything. I have enabled xp_cmdshell. I have also tried calling a bat file which then runs the exe and I have tried calling the bat file with SysWOW64cmd.exe. Same problem.

It seems to me the the operating system recognises the 32bit exe and runs it in that context but the SQL Agent thread keeps trying to run it as a 64bit exe and hence never gets anywhere. (My best guess)

Is there a way to force SQL job/steps to run an exe or bat file in a 32bit thread? Any other ideas.

Thanks
Scott

View 5 Replies View Related

Service Broker B/w 64bit And 32bit

Apr 25, 2006

Hi:

I wanted to make sure some things clear before setting up service broker. I have enterprise server as 64 bit and local client servers as 32 bit. I would like to know what steps do I need to take care when I am setting up service broker b/w sql server enterprise editon 2005(64 bit) and sql server express 2005 client server(32 bit)...any special considerations ...?

Thanks,

Pramod

View 3 Replies View Related

64bit OS 32bit SQL Install With Reporting Services?

Mar 10, 2008



Hi All,

Probably a dumb question but our network guy has installed 64 bit Win2003 on one of the servers onto which I'm tasked with running our 32bit SQL Server 2005 server.

The installation goes through without a hitch and I'm able to get the SP2 installed over the top with no problem. I am, however, having trouble when trying to browse into the Reporting Services pages. I simply get a std "Page Not Found" web page. I've gone through the Report Server Configuration to see if I can get things to come up properly and everything appears to be initializing properly but still "no go"...

Can one of you MVP's give me a direction? I know it's relatively few details to get started but I'll provide whatever's necessary to get me pointed in the right direction.

Thanks

REM7600
"Jack of All Trades, Master of SQL (NOT)"

View 4 Replies View Related

32bit SQL Server On 64bit Inter Hardware

Jun 26, 2007

Hello,



Are there any issues with running the 32 bit version of Windows 2003 server and SQL Server Standard edition on a 64 bit Intel hardware Platform? I don't see why there would be if the OS is 32bit but just thought I'd ask.



Thanks.

View 4 Replies View Related

Eval Between SQL 2000 32bit And SQL 2005 64bit

Oct 9, 2006

Hi

I just started a new job and one of my first assignments was to determine and prove the improvement between SQL Server 2000 32 bit and SQL Server 2005 64bit extension. (Itanium may come later but for now we will live with x64)

I have used SQL 2005 before but only with a fresh install and a new application built from the ground up. Now we want to upgrade our present databases to 2k5. In a previous test by another DBA, he found the SQL 2005 ran slower. However, he realized that he was using SQL 2005 32bit on Windows 2003 64bit. Now we have everything in place, here are the steps I have accomplished so far.


Loaded Windows 2003 64 and SQL 2005 64.
Made a copy of an existing database from a SQL 2000 32 bit
Attached this database to the new SQL 2005 server. However, I keep the compatibility at 8.0.
Updated the statistics and backed the db up.
Had another DBA run a Profiler trace on the production server.
Replayed the trace on the new server.

My problem is this doesn€™t seem to give the information I am looking for. First, we were only looking at queries over 5 minutes and only looking at things from a duration standpoint. We are going to change this. Second, even though I created a template that looks like the one used on the production server, it is not using it.

So how do I compare performance on this 64bit server verses the 32bit SQL 2000. Any and all help is greatly appreciated.



View 4 Replies View Related

64bit Mirrored SQL Server Std With 32bit Witness?

Mar 30, 2007



I have two 64bit SQL Server Std servers that will be principal and mirror. I also need to stand up a witness. I already understand that the witness can be any version of SQL Server, but can the witness server be 32bit given the principal and mirror are 64bit?

View 1 Replies View Related

SQL 2000 32bit Installed On 64bit OS Problem

Mar 31, 2008

We just built a new server with Windows 2003 64bit OS and installed SQL2005 64bit (named SQLServer let's say) as the default instance and SQL2000 32bit (named SQLServerSQL2000 let's say) as a second instance. The first instance is listening on the 1433 port and the second instance is on the 1344 port.

I can connect to the default instance with Management Studio without issue using the SQL instance name, but to connect to the second instance I have to create an alias with the port number (SQLServerSQL2000,1344) on my machine. I have never had to do that before with a second instance.

I am trying to figure out if this is an issue with 32bit SQL running on 64bit OS or what. I am kind of stumped.

Any information would be greatly appreciated! Thank you!!!

Jim Youmans
St. Louis, Missouri, USA

View 5 Replies View Related

SQL Server 2005 32bit To 64bit Testing

May 20, 2008

Hi,

Recently, we have migrated our database from 32bit to 64bit. So far the application is working fine.

But I want to confirm that by any tool or automated process.

Is there any way or tool to check that the migrated data is correct and also to check if migrated database objects will work fine in 64 bit environment.

Any timely help would be greatly appreciated !!

Thanks,
Bala

View 4 Replies View Related

SQLNCLI Connection On Vista Business 32bit

Nov 16, 2007



I have a client/server app with a connection string:

Provier=SQLNCLI;Server=ServerIP;Database=DBName;UID=Name;PWD=Password

This connection string works for Vista 64bit but not for Vista Business 32bit...

What have I done so far to the Vista Business 32bit...
1. Downloaded/Installed SQLNCLI from Microsoft Site
2. Tested the connection string several ways with no luck...
3. Was able to get Vista Business 32bit to connect via a File DSN with the same credentials... DSN route is not an option for this app...

Any ideas?

View 1 Replies View Related

64 Bit Edition And 32bit Participate In VIRTUALSQL Cluster

May 25, 2007

Hi All



I have a requiment to update a SQL Cluster that I have, however we only have the budget to upgrade one of the servers participating in the Cluster.



Older servers are ML370 G4 Dual 3Ghz 10GB RAM - Windows 2003 Enterprise (existing)

the server I want to upgrade to is a

DL380 G5 Quad 3Ghz (Duo) - 20GB RAM - Windows 2003 Enterprise x64 edition (new)



I would also be upgrading to SQL 2005 Enterprise in the same upgrade (x64 edition on the new server)



What I want to know is if a x64bit Edition and a standard x86 edition both participate in the same VIRTUALSQL instance in a clustered environment?



Would appreciate assistance from any Microsoft people reading this post?

View 3 Replies View Related

Getting Error In 32bit DTEXEC On 64bit Machine

Feb 7, 2007

I'm getting

will not acquire
a connection because the package OfflineMode property is TRUE. When the Offline
Mode is TRUE, connections cannot be acquired."
I'm running the 32bit DTEXEC on a 64bit machine since I'm using the Jet provider.
I see in the forum and other places that this error usually occurs when you try to run in 64bit.
I don't get this error when I've tried it, running the 64bit DTEXEC or when I run from BIDS on a 32bit machine.
Any help appreciated.
David

View 12 Replies View Related

Migrate SQL Server From 64Bit Platform To 32Bit

Jan 2, 2007

Hi, All:

We have to migrate several 64Bit SQL Servers to 32Bit platform. Due to the 64Bit source systems are all production system, the downtime is too limited. So we can only get the DB files via Detach way. Among the source systems, both SQL2000 and SQL2005 exist.

My question are:

Is it possible to migrate the DB from 64Bit to 32Bit via Detach/Attach?

If ok, how to do that?

Any info will be highly appreciated! Thanks!



Best Regards,

Kevin

View 1 Replies View Related

Will SQL 2k 64bit Ed Dump Files Load On 32bit SQL2k?

Aug 29, 2005

Hi there. I apologize if this topic had already been covered. I'mtrying to find out whether I can load up a data dump files, generatedoff of a 64bit SQL server on Itanium, to a 32bit MSSQL 2K server. Ifanyone has tried this before, please let me know your findings. Thankyou very much in advance folks.j

View 1 Replies View Related

How Can I Link Server To A 32bit ORACLE From A 64bit MSSQL?

Dec 17, 2007

Hello,


How can I link server to a 32bit ORACLE from a 64bit MSSQL?


LiJun

View 1 Replies View Related

How Can I Find If The SQL Server 2005 Installed Is A 64bit Or 32bit?

Feb 11, 2007



I am about to work on a SQL server 2005 migration and I have no clue what SQL server 2005 is as I have been working on 2K all along.

Fist of all I am not sure if the given box is having 64bit or 32 bit Operationg System?

Second of all I am trying to find if the SQL server 2005 installed on this box is 32bit or 64bit?

Thanks in advance,

sk

View 3 Replies View Related

FYI - Executing SSIS Jobs On IA64 With 32bit Drivers

Jul 14, 2006

Just an FYI for those scheduling SSIS packages on 64bit Itaniums.
This came to light when using a 32 bit OLEDB driver on a 64bit Itanium.




When manually executing the package on the server through SQL Management
Studio, we got the expected results. However, when we scheduled the
package as a job, it failed every time. The error was:
"The AcquireConnection method call to the connection manager 'ConnectionName' failed with error code 0xC0202009€?.

We tried everything to fix this, but nothing worked. Finally we found
that when manually running the package, SQL Management Studio was calling the
32bit version of dtexec.exe, while the Agent calls the 64bit version of
dtexec.exe. The fix is to not use the "SQL Server Integration
Services Package" type in the job step, but use "Operating system
(CmdExec)" type. Then in the command box, call the 32bit (x86)
version of dtexec.exe.


Example:

C:Program Files (x86)Microsoft SQL Server90DTSBinnDTExec.exe /DTS
"File SystemSSIS Packages[PackageName]" /SERVER [SQLSERVERNAME]
/DECRYPT [password] /MAXCONCURRENT " -1 " /CHECKPOINTING OFF
/REPORTING V

View 1 Replies View Related

Problem Installing SQL 2k 32bit On Windows 2003 64bit X86 SP1

Jun 28, 2006

I've been having no luck trying to install SQL 2k 32bit on Windows 2003 64bit x86 SP1 - I've found several articles regarding needing to put SP4 on the 64bit OS, but my problem is the SQL 2k 32bit ",,x86setupsetupsql" won't run.

I consistantly receive a "...(localuserdir)Local.ins. Unable to load installaion instructions. Error 703."

And of course, the SP4 setup won't run because there is not an existing SQL Service to upgrade.

Anyone come up against a similar problem?



Thanks!



View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved