Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Unable to logon - new ...
Microsoft Dynamics SL (Archived)

Unable to logon - new SL installation

(0) ShareShare
ReportReport
Posted on by Svante Kandel 380

Hi,

We have made a new installation of Dynamics SL 2011 on a SQL Server 2008 R2 and Win7 as client.

The SQL server is under a Small Business Server (2011) domain. 

We are however unable to logon to the SQL databases from the client installation. All databases are visible in the Find Database/logon screen (98.000.01) but pressing "OK" only brings up the same screen again, and again, - until cancelled.

Please note that I do not get any error message here and it is the very first logon-instance that we not can pass, i.e. when making the logon to SERVER and SLSYSTEM.

If trying the above logon procedure under the local Admin account, this will strangely enough bring up System Message 5003 "Unable to open the specified server database".

Suspect this all relates to a security matter on the SQL server. Have therefor tried to grant permissions to my own user-id on the SQL Server 2008. However, without any change. There are no messages in the Event- or SQL log files that relates to this matter, failed logins or similar. 

Thanks for your input.

*This post is locked for comments

  • scommar Profile Picture
    scommar 205 on at
    RE: Unable to logon - new SL installation

    Problem was resolved by starting SQL Server with Local System account. It was running under some other user account

  • Verified answer
    Svante Kandel Profile Picture
    Svante Kandel 380 on at
    RE: Unable to logon - new SL installation

    Thanks for your efforts Ricardo.

    As earlier mentioned I however opened a support case with MS on this and got it fixed by A) copying the solomon.ini file that not took place during the client installation, and B) resetting the SYSADMIN user and associating it with my own domain account.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to logon - new SL installation

    Hi SLK try to made this:

    Open the data base maintenace:

    select the SQL autentication, and use de sa user and password.

    Then on the database Tab press the change autentication mode and select SQL.

    Then select the scenario synchronize all ownership and security and press the button Update Database, this acction create master 80m finished the process try to enter to solomon using sydadmin.

  • ShawnO Profile Picture
    ShawnO 165 on at
    RE: Unable to logon - new SL installation

    If you are using windows Auth and doing an upgrade, this may sound funny but try switching SL to SQL auth and then switching it back to Windows Auth. I had the same issue and that is what worked for me.

  • Svante Kandel Profile Picture
    Svante Kandel 380 on at
    RE: Unable to logon - new SL installation

    As mentioned earlier I opened a support case with Microsoft and got the help I needed. Without entering into details, I believe(?) the workaround turned out to be;  resetting the SYSADMIN user and associating it with my own domain account (in Database Management).

    In answer to Ricardo's last question; No master80 is not a login on this server.

    Thanks for your support.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to logon - new SL installation

    It is very unusual, I see the problem in yout SQL, I have a question.

    Do your have on your sql server the user master80?

  • Svante Kandel Profile Picture
    Svante Kandel 380 on at
    RE: Unable to logon - new SL installation

    Thanks,

    Some small progress has been made in this matter.

    It showed out that the Solomon.ini file not was copied during the installation process (not to any client). By manually copying it to the client computer (into C:\Users\user.name\AppData\Roaming\Microsoft Dynamics SL) we were able to take one step forward. 

    There is however still some issue with the authentication.

    We have also tried the workaround you Ricardo suggest (which btw earlier worked for us in a SQL2000/Solomon 6.5 environment). We have thus created SQL login for Domain\user.name. However, when trying to create the User ID's, Dynamics does not allow us to associate these ID's - neither with the Windows User Name, nor with the SQL login and returns message 10265 - "This user cannot be authenticated by Windows. Please enter a valid windows account name. (Ex. Sales\Bob)".

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to logon - new SL installation

    Hi SLK then that you create to domain user try one more time to open dynamcis SL

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to logon - new SL installation

    Hi SLK you have using a windows atentication mode, for login to dynamics?

    You try... creating a the same domain\user on the SQL server users, with server role public.

  • Svante Kandel Profile Picture
    Svante Kandel 380 on at
    RE: Unable to logon - new SL installation

    Still not solved and I have opened a support case with Microsoft.

    In answer to your question; No, it is a default instance.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans