SQL server and Windows authentication is basically mixed mode if both are required. The server name is what ever host you have installed this onto. If your accessing it from the same host then your right, then it's localhost. SA could stand for service account. Basically the account that will be used to access the database. Regards Darragh Ó Héiligh Fujitsu Offices of the Houses of the Oireachtas, Fredrick Building, South Fredrick Street, Dublin2 Telephone: +353 (1) 618 3559 Email: darragh.oheiligh@oireachtas.ie Internet: http://www.oireachtas.ie From: "Barry Toner" <Barry.Toner@clanmil.org.uk> To: <blind-sysadmins@lists.hodgsonfamily.org>, Date: 05/11/2012 11:57 Subject: [Blind-sysadmins] SQL Server Sent by: "Blind-sysadmins" <blind-sysadmins-bounces@lists.hodgsonfamily.org> Hi folks, I've been tasked to setup a Helpdesk for our company. I'm going with nService, http://www.avensoft.com/ The DB uses SQL. Thing is I've no idea about SQL Servers. I've installed SQL Express by reading the nService RTM. OK, fine, it's installed, and according to the Management and Config it's running. The next few things I'm asked to do I'm confused about and can't find the options for this. Switch to SQL Server and Windows Authentication mode Enable the "sa" account and set a password Also I've no idea the name of the SQL Server to connect to it. Would this just be local or locahost? If it's any good I've IIS installed and running as well. Can someone please tell me how I do this so I can continue with the installation? Cheers, Barry. Barry Toner ICT Assistant ICT Department Clanmil Housing Northern Whig House 3 Waring Street Belfast BT1 2DX Tel: 02890 876000 Fax: 02890 876001 _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins Oireachtas email policy and disclaimer. http://www.oireachtas.ie/parliament/about/oireachtasemailpolicyanddisclaimer... Beartas ríomhphoist an Oireachtais agus séanadh. http://www.oireachtas.ie/parliament/ga/eolas/beartasriomhphoistanoireachtais...