SQL Server 2008 Standard Edition provides the relational database capabilities you would expect, as well as basic BI and reporting features. Its notable omissions include PowerPivot, Power View, Master Data Services, advanced auditing, transparent data encryption, columnstore indexes, and other data warehousing features.
SQL Server 2008 Standard Edition also includes support for two-node AlwaysOn failover clusters. Microsoft will also continue to offer the free SQL Server 2008 Express Edition, which includes the new LocalDB feature for lightweight deployments.
Cognosys Provides Hardened images of SQL Server 2008 Standard Edition on the cloud ( AWS marketplace, Azure and Google Cloud Platform).
SQL Server 2008 R2 Standard edition on Windows Server 2008
SQL Server 2008 R2 Standard edition on Windows Server 2008 on cloud for AWS
Major Features of SQL Server 2008 Standard Edition
1. Cross-Box Scale Limits
2. High Availability
3. Scalability and Performance
6. Management Tools
7. RDBMS Manageability
8. Development Tools
Installation Instructions For Windows
Note: How to find PublicDNS in AWS
Step 1) RDP Connection: To connect to the deployed instance, Please follow Instructions to Connect to Windows instance on AWS Cloud
1) Connect to the virtual machine using following RDP credentials:
- Hostname: PublicDNS / IP of machine
- Port : 3389
Username: To connect to the operating system, use RDP and the username is Administrator.
Password: Please Click here to know how to get password .
Step 2) SQL Connection: To Connect Microsoft SQL Server Management Studio in windows server, Please follow Instructions to Connect Microsoft SQL Server Management Studio
Step 3) Database Credentials:
You can Login by below SQL Database credentials
SQL UserName : sa || Password : Passw@rd123
Note: You can reset ‘sa’ password by using windows authentication to connect to local SQL instance. Please use localhost in the server name when connecting from inside the RDC
Step 4) Other Information:
- Windows Machines: RDP Port – 3389
- Http: 80
- Https: 443
- SQL Server Port: 1433 this is by default not allowed on the firewall for security.
Configure custom inbound and outbound rules using this link
Installation Step by Step Screenshots