Re: I can only connect via Windows Auth - WHY?
From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 09/29/04
- Next message: Sue Hoegemeier: "Re: Error 87 from GetProxyAccount on line 604"
- Previous message: Chris Clements: "Error 87 from GetProxyAccount on line 604"
- In reply to: SA Dev: "Re: I can only connect via Windows Auth - WHY?"
- Next in thread: SA Dev: "Re: I can only connect via Windows Auth - WHY?"
- Reply: SA Dev: "Re: I can only connect via Windows Auth - WHY?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 29 Sep 2004 16:25:18 GMT
Previous Post>
I would expect an error or an access denied. This is sort of the point of
the problem.
If I put my username/password in the server, then a net view would work,
then I can connect to the SQL server using sa and the blank password.
Yes. This is a permission issue. Since net view fails unless you put in a
valid
username/password, this indicates that you may be in a workgroup scenario
or
are denied access to this computer from the network.
Change your connection to use TCP .
Try this test with OSQL.
OSQL -Stcp:ServerNameHere -Usa -Ppassword here.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
- Next message: Sue Hoegemeier: "Re: Error 87 from GetProxyAccount on line 604"
- Previous message: Chris Clements: "Error 87 from GetProxyAccount on line 604"
- In reply to: SA Dev: "Re: I can only connect via Windows Auth - WHY?"
- Next in thread: SA Dev: "Re: I can only connect via Windows Auth - WHY?"
- Reply: SA Dev: "Re: I can only connect via Windows Auth - WHY?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|