Skip to Content
avatar image
Former Member

Problem with SQL SERVER connection

Dec 01, 2016 at 11:33 AM | 57 Views

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.

Microsoft SQL Server
SQL
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    Add comment
    10|10000 characters needed characters exceeded