SQL Server still thinks that a database exists

Question

I ran into an odd problem. I tried to disable an old, unused login but when I clicked OK the server came back with the following error

The database 'xyz' does not exist. Supply a valid database name.

The odd thing is that that database was detached years ago. Somewhere, SQL still has some reference to it. Where can I look and how can it be removed?

Thanks.

Could it be that this user has that xyz database set as its default database that he used to connect to? — marc_s
– marc_s, Commented Jul 26, 2012 at 16:00

marc_s · Accepted Answer · 2012-07-26 16:02:07Z

3

Could it be that this login has the xyz database set as its default database that he used to connect to?

enter image description here

If so: change that default database to something else, when you disable the login.

answered Jul 26, 2012 at 16:02

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jason Over a year ago

That was it. When I looked at the Default database the selected value was blank because the database obviously could not be found. Thanks!

Collectives™ on Stack Overflow

SQL Server still thinks that a database exists

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related