How to set up SQL for Ad Manager - Revision history

John.devonshire at 13:00, 6 March 2015

2015-03-06T13:00:58Z

John.devonshire at 12:21, 5 March 2015

2015-03-05T12:21:30Z

John.devonshire at 20:34, 4 September 2014

2014-09-04T20:34:48Z

John.devonshire at 20:28, 4 September 2014

2014-09-04T20:28:22Z

John.devonshire at 20:00, 4 September 2014

2014-09-04T20:00:43Z

John.devonshire: Created page with "There are many different versions of SQL available. This guide will assist with users that have SQL 2008 R2. Many of the steps will be identical in other versions, although ..."

2014-09-04T19:57:45Z

Created page with "There are many different versions of SQL available. This guide will assist with users that have SQL 2008 R2. Many of the steps will be identical in other versions, although ..."

New page

There are many different versions of SQL available. This guide will assist with users that have SQL 2008 R2. Many of the steps will be identical in other versions, although the location of the various items may differ.

← Older revision		Revision as of 13:00, 6 March 2015
Line 81:		Line 81:
	If you are not sure of the name of the server, or would prefer to use the IP Address of the server, you can enter the IP address of the server (e.g. 128.128.128.1) when logging in to Ad Manager (if you have SQL Express on the server, then use the IP address of the server, followed by \SQLExpress (e.g. 128.128.128.1\SQLExpress)		If you are not sure of the name of the server, or would prefer to use the IP Address of the server, you can enter the IP address of the server (e.g. 128.128.128.1) when logging in to Ad Manager (if you have SQL Express on the server, then use the IP address of the server, followed by \SQLExpress (e.g. 128.128.128.1\SQLExpress)

−	<b>If you are running SQL in a Hyper-V virtualized environment with a Broadcom network adapter, please see [http://support.microsoft.com/kb/2902166\| this Microsoft article] to address performance related issues</b>	+	<b>If you are running SQL in a Hyper-V virtualized environment with a Broadcom network adapter, please see [http://support.microsoft.com/kb/2902166 \| this Microsoft article] to address performance related issues</b>

← Older revision		Revision as of 12:21, 5 March 2015
Line 80:		Line 80:

	If you are not sure of the name of the server, or would prefer to use the IP Address of the server, you can enter the IP address of the server (e.g. 128.128.128.1) when logging in to Ad Manager (if you have SQL Express on the server, then use the IP address of the server, followed by \SQLExpress (e.g. 128.128.128.1\SQLExpress)		If you are not sure of the name of the server, or would prefer to use the IP Address of the server, you can enter the IP address of the server (e.g. 128.128.128.1) when logging in to Ad Manager (if you have SQL Express on the server, then use the IP address of the server, followed by \SQLExpress (e.g. 128.128.128.1\SQLExpress)
		+
		+	<b>If you are running SQL in a Hyper-V virtualized environment with a Broadcom network adapter, please see [http://support.microsoft.com/kb/2902166\| this Microsoft article] to address performance related issues</b>

@@ Line 4: / Line 4: @@
 [[File:SQL Step 1.png]]
 Once you are in SQL Server Configuration Manager, go to SQL Server Network Configuration and highlight Protocols for SQL Express
 [[File:SQL Step 2.png]]
 Right click on TCP/IP and select Properties
 [[File:SQL Step 3.png]]
 Make sure that Enabled = Yes.  If it does not, change it.
 [[File:SQL Step 4.png]]
 Click Apply.  You will be told to restart the service.
 [[File:Step Confirm.PNG]]
 Right click on Named Pipes and select Properties.
 [[File:SQL Step 5.png]]
 Make sure that Enabled=Yes. If it does not, change it.
-Step 6.PNG
+[[File:Step 6.PNG]]
 Click Apply.  You will be told to restart the service.
 [[File:Step Confirm.PNG]]
 Go to SQL Server Services in the left pane.
 [[File:Step 7.PNG]]
 Right click on SQLServer (it may say SQL Server (SQL Express) depending on your version of SQL.  Click Restart.
 [[File:Step 8.PNG]]
 If SQL Server Browser is Stopped, right click on it and select Start.
 [[File:Step 9.PNG]]
 At this point, you can close SQL Server Configuration Manager.

← Older revision		Revision as of 20:28, 4 September 2014
Line 1:		Line 1:
	There are many different versions of SQL available. This guide will assist with users that have SQL 2008 R2. Many of the steps will be identical in other versions, although the location of the various items may differ.		There are many different versions of SQL available. This guide will assist with users that have SQL 2008 R2. Many of the steps will be identical in other versions, although the location of the various items may differ.
		+
		+	First, go to SQL Server Configuration Manager

	[[File:SQL Step 1.png]]		[[File:SQL Step 1.png]]
		+
		+	Once you are in SQL Server Configuration Manager, go to SQL Server Network Configuration and highlight Protocols for SQL Express
		+
		+	[[File:SQL Step 2.png]]
		+
		+	Right click on TCP/IP and select Properties
		+
		+	[[File:SQL Step 3.png]]
		+
		+	Make sure that Enabled = Yes. If it does not, change it.
		+
		+	[[File:SQL Step 4.png]]
		+
		+	Click Apply. You will be told to restart the service.
		+
		+	[[File:Step Confirm.PNG]]
		+
		+	Right click on Named Pipes and select Properties.
		+
		+	[[File:SQL Step 5.png]]
		+
		+	Make sure that Enabled=Yes. If it does not, change it.
		+
		+	Step 6.PNG
		+
		+	Click Apply. You will be told to restart the service.
		+
		+	[[File:Step Confirm.PNG]]
		+
		+	Go to SQL Server Services in the left pane.
		+
		+	[[File:Step 7.PNG]]
		+
		+	Right click on SQLServer (it may say SQL Server (SQL Express) depending on your version of SQL. Click Restart.
		+
		+	[[File:Step 8.PNG]]
		+
		+	If SQL Server Browser is Stopped, right click on it and select Start.
		+
		+	[[File:Step 9.PNG]]
		+
		+	At this point, you can close SQL Server Configuration Manager.
		+
		+	If the SQL Server database is on the same machine that Ad Manager is installed on, the server name to use when logging into Ad Manager is localhost (if you have SQL) or localhost\SQLExpress (if you have SQL Express).
		+
		+	If the SQL Server database is on a different machine than Ad Manager, the server name to use when logging into Ad Manager will be the name of the server (this can be found by right clicking My Computer and selecting Properties, then going to the Computer Name tab and checking the Full computer name (e.g. JD-AM-570)
		+
		+	[[File:Step10.PNG]]
		+
		+	If the machine is running SQL Express instead of SQL, then use the name of the server, followed by \SQLExpress (e.g. JD-AM-570\SQLExpress).
		+
		+	If you are not sure of the name of the server, or would prefer to use the IP Address of the server, you can enter the IP address of the server (e.g. 128.128.128.1) when logging in to Ad Manager (if you have SQL Express on the server, then use the IP address of the server, followed by \SQLExpress (e.g. 128.128.128.1\SQLExpress)

← Older revision		Revision as of 20:00, 4 September 2014
Line 1:		Line 1:
	There are many different versions of SQL available. This guide will assist with users that have SQL 2008 R2. Many of the steps will be identical in other versions, although the location of the various items may differ.		There are many different versions of SQL available. This guide will assist with users that have SQL 2008 R2. Many of the steps will be identical in other versions, although the location of the various items may differ.
		+
		+	[[File:SQL Step 1.png]]