I have created a virtual machine on azure with the help of "SQL Server 2008 R2 SP2 Web on WS 2008 R2" VMImage, now when I remote connected to the virtual machine and open sql server try to login in server authentication mode. It is not accepting my credentials. Any one help which credentials I need to use.?
1
votes
2 Answers
2
votes
You need to use the administrator credentials you specified when you created the VM from the gallery image. Azure grants that account sysadmin rights on the SQL Server explicitly. Once you log on to the SQL Server with that account, you can set the permissions to meet your needs.
The administrator is a local machine account - so you can use Windows authentication while logged in (or running SQL Server Management Studio) as that administrator.
1
votes
After a long R&D my problem has been resolved by using the following steps :
1 . We need to enable SQL server for login as server authentication mode. technet.microsoft.com/en-us/library/ms188670.aspx
We need to enable it for public access
a. Create an endpoint in virtual machine dashboard www.windowsazure.com/en-us/manage/windows/how-to-guides/setup-endpoints/ msdn.microsoft.com/en-us/library/windowsazure/jj823131.aspx#endpoint
b. Create a Firewall rule on virtual machine to allow the SQL to public access follow the below link and create the inbound firewall rule for sql blogs.biztalk360.com/windows-azure-virtual-machines-virtual-network-may-not-ping-automatically/
