Professional Web Applications Themes

Looking for SQLDMO help - ASP Database

I am trying to use the SQLDMO object look at SQL server status and job status. I am using code-behind in an ASP.NET page to call the object. If I set the .LoginSecure property to TRUE (ie. use windows auth), I get the following error : [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. If I set the property to FALSE and use a Login I have setup on the SQL server, it only works if the Login has a Role of System Admin.(which I don't want to do). I ...

  1. #1

    Default Looking for SQLDMO help


    I am trying to use the SQLDMO object look at SQL server status and job
    status. I am using code-behind in an ASP.NET page to call the object. If
    I set the .LoginSecure property to TRUE (ie. use windows auth), I get
    the following error : [Microsoft][ODBC SQL Server Driver][SQL
    Server]Login failed for user '(null)'. Reason: Not associated with a
    trusted SQL Server connection. If I set the property to FALSE and use a
    Login I have setup on the SQL server, it only works if the Login has a
    Role of System Admin.(which I don't want to do). I am wondering if
    anyone else has had a similar problem and worked out the answer.

    Thanks,

    Jim



    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    JW Guest

  2. #2

    Default Re: Looking for SQLDMO help

    JW wrote:
    > I am trying to use the SQLDMO object look at SQL server status and job
    > status. I am using code-behind in an ASP.NET page
    This is a classic asp newsgroup. While you may be lucky enough to find a
    dotnet-savvy person here who can answer your question, you can eliminate the
    luck factor by posting your question to an appropriate group. I suggest
    microsoft.public.dotnet.framework.aspnet.

    HTH,
    Bob Barrows

    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"


    Bob Barrows Guest

Similar Threads

  1. SQLDMO?
    By Neil W. in forum Windows Vista
    Replies: 1
    Last Post: March 21st, 03:58 PM
  2. shrinking database with sqldmo
    By chris in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 8th, 05:28 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139