If you're having trouble connecting to Enterprise Data Warehouse (EDW) data, use the steps below to troubleshoot the most common issues.
Before you submit a support request, try the following:
Verify that you have been granted access to EDW data.
Make sure you're connecting using the fully qualified server name.
For most users, the main EDW server is: `edwpub.s.uw.edu`
If that doesn’t work, try using the port number format: `edwpub.s.uw.edu,1433`
Using port numbers is not recommended. If the server port changes, your connection will break. Some users have required port numbers to connect to named instances on clustered servers.
See the full list of EDW servers and databases.
If you’re working off-campus, make sure you're connected to the VPN using Husky OnNet.
Learn how to connect using Husky OnNet.
If you're using the RunAs command to open your query tool and connect, make sure the command does not include `/netonly`.
You may need to go through all the troubleshooting steps again after making this change.
Some users may see an error related to SSL security. If so, check that your computer trusts the UW Services CA Root Certificate.
Learn more about the CA Root Certificate.
---
If you’ve tried these steps and still can’t connect, contact your local IT support team or submit a help request to UW-IT at help@uw.edu.