Thursday, March 1, 2007

SQL Server 2005 Dev Edn Installation Issues

This is a strange problem. I have been trying to get the SQL Server 2005 Dev Edition installed on my laptop & there's a very strange error.

During installation, there's a choice for choosing an instance. An instance identifies the SQL Server's instance... ;-) Instances can be either Default or Named. If you have chosen default, then the SQL Server instance is identified by just the server name. Named instances are known by the network name of the computer plus the instance name. The client needs to specify both these values.

Now, the issue that I faced was when I tried to install using default instance, there were incomplete installations. I couldn't find SSMS or any development tools (these are just to start with). The only thing available was the configure manager. A developer would want to use the SSMS or BIDS more than the config mgr.

The solution is ( I looked up a
t a PDF document) to use named instance. The reason is still not known to me...will figure out & post it...meanwhile, if anyone else has experienced this kinda problem or knows why this occurs...enlighten.