+ Post New Thread
Page 3 of 3 FirstFirst 123
Results 31 to 42 of 42
MIS Systems Thread, New SIMS install not letting users log on in Technical; I had this problem the other day with a 64bit Windows 2008 server. It turned out to be the Windows ...
  1. #31
    John_Howarth's Avatar
    Join Date
    Aug 2008
    Location
    Atherton
    Posts
    42
    Thank Post
    9
    Thanked 5 Times in 5 Posts
    Rep Power
    12
    I had this problem the other day with a 64bit Windows 2008 server.

    It turned out to be the Windows Firewall on the server. The school's genius tech added an exception for port 1433 (SQL default, apparently) and it worked after that.

    He also did the NamedPipes thingy (can you tell I'm not a technician?!).

    I'll email him a link to this thread to see if he has any other suggestions.

  2. #32
    Number6's Avatar
    Join Date
    Feb 2009
    Location
    Worcester, UK
    Posts
    457
    Thank Post
    2
    Thanked 9 Times in 8 Posts
    Rep Power
    12
    Quote Originally Posted by Mcshammer_dj View Post
    is firewall on by default on server 2008
    Quote Originally Posted by Number6 View Post
    This could be the post of the century!!!

    I don't know but I'm going to check right now! Why didn't I think of that?

    Thanks
    It was the post of the century!! It was on, it's not now and it works!

    May the blessings of a thousand virgins be showered upon you!!

    I originally turned it off but forgot that I reinstalled the server and didn't recheck. Things like this make me feel like a right pillock.

    A thousand thanks.

  3. #33
    mrtechsystems's Avatar
    Join Date
    Jun 2005
    Location
    Yorkshire
    Posts
    423
    Thank Post
    93
    Thanked 21 Times in 21 Posts
    Rep Power
    23
    Well at the end of the day that is IT for you at least you learn something from it...

  4. #34

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    Quote Originally Posted by matt40k View Post
    Few thoughs:

    Check sims.ini, make sure setups is point to the new servers setups
    Make sure the user has access rights to the s drive (sims share)
    Make sure the firewall is opened up. (MSSQL,HTTP:8080(DMS),File sharing)
    If you installed MSSQL 2005 standard\enterprise, enable TCP\IP
    Checking the connect.ini (c:\program files\sims\sims .net\connect.ini)

    *Cough*

  5. #35
    Number6's Avatar
    Join Date
    Feb 2009
    Location
    Worcester, UK
    Posts
    457
    Thank Post
    2
    Thanked 9 Times in 8 Posts
    Rep Power
    12
    Interestingly, the firewall is configured exactly the same on both servers and SQL is named as an exception on both. Obviously on the new server SQL is using different ports so I'll have to track that down now.

  6. #36
    Number6's Avatar
    Join Date
    Feb 2009
    Location
    Worcester, UK
    Posts
    457
    Thank Post
    2
    Thanked 9 Times in 8 Posts
    Rep Power
    12
    Quote Originally Posted by matt40k View Post
    *Cough*
    Shut up!!!


  7. #37
    Number6's Avatar
    Join Date
    Feb 2009
    Location
    Worcester, UK
    Posts
    457
    Thank Post
    2
    Thanked 9 Times in 8 Posts
    Rep Power
    12
    Quote Originally Posted by matt40k View Post
    *Cough*
    It is actually configured with SQL as an exception but it's not working. I've had to turn the firewall off completely for the time being.

  8. #38
    John_Howarth's Avatar
    Join Date
    Aug 2008
    Location
    Atherton
    Posts
    42
    Thank Post
    9
    Thanked 5 Times in 5 Posts
    Rep Power
    12
    Taken from Capita's SupportNet (KB72234):

    If your Named Instance is called 'SIMS' and is installed on the D:\ drive

    D:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG.

    (Please note the above file has no extension, but can be opened in Notepad.)


    Look for a line ending in the following: -

    SQL server listening on 127.0.0.1: xxxx

    xxxx is the port which your installation of MS SQL Server is attempting to listen on, and this is the port which you need your Firewall to be aware of.

    Hope this helps.

  9. #39
    Number6's Avatar
    Join Date
    Feb 2009
    Location
    Worcester, UK
    Posts
    457
    Thank Post
    2
    Thanked 9 Times in 8 Posts
    Rep Power
    12
    Quote Originally Posted by John_Howarth View Post
    Taken from Capita's SupportNet (KB72234):

    If your Named Instance is called 'SIMS' and is installed on the D:\ drive

    D:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG.

    (Please note the above file has no extension, but can be opened in Notepad.)


    Look for a line ending in the following: -

    SQL server listening on 127.0.0.1: xxxx

    xxxx is the port which your installation of MS SQL Server is attempting to listen on, and this is the port which you need your Firewall to be aware of.

    Hope this helps.
    Yes, I checked the log earlier, it says port 49193 but opening that through the firewall makes no difference, it still errors.

  10. #40
    John_Howarth's Avatar
    Join Date
    Aug 2008
    Location
    Atherton
    Posts
    42
    Thank Post
    9
    Thanked 5 Times in 5 Posts
    Rep Power
    12
    My technical colleague at the school I was working at earlier this week sent me the following message:

    Number6 is right. I did create the firewall exception that you mentioned, but that alone wasn’t sufficient so I turned the firewall off completely pending investigation of other port usage (I apologise for not making that clearer on Tuesday).

    At some point next week I want to sit down with TCPView and figure out exactly what SIMS clients are making use of. It’s possible that they’re using randomly-assigned high-range ports, in which case you’d have to create firewall rules on the server that allowed SQL and any other SIMS server-side binaries to accept connections on any port.

    I’ll let you know what I find out.

    I'll post here again with any further information that comes my way.

  11. #41
    Number6's Avatar
    Join Date
    Feb 2009
    Location
    Worcester, UK
    Posts
    457
    Thank Post
    2
    Thanked 9 Times in 8 Posts
    Rep Power
    12
    Quote Originally Posted by John_Howarth View Post
    My technical colleague at the school I was working at earlier this week sent me the following message:

    Number6 is right. I did create the firewall exception that you mentioned, but that alone wasn’t sufficient so I turned the firewall off completely pending investigation of other port usage (I apologise for not making that clearer on Tuesday).

    At some point next week I want to sit down with TCPView and figure out exactly what SIMS clients are making use of. It’s possible that they’re using randomly-assigned high-range ports, in which case you’d have to create firewall rules on the server that allowed SQL and any other SIMS server-side binaries to accept connections on any port.

    I’ll let you know what I find out.

    I'll post here again with any further information that comes my way.
    Thanks for that.

    I'm away now for two weeks but I'll be interested to see what crops up here.

  12. #42

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    I know it's an old thread but for the sake of posterity in case it helps anyone, as i've spent ages on it here is what worked for me:
    Windows Server 2008 R2, with SQL 2008 R2:

    Allowed 2 inbound rules through the firewall, specifically for application, rather than any particular port and all works fine:

    %ProgramFiles%\Microsoft SQL Server\MSSQL10_50.SIMS2008\MSSQL\Binn\sqlservr.exe

    and

    %ProgramFiles% (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe

    The first one isn't needed for SIMS to work, but i haven't fully tested to see if everything works yet without it.

SHARE:
+ Post New Thread
Page 3 of 3 FirstFirst 123

Similar Threads

  1. Log users logging on to a laptop?
    By ICT_GUY in forum Windows Vista
    Replies: 1
    Last Post: 20th November 2009, 10:12 AM
  2. Can't log off SIMS users
    By timzim in forum MIS Systems
    Replies: 5
    Last Post: 13th November 2009, 08:35 AM
  3. Edugeek Joomla cant log in after install.
    By jamin100 in forum EduGeek Joomla 1.0 Package
    Replies: 8
    Last Post: 11th March 2008, 03:53 PM
  4. Staff laptops: Letting 'em install network software
    By eean in forum How do you do....it?
    Replies: 3
    Last Post: 13th September 2006, 08:08 PM
  5. Only allow certain users to log on to a machine?
    By wesleyw in forum How do you do....it?
    Replies: 7
    Last Post: 16th January 2006, 11:38 PM

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
  •