• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1175
  • Last Modified:

SQL Server Management Studio for SQL Server 2005 (Standard)

Dear experts,

Can anyone point me to the right direction to download SQL Server Management Studio for SQL Server 2005 Standard Edition please?

We have a SQL Server 2005 and the MAnagement Studio is installed on the same server. However, we are going to implement a reporting tool and the user (only one) was told she needs SQL Server Management Studio installed on her computer, in order to get data directly from the SQL Server.

I have searched online but most I found are the Free version - which I don't think is suitable as it has a limitation on database with size less than 10Gb (our d'base is definitely over 10Gb). Others I found are for the SQL Server 2008 Express edition, which may not be suitable as we are using SQL Server 2005 Standard.

So can anyone let me know where I can obtain a copy of SQL Server Management Studio, that works with SQL Server 2005 please? I can't see that on the CD.

Thanks in advance
0
ormerodrutter
Asked:
ormerodrutter
  • 5
  • 3
1 Solution
 
nicoberCommented:
Management Studio can be found on the second disk of MS SQL server 2005.
0
 
nicoberCommented:
I just double checked and the file is D:\setup\sql_ssms.msi
0
 
ormerodrutterAuthor Commented:
I can't see that file on either disc?
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
nicoberCommented:
using the same disk that was used for the installation of SQL 2005, a custom installation should let you choose to install only Management Studio then.
0
 
nicoberCommented:
any files called “SqlRun_Tools.msi” on the CDs ?
0
 
ormerodrutterAuthor Commented:
I found the SQLRun_Tool.msi file on the second CD of SQL Server 2005. However, I wasn't able to install it it gave me this error message :-

0:Watson 1:1807 2:StreamSupportFiles 3:getBootStrapDirectory 4:3
5:t:\yukon\sql\setup\darwin\sqlcastub\catarget.cpp 6:100 7:sqlcastub.dll
8:sqlrun.msi

When clicked ok after that another message displayed :- "A valid destination folder for the install could not be determined".

I wasn't able to choose destination folder anyway. I tried it on two different machine with the same error. Please help?
0
 
nicoberCommented:
is this workstation on a x64 based OS?
have you tried to execute the msi with "run as administrator"
0
 
ormerodrutterAuthor Commented:
THx for solution
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now