Ok, I installed SSMS 2014 and SQL Express 2014 to our server so I could begin to understand how to connect to it with access. Ultimately, my database will be hosted in the cloud through a service (Azure or similar).
Right now, Although I can connect to the database when I'm on the server, I cannot connect to it when I'm at my desktop through access. I installed SSMS on my computer and I cannot connect to it from there as well. It keeps saying the attached message...
I know I'm missing something simple in SSMS to set this up, but I don't know where to look? I'm a complete Newbie at SSMS. I've just purchased a book on this (won't be here for a few days) and I was hoping someone had the answer before I get it.
Thanks!:banghead:
Right now, Although I can connect to the database when I'm on the server, I cannot connect to it when I'm at my desktop through access. I installed SSMS on my computer and I cannot connect to it from there as well. It keeps saying the attached message...
I know I'm missing something simple in SSMS to set this up, but I don't know where to look? I'm a complete Newbie at SSMS. I've just purchased a book on this (won't be here for a few days) and I was hoping someone had the answer before I get it.
Thanks!:banghead: