[dba-SQLServer] New SQL Server Registration problem

what MDAC version do you have on your pc? (if you do not know for sure
visit microsoft and get the component checker)


On Wed, 30 Mar 2005 16:54:57 -0600, Steve Erbach <erbachs at gmail.com> wrote:
> 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
> 
> 


-- 
-Francisco
http://pcthis.blogspot.com | PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...