April 25, 2008 at 8:47 am
We want to replace one of our servers 32bits with a 64bits SQL Server 2005 that is called SERVER64 without causing any problems to users. Our actual Server is called SERVER32 and what we are planning to do is to put offline SERVER32, backup all databases, detach the server from the network, have the new machine renamed as SERVER32 and attach it to the network.
Restore all databases and create all LOGINS from the old server.
Am I missing something here? Is that it?
What happens with the service users created by SQL Server install? any problems with those?
Thanks for your help
April 25, 2008 at 9:02 am
Sounds like you could be okay.
The service users should be fine as the install grants them appropriate rights.
You might want to check out this thread, which I started a couple of months ago when I started working with 64-bit SQL Server. It has some issues others have dealt with when moving to 64-bit.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 25, 2008 at 9:15 am
sql mail won't work on 64bit so you may have to change everything to db mail. check the page file settings since the default ones are wrong. drivers are still a little flaky.
April 25, 2008 at 10:16 am
Guys thanks for your prompt reply.
I've been trying to move the logins but I'm stuck with finding all of the logins created with no database mappings. I executed sp_change_users_login 'Report' but got no orphans. Still when I use one of the login/passwords to connect using Management Studio and click the DB I get a 'No Access' error. How can the Login mappings be moved from the old server to the new one?
April 25, 2008 at 11:55 am
Found out that I generated the problem myself when I ran the script to create the login BEFORE restoring the databases.
Databases have to be restored first (even having all logins pointing to Master as default_database) and then create the logins.
April 25, 2008 at 1:19 pm
been using x64 for about 18 months now at various sites, can't say there's any major issues. Most config issues are well documented.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply