Change default db to Master db in SQL Server

Question

I have deleted my default db now I can not login using sql server authentication. How can I change default db back to Master db

EDIT: I cannot login using sql server authentication. It gives me error

Cannot open user default database. Login failed. Login failed for user 'xyz'. (Microsoft SQL Server, Error: 4064)

Thanks.

Joe Stefanelli · Accepted Answer · 2010-10-12 13:27:41Z

2

Connect via SSMS. In the connection dialog box, click on the "Options >>" button and change the "Connect to database:" option to be Master instead of <default>. alt text

This should get you in. Then you can use the command below to change your login's default DB.

Exec sp_defaultdb @loginame='login', @defdb='master'

answered Oct 12, 2010 at 13:27

Joe Stefanelli

136k21 gold badges243 silver badges241 bronze badges

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

Comments

Mitch Wheat · Accepted Answer · 2010-10-12 13:02:05Z

1

In SSMS: Server->Security->General Tab->Default Database

answered Oct 12, 2010 at 13:02

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

1 Comment

Kashif Over a year ago

Thanks Mitch, I know this option but I can not login and I don't have access to the server from where I can login using Windows Authentication. Please see my edit.

Collectives™ on Stack Overflow

Change default db to Master db in SQL Server

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related