how can i access my local SQL DB 2005 instance ??

Hi Experts,
i installed microsoft office sharepoint 2007 on my server and it created a database instance : "TEINTRANET01\Microsoft##SSEE" . i can see this name whenever i want to create a new web site i get this database name and in installing everything works fine. but the problem is that when i want to access this database from SQL Management studio installed on the same server it doesn't work !!! i can't access it and i get the error : "cannot connect to Microsoft##SSEE" !!! why this is happening ?? and is there any problem with the  ## characters ??

Thanks alot,
ebusinessAsked:
Who is Participating?
 
zephyr_hex (Megan)Connect With a Mentor DeveloperCommented:
if you want to manage your sharepoint database outside of sharepoint, you need to do a custom installation of sharepoint and choose a currently installed sql instance.

if you want to move your currently installed sharepoint over to a managed sql database, use stsadm to back up your content, completely uninstall sharepoint, reinstall sharepoint using the custom option so you can specify your databases.  once sharepoint has been completely reinstalled, restore your content using stsadm restore.

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1144
0
 
ptjcbCommented:
Yes, you should not use the ## characters in a database name.

Try
TEINTRANET01\[Microsoft##SSEE]
0
 
ebusinessAuthor Commented:
it is not working ...  and the this naming for the database is made by the sharepoint installation so i don't think this naming is wrong but maybe the ## resembles another character  or dunno what !!

anyway thanks for your help and lets see other comments about this prob
0
 
ptjcbCommented:
You are right. I checked another site - Sharepoint uses the SQL Server Embedded edition.

FROM http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=949426&SiteID=1

Now with this instance installed, i tried opening this instance (instance name being Microsoft#SSEE) through SQL Server Management Studio, i get the following error

 "TITLE: Connect to Server
------------------------------

Cannot connect to BANAPPS01\MICROSOFT##SSEE.

The reply



Hi,

This is an embedded data service that can only be used by a handful of Windows Services. It is the designed behavior that you are not allowed to connect to and use this particular database service.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.