MSSQL SHAREPOINT, basic question...

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!
LVL 1
webressursAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PedroCGDCommented:
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
webressursAuthor Commented:
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
PedroCGDCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.