+ Post New Thread
Results 1 to 2 of 2
Windows Thread, Administer SQL 2008 - confused... in Technical; Can I use: Microsoft® SQL Server® 2008 Management Studio Express to do the following: Connect to your SIMS2008 instance either ...
  1. #1
    kennysarmy's Avatar
    Join Date
    Oct 2005
    Location
    UK
    Posts
    1,286
    Thank Post
    80
    Thanked 45 Times in 31 Posts
    Rep Power
    30

    Administer SQL 2008 - confused...

    Can I use:
    Microsoft® SQL Server® 2008 Management Studio Express to do the following:

    Connect to your SIMS2008 instance either using Windows Authentication or SQL Authentication with SA as the username and the correct password.

    3. Navigate to Security -> Logins. Add the new windows account to the list as follows:

    a. Right-click Logins and choose New Login

    b. Search for and resolve the correct windows username that you require. You may need to change the location to your domain or the local computer depending on where the account resides.

    c. Ensure “Windows Authentication” is selected and all settings can be left as default.

    d. Under “Select a page” choose “Server Roles”

    e. Ensure “public” and “sysadmin” are selected

    f. Press OK to confirm your changes

  2. #2

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,160
    Thank Post
    98
    Thanked 318 Times in 260 Posts
    Blog Entries
    4
    Rep Power
    111
    Well, yes.

    Assuming you've got mixed mode authentication on and have an actual administrator account already available. If not there's a workaround to get into the system, but it's a little more work.

SHARE:
+ Post New Thread

Similar Threads

  1. Moodle / Server 2008 / IIS7 / MS SQL Server 2008 Express
    By Kamran7860 in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 23rd November 2010, 06:03 AM
  2. New SIMS Server - Windows 2008 R2 & SQL 2008 R2
    By MYK-IT in forum MIS Systems
    Replies: 23
    Last Post: 17th June 2010, 09:31 AM
  3. sql 2008
    By THERADIOTUBBY in forum MIS Systems
    Replies: 5
    Last Post: 1st June 2010, 09:09 AM
  4. Windows 2008, SQL 2008 and Backup Exec 12
    By joe90bass in forum Windows
    Replies: 2
    Last Post: 5th May 2010, 02:49 PM
  5. SQL 2008 express
    By Boon72 in forum Windows Server 2008 R2
    Replies: 1
    Last Post: 3rd February 2010, 10:55 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •