Re: SQL Permissions
From: Kim Oppalfens (kim_at_computacenter.nospam)
Date: 09/29/04
- Next message: Kim Oppalfens: "Re: Schema and "first" System Management Container"
- Previous message: Dave Halperin: "Re: Advertisement Recall???"
- In reply to: Michael A. Siefert: "SQL Permissions"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 29 Sep 2004 17:07:11 +0200
Depends on the security mode your in
In advanced security the site server machine account has to be a member
of the site server to sql connection group.
In standard security it is the sms service account that has to be a
member. All of this is usually done automatically.
The prompting for username and passwords for reports is a different
issue, that can be solved by going to Internet Explorer; Tools; Internet
Options; Security; And adding your reporting point as a trusted site.
Alternatively you can change the security settings of the internet zone
to custom level, and all the way at the bottom specify you allways want
to log in automatically. (Warning This is a less secure fix)
Kim Oppalfens
In article <596d515c.0409271209.6d878751@posting.google.com>,
masiefert@heapy.com says...
> I am having a difficult time with permissions.... I have my Primary
> server on a DC which mostly hooks up to the separate SQL server, and
> seems to work OK, although when I try to run reports it prompts for a
> username & password. I have a Secondary node on a Child domain that
> will not connect to the SQL server at all, although it is a member of
> the SQL connection group. What should the permissions look like on
> SQL in this type of environment???
> MAS
>
-- Check out the SMS Technical FAQ: http://www.microsoft.com/technet/prodtechnol/sms/sms2003/techfaq/default .mspx
- Next message: Kim Oppalfens: "Re: Schema and "first" System Management Container"
- Previous message: Dave Halperin: "Re: Advertisement Recall???"
- In reply to: Michael A. Siefert: "SQL Permissions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
