Remote Server access/login problem
- by shamim
My OS is Windows Server 2008 Enterprise. I have installed SqlServer 2008. In network i want to access Other users Server,i have already enable remote access,when i try to login show bellow error
**Connection can not TITLE: Connect to Server
------------------------------
Cannot connect to TECHNO009.
------------------------------
ADDITIONAL INFORMATION:
Login failed for user 'TECHNO009\Guest'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------**
Several times i try to connect as windows and sqlServer Authentication mode.But i failed,Other users also try to connect with my server they also failed and get the same message.
Why error occur ,How to solve it?