SQL login failure

Question

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

okbangas SSChampion Points: 11773 More actions · Answer 1

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 · Answer 2

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!