Hi, I have installed Visual Studio 2010 Express in my local system.
Steps 1. File->New Website
2.Open datbase explorer, right click on dataconnection
3.Select Create new connection
4.use Microsoft SQL Server Database file
5. Type new databse filename
6. Now i want to use SQL authentication which is not working
7.If we use windows authentication its wokring without any problem
8.But i need sql authentication to be used.
9.I have not installed SQL studio.
I am only using the one which is packaged in VisualStudio 2010 SQLClient. Let me know how can we create a new database file with userID and password. So that i can host it in other systems as well without any windows authentication. I know that VS2010 setup also installs the SQL client which is requiredto create and manage sql databse files/quries etc
i dont know the default userID and password for SQLauthentication. As the express setup did not asked any credentials while installing SQL components
Thanks and regards
View Complete Post