Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bluemagic74
Starting Member
15 Posts |
 Posted - 2011-12-09 : 10:12:53
|
| Hi,New joinee is using the same old previous employee laptop.SQL version: 2008 R2New employee is trying to connect SQL server with his newly created network login (SQL already installed by old employee with windows authentication). throwing errorLogin 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 SQLOR Do i need to reinstall sql? please advicethanks!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-12-11 : 04:48:42
|
| Can you confirm the logon account on the target SQL Server is enabled , mapped to the relevant databases , with suitable permissions?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
pnash
Starting Member
26 Posts |
Posted - 2011-12-11 : 14:17:42
|
| try by giving local administrator rights to new employee login id. and check connectivity.if you still not able to connect then try to Start the instance of SQL Server in single-user mode by using either the -m or -f options. Any member of the computer's local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role. |
|
|
|
|
|
|
SQL login failure