Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2014-01-01
6
Medium Priority
?
591 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 13

Expert Comment

by:Abhilash
ID: 39749745
0
 
LVL 8

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 1000 total points
ID: 39750596
0
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 
LVL 8

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 1000 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 8

Author Closing Comment

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

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

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

These days socially coordinated efforts have turned into a critical requirement for enterprises.
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

722 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