Yes, that is right. A user in the security group is connected and receives the error.

I tried:

sqlcmd -E -d master -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

and then:

ALTER LOGIN [PBTF\Group - IT DB Admins] WITH DEFAULT_DATABASE = master

No errors running the command, but I still see Error 4064 in Management...

I took off the [] and got results. PBTF\bob is in the security group.

account name ...

When I run the following in SSMS, I get:

-- how does this login get to the database (authority paths)

EXEC master..xp_logininfo @acctname = '[PBTF\Group - IT DB Admins]',@option = 'all'

go

Results:

Msg...

The login does exist in the security group.

In the event log, the event occurs when the error message occurs in SQL Server Management Studio:

The description for Event ID ( 18456...

Perhaps, my problem is that I have several instanaces of SQL Server. They are:

SQL Server 9.0.4035 (SharePoint instance)

SQL Server 8.0.2055 (Standard edition)

SQL Server 8.0.760 (MSDE)

SQL Server 9.0.4053 (Express Edition)

The instance...

I am trying with the security group name now.

ALTER command says Line 1: Incorrect syntax near 'LOGIN'.

C:\>sqlcmd -E -d master

1> ALTER LOGIN [PBTF\Group - IT DB Admins] WITH DEFAULT_DATABASE =...

The default database is master and it still exists.

I get this when running the commands:

C:\>sqlcmd -E -d master

1> ALTER LOGIN pbtf\bob WITH DEFAULT_DATABASE = master

2> go

Msg 170, Level 15, State...

Just looking for a basic backup plan, and wondering why I need to use Transcation files with .BAK file in full recovery mode.

Thanks, I will give this a try.