Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Hello,
I have a problem connecting to an sql server through ip address, here are the symptoms.
1) try to connect to managment studio with ip 127.0.0.1 and windows authentication error "login is from an untrusted domain..."
2) try to connect to managment studio with ip 127.0.0.1 and user sa and pass login success
The same behaviour when I try to connect from VB .Net with adoconnection,
I have windows 7 pro 64 bit, in my win xp pro sp3 machine can connect without errors.
 
(notice try to change the permissions of the user in sql managment studio but failed to give permission to user supervisor, only user sa has permissions.
Posted 6-Dec-12 7:03am
Comments
ryanb31 at 6-Dec-12 14:02pm
   
Your DBA needs to make a configuration change, it sounds like.
RedDK at 2-Jan-13 19:23pm
   
In addition to finding out what exactly the connection string might be, as r mentions, you could test in a scenario such as creation of a SQL project using Visual Studio (I see VB.NET). Or failing an info gained about possible Server being offline, checking your antivirus Block/Allow list for instance running discrepancy. In other words tell us that something related to SQL Server on this machine actually runs.
 
Ok, you did that. Also try switching the login from Server to Windows default user where no password other than operator is required.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

I had to add to the hosts file the line "127.0.0.1 localhost"
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 371
1 Sergey Alexandrovich Kryukov 269
2 CB Sharma 79
3 RyanDev 75
4 PhilLenoir 70
0 Sergey Alexandrovich Kryukov 6,676
1 OriginalGriff 6,056
2 CPallini 2,473
3 Richard MacCutchan 1,697
4 Abhinav S 1,560


Advertise | Privacy | Mobile
Web01 | 2.8.140821.2 | Last Updated 6 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100