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