Detatch Data Base from old server to new - small problem

[E_G_R2]

Hi,

 

sorry if this has been resolved elsewhere but I need a quick answer.

 

Replacing SIMS server, same instance and SQL version.

 

I do the following:

 

run this follwoing command on the SQL server

 

sqlcmd -S%SERVERNAME%\%SQLINSTANCE% -Usa -P%SAPASSWORD% -Q"exec SIMS.sims.db_p_transfer_login"

 

replacing the variables between (and including) the percentage signs with the ones appropreate for your school.

then run the DBdetatched utility and copy the sims.mdf and sims.ldf to the new server.

Run dbattatch utility but when I run sims I get invalid user/password

 

What have I failed to do? Bet its real simple (i hope)

[dapaulio]

What SQL version you using and pardon my bluntness but why are you essentially cloning the server?

 

to answer your question, i assume you had spaces after the switches and the database switch uses the -d switch eg sqlcmd -s server\instance -u sa -p password -d sims -q "exec sims.db_p_transfer_login"

 

never using the cmd line myself i would try running it in SQL Management Studio?

 

I did the same task migrating sims from server and sql 2008 to server and sql 2012 r2 just last week and I hit the same hurdle but I had forgot to run the transfer login procedure before deattaching the db.

 

I performed the migration manually in the same way you did but didn't use the cmd line.

 

Can I assume you have cloned your simsroot and docstorage on to your new server, if so check your connect.ini on the computer and the server. most clients connecting to sims will have a redirect to the s: which will point to your new server but in some cases I have seen the main connect.ini on the client with the server instance named, this will take precedence over the connect.ini on the server.

 

let me know how you get on

 

Also an alternative would be to use capitas migration tool?

Edited July 25, 2015 by dapaulio

[E_G_R2]

Sorted,

 

I killed the server, re built and this time it decided it was happy with the logins/passwords.