Re: sa not starting in master-db

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

Date: Tue, 15 Jul 2003 08:52:10 -0500

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
    ... that you were connecting using standard SQL security with the sa login. ... "jobi" wrote in message ... >> Is the sa database context set incorrectly when connecting from any ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Database recovery with data file only
    ... Basically using that command breaks your business logic as there's no ... "Dan Guzman" wrote in message ... >> database Backup as well as ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: How critical is the transaction log file?
    ... Tibor Karaszi, SQL Server MVP ... file when you have only one file (no log file). ... circumstances it is supported to attach only an mdf file. ... > This development database that we're building does not have any 'user' ...
    (microsoft.public.sqlserver.tools)
  • Re: commiting the transaction log?
    ... Tibor Karaszi, SQL Server MVP ... been that the file growth (such as that by alter database or autogrowth) is ... Is that the reason for the log file (in the file system) having time stamp that is pretty old ... But even if I run the FULL backup, and then the T-log backup, I can see that ...
    (microsoft.public.sqlserver.server)
  • Re: Inserting new rows that use divided values
    ... Mary Bray [SQL Server MVP] ... > it to an existing database. ... > REFERENCES order_cost; ... > correct syntax. ...
    (microsoft.public.sqlserver.programming)