Hi Everyone,
We have a new dedicated server for SQL operations. I'm moving all of the objects over to the new server: databases, jobs, alerts, operators, logins. While testing the transfer, I noticed that the logins do not have the access to the databases and roles
are not set. Considering I used the stored procedure in KB article 246133, it should have kept the same database accesses and db roles. Any ideas on this one?
Should I be moving these objects in a specific order for more accurate and optimal results? Does it make a difference?
Thanks in advance.
Larry
It does not really matter what order you transfer things. You mentioned
that you followed the directions within
http://support.microsoft.com/?id=246133. The users and the permissions
should be correct after everything is up-and-running. If not, you could try
sp_change_users_login.
You mentioned that you are using scripts to transfer all "components." I am
not sure what you mean, but you might be able to use a variety of methods to
move the various objects.
Here are some other links that you may find helpful:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
Keith
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:7007F18A-5363-4F85-A411-C129E601CFF8@.microsoft.com...
> Hi Everyone,
> We have a new dedicated server for SQL operations. I'm moving all of the
objects over to the new server: databases, jobs, alerts, operators, logins.
While testing the transfer, I noticed that the logins do not have the access
to the databases and roles are not set. Considering I used the stored
procedure in KB article 246133, it should have kept the same database
accesses and db roles. Any ideas on this one?
> Should I be moving these objects in a specific order for more accurate and
optimal results? Does it make a difference?
> Thanks in advance.
> Larry
Showing posts with label operations. Show all posts
Showing posts with label operations. Show all posts
Monday, March 19, 2012
Moving SQL Server Components
Hi Everyone,
We have a new dedicated server for SQL operations. I'm moving all of the ob
jects over to the new server: databases, jobs, alerts, operators, logins.
While testing the transfer, I noticed that the logins do not have the access
to the databases and roles
are not set. Considering I used the stored procedure in KB article 246133,
it should have kept the same database accesses and db roles. Any ideas on t
his one?
Should I be moving these objects in a specific order for more accurate and o
ptimal results? Does it make a difference?
Thanks in advance.
LarryIt does not really matter what order you transfer things. You mentioned
that you followed the directions within
http://support.microsoft.com/?id=246133. The users and the permissions
should be correct after everything is up-and-running. If not, you could try
sp_change_users_login.
You mentioned that you are using scripts to transfer all "components." I am
not sure what you mean, but you might be able to use a variety of methods to
move the various objects.
Here are some other links that you may find helpful:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
Keith
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:7007F18A-5363-4F85-A411-C129E601CFF8@.microsoft.com...
> Hi Everyone,
> We have a new dedicated server for SQL operations. I'm moving all of the
objects over to the new server: databases, jobs, alerts, operators, logins.
While testing the transfer, I noticed that the logins do not have the access
to the databases and roles are not set. Considering I used the stored
procedure in KB article 246133, it should have kept the same database
accesses and db roles. Any ideas on this one?
> Should I be moving these objects in a specific order for more accurate and
optimal results? Does it make a difference?
> Thanks in advance.
> Larry
We have a new dedicated server for SQL operations. I'm moving all of the ob
jects over to the new server: databases, jobs, alerts, operators, logins.
While testing the transfer, I noticed that the logins do not have the access
to the databases and roles
are not set. Considering I used the stored procedure in KB article 246133,
it should have kept the same database accesses and db roles. Any ideas on t
his one?
Should I be moving these objects in a specific order for more accurate and o
ptimal results? Does it make a difference?
Thanks in advance.
LarryIt does not really matter what order you transfer things. You mentioned
that you followed the directions within
http://support.microsoft.com/?id=246133. The users and the permissions
should be correct after everything is up-and-running. If not, you could try
sp_change_users_login.
You mentioned that you are using scripts to transfer all "components." I am
not sure what you mean, but you might be able to use a variety of methods to
move the various objects.
Here are some other links that you may find helpful:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
Keith
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:7007F18A-5363-4F85-A411-C129E601CFF8@.microsoft.com...
> Hi Everyone,
> We have a new dedicated server for SQL operations. I'm moving all of the
objects over to the new server: databases, jobs, alerts, operators, logins.
While testing the transfer, I noticed that the logins do not have the access
to the databases and roles are not set. Considering I used the stored
procedure in KB article 246133, it should have kept the same database
accesses and db roles. Any ideas on this one?
> Should I be moving these objects in a specific order for more accurate and
optimal results? Does it make a difference?
> Thanks in advance.
> Larry
Moving SQL objects
Hi Everyone,
We have a new dedicated server for SQL operations. I'm moving all of the ob
jects over to the new server: databases, jobs, alerts, operators, logins.
While testing the transfer, I noticed that the logins do not have the access
to the databases and roles
are not set. Considering I used the stored procedure in KB article 246133,
it should have kept the same database accesses and db roles. Any ideas on t
his one?
Should I be moving these objects in a specific order for more accurate and o
ptimal results? Does it make a difference?
Thanks in advance.
LarryIt does not really matter what order you transfer things. You mentioned
that you followed the directions within
http://support.microsoft.com/?id=246133. The users and the permissions
should be correct after everything is up-and-running. If not, you could try
sp_change_users_login.
You mentioned that you are using scripts to transfer all "components." I am
not sure what you mean, but you might be able to use a variety of methods to
move the various objects.
Here are some other links that you may find helpful:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
Keith
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:36682070-3D87-4DFA-B95F-0E53053F370B@.microsoft.com...
> Hi Everyone,
> We have a new dedicated server for SQL operations. I'm moving all of the
objects over to the new server: databases, jobs, alerts, operators, logins.
While testing the transfer, I noticed that the logins do not have the access
to the databases and roles are not set. Considering I used the stored
procedure in KB article 246133, it should have kept the same database
accesses and db roles. Any ideas on this one?
> Should I be moving these objects in a specific order for more accurate and
optimal results? Does it make a difference?
> Thanks in advance.
> Larry
We have a new dedicated server for SQL operations. I'm moving all of the ob
jects over to the new server: databases, jobs, alerts, operators, logins.
While testing the transfer, I noticed that the logins do not have the access
to the databases and roles
are not set. Considering I used the stored procedure in KB article 246133,
it should have kept the same database accesses and db roles. Any ideas on t
his one?
Should I be moving these objects in a specific order for more accurate and o
ptimal results? Does it make a difference?
Thanks in advance.
LarryIt does not really matter what order you transfer things. You mentioned
that you followed the directions within
http://support.microsoft.com/?id=246133. The users and the permissions
should be correct after everything is up-and-running. If not, you could try
sp_change_users_login.
You mentioned that you are using scripts to transfer all "components." I am
not sure what you mean, but you might be able to use a variety of methods to
move the various objects.
Here are some other links that you may find helpful:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
Keith
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:36682070-3D87-4DFA-B95F-0E53053F370B@.microsoft.com...
> Hi Everyone,
> We have a new dedicated server for SQL operations. I'm moving all of the
objects over to the new server: databases, jobs, alerts, operators, logins.
While testing the transfer, I noticed that the logins do not have the access
to the databases and roles are not set. Considering I used the stored
procedure in KB article 246133, it should have kept the same database
accesses and db roles. Any ideas on this one?
> Should I be moving these objects in a specific order for more accurate and
optimal results? Does it make a difference?
> Thanks in advance.
> Larry
Moving SQL objects
Hi Everyone,
We have a new dedicated server for SQL operations. I'm moving all of the objects over to the new server: databases, jobs, alerts, operators, logins. While testing the transfer, I noticed that the logins do not have the access to the databases and roles
are not set. Considering I used the stored procedure in KB article 246133, it should have kept the same database accesses and db roles. Any ideas on this one?
Should I be moving these objects in a specific order for more accurate and optimal results? Does it make a difference?
Thanks in advance.
Larry
It does not really matter what order you transfer things. You mentioned
that you followed the directions within
http://support.microsoft.com/?id=246133. The users and the permissions
should be correct after everything is up-and-running. If not, you could try
sp_change_users_login.
You mentioned that you are using scripts to transfer all "components." I am
not sure what you mean, but you might be able to use a variety of methods to
move the various objects.
Here are some other links that you may find helpful:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
Keith
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:36682070-3D87-4DFA-B95F-0E53053F370B@.microsoft.com...
> Hi Everyone,
> We have a new dedicated server for SQL operations. I'm moving all of the
objects over to the new server: databases, jobs, alerts, operators, logins.
While testing the transfer, I noticed that the logins do not have the access
to the databases and roles are not set. Considering I used the stored
procedure in KB article 246133, it should have kept the same database
accesses and db roles. Any ideas on this one?
> Should I be moving these objects in a specific order for more accurate and
optimal results? Does it make a difference?
> Thanks in advance.
> Larry
We have a new dedicated server for SQL operations. I'm moving all of the objects over to the new server: databases, jobs, alerts, operators, logins. While testing the transfer, I noticed that the logins do not have the access to the databases and roles
are not set. Considering I used the stored procedure in KB article 246133, it should have kept the same database accesses and db roles. Any ideas on this one?
Should I be moving these objects in a specific order for more accurate and optimal results? Does it make a difference?
Thanks in advance.
Larry
It does not really matter what order you transfer things. You mentioned
that you followed the directions within
http://support.microsoft.com/?id=246133. The users and the permissions
should be correct after everything is up-and-running. If not, you could try
sp_change_users_login.
You mentioned that you are using scripts to transfer all "components." I am
not sure what you mean, but you might be able to use a variety of methods to
move the various objects.
Here are some other links that you may find helpful:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
Keith
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:36682070-3D87-4DFA-B95F-0E53053F370B@.microsoft.com...
> Hi Everyone,
> We have a new dedicated server for SQL operations. I'm moving all of the
objects over to the new server: databases, jobs, alerts, operators, logins.
While testing the transfer, I noticed that the logins do not have the access
to the databases and roles are not set. Considering I used the stored
procedure in KB article 246133, it should have kept the same database
accesses and db roles. Any ideas on this one?
> Should I be moving these objects in a specific order for more accurate and
optimal results? Does it make a difference?
> Thanks in advance.
> Larry
Subscribe to:
Posts (Atom)