This task used to be a lot easier in earlier versions. Now you have more things to think and work on before you use the tool. SQL Server 2000 and SQL Server 2005 can be migrated. Now you can migrate logins as well.
Copying a database from an SQL 2005 Server to an instance of SQL Server 2008 is described using the Copy Database tool available in the SQL Server 2008. Procedure to create a proxy needed for this task is also described. The transfer method adopted in this article allows you to transfer chosen objects without stopping the source server. The transfer is painless as long as the security is not violated. Make sure you record the execution logging of the transfer as this is invaluable in the postmortem of failed transfers.
Read on and enhance your KB...
Copying a Database from SQL Server 2005 to SQL Server 2008 using the Copy Database Wizard
Showing posts with label Credentials. Show all posts
Showing posts with label Credentials. Show all posts
Monday, April 28, 2008
Thursday, January 31, 2008
Creating a Credential in SQL 2008 Server
Introduced in SQL Server 2005 Credentials is a new security feature on top of the security
policies to address the issue of privileges one can have while accessing a resource outside the
boundary on the network. Net Framework makes the outside access very easy with procedural code and credentials provide the security backup. This is continued in SQL 2008 as well. This short note shows how you may create credentials in SQL Server 2008 .
policies to address the issue of privileges one can have while accessing a resource outside the
boundary on the network. Net Framework makes the outside access very easy with procedural code and credentials provide the security backup. This is continued in SQL 2008 as well. This short note shows how you may create credentials in SQL Server 2008 .
Step 1:
In MS SQL Server Management Studio expand the Security node and right click on the Credentials folder and from the pop-up click on New Credentials... as shown.
Step2:
This opens up the New Credential window. You provide a name for this, for this note
' mysorian' is used.
Step3:
Click on the ellipsis button along the field 'Identity'. The identity has a login to the local
server. This opens the Select User or Group window. The Object Types button will bring up the accessible Object Types. Here the USER or Built-in security prinicpal has been brought in. The location is the local computer. Insert a local identity such as the one shown. Click on the OK button.
server. This opens the Select User or Group window. The Object Types button will bring up the accessible Object Types. Here the USER or Built-in security prinicpal has been brought in. The location is the local computer. Insert a local identity such as the one shown. Click on the OK button.
Step4:
This will bring you back to the New Credential window. Now provide a password and confirm it by entering it again, it better be strong. If you need to encrypt this, you may choose to do so and finally click on the OK button. A credential gets added to the Credentails folder.
That's all folks.
HTH
Jay
Subscribe to:
Posts (Atom)
