Monday, February 16, 2009

Connecting SQL SSEE to SQL Management Studio

If you are using SQL 2005 SSEE & wants to edit permission or take SQL backup

Actual place where the database is Stored.
C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data

You can See the databases in SQL by Downloading Microsoft SQL Server Management Studio Express from the below link

https://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

After you install this application Copy & paste

\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

On the Authentication Window Under server name. & you will be able to See all the databases

No comments: