Re: SBS2003 and SQL

Tech-Archive recommends: Fix windows errors by optimizing your registry

anonymous_at_discussions.microsoft.com
Date: 06/21/04 

Date: Mon, 21 Jun 2004 11:30:47 -0700

Also, the server name is (local)(windows NT). THe other
servers are pern\SBSMonitoring and pern\sharepoint.

>-----Original Message-----
>Hi John -
>
>Let's do this - on your server, open SQL Enterprise
Manager and navigate to
>Microsoft SQL Servers | SQL Server Group | <servername>
| Security | Logins.
>Do you have your domain account listed (DOMAIN\user)?
If so, double-click
>on it to open the properties page and go to the Database
Access tab. Is
>there a check allowing access to your Goldmine database?
>
>--
>
>Chad A. Gross - SBS MVP
>SBS ROCKS!
>
>www.msmvps.com/cgross
>www.gosbs.org
>
>
>anonymous@discussions.microsoft.com wrote:
>> I used the osql -U sa command to verify sql login. That
>> is the only login that worked. I then ran xp_logininfo
>> and it displayed all of my domain admin accounts with
>> either group or user with admin access. The permission
>> path on all is null.
>>> -----Original Message-----
>>> Hi John -
>>>
>>> Have you created a login in SQL for your domain user
account?
>>>
>>> --
>>>
>>> Chad A. Gross - SBS MVP
>>> SBS ROCKS!
>>>
>>> www.msmvps.com/cgross
>>> www.gosbs.org
>>>
>>>
>>> John Hill wrote:
>>>> I have SBS2003 server from the action pack which
should
>>>> be the premium version. I installed SQL 2000 and
setup a
>>>> database for Goldmine. The database works fine except
>>>> that I can only log in as SA. I have changed the
security
>>>> to allow both sql and windows authentication but it
still
>>>> won't work.
>>>> I have also run the osql -U test and it fails with
>>>> everything but SA.
>>>> What could be the problem?
>>>
>>>
>>> .
>
>
>.
>

Relevant Pages

  • Re: Big Problem w/ Admin accounts locked out
    ... The server has three drives, C:, F:, and S:. ... of my last good backup to the F: drive using the non-admin account I ... now for some reason we can't login with any domain admin accounts ...
    (microsoft.public.windows.server.sbs)
  • Re: Win2k8 authentication problem: Being a member of Domain Admins group does not fix it.
    ... That's UAC on the server and by design. ... even if domain administrators are effected. ... Use RUNAS with the domain admin accounts and it should work. ... So, in other words, if my user account is a member of the domain ...
    (microsoft.public.windows.server.general)
  • Re: Re-Post - "the trust relationship between this workstation and the
    ... "the trust relationship between this workstation and the primary domain ... only problem is adding a new user account on the station. ... Client computer must use STRICTLY the INTERNAL DNS server which can ... Attr: subschemaSubentry ...
    (microsoft.public.windows.server.active_directory)
  • Re: Same question, still no answer!!!
    ... Sounds then like we are all paying for a feature set only large companies ... The "proxy server" pc is actually an older box stuffed ... Expectation #1) keep the ethernet more or less as is. ... The kids account would be ...
    (microsoft.public.windowsxp.basics)
  • Re: Re-Post - "the trust relationship between this workstation and the
    ... "the trust relationship between this workstation and the primary domain ... only problem is adding a new user account on the station. ... This would be on the DNS server 172.20.100.2 ... Attr: subschemaSubentry ...
    (microsoft.public.windows.server.active_directory)