Learning

Installing MS SQL and MS CRM

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: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) Access is denied

Rana Muhammad Waqas22 hrs · LahoreHey guys I have installed MS SQL 2008 and CRM 2013 on a server but I am getting this error when I try to access the CRM “Server Error404 – File or directory not found.The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.”I’ve checked SQL Services running and IIS is running. Did little bit google on it, but couldn’t find any solution. Help!LikeLike ·

Rojan V Thomas go to Application Pools and check the status of CRMAppPool20 hrs · Like

Rana Muhammad Waqas yes its running20 hrs · Like

Pradip Isaac go to control panel and try repair crm20 hrs · Like

Rojan V Thomas From the screenshot provided it’s visible that you are using port number 80 for the application. Always give a unused port (by default it’s 5555 which gets opened and installed along with CRM (if you chose the option during installation). try changing it and see20 hrs · Like

Hasan Kamal Try to first login with the user account of deployment administrator.20 hrs · Like

Rana Muhammad Waqas Hasan Kamal I am doing that but it gives the error i mentioned20 hrs · Like

Rana Muhammad Waqas Rojan, Pradip When I repair or installed it first time i got these warningsRana Muhammad Waqas’s photo.20 hrs · Like

Rojan V Thomas that is okay..20 hrs · Like

Rana Muhammad Waqas While repairing it doesnt ask for the port, I guess there’ll some option in IIS for that20 hrs · Like

Rojan V Thomas problem here is it can’t be accessed properly via a browser which is nothing but the IIS setup issue.. it could be service account issue or the port issue20 hrs · Like

Peeyush Jain @Rana have u installed crm and SQL server in two different machine or in the same machine…if two different machine so make sure all the default port 8080 ,555 or any SPL port which you have given during installation should be accessible...check your inbound outbound firewall rule20 hrs · Like

Rana Muhammad Waqas Peeyush I have Installed both on the same machine20 hrs · Like

Rana Muhammad Waqas Rojan I have changed the binding to the server ip and port 5555 when i Access it there and use Administrator Account Which i used in Installations it says “HTTP Error 401 – Unauthorized: Access is denied”20 hrs · Like

Pradip Isaac do a repair and give a different account for application service20 hrs · Like

Rana Muhammad Waqas Pradip How do i do that ?20 hrs · Like

Pradip Isaac this is something to do with app pool account20 hrs · Like

Pradip Isaac will it be possible for u to call me20 hrs · Like

Pradip Isaac +91 909472736520 hrs · Like

Pradip Isaac sorry I din get any msg20 hrs · Like

Rana Muhammad Waqas Does this have to do anything with Active Directory ?20 hrs · Like