Looking for SQLDMO help

[JW]

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!

[Bob Barrows]

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"