|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Database transferI needed to move some databases from one SQL server to another (SQL 2000
on both). I did this by doing a back up of the server on one, copy the file across and restore on the other. The data is there and so are the users, but none of the users can log into the new server. Is this not a recommended method or do I need to enable the users? Any other ideas? Just check the user rolls.
Show quote "No One" wrote: > I needed to move some databases from one SQL server to another (SQL 2000 > on both). I did this by doing a back up of the server on one, copy the > file across and restore on the other. The data is there and so are the > users, but none of the users can log into the new server. Is this not a > recommended method or do I need to enable the users? Any other ideas? > Chandra wrote:
> Just check the user rolls. The database user rolls are correct.> Does the new box have the Logins? Logins are for the box, users are for the
db. Once the Logins have been added, you may need to drop/ recreate the users. Show quote "No One" <aintno***@blahblahblah.com> wrote in message news:2tqal2-joj.ln1@gandalf.grey-net.com... > I needed to move some databases from one SQL server to another (SQL 2000 > on both). I did this by doing a back up of the server on one, copy the > file across and restore on the other. The data is there and so are the > users, but none of the users can log into the new server. Is this not a > recommended method or do I need to enable the users? Any other ideas? Instead of dropping or synchronizing the users after adding the logins, I suggest transferring the
logins from the source server. Search KB for sp_help_revlogin. -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "ChrisR" <Chr***@noEmail.com> wrote in message news:OCgzq3qVFHA.548@tk2msftngp13.phx.gbl... > Does the new box have the Logins? Logins are for the box, users are for the > db. Once the Logins have been added, you may need to drop/ recreate the > users. > > > "No One" <aintno***@blahblahblah.com> wrote in message > news:2tqal2-joj.ln1@gandalf.grey-net.com... >> I needed to move some databases from one SQL server to another (SQL 2000 >> on both). I did this by doing a back up of the server on one, copy the >> file across and restore on the other. The data is there and so are the >> users, but none of the users can log into the new server. Is this not a >> recommended method or do I need to enable the users? Any other ideas? > > The logins never existed on the old box. These are simple database
users and they did not exist as users on the old box. ChrisR wrote: Show quote > Does the new box have the Logins? Logins are for the box, users are for the > db. Once the Logins have been added, you may need to drop/ recreate the > users. > > > "No One" <aintno***@blahblahblah.com> wrote in message > news:2tqal2-joj.ln1@gandalf.grey-net.com... > >>I needed to move some databases from one SQL server to another (SQL 2000 >>on both). I did this by doing a back up of the server on one, copy the >>file across and restore on the other. The data is there and so are the >>users, but none of the users can log into the new server. Is this not a >>recommended method or do I need to enable the users? Any other ideas? > > > Here's an interesting sidenote. I cannot find where to change these
users' passwords. I did create a new user and was able to connect. A user doesn't have password, the login does; and only if it is a SQL Server login.
-- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "No one" <no***@yahoo.com> wrote in message news:fr7cl2-n2d.ln1@gandalf.grey-net.com... > Here's an interesting sidenote. I cannot find where to change these users' passwords. > > I did create a new user and was able to connect.  |
|||||||||||||||||||||||
Other interesting topics