To add a content database to Web App. I am using admin account that has full access to SP 2010 and Sql 2008 R2 with all needed rights. It throws the following exception while debugging the code. "Could not connect to SqlServer\instanace with user domain\user: Cannot connect to database master at SQL server at SqlServer\instance. The database might not exist, or the current user does not have permission to connect to it." Solution: Create and Delete the Web Applications and Site collections Programmitically in Sharepoint To create and delete a web application and associated site collection programmatically. Deleting was achieved using the following code: SPServiceCollection services = SPFarm.Local.Services; foreach (SPService curService in services) { if (curService is SPWebService) { SPWebService webSer...
Enterprise AI & Cloud Architecture is a thought-leadership platform focused on AI-driven, cloud-based enterprise systems. It examines advanced architectures leveraging SharePoint, Microsoft 365, Azure, Power Platform, RAG, and Agentic AI to modernize mission-critical environments in healthcare, research, government, and enterprise organizations.