Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: Cannot get into SQL Server. Help please!

    I accidently changed the maximum connections from 0 (unlimited) to 10 and rebooted my server. now I can't connect to it! is there anyway to change that connection number without being able to connect to the server via EM?

    Running MSSQL7 on Windows NT4 SP6.

    Thanks for any advice!!

    Joshua Gregory

  2. #2
    Join Date
    Oct 2003
    Location
    Ireland
    Posts
    54
    Not that I'm aware off. Perhaps during an off peak time or non-production period you'll be able to login ?

  3. #3
    Join Date
    Nov 2003
    Posts
    2
    Thanks for the help. I unplugged the NIC and rebooted. Then I went into EM and changed the setting back.

    Can anyone point me to a good information source for using the sp_configure command? I read lots of info about this command, but when I tried to type it in a DOS command prompt it said unknown command.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    If you want to run sql outside of sql you need to place the code in a file (*.sql), whatever, and execute using isql or osql from a command line...

    syntax is in bol
    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.

Posting Permissions

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