[dba-SQLServer] New SQL Server Registration problem

Billy,

Hmmm, this is making some sense to me. What's funny to me about this
situation is that, with ODBC, you can select a default database from
the list that's presented to you once the connection is established to
the server. With EM that choice is not available to you.

Is the sp_defaultdb sproc something I could execute with the SQL
Server command line interface? I forget what it's called at the
moment. I mean login via the command line and maybe run sp_defaultdb?

Steve Erbach

On Apr 4, 2005 10:36 PM, Billy Pang <tuxedo_man at hotmail.com> wrote:
> afaik, you have everything you need to connect to the db.  however, the db
> login you are using to connect to the SS via EM has a database set as
> default but the specified user no longer has access to that db.  i'd find
> some way of setting that default db of that login to a db that login has
> access to (eg. tempdb).  maybe use the sp_defaultdb sproc.
> 
> HTH
> 
> Billy
>