How To Enable the sa Login for MS SQL Server on AWS AMI

Author: , January 8th, 2013

To change security authentication mode: In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties. On the Security page, under Server authentication, select the new server authentication mode (Windows and SQL auth), and then click OK. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to […]

Categories: How-To's, Technology Tags: , , , , , , , , | No comments

How to copy users from one MS SQL Server to another

Author: , November 19th, 2009

http://support.microsoft.com/default.aspx?scid=kb;en-us;246133 On server A, start SQL Server Management Studio, and then connect to the instance of SQL Server from which you moved the database. Open a new Query Editor window, and then run the below script to create the two needed stored procedures… Then run the following command: EXEC sp_help_revlogin Take the output from above […]

Categories: How-To's, Technology Tags: , | No comments