Solved

MSSQL SHAREPOINT, basic question...

Posted on 2008-10-27
3
453 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
ID: 22821235
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
ID: 22821416
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
ID: 22821461
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

911 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

22 Experts available now in Live!

Get 1:1 Help Now