- Getting back to your Workout VDI
To Manage the SQL Server on Training Hands-On Network, you can use your Workout-VDI for accessing to the SQL Server via Management Studio
Confirm you find the SQL Server Management studio at VDI.
- You now, open the SQL Management Studio.
- SQL Connection Dialog comes up.
- Fill the parameters for accessing to the SQL Server you configured in previous step.
Parameters
- Server Type : Database Engine
- Server name : IP address + port number (example: 192.168.1.1,2500)
- Authentication – SQL Server Authentication
- User name – SA
- Password – Password your configured for SA in SQL server installation
- Connect
- You Experience the connection issue – as blow.
- Go back to the SQL Server -> SQL Server Configuration manager.
Move into SQL Server Network Configuration -> Protocols for SQLEXPRESS (SQLEXPRESS is what you created in SQL installation.) Find, TCP/IP.
- Right click TCP/IP -> Properties.
- At IP Address tab, scroll down to bottom. You notice the TCP Port for IP ALL is 0.
- Change it to 2500. Apply -> OK.
- Go to SQL Server Services and Restart the SQL Server (SQLEXPRESS).
- OK, going back to Workout VDI, try connecting to the SQL Server from SQL Management studio again.
- You will see that the SQL access gets established at this time.
Now you are ready to control this SQL Server as SQL Database Administrator