asked on

MS SQL Database move from server 2003 32bit to 2008 64bit

Hi,

I have server2003 32BIT running sql2005 with our company database, is it going to be possible to move this database to a server running server 2008 64bit?

I have already installed SQL 2005 64bit software.

Is it a case of right click on database >Backup etc?

SOLUTION

x-men

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anillucky31

Yes you can move your database on windows server 2008 64 bit from windows server 2003 32 bit. I have done this in my company and everything went smoothly. Just backup your database on server 2003 and restore on server 2008 64 bit.

unrealone1

ASKER

Ok thanks.

Done the restore, but can't connect to it from a client PC. New server has same server name and IP address.

anillucky31

From stat menu got to Microsot SQL Server -> configuration Tools->Sql Server Configuration Manager->SQL Server 2005 NetWork Configuration-> Protocols for MMSQL Server- Enable TCP/IP.

Also make sure sql port in enable through firewall

unrealone1

ASKER

Yes TCP/IP is enabled, I allowed 1433 access but that didnt work so I have disabled the firewall for now.

anillucky31

after disabling firewall is it working now?

x-men

you have to remap the DB user to the SQL Logins on the new server

unrealone1

ASKER

@anillucky31 No its not working with firewall disabled.

@x-men, how do I do this?? "you have to remap the DB user to the SQL Logins on the new server "

SOLUTION

anillucky31

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

unrealone1

ASKER

Ok firewall is disabled. How do I go about mapping the user?

ASKER CERTIFIED SOLUTION

anillucky31

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial