Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
demodown
Starting Member
1 Post |
 Posted - 2002-08-08 : 05:02:27
|
| Hi,Anyone of you having any idea about how to1.Create a new user login account in MSDE 2000 using VB.2.Change the sql server authentication mode to allow both Windows and SqlServer authentication in MSDE using VB.My web application works fine with the SQL Server 2000 but when trying to dumb the database files .mdf in to the MSDE 2000 and after attaching the file and creating the new user.Its giving the login failed for user 'sa'byedemodown |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-08 : 08:15:15
|
| Are you using 'sa' to connect to your database from your VB application? Actually....don't answer that....just change it if you are!!! Bad developer, bad...Users and Logins are two different things. I'd recommend you do some reading in books online about "managing security". Usually the authentication model is determined at install time. I think you are going to need to used SQLDMO to change it. Take a look at the IntegratedSecurity Object and the SecurityMode Property.Jay White{0} |
 |
|
|
|
|
|
security->logins