Skip to main content

Posts

Showing posts with the label Sql server installation

MS SQL Server 2008 Installation Step by Step

MS SQL Server 2008 DATABSAE AND USER CREATION S GOTO START PROGRAM CLICK SQL SERVER MANAGEMENT STUDIO EXPAND SQL SERVER MANAGEMENT STUDIO SELECT SQL SERVER MANAGEMENT STUDIO CONNECT TO DATABASE SERVER ENTER USER NAME AND PASSWORD AFTER ENTERING USER NAME AND PASSWORD CLICK CONNECT Id: sa Pwd: ******** Expand the database in which to create the new database user Right-click the Security folder, point to New, and then click NEW LOGIN On the General page, enter a name for the new user in the User name box. ENTER PASSWORD AND CONFIRM PASSWORD CLICK OK Id: hyperion Pwd: ************ ASSIGN SECURITY PREVILIGES TO A USER ASSIGN USER MAPPED FOR A LOGIN ASSIGN LOGIN STATUS SETTINGS TO A USER AFTER SECURITY PREVILIGES SETTING TO A USER DISCONNECT THE SQL SERVER CONNECT DATA BASE ENGINE ENTER WITH NEW LOGIN AND PASSWORD In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand tha...