Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MSSQL SHAREPOINT, basic question...

Posted on 2008-10-27
3
Medium Priority
?
459 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 2000 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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

577 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