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 |
|
hornet
Yak Posting Veteran
96 Posts |
 Posted - 2006-04-10 : 08:39:38
|
Hi! I need to connect to msde database without SQL authentication (sa). I need to connect using Windows authentication. Can you tell me how make it? Thanks in advance! |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-04-10 : 09:31:19
|
| Hornet,Just connect. Windows authentication is the default meansof authenticating. |
 |
|
|
hornet
Yak Posting Veteran
96 Posts |
Posted - 2006-04-11 : 01:19:16
|
| No, I mean another thing. I have installed only MSDE on Win XP. And i work with database over command line with osql. So how i can change authentication type for connection with db?Thanks:) |
|
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-04-12 : 14:49:23
|
| Hornet,Then just use osql with the -E parameter. (-E means "trusted connection".)HTH |
|
|
|
|
|
|
Connect using WinAuth