Skip to Content
avatar image
Former Member

Problem with SQL SERVER connection

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Add comment
    10|10000 characters needed characters exceeded