none
I have problems with a DB

    Question

  • Hello I'm really frustrated because I can't enter to a Data Base, the problem is that I'm using the PC of my job and before me, other guy was in my place, and he created the DB that I need to work, the problem is, he created that DB with Windows permissions and when I want to enter to the DB I can't because my user can't access to his DB and I really need to enter.

    I don't know if I'm clear in my explanation.

    Thanks!

    Friday, August 15, 2014 8:06 PM

Answers

  • You'll need to find a person having access to the SQL instance with sysadmin privileges.

    Usually the person or the Department that installed the SQL Server instance will have such a privilege.

    Once that person is found, let him/her change the owner of the database to [sa] (from my point of view there's no need to have a different owner) and let him/her add you as a user with required permission (db_owner?) for the database in question.

    If you have administrator privileges on the machine the SQL instance is installed, you could install PsExec. Aaron Bertrand's blog might help you how to get access to the SL Server instance again.

    Sunday, August 17, 2014 7:53 AM
  • Hello I'm really frustrated because I can't enter to a Data Base, the problem is that I'm using the PC of my job and before me, other guy was in my place, and he created the DB that I need to work, the problem is, he created that DB with Windows permissions and when I want to enter to the DB I can't because my user can't access to his DB and I really need to enter.

    I don't know if I'm clear in my explanation.

    Thanks!

    Hi,

    Can you please check below link.

    http://msdn.microsoft.com/en-GB/library/dd207004.aspx


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Sunday, August 17, 2014 10:09 AM
  • Is this fixed ? Is this test or Dev server ? If this is not a production server then please follow the below, then you can fix it easily..

    http://blogs.technet.com/b/sqlpfeil/archive/2013/07/22/the-scenario-of-a-missing-sa-password.aspx

    http://www.mssqltips.com/sqlservertip/2478/connecting-to-sql-server-using-sqlcmd-utility/


    Raju Rasagounder Sr MSSQL DBA

    Tuesday, August 19, 2014 10:01 AM

All replies

  • Can you able to connect the sql instance ? what is the level of permission are you having ? what is the error message are you getting ? can you able to access other DB's ? other than you is there anyone having access to this sql instance ? check if others can able to access the database ? then ask them to grand correct permission to your login to access this database.

    Raju Rasagounder Sr MSSQL DBA

    Sunday, August 17, 2014 3:29 AM
  • You'll need to find a person having access to the SQL instance with sysadmin privileges.

    Usually the person or the Department that installed the SQL Server instance will have such a privilege.

    Once that person is found, let him/her change the owner of the database to [sa] (from my point of view there's no need to have a different owner) and let him/her add you as a user with required permission (db_owner?) for the database in question.

    If you have administrator privileges on the machine the SQL instance is installed, you could install PsExec. Aaron Bertrand's blog might help you how to get access to the SL Server instance again.

    Sunday, August 17, 2014 7:53 AM
  • Hello I'm really frustrated because I can't enter to a Data Base, the problem is that I'm using the PC of my job and before me, other guy was in my place, and he created the DB that I need to work, the problem is, he created that DB with Windows permissions and when I want to enter to the DB I can't because my user can't access to his DB and I really need to enter.

    I don't know if I'm clear in my explanation.

    Thanks!

    Hi,

    Can you please check below link.

    http://msdn.microsoft.com/en-GB/library/dd207004.aspx


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Sunday, August 17, 2014 10:09 AM
  • Is this fixed ? Is this test or Dev server ? If this is not a production server then please follow the below, then you can fix it easily..

    http://blogs.technet.com/b/sqlpfeil/archive/2013/07/22/the-scenario-of-a-missing-sa-password.aspx

    http://www.mssqltips.com/sqlservertip/2478/connecting-to-sql-server-using-sqlcmd-utility/


    Raju Rasagounder Sr MSSQL DBA

    Tuesday, August 19, 2014 10:01 AM