Tech Off Post

Single Post Permalink

View Thread: Trying to use SQL studio 2005 to script tables for SQL 2000
  • User profile image

    qwert231 wrote:
    Hmm.. and where would I do that? (Currently I'm running my app and this install of 2005 on my development machine.)

    Remember developer edition, and SQL Express disable remote connections by default. That includes connections using localhost.

    Run the Surface Area Configuration tool and choose to set the SAC for services and connections. Look at the Remote Connections property for the Database Engine of your instance