We had a old access control server, and the access control application was installed on SQL 2005( windows 2003 Server).
Now I have built a new SQL server 2012 (Windows 2012) and we have migrated the database form old server to our new SQL 2012 server.
We have a client application which needs to be installed on the client PC and this will be the console to the access the new Access control server.
During the client installation (access control console) on a windows 7 PC, It defaults to C:\program files
On the next screen I get a "Define connection string" dialog box.
In this screen it says this screen will help you to define a database connection information.
I click the "define connection string"
I get a connection properties windows see the attached.
On the Server name if I drop down to select the new access control server, the new server is not listed. But I can see our old access control server and few other servers which is on our network. Do I need to give additional permissions on the new server- SQL database to list my new server here.
On this tab I will be using the SQL server authentication and select the database name.
Please suggest as how I will be able to list my new server , when I click the drop down menu. Any help to sort this much appreciated.