Data Access for Reporting/Analysis

Manager SE Settings, Defaults, Database
Locked
jmason81
Member
Posts: 3
Joined: Mon Jan 07, 2019 8:09 am

Data Access for Reporting/Analysis

Post by jmason81 »

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?
User avatar
Pauls Automotive
1000 Club: Interstellar
1000 Club: Interstellar
Posts: 1415
Joined: Wed May 24, 2006 6:32 am
Location: Baltimore Maryland
Contact:

Re: Data Access for Reporting/Analysis

Post by Pauls Automotive »

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
User avatar
Silky7
System Guru / Moderator
System Guru / Moderator
Posts: 1035
Joined: Mon Dec 31, 2007 10:07 am

Re: Data Access for Reporting/Analysis

Post by Silky7 »

The database can be accessed on the host machine with nothing more than Windows authentication.
M1 Product Manager
jmason81
Member
Posts: 3
Joined: Mon Jan 07, 2019 8:09 am

Re: Data Access for Reporting/Analysis

Post by jmason81 »

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?
User avatar
Silky7
System Guru / Moderator
System Guru / Moderator
Posts: 1035
Joined: Mon Dec 31, 2007 10:07 am

Re: Data Access for Reporting/Analysis

Post by Silky7 »

Yes, a remote session would be the easiest way to do this work.
M1 Product Manager
jmason81
Member
Posts: 3
Joined: Mon Jan 07, 2019 8:09 am

Re: Data Access for Reporting/Analysis

Post by jmason81 »

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.
User avatar
Silky7
System Guru / Moderator
System Guru / Moderator
Posts: 1035
Joined: Mon Dec 31, 2007 10:07 am

Re: Data Access for Reporting/Analysis

Post by Silky7 »

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
Locked

Return to “Database + Settings”