+ Post New Thread
Results 1 to 2 of 2
Windows Thread, Getting in a muddle with SQL Server in Technical; Im not a great master of SQL, I've installed MSDE and SQL Express and have apps using them but I ...
  1. #1

    Join Date
    Jul 2006
    Location
    London
    Posts
    2,963
    Thank Post
    160
    Thanked 153 Times in 117 Posts
    Rep Power
    49

    Getting in a muddle with SQL Server

    Im not a great master of SQL, I've installed MSDE and SQL Express and have apps using them but I dont know much so I could do with some help.

    Ive got a server with 2 apps needing SQL databases on. The apps are Policy Central Enterprise and Visual Audit.

    Originally, both ran on MSDE (if thats the proper name - the old free one anyway) but recently we had a big upgrade to Visual Audit which I think required me to install SQL Express 2005.

    I installed this, but as I wasnt too bothered about converting the DB or anything (since Visual Audit has an import tool) I just installed it alongside MSDE and created a new database.

    Now, however, I need to upgrade PCE as well, and that too needs SQL 2005. There are instructions on how to install it and keep your settings, but I cant do this because I already have 2005 installed.

    So somehow I need to convert the PCE database to 2005 and ideally remove MSDE to stop the confusion in the future. But Im getting confused on how to do this, not least because both the MSDE and 2005 service managers seem to see both databases.

    How do I go about this? Im sure its doable and probably quite easy, but Im getting a bit confused

  2. #2

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,297
    Thank Post
    242
    Thanked 1,586 Times in 1,263 Posts
    Rep Power
    344
    I believe the SQL 2000 and SQL 2005 Service Managers are started from shortcuts within the Startup folder. Once you have SQL 2005 Service Manager installed, it should be safe to delete the SQL 2000 Service Manager shortcut, logoff, then log back on.



SHARE:
+ Post New Thread

Similar Threads

  1. VBScript / SQL Server
    By Gatt in forum Scripts
    Replies: 7
    Last Post: 23rd September 2011, 04:21 PM
  2. Virtualising SQL Server
    By robknowles in forum Network and Classroom Management
    Replies: 13
    Last Post: 29th August 2009, 09:16 AM
  3. SQL Server pricing?
    By pete in forum Windows
    Replies: 9
    Last Post: 21st July 2006, 07:19 AM
  4. SQL Server
    By wesleyw in forum Windows
    Replies: 5
    Last Post: 28th June 2006, 09:42 AM
  5. sql server
    By chrbb in forum Windows
    Replies: 17
    Last Post: 19th January 2006, 12:23 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •