Home Forums Programming SMO/RMO/DMO Scripting Remote Database using SMO in .net RE: Scripting Remote Database using SMO in .net

  • Check the Login's database mapping at the Server Level:

    Expand the Server's Security folder (not the Database's)

    , then expand the "Logins" folder

    , then select and right-click the "SomeUser" login

    , Select "Properties" for the popup menu

    On the Properties dialog, select the "User Mapping" view

    Now check the list for your database. Unless SomeUser is a SysAdmin, it needs to be mapped to the database here.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]