Re: sa not starting in master-db

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 07/17/03 

Date: Wed, 16 Jul 2003 23:46:58 -0500

Glad you found the problem. I understood incorrectly from your post
that you were connecting using standard SQL security with the sa login.
That's quite different than Windows authentication using a sysadmin role
member account. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"jobi" <jobi@reply2.group> wrote in message
news:bf2u3g$j76$1@reader08.wxs.nl...
> Found it ! Aparently it was not related to sa or sa-settings but it
had all
> in the nt-authentication for my default connection setting.
>
> "EXEC master..xp_logininfo @acctname =
'domain\dbadministrator',@option =
> 'all' " produced two lines of output.
> account name                 type  privilege mapped login name
> permission path
> domain\dbadministrator  user  admin     domain\dbadministrator
> domain\dbadmins
> domain\dbadministrator  user  user       domain\dbadministrator
> server\localappsgroup
>
> I didn't expect to be member of server\localappsgroup. The
> "server\localappsgroup" has default database "fabrdb".
> This causes this "strange?" behaviour. I'll check out this
group-membership.
>
> Thanks for your support.
>
> jobi
> "Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
> news:#pryKhtSDHA.2280@TK2MSFTNGP12.phx.gbl...
> > Strange...
> >
> > Is the sa database context set incorrectly when connecting from any
> > client?
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> >
> > "jobi" <jobi@reply2.group> wrote in message
> > news:bf0b0f$c7r$1@reader08.wxs.nl...
> > > sp_helplogins 'sa' gives this :
> > > LoginName SID
> > > DefDBName    DefLangName          AUser ARemote
> >
> --------- ------------------------------------------------------------
> > ------
> >
> ----------------------------------------------------------------------
> > ------
> >
> ------------------------------ ------------ -------------------- -----
> >  -----
> > > --
> > > sa        0x01
> > > master       us_english           yes   no
> > >
> > > (1 row(s) affected)
> > >
> > > LoginName DBName               UserName         UserOrAlias
> > > --------- -------------------- ---------------- -----------
> > > sa        fabrdb               db_owner         MemberOf
> > > sa        fabrdb               dbo              User
> > > sa        fabrdb_opl           db_owner         MemberOf
> > > sa        fabrdb_opl           dbo              User
> > > sa        master               db_owner         MemberOf
> > > sa        master               dbo              User
> > > sa        model                db_owner         MemberOf
> > > sa        model                dbo              User
> > > sa        msdb                 db_owner         MemberOf
> > > sa        msdb                 dbo              User
> > > sa        tempdb               db_owner         MemberOf
> > > sa        tempdb               dbo              User
> > >
> > > (12 row(s) affected)
> > >
> > > QA is started with "C:\Program Files\Microsoft SQL
> > > Server\80\Tools\Binn\isqlw.exe"
> > > This is the only server that behaves like this.
> > >
> > > jobi
> > > "Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
> > > news:u1n#4vgSDHA.2188@TK2MSFTNGP10.phx.gbl...
> > > > Double check the default database with sp_helplogins:
> > > >
> > > >     EXEC sp_helplogins 'sa'
> > > >
> > > > You might also check your Query Analyzer shortcut to ensure the
'-d'
> > > > parameter is not specified.  This will override the default
> > database.
> > > >
> > > > --
> > > > Hope this helps.
> > > >
> > > > Dan Guzman
> > > > SQL Server MVP
> > > >
> > > > -----------------------
> > > > SQL FAQ links (courtesy  Neil Pike):
> > > >
> > > > http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> > > > http://www.sqlserverfaq.com
> > > > http://www.mssqlserver.com/faq
> > > > -----------------------
> > > >
> > > > "jobi" <jobi@reply2.group> wrote in message
> > > > news:beu4mk$c8m$1@reader08.wxs.nl...
> > > > > Hi,
> > > > >
> > > > > I've noticed sa does not start in master-db when I connect
using
> > QA.
> > > > >
> > > > > Even after I ran "exec sp_defaultdb N'sa', N'master'" this
> > behaviour
> > > > > persists.
> > > > >
> > > > > Any hints on how to solve this ?
> > > > >
> > > > > jobi
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: sa not starting in master-db
    ... Is the sa database context set incorrectly when connecting from any ... "jobi" wrote in message ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: security
    ... You are right that this won't stop users from connecting with another ... That can only be addressed with application code changes, ... connecting to the database, ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: sa not starting in master-db
    ... This will override the default database. ... SQL Server MVP ... "jobi" wrote in message ...
    (microsoft.public.sqlserver.security)
  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.externaldata)
  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.dataaccess.pages)