+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 27
MIS Systems Thread, set up a new sims server in Technical; Hello everyone. im new here im just wondering if you could help. been thrown in at the deep end a ...
  1. #1

    Join Date
    Sep 2009
    Posts
    12
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    set up a new sims server

    Hello everyone. im new here im just wondering if you could help.

    been thrown in at the deep end a bit in seetting up a new SIMS server never had a previous one.

    server 2003 Standard Edition
    i ran CCSSQLExpressInst.exe to install the SQL on the server installing a new SQL Instance to host SIMS. then once all had finished i then ran SIMSINST.exe and chose the option for SIMS SQL Server and SIMS Document Server changed all the options that were applicable to us in the Settings tab and then installed. it installed the database called NewSimsDatabase.mdf into D:/Program Files/.../Data and called itself SIMS.

    once that setup was complete i checked to make sure the SQL server services were all running and checked the settings were allowing TCP/IP AND Named Pipes and turned off the windows firewall on the server.

    then worked on the workstation and installed SIMS Workstation. had mappings to S:/ and also turned off windows firewall and installed the SQL Server Studio on the workstation to make sure i could connect to the server. through there using username SA i could connect to the server and under the databases was our database, SIMS.

    once all workstation software was setup i tried to login to SIMS using the username Sysman and the password password. i got both errors as Reason0 and incorrect username/password.
    the local connect.ini file redirects to the S:/SIMS/Connect.ini and this is all fine.

    i browsed the database using the SQL Server studio and found the username for sysman and the password is password but still wouldnt let me login

    sorry for the lenghty detail but just thinking someone might be able to point us in the right direction if we are going slightly wrong in the setup procedures.

    Many Thanks in advance!!

  2. #2
    John_Howarth's Avatar
    Join Date
    Aug 2008
    Location
    Atherton
    Posts
    42
    Thank Post
    9
    Thanked 5 Times in 5 Posts
    Rep Power
    13
    Hi there and welcome!

    When you say you're setting up a new SIMS server, is your establishment about to start using SIMS or do you have an existing SIMS database to attach to the newly created SQL instance?

    If it's the latter, you don't need to connect to the "blank" database at all. The next step would be to attach the school's existing database.

    Apologies if I've got the wrong end of the stick; I should really be in bed at this hour!

  3. #3

    Join Date
    Sep 2009
    Posts
    12
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    have got no existing sims installations. it is a new sims server and database. was explaining my processes of installation just incase i was going wrong somewhere

  4. #4
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    You sound like you have done all the right things.

    If it can give you a username/password error it souns like it is connecting.

    Can a ping resolve the Name (not IP) of the Server.

    Is the SQL Server Browser Service running on the Server?

    Is there more than one instance of SQL Server on the Server somehow and you are trying to connect to the wrong one?

    Can you run the SIMS module up successfully on the Server itself?

  5. #5

    Join Date
    Sep 2009
    Posts
    12
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    yes ping ok. browser service running. no other module of SQL.

    SIMS Workstation isnt installed on the server itself. should it be installed and check that way??

    Thanks

  6. #6
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    I'd install it on the Server for the following reasons:

    Helps with troubleshooting - if you can connect on the Server it will most likely be a network/firewall issue that's been overlooked and giving you this problem.

    Good for upgrades - if SIMS Workstation is installed on the Server and you have agreed downtime to do your SIMS upgrades (not always possible) it makes it easy to check that the upgrade has worked successfully before deploying it to clients. If you have a problem you can rollback quickly.

    Are your workstations up to date with .net framework?

    [EDIT]

    Also make sure CLR is enabled in the SQL Server management Studio - can't remember the exact route for this though.

    Once this is enabled restart the SQL Server Service and (possibly) re-run SIMSInfrastructureSetup.exe
    Last edited by superfletch; 18th September 2009 at 10:07 AM. Reason: Add more gumf

  7. #7

    Join Date
    Sep 2009
    Posts
    12
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    have installed workstation on server. still getting incorrect username/password.
    the .net framework is all fine on the workstations
    could you point in a way to enabling CLR in management studio?

    Thanks
    Last edited by priestm; 18th September 2009 at 12:11 PM. Reason: added more

  8. #8
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,024
    Thank Post
    803
    Thanked 346 Times in 270 Posts
    Blog Entries
    60
    Rep Power
    278
    Sounding picky but you have to be with SIMS.

    I noticed you typed S:/SIMS/Connect.ini but the slashes should be a backslash. Have you checked these?

    Also try this in your connect.ini on the local computer:

    Code:
    [SIMSConnection]
    Redirect=S:\sims
    Note that there is no connect.ini on the end of the path.

  9. #9
    ravens's Avatar
    Join Date
    Oct 2007
    Location
    Barnet
    Posts
    39
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    There a few things Capita want you to try if you get this error.

    Below is the link, good luck.

    Hot Topics

    Also you could try entering the details in the connect.ini rather than the redirection, using the ip address in case the name of the server cannot be resolved, for example:

    [SIMSConnection]
    ServerName=IP ADDRESS\sims
    DatabaseName=SIMS
    ServerType=SIMSSQL
    Commandtimeout=10000

    and see if that works
    Last edited by ravens; 18th September 2009 at 01:31 PM. Reason: Addtional thought

  10. #10

    Join Date
    Sep 2009
    Posts
    12
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    have changed all connect.ini info to what ravens said. also enabled CLR in management studio.
    i have browsed through the tables in the SIMS database and found under "sims.db_user" 2 users as DataExportsUser and sysman.
    is there any way in the management studio to create a user that has administrator rights? is it in the same table as these users.
    Thanks

  11. #11
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    Seeing you used the CCSSQLExpress installer I don't think this should be an issue, I'll say it anyway though... could it be the authentication type (ie using Trusted instead of SQL based authentication).

    Old fixes are the best - have you detached and re-attached the SIMS database using SIMS DBAttach and logging in using your SQL Server SA user account?

  12. #12

    Join Date
    Aug 2008
    Posts
    40
    Thank Post
    0
    Thanked 7 Times in 7 Posts
    Rep Power
    13
    When you attached the database, what configuration did you select?

  13. #13

    Join Date
    Sep 2009
    Posts
    12
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    i think it was SQL Authentication. i wouldnt use trusted authentication because i dont think its that secure. have detached and attached but still no login

  14. #14

    Join Date
    Aug 2008
    Posts
    40
    Thank Post
    0
    Thanked 7 Times in 7 Posts
    Rep Power
    13
    Quote Originally Posted by priestm View Post
    i think it was SQL Authentication. i wouldnt use trusted authentication because i dont think its that secure. have detached and attached but still no login
    which phase configuration did you select when you configured the blank database? If you install a blank database it needs to be configured. For example, the sector, region and suchlike.

  15. #15

    Join Date
    Sep 2009
    Posts
    12
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    i dont recall it asking that. im going to uninstall all sims apps and SQL off the server and retry installing again and see what happens. will let you know if i get anywere.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 12
    Last Post: 18th August 2009, 09:09 AM
  2. Server re-set during SIMS (December) update.
    By Stuart_C in forum MIS Systems
    Replies: 14
    Last Post: 26th January 2009, 09:29 AM
  3. Replies: 1
    Last Post: 17th April 2008, 04:44 PM
  4. Best raid set up for Exchange server
    By Kyle in forum Windows
    Replies: 11
    Last Post: 7th January 2008, 02:50 PM
  5. Opinions of Raid set up for new server.
    By tosca925 in forum Windows
    Replies: 10
    Last Post: 31st January 2007, 10:15 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
  •