SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Enthusiast xarzu's Avatar
    Join Date
    Apr 2007
    Posts
    72
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Just Testing To See if SQL Server Works

    Hello Forum.

    I have installed SQL Server 2008 on a network and it seems to be installed with no problem. I was sure to specify it as a Network Service account.

    But other programs that should be able to access the database are unable to connect.

    What steps should I go through to ensure that the database is up and running correctly?

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,627
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    First, check to see if it works locally (eg--you can connect using management studio, etc). Second, check the surface area configuration to make sure it can take external connections. Third, make sure the firewall isn't blocking it, TCP port 1433 should be punched through by default.

  3. #3
    SitePoint Enthusiast xarzu's Avatar
    Join Date
    Apr 2007
    Posts
    72
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I need to fix something that I see as being a problem. It appears I was installing the wrong version of SQL Server. I was installing the express version. I think there is also an issue with installing an x86 version on a x64 machine.

    So first things first. I need to completely uninstall what I have installed. Here is what I have done. I have stopped the sql services on my machine. Then I went through the uninstaller and uninstalled all the programs starting with SQL. Then I went into the programs directory and I renamed the MICROSOFT SQL SERVER directory.

    But when I restart the program, I still see one of the sql services still listed in the list.

    How do I get rid of that?

  4. #4
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,627
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Hmm, I think x86 should work just fine on an x64 machine--I think I've made the same mistake a few times.

    What service isn't getting uninstalled?


Bookmarks

Posting Permissions

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