Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Michael 22 posts 71 karma points
    Aug 09, 2012 @ 09:25
    Michael
    0

    Database Configuration and SQLExpress

    I'm trying to install Umbraco 4.8

    I'm running Windows XP IIS 5.1 and .NET 4

    I Get the 'Database Configuration' screen.

    I choose 'Microsoft SQL Server', my machine has SQL Express and management studio.

    So I type in 'computername\SQLEXpress'

    I type in 'Umbraco' as the db name (I've already set this up) - I get a confirguation error when I click the button.

    My question is what's the username and password?

    Can I run windows integrated security and not have a user name and password
    and if I can't how can I set a username and password in SQLExpress?

    thanks.

  • Dirk De Grave 4541 posts 6021 karma points MVP 3x admin c-trib
    Aug 09, 2012 @ 09:51
    Dirk De Grave
    0

    Hi Michael,

    You need to create a sql login and a database login (which maps to your sql login).

     

    Cheers,

    /Dirk 

  • Michael 22 posts 71 karma points
    Aug 09, 2012 @ 11:59
    Michael
    0

    Thanks Dirk.

    Done that but for some reason I still get a database connection failed to initialise error.

    I tested logging into SQL Server 2008 Express Edition
    When logging in I select the Authentication mode - SQL Server Authentication.

    I type in the username and password, I get
    Login failed for user 'Test2'.

    I have set up SQL Server and Windows Authentication Mode
    and I have created a user and mapped that user to the database.

    Not sure what I'm missing.

     

  • Dirk De Grave 4541 posts 6021 karma points MVP 3x admin c-trib
    Aug 09, 2012 @ 12:37
    Dirk De Grave
    0

    yup, you need sql server authentication enabled on your sql box.

     

    Cheers,

    /Dirk

  • Michael 22 posts 71 karma points
    Aug 09, 2012 @ 12:46
    Michael
    0

    I have set up SQL Server and Windows Authentication Mode or do I need to do something else.

  • Dirk De Grave 4541 posts 6021 karma points MVP 3x admin c-trib
    Aug 09, 2012 @ 12:47
    Dirk De Grave
    0

    Yes, you need to switch to mixed or sql authentication mode

     

    Cheers,

    /Dirk

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies