New to Dynamics CRM - blank web page showing after a new install

(0) Share

Report

Posted on by Sudhir Shukla

125

Hi all,

Firstly, thanks in advance for your patience as I am a newbie to Dynamics CRM. I just installed Microsoft Dynamics CRM 2013 in the following environment:

- Windows Server 2012 R2 (64 bit)

- SQL Server 2012 (Standard Edition) (64 bit)

- MS Dynamics CRM 2013 (64 bit)

MS Dynamics install got completed with a successfull message but when I go to the organization I created ("demo") webpage:

http://localhost/demo

I get the authentication prompt and enter the admin credentials.

Once I click the OK button all I see is a blank page.

3580.Dynamics-CRM-Deployment-Manager.png

I thought maybe for some reason the Org was disabled in Deployment manager but it wasn't:

5481.Authentication-Prompt.png

So then I clicked on the "Browse" option on the right hand menu pane and again it prompted me for authentication as before:

0871.IIS-Manager.png

So I entered the authentication again and again a blank page was displayed.

At this point I thought maybe I should look at IIS Manager since the site configuration would be there. Under "Sites" I saw "Microsoft Dynamics CRM" but nothing with "Demo" as below:

8154.Browse-from-IIS-Manager.png

When I click on the "Browse" for "Micrsoft Dynamics CRM" site, it look me to http://localhost (while I was expecting http://localhost/demo) which was also blank:

Your help with this problem fix is greatly appreciated.

Thanks,

Sudhir

*This post is locked for comments

All responses (9)

Answers (0)

Aileen Gusni 44,524 on at

Like (0)

Report

RE: New to Dynamics CRM - blank web page showing after a new install

Can you just give CRM Reader Role?
Suggested answer

Sudhir Shukla 125 on at

Like (0)

Report

RE: New to Dynamics CRM - blank web page showing after a new install

Hi Aileen,

I just tried doing the following which seems to have fixed the issue (pasting it so that it may be helpful to others too and also open it up to scrutinization):

- Launch SQL Server Management Studio

- Navigate to the <MSCRM_Config> database

- Navigate to Security>>Users>>NT AUTHORITY\NETWORK SERVICE

- Right click on the User and select Properties

- Under Membership select the dbo_owner checkbox and save changes.

This allowed the Demo web page to be displayed. I'm not sure if this permission level is an overkill in terms of security but it got the page to work.

Thanks for all your help and patience!

Cheers,

Sudhir
Aileen Gusni 44,524 on at

Like (0)

Report

RE: New to Dynamics CRM - blank web page showing after a new install

I see,

Can you try to grant access to object: entity view same as this link:

community.dynamics.com/.../the-select-permission-was-denied-on-the-object-39-filteredactivitypointer-39.aspx

Thanks.
Sudhir Shukla 125 on at

Like (0)

Report

RE: New to Dynamics CRM - blank web page showing after a new install

Hi Aileen,

"You are Deployment Administrator? And then you can open the CRM Deployment, you can get the Organization, you can get prompted after you hit the URL, so it means that you are be able to access the MSCRM_Config database."

- Yes I am a Deployment Administrator

"Another checking, just want to ask, when you install the SQL, what user are using? Then, are you now using the same user, or you install SQL with User A, install CRM with user B, and now you are logged in with User C? I need this to make it clearer."

- I used a windows administrator account to install SQL and used the same account to install CRM and now using the same account to log into CRM.

"Anyway, can you do simulate, you go to SQL Management Studio, then login with your current user (windows authentication, not SQL one), then you see in the Database Catalog, can you see the Database : Demo_MSCRM?

And if you can, can you do query : select * from entityview?"

- I opened SQL Management Studio and logged in with the same windows authentication account and was able to run the query : select * from entityview

Thanks,

Sudhir
Aileen Gusni 44,524 on at

Like (0)

Report

RE: New to Dynamics CRM - blank web page showing after a new install

Yes, I think you should check that first.

Later, I can give you another step.

Refer to this link first: community.dynamics.com/.../the-select-permission-was-denied-on-the-object-39-filteredactivitypointer-39.aspx

But, do not do anything first.

I think you just need to try access the SQL, see the database catalog as well, and select the query if you are be able to access the Demo_MSCRM Database, you just neeed dbreader grant access, which is CRMReaderRole.

mscrmnovice.blogspot.com/.../select-permission-was-denied-on-object.html
Suggested answer

Aileen Gusni 44,524 on at

Like (0)

Report

RE: New to Dynamics CRM - blank web page showing after a new install

Hi Sudhir,

Great, you found that in the Event Viewer, very useful.

"The SELECT permission was denied on the object 'EntityView', database 'Demo_MSCRM', schema 'dbo'"

--> It is surely about SQL permission, you cannot access the Demo_MSCRM

Okay, I am checking your scenario.

You are Deployment Administrator? And then you can open the CRM Deployment, you can get the Organization, you can get prompted after you hit the URL, so it means that you are be able to access the MSCRM_Config database.

But, you dont have access to Demo_MSCRM.

Another checking, just want to ask, when you install the SQL, what user are using? Then, are you now using the same user, or you install SQL with User A, install CRM with user B, and now you are logged in with User C? I need this to make it clearer.

Anyway, can you do simulate, you go to SQL Management Studio, then login with your current user (windows authentication, not SQL one), then you see in the Database Catalog, can you see the Database : Demo_MSCRM?

And if you can, can you do query : select * from entityview?

Need you to answer it first.

Thanks.
Sudhir Shukla 125 on at

Like (0)

Report

RE: New to Dynamics CRM - blank web page showing after a new install

In the event viewer there seem to be quite a few errors on "The initialization of the CRM authentication pipline execution has failed for org localhost with a sql error: System.Data.SqlClient.SqlException". This seems to be pointing to a permissions related issue. Am I looking in the right direction and if so what permissions should be ensuring are in place?

Thanks,

Sudhir
Sudhir Shukla 125 on at

Like (0)

Report

RE: New to Dynamics CRM - blank web page showing after a new install

Hi Aileen,

Thanks for your response. It was much appreciated. Below are my comments to your questions:

"When you click browse in the Deployment Manager, I think based on the command prompt,

It redirected you to this:

http://WIN-HSGRI8QLHAR? Is it?"

If I browse from Deployment Manager, I am directed to http://WIN-HSGRI8QLHAR/demo and prompted for authentication. After I enter the admin credentials I am directed to a blank page.

"Try using your browser:

http://WIN-HSGRI8QLHAR

or

http://WIN-HSGRI8QLHAR/demo

Are they working or not?"

I have tried manually entering both those url's and in both cases I got the authentication prompt and after entering the admin credentials both displayed a blank page.

"Have you tried to restart the service and server, IIS Reset as well?"

Yes, I have tried to restart the service, server and iis as well. But still getting the blank page.

Good idea about checking the Event Viewer. I get the following error:

The initialization of the CRM authentication pipline execution has failed for org win-hsgri8qlhar with a sql error: System.Data.SqlClient.SqlException (0x80131904): The SELECT permission was denied on the object 'EntityView', database 'Demo_MSCRM', schema 'dbo'.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteScalar()

at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)

at Microsoft.Crm.CrmDbConnection.InternalExecuteScalar(IDbCommand command)

at Microsoft.Crm.CrmDbConnection.ExecuteScalar(IDbCommand command, Boolean impersonate)

at Microsoft.Crm.Metadata.MetadataCache.IsMergeBaseAndExtensionTablesCompleted(CrmDbConnection connection, IDbTransaction transaction, Guid orgId)

at Microsoft.Crm.Metadata.MetadataCache.IsMergeBaseAndExtensionTablesCompleted(IOrganizationContext context)

at Microsoft.Crm.Metadata.MetadataCache.LoadCache(IOrganizationContext context, Boolean fileOnlyIfExists)

at Microsoft.Crm.Metadata.MetadataCache.GetInstance(IOrganizationContext context)

at Microsoft.Crm.BusinessEntities.BusinessEntityMoniker..ctor(Guid id, String entityName, IOrganizationContext orgContext)

at Microsoft.Crm.Caching.UserDataCacheLoader.LoadCacheData(Guid key, ExecutionContext context)

at Microsoft.Crm.Caching.ObjectModelCacheLoader`2.LoadCacheData(TKey key, IOrganizationContext context)

at Microsoft.Crm.Caching.CrmMultiOrgCacheBase`2.CreateEntry(TKey key, IOrganizationContext context)

at Microsoft.Crm.Caching.CrmMultiOrgCacheBase`2.LookupEntry(TKey key, IOrganizationContext context)

at Microsoft.Crm.BusinessEntities.SecurityLibrary.GetUserInfoCommon(IOrganizationContext context, Guid userGuid, LocatorServiceContext locatorServiceContext)

at Microsoft.Crm.BusinessEntities.SecurityLibrary.GetCallerAndBusinessGuidsFromThread(WindowsIdentity identity, Guid organizationId, LocatorServiceContext locatorServiceContext)

at Microsoft.Crm.Authentication.CrmWindowsIdentity..ctor(WindowsIdentity innerIdentity, Boolean publishCrmUser, Guid organizationId)

at Microsoft.Crm.Authentication.WindowsAuthenticationProviderBase.Authenticate(HttpApplication application, WindowsIdentity userIdentity)

at Microsoft.Crm.Authentication.AuthenticationStep.Authenticate(HttpApplication application)

at Microsoft.Crm.Authentication.AuthenticationPipeline.Authenticate(HttpApplication application)

at Microsoft.Crm.Authentication.AuthenticationEngine.Execute(Object sender, EventArgs e)

ClientConnectionId:6e08bfdc-79cb-4f70-9e81-817f5e145961.
Suggested answer

Aileen Gusni 44,524 on at

Like (0)

Report

RE: New to Dynamics CRM - blank web page showing after a new install

Hi Sudhir,

When you click browse in the Deployment Manager, I think based on the command prompt,

It redirected you to this:

http://WIN-HSGRI8QLHAR?

Is it?

Try using your browser:

http://WIN-HSGRI8QLHAR

or http://WIN-HSGRI8QLHAR/demo

Are they working or not?

Under "Sites" I saw "Microsoft Dynamics CRM" but nothing with "Demo" as below:

--> The demo one will not be created as physical folder in IIS, it is just known in the CRM Deployment Manager as Organization, you cannot get it through IIS Manager.

Have you tried to restart the service and server, IIS Reset as well?

Anyway, try to check your event viewer as well, what is the error?

Maybe my questions above can help you.

Thanks.