How to set up SQL for Ad Manager

From Dot2DotCommunications
Revision as of 16:28, 4 September 2014 by John.devonshire (Talk | contribs)

Jump to: navigation, search

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

SQL Step 1.png

Once you are in SQL Server Configuration Manager, go to SQL Server Network Configuration and highlight Protocols for SQL Express

SQL Step 2.png

Right click on TCP/IP and select Properties

SQL Step 3.png

Make sure that Enabled = Yes. If it does not, change it.

SQL Step 4.png

Click Apply. You will be told to restart the service.

Step Confirm.PNG

Right click on Named Pipes and select Properties.

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.

Step Confirm.PNG

Go to SQL Server Services in the left pane.

Step 7.PNG

Right click on SQLServer (it may say SQL Server (SQL Express) depending on your version of SQL. Click Restart.

Step 8.PNG

If SQL Server Browser is Stopped, right click on it and select Start.

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)

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)

Retrieved from "http://wiki.d2dcm.com/index.php?title=How_to_set_up_SQL_for_Ad_Manager&oldid=2220"