You can add a custom table to the Umbraco database on your database server for instance. But what are you trying to achieve? Whould the purpose of your table-creation be? Perhaps it's better to connect to an alternate database to keeps things seperate? It of course depends on what it is you're trying to achieve I guess.
I am using Umbarco, I am just a begginer and I want to create custom database in my website but i am unable to access my database. can you please give any documentation or any link which is guide me to step by step.
Ususally I use Microsoft SQL Management Studio to connect to my database and work on it when needed. You should be able to just google Microsoft SQL Management Studio and find a version that fits the version of MSSQL you're running (IF you're using MSSQL).
You cannot work directly on the database inside Umbraco backend.
we are using sql server managment studio R2 and MS Sql but unable to connect database.so can you please suggest any link or article that guide to link step by step and how to comunicate with the Database in Umbraco.
You should be able to connect to the DB through sql server management studio.This seems to be a problem with your login/setup.
Are you SURE you're using the correct name of your instance of the db server? I think you set this up when installing sql server. I've had this problem sometimes when I just ran quickly over the setup and forgot to make a note of it.Otherwise try the name (local)
Are you SURE that you are using the correct credentials to connect? You chose your user and pass when you set up Umbraco. Or you could try to connect with "Windows authentication" instead of "SQL Authentication" and use your normal windows user for that.
You should be able to find both the SQL server instance name and the login in your web.config file.
Sorry, I don't have any resources on this, it should be straightforward if you have the right servername and credentials.
Sorry for the confusion. Actually, I am able to login to my MSSQL Server database using Management Studio but don't know actually how to configure and use the particular database & table in Umbraco. I will appreciate if you can point me to some steps/links to configure SQL Server DB/Table in umbraco.
Thank you so much for your help in advance. Waiting for your reply on this.
I already have my umbraco website running in my local server. Now I created one Database in my DB Server (MS SQL Server 2008 R2). I wonder how to connect the website with that particular Database. Looking forward for your kind reply soon.
But what is the purpose of that new database? What do you want it to contain?
If you just want to switch the database, just update your web.config with the credentials for that database. However, if the database is empty, this will propably go wrong or trigger the installation wich will then populate the database.
If you want to use the new database for something completely different, and use that in umbraco, my recommendation would be to write your own usercontrols that just gets the data out of the database the way you want to present it.
You *could* also use the package called DEWD, it should be able to connect to databases and make it easier to work with external datasources in umbraco. I don't have any experience with that, though.
Still, I'm curious about what it is your'e trying to accomplish? Do you want to switch the database running your website or do you want a database to contain something other than umbraco and use that data on your website?
I am using sql server managment studio R2 but unable to connect database in umbraco so can you please suggest any link step by step and how to configure with the database in umbraco.
Create new database
How to create new database table in umbraco ?
Hi Sharad
You can add a custom table to the Umbraco database on your database server for instance. But what are you trying to achieve? Whould the purpose of your table-creation be? Perhaps it's better to connect to an alternate database to keeps things seperate? It of course depends on what it is you're trying to achieve I guess.
/Jan
Hi Jan,
I am using Umbarco, I am just a begginer and I want to create custom database in my website but i am unable to access my database. can you please give any documentation or any link which is guide me to step by step.
Ususally I use Microsoft SQL Management Studio to connect to my database and work on it when needed. You should be able to just google Microsoft SQL Management Studio and find a version that fits the version of MSSQL you're running (IF you're using MSSQL).
You cannot work directly on the database inside Umbraco backend.
Cheers,
Niels
Hi Niels,
we are using sql server managment studio R2 and MS Sql but unable to connect database.so can you please suggest any link or article that guide to link step by step and how to comunicate with the Database in Umbraco.
Regards,
Sharad Kumar Rathore
You should be able to connect to the DB through sql server management studio.This seems to be a problem with your login/setup.
Are you SURE you're using the correct name of your instance of the db server? I think you set this up when installing sql server. I've had this problem sometimes when I just ran quickly over the setup and forgot to make a note of it.Otherwise try the name (local)
Are you SURE that you are using the correct credentials to connect? You chose your user and pass when you set up Umbraco. Or you could try to connect with "Windows authentication" instead of "SQL Authentication" and use your normal windows user for that.
You should be able to find both the SQL server instance name and the login in your web.config file.
Sorry, I don't have any resources on this, it should be straightforward if you have the right servername and credentials.
Hi Niels,
Sorry for the confusion. Actually, I am able to login to my MSSQL Server database using Management Studio but don't know actually how to configure and use the particular database & table in Umbraco. I will appreciate if you can point me to some steps/links to configure SQL Server DB/Table in umbraco.
Thank you so much for your help in advance. Waiting for your reply on this.
Ok. Still a bit confused.. Is you site running? If so, everything is fine and the site is using your database..
During an installation the connectionstring should be automatically written to your web.config.
Can you tell me what it is you're trying to achieve?
Cheers
Niels
Hi Niels,
I already have my umbraco website running in my local server. Now I created one Database in my DB Server (MS SQL Server 2008 R2). I wonder how to connect the website with that particular Database. Looking forward for your kind reply soon.
Thanks & Regards,
Sharad
But what is the purpose of that new database? What do you want it to contain?
If you just want to switch the database, just update your web.config with the credentials for that database. However, if the database is empty, this will propably go wrong or trigger the installation wich will then populate the database.
If you want to use the new database for something completely different, and use that in umbraco, my recommendation would be to write your own usercontrols that just gets the data out of the database the way you want to present it.
You *could* also use the package called DEWD, it should be able to connect to databases and make it easier to work with external datasources in umbraco. I don't have any experience with that, though.
Still, I'm curious about what it is your'e trying to accomplish? Do you want to switch the database running your website or do you want a database to contain something other than umbraco and use that data on your website?
Cheers,
Niels
Hi Niels.
I am using sql server managment studio R2 but unable to connect database in umbraco so can you please suggest any link step by step and how to configure with the database in umbraco.
Regards,
sharad
is working on a reply...