Logo Home   Documents & Lists   Site Settings   Help   
Icon
SharePoint Support
Advanced Technical Help: Accessing SharePoint Services databese stored...
   
Post Reply Post Reply
|
Edit Edit Message
|
Delete Delete Message
|
Alert Me
|
Go Back to Discussion Board
From:
Posted At: 7/3/2003 7:05 PM
Subject:
Accessing SharePoint Services databese stored in MSDE
Text:
This is due to the fact that MSDE installed an instance of SQL Server, rather than the default instance. additional instances of SQL Server are installed as YOURSERVERNAME\INSTANCENAME. SPSv2 installs it as YOURSERVERNAME\SHAREPOINT.
 
to verify, go to Administrative Tools->Services, and locate the running SQL Server instance.
 
To connect to an instance of sql server via osql or Ent. Mgr., establish the connection as SERVERNAME\INSTANCENAME, for example, if your server name is MYSERVER01 and the instance name is SHAREPOINT, enter MYSERVER01\SHAREPOINT into Ent. Mgr. server registration window.
 
cheers
Attachments:
 
 
Created at 7/3/2003 7:05 PM by
Last modified at 7/3/2003 7:05 PM by