Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: SQL Server Express

    I am very excited...Just finished the install on an XP client..

    So what would be the name of the server?

    The machine name?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    If it is the default instance, yes. If it is a named instance, you can get the name from the Services applet. With SQL 2005, though,, you are looking for the SQL Server service, instead of the MSSQLServer Service.

    If you want to connect remotely, you have to turn on the SQL Browser service. Just like the Oracle Listener.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What do you connect with?

    I'm looking at something called QARA
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    BooYah

    I'm IN baby

    QARA has to be on the local client..and it installed with the default instance as

    machinename\SQLEXPRESS

    Wonder how I missed that..
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I am able to use query analyzer with SQL Express, too. Like I said, you just have to start up the SQL Browser service to get it to work remotely. Sounds like a bit of fallout from the SQL Slammer virus.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What is the SQL Browser service?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The SQL Browser Service is basically the Port 1434 (and 1433 too) manager that now runs independantly. This allows you to set up a single system service (like MSDE) that isn't nearly as vulnerable to "drive by attacks" as previous versions.

    -PatP

Posting Permissions

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