Re: Trusted Connection problems
- From: "YYZ" <none@xxxxxxxx>
- Date: Fri, 29 Apr 2005 14:19:20 -0500
Okay, solved the problem -- not me, but the sql guru here -- he finally
slapped his head.
The problem was that we had to run the svrnetcn.exe utility and make sure
that Named Pipes and TCP/IP were enabled. Nothing was enabled...go figure.
Sorry to waste anyone's time.
Matt
"YYZ" <none@xxxxxxxx> wrote in message
news:eqbEytOTFHA.1152@xxxxxxxxxxxxxxxxxxxxxxx
> Okay, I've got a SQL Server (MSDE) instance installed on a machine called
> DEBRA-F -- I specified the sa password as localadmin -- easy enough.
>
> At first, I couldn't connect to her machine FROM her machine, using the sa
> login. So we had to login using the -E switch (ie, no username or
> password, just use the NT login rights...I think that's what it means).
>
> Then our sql guru ran some scripts, and I don't exactly know what those
> did. However, now, from her machine she can get into sql server using the
> osql utility.
>
> Unfortunately, I can't get to her machine from MY machine, using the sa
> account (or any account for that matter). I need to get there to do some
> testing, and I've already got one other user setup and this work fine.
> He's in Indiana and it works, her machine is down the hall and it doesn't
> work.
>
> Can anyone point me in the right direction to fix this issue? I've tried
> the KB fix of editing the article where you edit the registry and change
> the 0 or 1 to 2 for the key of LoginMode. Article 285097 I think...
>
> Thanks for any and all advice.
>
> Matt
>
.
- References:
- Trusted Connection problems
- From: YYZ
- Trusted Connection problems
- Prev by Date: Re: Will MSDE easily move to SQL Express?
- Next by Date: Re: Will MSDE easily move to SQL Express?
- Previous by thread: Trusted Connection problems
- Index(es):
Relevant Pages
|
