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

Posted on 2007-10-10
Last Modified: 2008-03-10
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,
Question by:ebusiness
    LVL 27

    Expert Comment

    Yes, you should not use the ## characters in a database name.


    Author Comment

    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
    LVL 27

    Expert Comment

    You are right. I checked another site - Sharepoint uses the SQL Server Embedded edition.


    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


    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.

    LVL 42

    Accepted Solution

    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.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now