Click on the Windows Start Button, choose all programs.
Then click menus in following order…
1. Click on Microsoft SQL Server 2008 R2
2. Click on Configuration Tools
3. Click on SQL Server Configuration Manager
We need first to check that named instance Server and Browser Service that we setup during our installation are currently running from the SQL Server
Services node on the left side panel of the SQL Server Configuration Manager. If not we have start the service by Right Click Over the
SQL Server and
choose Start menu manually for the time being to Start our SQL Server and SQL Browser for the first time.
Then Click on the SQL Server Network Configuration and click on the Protocols for OCI2008R2 from the Left Panel of the Configuration
and verify the first three highlighted Protocols with red color box are Disabled by Default on the system from our Right Panel of the
Manager as we see above.
Right Click over the Protocol and choose Enable on the Shared Memory, Named Pipes and TCP/IP Protocols to enable it. While we click on the enable
menu system will prompt us…
Click OK to continue for all the three protocols as we discussed above.
After we enable all of them the Right Panel Window should look like the above one.
Finally click on the SQL Server Services Node from the left Panel of the Configuration Manager and Right Click over the SQL Server
at Right Panel and choose Restart.
Now the SQL Server Configuration Manager will stop the SQL Server Service.
After it stops the service will start it automatically again. Once this process finished we can verify the SQL Server starts Running. Now we can
close the SQL Server Configuration Manager and Proceed to Next Step.
Again Click Windows Startup Button, All Programs, Microsoft SQL Server 2008 R2 and click SQL Server Management Studio as we see from the above screen.
Wait for a while windows loading SQL Server Management Studio…
Now click connect to the Microsoft SQL Server first time with Windows Authentication.
Right Click over the Security then Click New and Choose Login…
Do the following steps to create a SQL Server User Login to access AC10 database. Click the General Tab
1. Type Login Name as “ocac”
2. Choose SQL Server authentication
3. Type Password as “ocac” in Password and Confirm Password Text Boxes.
4. Un -Tick the Enforce password policy check box.
5. Click OK Button.
Note: User Name and Password please follow the instruction same as above.
Click the Server Roles Node on the top left hand side panel and Tick the sysadmin Sever role then click OK Button. Done.