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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
nicober
I just double checked and the file is D:\setup\sql_ssms.msi
ASKER
I can't see that file on either disc?
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.
any files called “SqlRun_Tools.msi” on the CDs ?
ASKER
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\darwi
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:Watson 1:1807 2:StreamSupportFiles 3:getBootStrapDirectory 4:3
5:t:\yukon\sql\setup\darwi
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?
is this workstation on a x64 based OS?
have you tried to execute the msi with "run as administrator"
have you tried to execute the msi with "run as administrator"
ASKER
THx for solution