Re: Database Access from Active Directory to NT 4.0

From: Denny (mrdenny@gamespy.com)
Date: 02/13/03 

From: "Denny" <mrdenny@gamespy.com>
Date: Thu, 13 Feb 2003 12:09:24 -0800

That should do the trick. The AD Account has been given all the correct
access in the SQL Server correct?

Would it be possable to move the SQL 2K cluster to the AD domain instead of
the NT4 domain? 

--
Denny Cherry
Database Administrator
GameSpy Industries
"lwood" <lwood@wnco.com> wrote in message
news:040201c2d322$7001a520$a201280a@phx.gbl...
> I have a complete 2 way trust. Should that accomodate the
> access ?
> >-----Original Message-----
> >Are your domain trusts setup correctly?
> >
> >--
> >Denny Cherry
> >Database Administrator
> >GameSpy Industries
> >
> >"Lwood" <lwood@wnco.com> wrote in message
> >news:019901c2d2e5$5df00530$a301280a@phx.gbl...
> >> I currently have a 2000 SQL cluster in my NT 4.0 domain.
> >> I have an Active Directory Domain that I am trying to
> >> setup an applicaiton server to utilize the database in
> >> the NT 4.0 domain. I can connect via system DSN, but
> when
> >> I try to install the app and use the AD account
> >> information user is not authorized. I am using mixed
> >> security on the SQL server and I have added the AD
> >> account to the SQL logins given dbo on master. I also
> >> attempted this after adding the AD account to the local
> >> administrators accounts on both cluster servers. Any
> >> ideas of why this may be happening? Thanks, Lisa
> >
> >
> >.
> >

Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Re: Database Access from Active Directory to NT 4.0
    ... >Are your domain trusts setup correctly? ... >Database Administrator ... >> security on the SQL server and I have added the AD ... >> account to the SQL logins given dbo on master. ...
    (microsoft.public.sqlserver.security)