February 24, 2010 at 1:29 pm
Hi. Here goes..Environment: SQL Server 2005 Standard SP2.
I have been asked to delegate access for a novice user to allow them to create queries for the purpose of report creation.
Access will be to all database tables (there are no views). I do not see a requirement to access stored procedures at this time. I anticipate user will write SELECT statements, use inbuilt functions.
Now never having delegated control (never been able to let go..........) I propose to do the following;
Assign the domain account to database role 'Datareader' (initially on a Test System).
Questions:
1) Do I simply install SSMS / Microsoft Visual Studio on the client machine
2) Report Creation - The application reports reference a shared data source. The account used for the data source is the database owner (this was set-up by application vender). I do not want to disclose this password to the user.
I am unclear regards the licensing side of things (SSMS / Microsoft Visual Studio). Can I install on as many client machines as required?
Question:
3) Monitoring - I would like to monitor the system. Not just because of the delegation. I have read it is not advised to run sql profiler on the sql server but to instead run on an administrator machine. I am unsure how to do this? How do you run a trace without launching profiler from the sql server?
I look forward to your expert comments / advice.
Kind Regards,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 24, 2010 at 2:25 pm
1) You can download and install SSMS express without any licensing problems:
2) Not sure about this one
3) When you fire up SQL Profiler, it asks for a server to connect to, similar to what happens when you fire up SSMS. Simply point it to the database server you'd like to profile.
Here's a quick hit:
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1159433_mem1,00.html
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 24, 2010 at 4:55 pm
Regarding question 3, you can create and start Server Side trace, have a look in BOL about creating them but you can use profiler to generate a script that can be used to create your side trace.
Gethyn Elliswww.gethynellis.com
February 25, 2010 at 1:18 am
Thanks for the input. How does visual studio (delivered with SQL) fit in regards deployment to multiple users?
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 26, 2010 at 7:02 am
Found this on Andrew Fryers blog thought others might find it useful:
http://blogs.technet.com/andrew/archive/2008/07/14/licensing-sql-server-client-tools.aspx
Regards,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply