[dba-SQLServer] New SQL Server Registration problem

Steve Erbach erbachs at gmail.com
Wed Apr 6 10:25:09 CDT 2005


Hey! Using OSQL to connect to the database (since I could specify the
default database in the command line) I was, indeed, able to use the
sp_defaultdb sproc to change the default db. Now -- finally -- I was
able to connect to the database using Enterprise Manager! Thank you
very much.

Seems funny, though, that EM doesn't seem to have any built-in way of
specifying the default db when a new Registration is created. In any
event, I'm set.

Steve Erbach
Neenah, WI

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.
> Billy

More information about the dba-SQLServer mailing list