CODEWITHSUNDEEP
databaseconnection-stringumbraco
user2963570
user2963570

Reputation: 381

Umbraco Database Connection Credentials

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...

Upvotes: 1

Views: 6155

Answers (2)

Eyescream
Eyescream

Reputation: 901

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

Upvotes: 0

Lokesh kumar Chippada
Lokesh kumar Chippada

Reputation: 1411

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.

Upvotes: 2

Related Questions