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 |
|
ttidrick
Starting Member
1 Post |
 Posted - 2002-01-31 : 21:59:34
|
| Greetings,If this is not Admin, please point me to the correct forum.I am setting up a development machine with SQLSrvr7 and VS.NET. My first attempt to connect to SQL7 failed until I set security to 'Mixed'. My question: what do I need to do to use 'Integrated' security (ie, windows only)? References?Thanks,Ty |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-02-01 : 00:09:45
|
| HiYou need to have the user that ASP.Net is running as (probably IUSER_Servername) to be given access to your database. Then a conneciton sting like thisProvider=SQLOLEDB; Data Source=MyServer; Initial Catalog=MyDatabase; Trusted_Connection=YesDamian |
 |
|
|
|
|
|
trusted connection?