Loading

SQL DB Question

David Alderman

I'm in the process of designing a program to sell and Iu'm trying to decide what type of DB to use. In the past, I built a program for my church and used an Access database. I was thinking of using an SQL DB, but began to think, in order to distribute my program, I'm going to have to distribute SQL Server Express. My problem is, if I build my program using an SQL DB, will the login info for the DB have to be the same if I use Windows Authentication as it is on my computers or will that matter?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vasanth R16y ago
If you use Windows Authentication, the sql will authenticate using your windows user name and password in which you have logged in. So you no need to mention the user name and password in your connection string. When you run the sql in your machine, it iwll consider ur machine user name and password, simillarly when you use sql in another machine it will consider that machine's user name and password. So it is not necessary to be same
0