So, I get data source=localhost\SQLEXPRESS working now. I am using Windows 7 for both terminal. Still, the client terminal can't connect to the server
Here's info
Server terminal name = FMT1
Client = FMT2
server password = sambapos.1234
user id = sa ?
on the client terminal, I have tried to set data source = FMT1\SQLEXPRESS <--- doesn't work
data source = FMT1\SQLEXPRESS; user id=sa; password=sambapos <--- also doesn't work
on the server machine Manage>locals settings I have set Message server Name = FMT1 , and enable Auto Start Message Client
But it shows Disconnect at the right bottom of the screen
and from my understanding, on the client terminal we don't have to install SQLExpress right? and do I have to set Message Server Name = FMT1 <-- my server name , and enable Auto start message client ?
Please HELP !