I am unable to connect to other machines with the same domain and network. SQL Server 2008 is running, I can connect locally with MSSQL01\Administrator and password using Windows authentication.
Although I would like other servers also to be able to access it... but it fails with the following error:
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
And how come after renaming the hostname and following instructions at http://msdn.microsoft.com/en-us/library/ms143799.aspx, both MSSQL(old hostname) and MSSQL01 appear in sqlcmd -L.
C:\Documents and Settings\Administrator>sqlcmd -L Servers: MSSQL MSSQL01