Thursday, February 16, 2012

Accessing SQL Server 2005 Express

I recently downloaded SQL Server 2005 Express Edition. Everything was installed correctly without any problems. However, when I went to my Program list, the only thing listed for Microsoft SQL Server 2005, was Configuration tool.

Where is the actual program where I can write and run queries? How do I access the server?I think that the 'default' installation only installs SQL Server. If you want the client tools, you will need to insert the media again and select Client Tools (or something like that...)|||The Express SKU does not include the client tools you are referring to. If you want to install these, you need to download Express Advanced and add Management Studio Express. This will give you the UI-based client tools you are looking for.

Thanks,
Sam Lester (MSFT)

No comments:

Post a Comment