none
SQL SERVER 2012 MDS .. Login failed for user domain/billcool

    Question

  • SQL SERVER 2012 MDS

    I installed SQL 2012 trial version on my local Windows 7 64bit machine. The plan is to play with new MDS. The MDS installation was successful. I am able to see the MDM database where I am sysadmin. When I browse tourl:  http:billcool/mds I get the following error:

    [SqlException (0x80131904): Login failed for user 'domain\billcool$'.]
       Microsoft.MasterDataServices.Core.DataAccess.DbHelper.ExecuteNonQueryHandlingTransportError(SqlCommand sqlCommand) +461
       Microsoft.MasterDataServices.Core.DataAccess.DbHelper.GetTimeout(String settingName) +231
       Microsoft.MasterDataServices.Core.DataAccess.DbHelper.SetConnection(String connectionString) +532
       Microsoft.MasterDataServices.Core.BusinessEntities.RequestContext.InitializeDatabaseContext() +117
       Microsoft.MasterDataServices.Core.BusinessEntities.RequestContext.InitializeRequestContext(HostContext hostContext) +95
       Microsoft.MasterDataServices.WebUI.ServiceAdapter.GetCurrentUser() +178
       Microsoft.MasterDataServices.WebUI.Common.Header.OnInit(EventArgs e) +294
       System.Web.UI.Control.InitRecursive(Control namingContainer) +186
       System.Web.UI.Control.InitRecursive(Control namingContainer) +421
       System.Web.UI.Control.InitRecursive(Control namingContainer) +421
       System.Web.UI.Control.InitRecursive(Control namingContainer) +421
       System.Web.UI.Control.InitRecursive(Control namingContainer) +421
       System.Web.UI.Control.InitRecursive(Control namingContainer) +421
       System.Web.UI.Control.InitRecursive(Control namingContainer) +421
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2098

    Why it's showing a '$' sign after my name in login? Can anybody help resolve this?

     domain/billcool is a serveradmin and has all permissions to the sql server.

    Thanks in advance for any help....

    Monday, July 15, 2013 1:58 PM

Answers

  • Hi David, Thanks for your response. In fact I created the MDS website thru MDS Config Wizard. I did that all over again. But same issue. I also checked that my userid is a member of mds_exec group. Whe I ran the wizard it I received an error from website 'HTTP Error 503. The service is unavailable.' I saw it was using ASP.NET v4.0 app pool. I changed to 'Default App Pool' and received the very first error again as in the thread.

    Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'domain\billcool$'

    Any guess what is wrong?

    Hi billcool,

    When you try to access Master Data Manager, you might encounter an HTTP 503-Service Unavailable error. This can occur when there is a problem with the application pool that the Master Data Manager Web application runs in. In IIS, ensure that the application pool is running, and verify that the application pool identity is configured properly. For detail information, please see:
    Troubleshooting Installation and Configuration Issues (Master Data Services): http://msdn.microsoft.com/en-us/library/ff487039(v=sql.105).aspx#websvc

    In addition, I recommend you refer to the following article to install Master Data Services. Please see:
    Install Master Data Services: http://msdn.microsoft.com/en-us/library/ee633752.aspx

    Best Regards,


    Elvis Long
    TechNet Community Support

    Sunday, July 21, 2013 9:21 AM
    Moderator

All replies

  • This: domain\billcool$ is the "machine account" for your server called "BillCool".  Apparently the MDS application is running on that server and using Network Service as the account for the IIS Application Pool.

    The Application Pool identity needs to have a login on the SQL Server hosting the MDS login and be a member of the mds_exec group in the MDS database.  The MDS Configuration Wizard will do this all for you. 

    Easiest thing is probably to delete the MDS web site and Application Pool in IIS and use the MDS Configuration Wizard to recreate them.

    Also it's not supported have the App Pool identity as a non-domain account.  MDS will come up initially (so that's not your problem here), but the security integration with Active Directory won't work correctly if the MDS Application Pool identity is a non-domain account.

    David


    David http://blogs.msdn.com/b/dbrowne/

    Monday, July 15, 2013 4:46 PM
  • Hi David, Thanks for your response. In fact I created the MDS website thru MDS Config Wizard. I did that all over again. But same issue. I also checked that my userid is a member of mds_exec group. Whe I ran the wizard it I received an error from website 'HTTP Error 503. The service is unavailable.' I saw it was using ASP.NET v4.0 app pool. I changed to 'Default App Pool' and received the very first error again as in the thread.

    Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'domain\billcool$'

    Any guess what is wrong?

    Monday, July 15, 2013 7:31 PM
  • Yes.  The 'Default App Pool' is running under a Network Service or a Virtual Account and so authenticates to other servers as the machine account: domain\billcool$.

    The MDS Config Wizard will create a new IIS AppDomain for you using domain credentials.  That's the one you need to use.

    David


    David http://blogs.msdn.com/b/dbrowne/

    Monday, July 15, 2013 8:22 PM
  • Hi David, Thanks for your response. In fact I created the MDS website thru MDS Config Wizard. I did that all over again. But same issue. I also checked that my userid is a member of mds_exec group. Whe I ran the wizard it I received an error from website 'HTTP Error 503. The service is unavailable.' I saw it was using ASP.NET v4.0 app pool. I changed to 'Default App Pool' and received the very first error again as in the thread.

    Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'domain\billcool$'

    Any guess what is wrong?

    Hi billcool,

    When you try to access Master Data Manager, you might encounter an HTTP 503-Service Unavailable error. This can occur when there is a problem with the application pool that the Master Data Manager Web application runs in. In IIS, ensure that the application pool is running, and verify that the application pool identity is configured properly. For detail information, please see:
    Troubleshooting Installation and Configuration Issues (Master Data Services): http://msdn.microsoft.com/en-us/library/ff487039(v=sql.105).aspx#websvc

    In addition, I recommend you refer to the following article to install Master Data Services. Please see:
    Install Master Data Services: http://msdn.microsoft.com/en-us/library/ee633752.aspx

    Best Regards,


    Elvis Long
    TechNet Community Support

    Sunday, July 21, 2013 9:21 AM
    Moderator