childofthe1980s (childofthe1980s (AT) discussions (DOT) microsoft.com) writes:
Quote:
We have implemented a 64-bit SQL 2005 Server Standard. We need to install
the client tools on three 32-bit workstations.
To do so, would we use the 64-bit client tools or the 32-bit? Would these
32-bit tools be on a 32-bit CD? Are they downloadable? |
As Aaron says, there are no 64-bit tools (save the command-line ones).
However, if memory serves, you need 32-bit media to be able to install
them on the workstations, because the 64-bit Setup does not like to run
32-bit. This issue applies to SQL 2005; I believe it has been corrected in
SQL 2008.
Quote:
Can any user access these tools? Or, does it have to be a SQL admin? I
want to make sure that the user can easily access the tools. |
Any user can use the tools, but he can of course only perform tasks for
which he has permission in SQL Server. Running queries, no problem. Running
Profiler, on the other hand, requires at least ALTER TRACE on the server
he connect to.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx