Re: SQL Permissions

From: Kim Oppalfens (kim_at_computacenter.nospam)
Date: 09/29/04 

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

Relevant Pages

  • Re: Borland is neglecting Delphi for Win32 badly
    ... Today in SQL ... Server 2000 you can write server extensions as COM objects and call them via ... SQLCLR allows CLR ... The security benefits are also tremendous and we could discuss for a long ...
    (borland.public.delphi.non-technical)
  • Re: KRB Error
    ... There is so much that can be done with a security template that wouldn't be obvious from any common interface that the best bet would be to identify what changes were made. ... > party vendor was used to harden security on this server and another ... > both members of Domain A. Another member server on Domain A did not> have ... >>> Member servers on Domain A cannot access resources on Domain B. ...
    (microsoft.public.win2000.active_directory)
  • Re: Assigning Security through W2k3 to W2k Trusted Domains
    ... I cannot see how a member reboot would matter, ... allowed me to assign security on that domain controller. ... assign security on member servers running windows 2000. ... Would I have to reboot the member server? ...
    (microsoft.public.security)
  • RE: Users Logins
    ... On the sql ... server machine, go to start, programs, SQL Server, then choose the icon for ... For information about the Microsoft Strategic Technology ... Protection Program and to order your FREE Security Tool Kit, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL permission problem when installing SMS2003 in 2003 network
    ... Scenarios and Procedures for SMS 2003: Security ... >> I may need to put this post in an SQL newsgroup, ... >> install SMS2003 on ServerB. ... >> "Either the SQL Server is in a Windows NT 4 domain or this computer's ...
    (microsoft.public.sms.setup)