priestm

shall be getting in touch with one of them then. Thanks very much everyone for all your help.

so when i set up SQL and it asks for an instance name and SIMS2005 is the default, i should change that to something else?

do apologise for my late reply. having time off work and so on. havent seen any errors of the kind in the logs. but can i ask what patch it is just incase i have missed it? im new to the job and the file structure was already on the server. im just guessing my predecessor was going to start then left. not to sure on that situation. i havent really been asked about a timeframe. is V1.21 of the SIMSINST.exe the right version? can i ask if that is the same one you use too?

sorry i never saw your previous post i closed the tinterweb. the version i am using of SIMSINST.exe is v1.21 dont have August 2008 CD.

installed again and it never asked me for any phases. instead of running CCSSQLExpress i ran simsinst.exe and installed Server that way but still no luck.

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.

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

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

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

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

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

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!!