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 |
|
Lasse_carlsson
Starting Member
2 Posts |
 Posted - 2011-01-12 : 05:21:07
|
| Hello, I have installed MS SQL Express 2008 on one computer and configured a database. I tried to configure a ODBC from another computer on the same network, but I get an error: Connection faild: SQLState: '28000' SQL Server Error: 18452 [Microsoft]SQLNative Client][SQL Server]login failed. The login is from an untrusted domain and cannot be used with Windows authentication. Does anybody have any ides what I need to do ? Cheers Lasse |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-01-12 : 05:58:38
|
| 1) Check that the other computer is on the same domain where the SQL Server is installed.Or try to access the system through the SQL authentication mode not through the windows authentication. However SQL authentication is not preferred! 2) Include the SQL server port to the exception list on the computer where the instance is installed. |
 |
|
|
|
|
|
MS SQL Server Express 2008 Login, ODBC