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 |
|
rajsiiv
Starting Member
4 Posts |
 Posted - 2007-06-05 : 01:04:42
|
| Hi, We have four windows xp systems. Iam trying to connect Sql Server 2005 to one of our 4 systems, from remaining systems. It is possible or not, I am getting login failed for user, I have doubt, this is possible on XP system or not Plz help me, Rajesh Sirivella |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-05 : 01:23:30
|
are you using windows or sql auth? are the machines part of a domain? if so windows auth should work fine. I'm not sure if remote connections with windows auth works in a workgroup.sql auth should work either way, whether you have a domain or just a workgroup.
www.elsasoft.org |
 |
|
|
rajsiiv
Starting Member
4 Posts |
Posted - 2007-06-05 : 01:34:32
|
| We are using windows authentication, out systems in domain only.But all systems using windows XP onlyRajesh Sirivella |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-05 : 01:37:42
|
have you created logins/roles on the remote server for the nt account you are trying to connect as?
www.elsasoft.org |
|
|
|
rajsiiv
Starting Member
4 Posts |
Posted - 2007-06-05 : 01:51:52
|
| yes I added that user in our login user. I am getting error like The user is not associated with a trusted SQL Server connectionRajesh Sirivella |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-05 : 02:24:21
|
it sounds to me like you are connecting with a windows account that does not have perms to the server/database.does that login have a user or role associated with it in the database you are connecting to? has it been granted database access? the kb article here may help you, see the "workaround" section, third bullet point: http://support.microsoft.com/kb/889615
elsasoft.org |
|
|
|
rajsiiv
Starting Member
4 Posts |
Posted - 2007-06-05 : 02:27:17
|
| Yes, Thank you for replying. I cleared that problem.Rajesh Sirivella |
|
|
|
|
|
|
Connecting to remote server