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 |
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
 Posted - 2008-03-25 : 19:56:00
|
| HiI've just installed SQL Server 2005 on my local machine. When I try connecting to the server I get the following message:'Login failed for user 'Home-PC\RR'. (Microsoft SQL Server, Error: 18456)'I am using the correct the username and password but still having the same problem.Does anyone know what the problem could be?Thanks |
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-03-25 : 23:13:46
|
| 'Home-PC\RR' is this login has access to the machine. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-25 : 23:17:27
|
| Do you use sql authentication? Ensure you use valid sql login which created in sql already. For windows authentication, you don't have to input user name and password. |
|
|
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2008-03-26 : 04:16:17
|
| HiI am using Windows authentication.Thanks |
|
|
|
PABluesMan
Starting Member
26 Posts |
Posted - 2008-03-26 : 09:49:32
|
| You are probably going to have to go in under the "sa" login and grant access to the "HOME-PC\RR" login and give it sysadmin privileges (if that's what you want it to have).I geek, therefore I am |
|
|
|
|
|
|
Problem Connecting To Server