I am unable to open the DB

[Former Member]

Dear Experts,

We have MSSQL 2005. Today I by mistake made the DB schema SM1 offline using MSSQL Management Studio.

Now I am unable to open the DB. I have already restarted the DB and server. But every time I am getting the error

Cannot connect to TDEP.

------------------------------
ADDITIONAL INFORMATION:

Cannot open user default database. Login failed.
Login failed for user 'TDEP\ep1adm'. (Microsoft SQL Server, Error: 4064)

r3trans -d results

This is r3trans version 6.14 (release 700 - 12.06.09 - 15:20:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = MSSQL                            ---  SERVER = 'TDEP' DBNAME = ''"
r3trans finished (0012).

trans.log results

4 ETW000  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]                                 18  0.173472
4 ETW000  [dev trc     ,00000]  failed to establish conn. 0                                            11701  0.185173
4 ETW000  [dblink      ,00433]  ***LOG BY2=>sql error -1     performing CON [dblink#8 @ 433]             173  0.185346
4 ETW000  [dblink      ,00433]  ***LOG BY0=>Login failed for user 'TDEP\ep1adm'. [dblink#8 @ 433]         32  0.185378
2EETW169 no connect possible: "DBMS = MSSQL                            ---  SERVER = 'TDEP' DBNAME = ''"

I dont know how to resolve the issue. It might be very silly question but I am not DB expert. I need your help urgently.

Regards,

Partha

[Former Member]

how do you solve this?

[Former Member]

In MSSQL every login has default DB, and for successful logging in the default DB should be online. If you make a user's login default DB offline, the user cannot login, unless the default DB is changed or the DB itself is brought back online.

Thanks

Mushtaq

[Former Member]

Issue Resolved