Solved

MSSQL SHAREPOINT, basic question...

Posted on 2008-10-27
3
452 Views
Last Modified: 2012-05-05
I am updating from SBS 2003 to SBS 2003 R2 and have just installed SQL Server 2005. When running SQL Server Management Studio I see that my database engine is called "[Computername]\SHAREPOINT". When using the "old" version of SMS (with SQL 2000) the database engine was just called "[Computername]".

In the previous version (SQL 2000) the SQL data files was (by default) put here: C:\Program Files\Microsoft SQL Server\MSSQL\Data

In this new version (SQL 2005) there is no "MSSQL" directory, it is replaced with a "MSSQL$SHAREPOINT" directory so the path to the data files is like this: C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data

Is this correct? Will the change from "MSSQL" to "MSSQL$SHAREPOINT" have anything to say when connecting to a SQL database fron one of our ASP.NET websites?

As you understand I dont really know what sharepoint is, if someone please can tell me a little about this and the questions above I will be very thankful!
0
Comment
Question by:webressurs
  • 2
3 Comments
 
LVL 22

Expert Comment

by:PedroCGD
Comment Utility
Seems to be not problem.
In SQL 2005 you have this path:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

Sharepoint is a tool to create a website based on some templates to share documents, use as interface for BI applications, as interface for reports created with Reporting Services...

Sharepoint need a database to store all website configurations, and the place where you have the SQL datafiles should not be a problem!
Helped?
regards!
Pedro
0
 
LVL 1

Author Comment

by:webressurs
Comment Utility
Hi Pedro! So what you say is that there is no problem making other databases in SQL Server (under "[Computername\SHAREPOINT"), even if I dont neeed the sharepoint functionality? The connectionstring can refer to IP adress, Database name (example "MyDatabase") username and password like I'm used to do? And I can place the datafiles (MDF / LDF) where I want, for example under d:\Databases\MyDatabase\

Thanks for your help!!
0
 
LVL 22

Accepted Solution

by:
PedroCGD earned 500 total points
Comment Utility
When you install Sharepoint are created 2 databases Sharepoint_AdminContent and Sharepoint_Config.
The name Computername\Sharepoint  is the instance of SQL Server. You can create other databases inside this instace or create other instances of SQL Server.

Yes you can change the location of SQL Datafiles, but you need to stop the Services and if you have users connected, you will unable them to access databases.

Helped?
Regards
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

743 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

18 Experts available now in Live!

Get 1:1 Help Now