[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • Last Modified:

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,
0
ebusiness
Asked:
ebusiness
  • 2
1 Solution
 
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
 
zephyr_hex (Megan)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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now