moving from MSDE to SQL - no connection to databases

moving from MSDE to SQL - no connection to databases

Post by Sergey Yat » Sun, 19 Oct 2003 00:03:02


Hello all! I have got a problem with Sharepoint SErvices
on MSDE. I am running out of space in my MSDE, so I
decided to switch to MSSQL 2000. The point is that
although I attached EXISTENT databases (content and
config) to MSSQL (with SP 3 installed), Sharepoint cannot
access these databases. I would really appreciate any
suggestions on this issue. Thanks a ton.
 
 
 

1. MSDE Database move to a new Server - any SQL guru's out there?

2. MSDE SHAREPOINT, MSDE SBSMONITORING, MSDE LIVECOMMUNICATIONS, SQL NORTHWIND --> 1

There have been many posts about upgrading MSDE instances to SQL and so on,
but they all seem to result in having multiple instances of the SQL server
process running. Is there a way to cleanly, organise all the databases in
such a way that there is only ONE SQL server process running that serves all
the tables required?

i.e. A default install on SBS2003 premium with LiveCommunicationsServer
would result in the following separate instances:
1. MSDE SHAREPOINT
2. MSDE SBSMONITORING
3. MSDE LIVECOMMUNICATIONS
4. SQL DEFAULT

Assuming there is no live data that needs to be backed up or moved over, how
could one merge all these into a single SQL instance, or set this up fresh
in this way?

The purpose of this is to use memory more efficiently, and make applying SQL
patches easier as there's only 1 instance, not 4.

3. Sql Mobile (sql ce3.0) connection to MSDE 2000 using RDA or Merge Replication

4. Transferring Data from MSDE Database to SQL 2000 Database

5. SQL 7 Server: Moving One Database from One SQL Server to a Second SQL Server

6. MSDE 1.0 --> MSDE 2000 DB Connection Failure

7. Problems moving MSDE database

8. Using MSDE and moving databases

9. Moving MSDE Database store

10. Sharepoint Database Move from MSDE to SQLServer - HELP

11. MSDE - moving a copy of a database and reloading onto another PC

12. Moving Sharepoint 3.0 MSDE database files

13. MSDE & database moving.

14. Move around MSDE Log Databases

15. SPS V2 - Moving the MSDE Database from the C drive to a larger drive