i know the basics about how to manipulate SQL server database, i mean the code itself, but there are few other things which i don't understand.
first, databases which i have created by my own, i can use only when
i have the website itself open (i get an icon at the taskbar)
but database such as 'master' which came with the sqlserver, i can acess always even without running the page with visual studio first. i have no idea why.
also, when i try to connect my website using my ip, i can only do it with
the master database.. those i created by my own i can only connect when i enter the URL page as localhost.
I don't understand what's USER INSTANCE for and how do i really set
a database username and password
can someone exaplin a little? thanks, because i am very confused .
from the post it is not clear what your problem is. do u mean that u can connect to master database but not to the one u created? please ready the Sticky post at the top to make a more meaningful post if u are interested in getting proper reply.....
Are you using Visual Studio to look at your database, or SQL Server Management Studio? The second one is the preferred tool. The first is something you are more likely to use if you are a webby developer rather than a database developer.