Sign in Register
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

    Installing umbraco

    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.

    Copy Link
  • 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 

    Copy Link
  • 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.

     

    Copy Link
  • 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

    Copy Link
  • 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.

    Copy Link
  • 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

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft