I have installed Visual Studio 2005 Prof Edition on a Vista machine and SQL Server 2005 Developer Edition on a Windows 2000 server. They will be used as a development environment for us. As we need to management the SQL Server 2005, we would like to install the 2005 Developer SSMS on the Vista machine such that we can manage the SQL Server 2005 developer instance installed on that Win2k machine. However, the system does not allow us to do it. We have the express edition autoamtically installed while we installed the Vistual Studio. Is there any workaround that i can still install the 2005 developer SSMS without uninstall the sql server 2005 Xpress version? Or, I have to uninstall the Xpress version before i can install the 2005 developer's SSMS? Please help!
All VS2005 pro comes with free SQL Server 2005 developer edition so you can install one in each Vista and do the needed configuration of enabling browser service, and enabling both TCP/IP and Named Pipes in configuration Manager and use the Surface Area Configuration tool to allow both local and remote and allow TCP/IP and Named Pipes. While you are at it also configure mixed Authentication so all developer can register each other SQL Server and access all in one place.
Another option is to uninstall Express and use Express Advanced that comes with Management Studio.
http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en
Thanks for the reply. My question probably not clear for what we're trying to do. Actually, we are trying to install an instance of SQL Server 2005 Developer Edition (whcih come with Visual Studio Developer Edition into a machine running Windows 2000 SP4). And then I installed the Visual Studio 2005 professional edition into my company which is running on a Vista version Ultimate. Both installation success without any big problem. However, I would like to be able to manage that SQL Server 2005 Developer edition which installed in that Windows 2000 server through my local computer (Windows Vista with Visual Studio 2005 Prof installed). The problem is, there is a SQL Server 2005 Express edition installed into my computer (Vista) when I installed teh Visual Studio. And now, I tried to install the Sql Server Mangement Studio from SQL SErver 2005 Developer edition into my Vista machine, the system doesnt allow me to do it. So, do i have to uninstall the express edition in my local computer (vista) and then install the SSMS from the SQL Server 2005 Developer edition disc? Or, there's somoe other work around that it will allow me to install the SSMS from SQL Server 2005 Developer edition and the same time, keep the 2005 Express edition running in my local computer system. My reason is, the SSMS is just a management tools, it shouldnt depends on what version of DB engine installed into my local computer. Anyone please help
|||I am one of the people who got the SQL Server developer edition price down from $450 to $50 list so I don't think such strange uses is valid. However you can uninstall the standard Express and use the Advanced which is also free and comes with most features of the full product including Management Studio. But you still have to do what I have explained in my first post because Express and the Developer edition comes with most services disabled.
|||ic.. so uninstall the pre-installed sql server express from my computer (which has the visual studio 2005 prof edition installed) wont affect my visual studio 2005, right? Just want to make sure before i uninstall anything 
sorry about the noob question..
Actually Microsoft now let you download the Management Studio for standard Express so download it below and install it. This link also gives you features compare of the Advanced and the Standard Express. But remember you have to go back and use my remote connection instruction. Hope this helps.
http://msdn2.microsoft.com/en-us/express/bb410792.aspx
No comments:
Post a Comment