asked
SSAS Database remote connection
Apologies, this must have been answered a million times. I cannot find a simple answer, or one that actually works. I'm working my way through "Multidimensional Modeling (Adventure Works Tutorial)" on SQL Server 2014 BI edition. I'm building the project on my workstation and want to deploy to my DEV server on Windows 2012 R2. I just spent most of the day trying to resolve the error "A connection cannot be made. Ensure that the server is running". I've created a database on the server directly using an admin account. You cannot connect SSMS or deploy from Visual Studio with anything but Windows authentication to SSAS instances. So, 1. Added my Windows Account with God status under 'Roles' in the SSAS database 2. Ensued the Server name and database name are correct in the VS project properties. 3. Ensured my windows account has access to the SSAS instance (unnamed). Problem: Cannot deploy with error as above Through SSMS I cannot make a connection due to a time out error. I've searched hundreds of links, literally, yet most seem to point to making sure the correct target info is entered Many people have solved this so if someone can post a link that I may not have stumbled across, please do. Any ideas would be appreciated. I must be missing something. How do I diagnose a deeper, more meaningful error? In advance, Thanks
I recommend that you check 2 things: 1. Is the SQL Server Browser service running on your DEV server? If not, you need to specify the port in your connection to the DEV server. 2. Could also be a firewall issue. Temporarily disable the firewall on your DEV server, and see if you can connect. If you can, it means that the firewall was preventing incoming connection requests and you'd have to create a rule for either the port or application.
Thanks Martin, Yes - I'd checked the SQL Server Browser. Windows firewall is off, but i need to check with them if they have something else in place. cheers
update - yep the sys admin guys had a different firewall - disabling that allowed the connection and I need to work with them now to iron out the settings so work can actually be done. thanks
19 People are following this question.
