Umbraco Database Connection Credentials

Question

Where can I find the database credentials of my umbraco database?

In web.config there is just the following line:

<add name="umbracoDbDSN" connectionString="Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1;" providerName="System.Data.SqlServerCe.4.0" />

Which provides insufficient information...

marc_s · Accepted Answer · 2017-02-19 13:00:14Z

2

Your connection string clearly shows that you're using default SQL Server CE database (Umbraco.sdf). You can find the Umbraco.sdf file in the /App_Data folder.

Depends on your requirement you can convert the SQL Server CE database to SQL Server Express or open up your solution in Webmatrix to see database tables.

You can find more information on conversion here https://our.umbraco.org/forum/umbraco-7/using-umbraco-7/53818-Convert-Umbraco-SQL-CE-database-to-SQL-Express

To view database tables from webmatrix, you need to open up your solution and click the tab called databases.

umbracoUser is the table where you can find users.

edited Feb 19, 2017 at 13:00

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered May 18, 2016 at 11:32

Lokesh kumar Chippada

1,4711 gold badge12 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

marc_s · Accepted Answer · 2017-02-19 13:00:24Z

0

It seems that you are using SQL Server CE and not a SQL Server instance

edited Feb 19, 2017 at 13:00

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered May 2, 2016 at 11:58

Eyescream

9215 silver badges14 bronze badges

3 Comments

user2963570 Over a year ago

Exactly. Does that change the case?

Eyescream Over a year ago

I dont think that the sql ce installation does set up a password. That connection string is all umbraco needs. What is your problem/task exactly?

user2963570 Over a year ago

I'm trying to implement Google's sample code to store RefreshTokens into the database. In the sample code it is stored in a datastore. I'm implementing an IDatastore that communicates with the Umbraco Database. So I'm able to insert this data into the databank rather then a file. I was using sample code aswel for this implementation of the datastore which required me to fill out all the databank credentials. I decided to leave that approach and I'm just making a custom datastore using ApplicationContext.Current.DatabaseContext.Database. Which is working. Thanks for the help anyway.

Collectives™ on Stack Overflow

Umbraco Database Connection Credentials

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related