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.
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?
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 11:07 AM.
Reason: Add more gumf
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.
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?