Azure Cosmos DB Git hub sample EcommerceWebApp it is not working

Question

Hi All,

we are using sample github sample -https://github.com/Azure-Samples/azure-cosmos-db-change-feed-dotnet-retail-sample

in this sample we have one application -EcommerceWebApp it is not working.

in Code it will beak in below if condition

if (!roleMgr.RoleExists("canEdit"))

{

idRoleResult = roleMgr.Create(new IdentityRole { Name = "canEdit" });
}

Error message-

System.Data.SqlClient.SqlException: 'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network

We really appreciate any help to run this program

Answer 1

Hi @manish verma Thanks for posting your query in Microsoft Q&A
I understand that you are using the sample GitHub code and you are facing a connection issue.
The exception message seems that there's no SQL server for it to connect to, or the instance is not accessible over the network.
can you please check the connection and give it a try.

Regards
Geetha

Answer 2

thanks.

it is working once sql connection is given