Re: sa not starting in master-db
From: jobi (jobi_at_reply2.group)
Date: 07/16/03
- Next message: Tariq: "Protecting my backup"
- Previous message: Carlos Eduardo Rojas: "Re: C2 auditing"
- In reply to: Dan Guzman: "Re: sa not starting in master-db"
- Next in thread: Dan Guzman: "Re: sa not starting in master-db"
- Reply: Dan Guzman: "Re: sa not starting in master-db"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 16 Jul 2003 09:12:22 +0200
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
> > > >
> > > >
> > >
> > >
> >
> >
>
>
- Next message: Tariq: "Protecting my backup"
- Previous message: Carlos Eduardo Rojas: "Re: C2 auditing"
- In reply to: Dan Guzman: "Re: sa not starting in master-db"
- Next in thread: Dan Guzman: "Re: sa not starting in master-db"
- Reply: Dan Guzman: "Re: sa not starting in master-db"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
