如何将用户添加到SQL Server 2008 Managment Studio

I am trying to install DotNetNuke CMS. I created a database in my Microsoft SQL Server Management Studio 2008, which I installed after installing Microsoft Visual Studio 2010. I created a login for it and a password but I am not able to log in. I am trying to install DotNetNuke CMS. I create