Solved

MSSQL SHAREPOINT, basic question...

Posted on 2008-10-27
3
456 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
[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
  • 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

733 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