# SQL Server:Cannot open user default database

**URL:** https://forum.kirupa.com/t/sql-server-cannot-open-user-default-database/635117
**Category:** programming
**Created:** [August 15, 2016, 6:22pm UTC](https://forum.kirupa.com/t/sql-server-cannot-open-user-default-database/635117 "2016-08-15T18:22:32Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![GarryWitt](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/garrywitt/32/7721_2.png) [@GarryWitt](https://forum.kirupa.com/u/GarryWitt)
#### Post date: [August 15, 2016, 6:22pm UTC](https://forum.kirupa.com/t/sql-server-cannot-open-user-default-database/635117/1 "2016-08-15T18:22:32Z")

</div>

Hello.

My problem conserns Microsoft SQL Server.  
When I try to connect SQL Server get the error message : "Cannot open user default database"  
What is it?  
Can anyone suggest me for SQL database fix?

Regards,  
Garry

---

<div class="post-metadata">

### Author: ![GarryWitt](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/garrywitt/32/7721_2.png) [@GarryWitt](https://forum.kirupa.com/u/GarryWitt)
#### Post date: [August 17, 2016, 2:06pm UTC](https://forum.kirupa.com/t/sql-server-cannot-open-user-default-database/635117/2 "2016-08-17T14:06:21Z")

</div>

can anyone help me??

---

<div class="post-metadata">

### Author: ![ssloan](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/ssloan/32/7726_2.png) [@ssloan](https://forum.kirupa.com/u/ssloan)
#### Post date: [August 22, 2016, 3:52pm UTC](https://forum.kirupa.com/t/sql-server-cannot-open-user-default-database/635117/3 "2016-08-22T15:52:21Z")

</div>

Hi GarryWitt.  
The user default database is unavailable at the time of connection. It is possible that the database is in suspect mode or no longer exists. To avoid the error when the user’s default database is unavailable, try to log on as a user who can modify logins. Then, change the user’s default database to a database that is currently available for a connection. If it useless try a special tool - SQL Server Fix Toolbox.  
[https://www.fixtoolbox.com/sqlserverfix.html](https://www.fixtoolbox.com/sqlserverfix.html)  
It recovers databases of SQL Server format.

Good luck

---

<div class="post-metadata">

### Author: ![GarryWitt](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/garrywitt/32/7721_2.png) [@GarryWitt](https://forum.kirupa.com/u/GarryWitt)
#### Post date: [September 2, 2016, 10:10pm UTC](https://forum.kirupa.com/t/sql-server-cannot-open-user-default-database/635117/5 "2016-09-02T22:10:40Z")

</div>

Thanks for helpful info friend