April 9, 2009 at 10:14 pm
Hi,
Could you please tell me whether you guys install Management studio, Books Online on a production server or not?
If we install Management studio and Books Online will it effect anything?
Please advice...
April 10, 2009 at 12:21 am
We install SSMS + BOL on every sqlserver server.
(BIDev studio will only get installed at request.)
Why do we install SSMS locally on the server ?
Because we are only allowed to perform certain actions using a remote desktop solution.
"But you can also use 'run as' with your clients SSMS" indeed, but the remote desktop account doesn't have logon authority on our local pc or laptops.
btw: we only use windows authentication to perform administrative tasks for sqlserver. sa isn't being used!
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 10, 2009 at 10:21 am
Same here. The client tools are a standard part of each of our SQL Server installations on database servers.
Greg
April 10, 2009 at 11:25 am
We also install the client tools on the server. It does not hurt anything, but when you need to do something and your PC is not available (with all of your tools, including SSMS) - it is nice to be able to remote desktop to the server and perform the work.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 10, 2009 at 12:39 pm
same here...
Its not going to hurt the server performance either.
April 10, 2009 at 12:58 pm
Boolean_z (4/10/2009)
same here...Its not going to hurt the server performance either.
Unless someone decides to run a query on the server and return millions of very large rows. I would not recommend doing those kinds of queries on the server - but I have seen it.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply