SQL login failure

• HBK_4700

  SSCrazy Eights

  Points: 8932

  More actions

  December 9, 2011 at 8:08 am

  #264719

  Hi,

  New joinee is using the same old previous employee laptop. SQL version: 2008 R2

  New employee is trying to connect SQL server with his newly created network login (SQL already installed by old employee with windows authentication). throwing error

  Login failed for user '<user_name>

  So since old employee installed SQL and able to access SQL server successfully.

  What permissions need to set for new employee to connect to SQL

  OR Do i need to reinstall sql? please advice

  thanks!!

• okbangas

  SSChampion

  Points: 11773

  More actions

  December 9, 2011 at 10:18 am

  #1419526

  The "default" permission would to be that the user installing SQL server Is admin, no other have access. In that case, the old laptop user woul need to grant access, or you have to rebuild the master database, or reinstall.

  ---

  
  Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

  Concatenating Row Values in Transact-SQL[/url]

• Lowell

  SSC Guru

  Points: 323518

  More actions

  December 9, 2011 at 11:20 am

  #1419554

  since you have control of the physical server on the laptop,

  you an stop and start the service in single user mode, connect and then add a domainuser or localuser as a sysadmin user, or change the sa password so you can restore access:

  http://beyondrelational.com/blogs/chintak/archive/2010/07/20/sql-2008-r2-new-installation-and-login-password-unknown.aspx

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!