[dba-SQLServer] New SQL Server Registration problem

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

>From: Steve Erbach <erbachs at gmail.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver at databaseadvisors.com
>Subject: [dba-SQLServer] New SQL Server Registration problem
>Date: Wed, 30 Mar 2005 16:54:57 -0600
>
>Dear Group,
>
>I'm baffled. I have an Access 2000 ADP that connects to a certain SQL
>Server database. I have an Access 2000 MDB that connects via ODBC to
>the same SQL Server database. I have an Access 2003 ADP that connects
>to the same database. I have an ASP.NET project that connects to the
>same database.
>
>My problem is that I can't seem to connect to the database using SQL
>Server Enterprise Manager. I go to add a new Registration and up pops
>the 'Registered SQL Server Properties' dialog box. I fill in the IP
>address of the SQL Server and select the 'Use SQL Server
>Authentication' button, and type in the Login Name and Password. When
>I click OK I get the following message:
>
>-----------------------------------------------
>SQL Server Enterprise Manager
>-----------------------------------------------
>? SQL Server registration failed because of the connection failure
>displayed below. Do you wish to Modify anyway?
>
>Cannot open user default database. Login failed.
>-----------------------------------------------
>
>I've used Enterprise Manager to set up four other SQL Server
>connections that all work fine. Any ideas why I can't get EM to create
>a new registration?
>
>--
>Regards,
>
>Steve Erbach
>Scientific Marketing
>Neenah, WI
>www.swerbach.com
>Security Page: www.swerbach.com/security
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>