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 |
|
Oliver wang
Yak Posting Veteran
50 Posts |
 Posted - 2011-06-01 : 02:02:12
|
| Hello everyone,I got a weird connection issue. The current situation is as below:1. Database is in a workgroup rather than a domain. Instance is under Mixed mode.2. If I use a Sql Server user(not domain user) to logon from local, I can login successfully.3. If I use a Sql Server user to logon from remote, a. If I type IP address in Server Name textbox on SSMS(other parameters are the same), I can login successfully. b. If I type in the corresponding computer name in Server Name textbox on SSMS, an error pop up saying: "The login is from an untrusted domain and cannot be used with Windows authentication." The Error code I got from error log is "rror: 18452, Severity: 14, State: 1"Could anybody share your idea on this issue? Thank you very much.regards,Oliver |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-06-01 : 18:17:42
|
| It sounds like it is trying to connect using a Windows account. Have you changed security mode recently to or from Mixed Mode? If so, have you overlooked having to restart the SQL Service? Just a thought...=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
 |
|
|
lappin
Posting Yak Master
182 Posts |
Posted - 2011-06-02 : 10:53:20
|
| Where logged in successfully execute: SELECT @@SERVERNAMEThis will give you the name of the SQL Server Instance - it may be different to the machine name. |
|
|
|
|
|
|
Connectivity issue