SQL Server 2008 R2 Management Studio login problems

Use windows authentication login, the following error message:

User login failed. The login name from an untrusted domain, can not be used together with Windows authentication.

Access to a lot of information on the web, haven't said it clearly, I found the server name server name is not IP address, you can, we share

Started by Christina at February 11, 2016 - 6:31 PM

Study. Thank you!

Posted by Derek at February 15, 2016 - 7:20 PM

Is it right? The client to do the mapping alias or DNS.

Posted by Craig at February 26, 2016 - 8:08 PM

Thanks for your sharing after the encounter of this kind can be solved

Posted by Mariah at March 12, 2016 - 8:45 PM

No settings, even I, too, SQL Server say, the direct use of IP access, and DNS also it doesn't matter.
I doubt and windowx operating system settings, different ghost versions of XP, there are some differences, making the installation package gohost people have done a lot of set

Posted by Christina at March 13, 2016 - 9:12 PM

There is a certain relationship with the operating system, I said DNS is when you use the name of the server connection
See your description should also.~
This condition is not met, the sqlserver is not installed in the XP. Ha ha

Posted by Craig at March 15, 2016 - 9:37 PM

Your service should leave leave yet? With the server name to login to open named piped. Browser and SQLServer sometimes affect.

Posted by Sean at November 20, 2016 - 2:11 PM

The service must be opened, because now is to log in using the server name, if you use IP on it, but only by the SQL Server users landing, landing can not use Windows system user. This in turn profile trouble, the user password should not be saved, but Windows users of the system can't log on

Posted by Christina at November 22, 2016 - 2:20 PM

Good thanks for sharing

Posted by Jenny at December 05, 2016 - 2:50 PM

Use windows authentication login should be used together with AD.

Posted by Sammy at December 15, 2016 - 3:38 PM

This machine administrator account can't use windows landing?

Posted by Sean at December 16, 2016 - 3:47 PM

Is not logged in, very strange. I just started is the installation of SQL Server Administration user, but then I landed on the operating system to switch to another user of the computer system, is also a member of the administrators group account, found the windows system user cannot connect to SQL server, cut back to the original Administration user is not, later found not in the landing when the IP address but the name of the computer, but can be landed

Posted by Christina at December 27, 2016 - 4:19 PM

Then you try SA do not disable, and then log on to remove the Administrator Server account and put it in and try to not

Posted by Sean at January 10, 2017 - 4:51 PM

Server name server name rather than an IP address, you can,

What do you mean? I don't understand?

Posted by Gwendolyn at January 12, 2017 - 5:02 PM

Access to a lot of information on the web, haven't said it clearly, I found the server name server name is not IP address, you can, we share

What do you mean, you explain.

Posted by Jacob at January 13, 2017 - 6:01 PM