Click here to Skip to main content
12,954,522 members (59,226 online)
Rate this:
Please Sign up or sign in to vote.
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 and windows authentication error "login is from an untrusted domain..."
2) try to connect to managment studio with ip 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
ryanb31 6-Dec-12 14:02pm
Your DBA needs to make a configuration change, it sounds like.
RedDK 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
Please Sign up or sign in to vote.

Solution 1

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

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,539
CHill60 3,490
Maciej Los 3,143
ppolymorphe 2,030
Jochen Arndt 1,975

Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 6 Jan 2013
Copyright © CodeProject, 1999-2017
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