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!