Post reply

Members of the Domain Admins group are the only users that can access a new install and DB

  • February 21, 2008 at 1:08 pm

    #780839

    Did you add the user's domain login to SQL Server? Builtin\Administrators is added by default during SQL Server installation. You'll have to add any other individuals or groups that you want to access SQL Server. See "Logins [SQL Server]" in BooksOnLine.

    I don't use Express, but I think it comes with an version of SQL Server Management Studio which you can use to add logins. In Object Explorer, expand Security, right-click on logins, and select "New Login...". Once you've added the login, you can grant database access and other permissions.

    Greg

  • February 21, 2008 at 1:19 pm

    #780843

    Yes I did. I figured it out shortly after posting the original message. I didn't have a chance to respond before you replied.

    Thank you for your help.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply