Re: SBS2003 and SQL
anonymous_at_discussions.microsoft.com
Date: 06/21/04
- Next message: anonymous_at_discussions.microsoft.com: "Re: SBS2003 and SQL"
- Previous message: Sean Sharpe: "OWA in SBS2003"
- In reply to: Chad A. Gross [SBS MVP]: "Re: SBS2003 and SQL"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: SBS2003 and SQL"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 21 Jun 2004 11:26:01 -0700
I have server\domain admins, server\sa,
server\goldminelink. All have server roles as
administrators and are assigned access to my databases as
public and DBO.
>-----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?
>>>
>>>
>>> .
>
>
>.
>
- Next message: anonymous_at_discussions.microsoft.com: "Re: SBS2003 and SQL"
- Previous message: Sean Sharpe: "OWA in SBS2003"
- In reply to: Chad A. Gross [SBS MVP]: "Re: SBS2003 and SQL"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: SBS2003 and SQL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
