SharePoint Project Series.

This is a series of blogs I am writing on SharePoint projects:

Part 1 - Design and Planning Part 2 - Implementation (Stage 1) Part 3 - Implementation (Stage 2)
Part 4 - Training Part 5 - Continued Support Part 6 - Suggested Continued Improvement

Thursday, October 23, 2008

SharePoint Windows Internal Database

A lot of the time when clients cannot afford SQL 2005 standard, SharePoint usually gets installed as a single server farm with an Windows Internal Database. The windows internal database is actually a version of SQL 2005 Express edition. It is actually preferable to use this internal database over a copy of SQL 2005 Express edition because you are not limited to 4gb with the internal database, as you would be if you used an external SQL 2005 Express instance.

Always keep in mind that you can connect to the Internal database using SQL Management studio express found here:

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

When you download this you can connect to windows internal database by using the following server name:

\\.\pipe\mssql$micrsoft##ssee\sql\query

This will enable you to see the databases used inside the windows internal database. This is exactly the same as if you were using a standard version of SQL.

Enjoy!

No comments: