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 |
|
cpolk10
Starting Member
1 Post |
 Posted - 2011-08-01 : 14:31:34
|
| I have 2008 R2 and 2005 SQL instances on my local work station.I recently updated to a new user when joining a new domain. When I did, I updated the services that run each of these instances to this new user.The SQL 2005 instance worked perfectly. But, my 2008 R2 instance keeps getting login failure when authenticating."Login failed or user "". (Microsoft SQL Server, Error: 18456)"Any suggestions?Craig Polk |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-08-02 : 06:20:23
|
| I sincerely wish that you have NOT forgotten your sa password.PBUH |
 |
|
|
|
|
|
Windows Auth not Working