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

Hi, When you launch SQL Server Management Studio (SSMS), you are prompted for a server to connect to. In this box, you wound type: Servername\sqlexpress Where servername is the computer you install SQL to. (since you mentioned it was SQL Express you installed) If you are on the same server, you could have easily typed in: .\sqlexpress (that is a period backslash then sqlexpress) To set the authentication mode to mixed mode (supporting both SQL Authentication and Windows Authentication), right click on the server name and select properties. On the left side of this property sheet there is a few choices. Chose Security and tab to a radio button for Mix mode authentication. Then, ok out of the dialog box. To set the SA password, back to the object view where you saw the computer name; this is a tree view. Expand the computer name, arrow down to security and expand it, then arrow down to login and expand it; then arrow down to SA and get properties on this account. You can set the password in this dialog. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Barry Toner Sent: Monday, November 05, 2012 6:57 AM To: blind-sysadmins@lists.hodgsonfamily.org Subject: [Blind-sysadmins] SQL Server 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

Hi, Further to what has been advised already, during the SQL Express install, there is an option to show advanced features, if you choose this option you can set the authentication mode to mixed (it is Windows only by default), and if you choose mixed you can set the SA account password during the installation. Andrew. -----Original Message----- From: Blind-sysadmins [mailto:blind-sysadmins-bounces@lists.hodgsonfamily.org] On Behalf Of Barry Toner Sent: 05 November 2012 11:57 To: blind-sysadmins@lists.hodgsonfamily.org Subject: [Blind-sysadmins] SQL Server 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