Follow me as I struggle with rogue technology, insane programmers, and impossible math questions in a battle to the death.

Tuesday, March 24, 2009

Where is my Apache installed on Ubuntu?

Go to the terminal and type:

locate apache

Labels: ,

Wednesday, March 11, 2009

Add User to SQL Server 2008

Open Microsoft SQL Server Management Studio.
Right Click the server of choice in the tree and click Properties.
Click Security.
Make sure the SQL Server and Windows Authentication radio button is selected.
Click OK.
In the tree, expand the Security folder under your chosen server.
Right click Logins and choose New Login.
Enter login name.
Click SQL Server Authentication radio button.
Enter password.
It may be necessary to unclick User must change password at next login if not using Windows Server 2003.
Click Server Roles in left menu.
Click all entries.
Click OK.

In the tree inside your instance, expand the database folder, then Security.
Right click on Users and click New User.
Enter the User name and login name.
Enter the default schema.
Under Owned Schemas click all checkboxes except "guest".
Under Role Members click all checkboxes.
Push OK.

To test:
Click the Connect button at the top of the tree.
Choose Database Engine.
Enter login name and password and click Connect.

Labels:

Tuesday, March 10, 2009

Restore a backup in Microsoft SQL Server 2008 from a bak file

In Start, Programs, Microsoft SQL Server 2008, open SQL Server Management Studio.

In the Object Explorer tree, right click on Databases.

Right click on Restore Database.

Choose From Device and click the ... button that becomes available.

Choose File as Backup Media, then click Add.

Add the file from the tree.

Click the Restore checkbox.

Choose the correct database from the To Database dropdown.

Labels: