Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 32-bit/64-bit - compatibility issues!

Author  Topic 

f.pasquinelli
Starting Member

1 Post

Posted - 2010-09-03 : 10:01:13
Hi,

I have some doubts on the 32-bit/64-bit compatibility between SQL Server, SAP and the underlying OS. Can somebody explain me in a general manner how does this all work?

Q1: can i have a SQL 2000 32-bit running on a 64-bit OS?
Q2: my SQL Server 2000 (32-bit) is connected through the NSX SAP connector to SAP R/3 v6. Does a migration of my SQL 2000 32-bit to a 64-bits version have any impact on the connection to SAP (R/3 v6)? Shall I migrate also SAP to a 64-bit version to avoid inconsistencies?
Q3: what are the best connectors to connect SQL to SAP?
Q4: what’s the high-level impact of a migration from SQL 2000 to SQL 2005/2008? Rebuilding all DTS packages?
Q5: any compatibility issue between SQL Server 2000/2005/2008 32 / 64-bit with Windows Server 2008/Windows Vista/Windows7?

Thanks for your help!

If it's not the right forum please address me to the correct one...

F
   

- Advertisement -