Solved

How to identify which SQL Server DB is used by WSS 3.0 or SharePoint 2007 ?

Posted on 2014-01-01
6
541 Views
Last Modified: 2014-01-12
Hi Folks,

Where can I identify which SQL Server is used by the WSS 3.0 or SharePoint Server 2007 ?

at the moment I'm about to delete the SQL Server 2005 Express Edition DB directory but not sure if it is being used by the current WSS 3.0 or not to store all of my Document Library items.
0
Comment
  • 3
  • 2
6 Comments
 
LVL 13

Expert Comment

by:Abhilash
ID: 39749745
0
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 39750381
Thanks for the reply, but somehow I still cannot determine which is the correct SQL Server database that is in used by my WSS 3.0

There are multiple DB server in the SharePoint CA site and I'm not sure which one that is still in use.
0
 
LVL 13

Assisted Solution

by:Abhilash
Abhilash earned 250 total points
ID: 39750596
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 39750776
So does in this case WSS 3.0 have SSP database as well ?
0
 
LVL 6

Accepted Solution

by:
Harish Kumar earned 250 total points
ID: 39750850
In central admin -> servers in farm -> This will have the config db name and the server it resides on.

In the application management page you'll have the default DB server. Mostly all your content DB's are going to be there.

NO WSS 3.0 does not have SSP, unless you have project server or biztalk server installed.

Regards,
Harish Kumar
0
 
LVL 7

Author Closing Comment

by:Senior IT System Engineer
ID: 39775740
Thanks people !
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

773 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