+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Configure SQL 2000 surface area browsing in Technical; Hi we have a resource scheduler management system provided by peoplecuble (formerly meeting maker). Everything is running fine and we ...
  1. #1
    ben_snclc's Avatar
    Join Date
    Nov 2009
    Location
    South Yorkshire
    Posts
    34
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Configure SQL 2000 surface area browsing

    Hi we have a resource scheduler management system provided by peoplecuble (formerly meeting maker). Everything is running fine and we have this on a virtual server running SQL 2000. We want to run off reports from the underlying database. I'm OK with this but can't connect through to the server using standard ODBC links from Access because of SQL Surface Browsing isn't enabled. Does anyone know how to get this working? I don't want to upgrade to server express 2005 if possible.

    Thanks,

  2. #2
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30
    God only knows... but you do know SQL2000 is no longer supported? What's holding you back from upgrading?

  3. #3

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,991
    Thank Post
    851
    Thanked 2,653 Times in 2,253 Posts
    Blog Entries
    9
    Rep Power
    764
    Can you not install the SQL 2005 or 2008 express environment on the server also and then use the "SQL Server Configuration Manager" tool to manage your 2000 server and configure it that way. Not the most direct way but probably the easiest, you will need to enable TCP/IP and make sure that the "SQL Server Browser" service is running I think.

    You may just be able to install the management tools from the later versions too which would be even better.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 6
    Last Post: 2nd October 2009, 12:21 PM
  2. Restoring a SQL 2000 Database
    By Neville in forum Windows
    Replies: 0
    Last Post: 12th March 2009, 09:09 AM
  3. What Corrupted an MS SQL 2000 Table ?
    By Richard_Finnigan in forum MIS Systems
    Replies: 8
    Last Post: 26th February 2009, 10:01 PM
  4. SQL Server 2000/2005
    By techie08 in forum Windows Server 2000/2003
    Replies: 6
    Last Post: 12th February 2009, 11:06 PM
  5. Serco Withdraw Support for SQL 2000
    By Tallwood_6 in forum MIS Systems
    Replies: 6
    Last Post: 7th July 2008, 09:26 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
  •