Skip to Content

Problem with SQL SERVER connection

Dec 01, 2016 at 11:33 AM


avatar image
Former Member

Hello everyone.

I cannot connect SQL SERVER. Get the following error message : "Cannot open user default database." So my question is, could anyone suggest me something for sql repair?

Hopefully someone will be able to help me with this.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Luis Darui
Dec 01, 2016 at 11:52 AM

Hi Antonio, what SAP product are you running on SQL Server? Is this coming from the system logs?

It is very likely that your database is not available or in suspect mode, offline or even in SINGLE_USER.

Anyway, new created users, by default, have master database as default. In SAP NetWeaver and SAP NetWeaver-based products the database accounts have a default database set. You can see more details within SAP Note 592514.

What you can do is to try to use the SQL Server Management Studio and force the option to connect to another database, e.g. 'master' database.

10 |10000 characters needed characters left characters exceeded