MIS Systems Thread, moved sims sql database but logins not moved in Technical; I`m moving sims from one sql 2008 server to another I`ve detached the database from one and reattached it to ...
13th November 2010, 08:37 AM #1
- Rep Power
moved sims sql database but logins not moved
I`m moving sims from one sql 2008 server to another I`ve detached the database from one and reattached it to the other but cant login as the logons havent transferred over. All users are down as users under the sims database but arnt there as logins any ideas where I`ve gone wrong and how I can rectify it?
13th November 2010, 08:51 AM #2
Firstly, by this I assume that you are not using AD integration, you are using separate SIMS passwords?
Did you use the SIMS db attach tool to detach the database? If so there should have been the option to drop SQL logins. I believe (not used in a year) that if you use this option the passwords can transfer with the database.
13th November 2010, 09:06 AM #3
- Rep Power
just checking the basis, have you update the connect.ini file to point to the new server?
13th November 2010, 10:06 AM #4
have you allowed remote connections to the sql server - i think by default this is disabled
By mb2k01 in forum MIS Systems
Last Post: 12th February 2010, 11:44 PM
By alandickey41 in forum MIS Systems
Last Post: 11th March 2009, 06:26 PM
By edie209 in forum MIS Systems
Last Post: 16th November 2007, 06:22 PM
By Dos_Box in forum Comments and Suggestions
Last Post: 20th July 2007, 05:32 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)