VS2010 Express ASP.net and database file with SQL Authentication

mvkotekar 0 Newbie Poster

13 Years Ago

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.

Thanks and regards
Mahesh kotekar
http://mahesh.kotekar.com

1 Contributor
0 Replies
120 Views

Be the first to reply

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.