Connect.Collaborate.SharePoint

Connecting to the SharePoint Services Embedded Database with Management Studio Express

If you use the WSS 3.0 embedded SQL engine (standalone install) you will have noticed there is no database admin tool except for the stsadm back/restore command line utility. Even if you have a full copy of SQL server on another server, you can't connect to the WSS database remotely because network connectivity is disabled.

There is a free SQL management tool called Management Studio Express which you can download from http://www.wssdemo.com/redir.aspx?ID=1008

And using the magic connection string \\.\pipe\mssql$microsoft##ssee\sql\query you can connect to the Microsoft##SSEE instance.

Management Studio Express

http://www.wssdemo.com/v3Images/_w/sqlconnection_jpg.jpg

Posted by Ian Morrish on Monday, 2 Apr 2007 10:41 | 0 Comments
SharePoint

Links to this post

Trackback from Blog on 12 Apr 2008 08:58

Name

Url

Email

Comments

CAPTCHA Image Validation