Database

Topics: Developer Forum
Jan 13, 2009 at 6:42 AM
Hi i'm wondering where do my data go.. where in mg web.config i didn't specify the database name

here's my connectionstring

<add name="N2CMS" connectionString="Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
Jan 13, 2009 at 11:33 AM
It looks like it'll use a default db for the login you're accessing your server under. By default, it'll be master -- a horror ! Luckily, you have a User Instance=true, so it will actually create a dedicated master database for your instance. Not a good thing for a production site.
Jan 13, 2009 at 11:52 AM
so it means that the data i stored was on the masterdb Database?
Jan 13, 2009 at 1:02 PM
I guess so.. To check it one will need to connect to that instance and look into it's master: SQLCMD -E -S .\sqlexpress ; select * from sys.dm_os_child_instances; SQLCMD -E -S \\.\pipe\...\tsql\query ; use master; ...