Data Access for Reporting/Analysis
Data Access for Reporting/Analysis
Is it possible to grant someone access to the SQL Server database directly for querying and more in-depth reporting/data analysis? I'd like to whitelist an IP and allow read only access to the database for an individual who does this kind of technical work. Is that something I could explore or am I asking too much?
- Pauls Automotive
- 1000 Club: Interstellar
- Posts: 1415
- Joined: Wed May 24, 2006 6:32 am
- Location: Baltimore Maryland
- Contact:
Re: Data Access for Reporting/Analysis
I don't know about SQL but back in the access days you could request to open the database and they would give you the password however you had to sign an agreement that it was your baby from then on and you gave up support if there were problems. Not sure what they do nowadays.
Paul
Pauls Automotive
6318 Falls Road
Baltimore, Md 21209
410-825-2224
paul@paulsauto.com
TRUE HAPPINESS IS WITHIN YOU
Pauls Automotive
6318 Falls Road
Baltimore, Md 21209
410-825-2224
paul@paulsauto.com
TRUE HAPPINESS IS WITHIN YOU
Re: Data Access for Reporting/Analysis
The database can be accessed on the host machine with nothing more than Windows authentication.
M1 Product Manager
Re: Data Access for Reporting/Analysis
Could this be done remotely though? The individual who is doing the reporting/analysis isn't here locally and would need to be able to connect to the database remotely.
I'm assuming you're saying the user would need to remote into the machine where the DB is and then log in from there?
I'm assuming you're saying the user would need to remote into the machine where the DB is and then log in from there?
Re: Data Access for Reporting/Analysis
Yes, a remote session would be the easiest way to do this work.
M1 Product Manager
Re: Data Access for Reporting/Analysis
what about whitelisting an IP with inbound/outbound rules on the host and then connecting directly to the database remotely? Since TCP/IP is already enabled, this seems at least theoretically possible.
Re: Data Access for Reporting/Analysis
In theory it is. However, anything outside of a "local" connection can't use Windows authentication. It would be SQL server authentication at that point, and we do not give out the password for that.
M1 Product Manager