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 |
|
Ken Blum
Constraint Violating Yak Guru
383 Posts |
 Posted - 2008-06-20 : 09:08:19
|
| When attempting SQL Replication I am getting an error that the user I setup for connecting to the Distribution database was unable to connect. I have setup a domain administrator user on our Domain (Active Directory) with the name of SDP. In order to test the SDP login I attempted to connect as DOMAIN\SDP, and it failed. If I login to Windows (2000) as SDP I can connect to the Server using Windows Authentication without any problem.Why can I not connect using SQL Server Authentication as DOMAIN\SDP when I am logged into Windows as kblum? Is there some sort of setting that I need to establish to allow this?TIA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Can't connect as another windows user