Re: Login to SQL with non domain account
- From: "Hari Prasad" <hari_prasad_k@xxxxxxxxxxx>
- Date: Tue, 10 Oct 2006 07:23:26 +0530
Hi,
Looks liks your SQL Server is setup for Windows Authentication only. In that
case to communicate to
SQL Server you may need to login to client with an domain user which has
access to SQL Server. Incase
if you can not do that then change the authetication mode to Windows and SQL
Server authentication.
In this you could connect to SQL Server using SQL Server Authentication.
Thanks
Hari
"Ido friedman" <Idofriedman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:85A4A648-23E0-4AF6-870D-BE7380734DBC@xxxxxxxxxxxxxxxx
I have a problem accessing a SQL instance from a VB script that uses a SQL
user, and is executed with a local computer user.
When I use the same VB script while logged on with any domain user it
executes successfully.
All SQL tools like query analyzer and enterprise admin have not problems.
What can cause this problem?
Any help would be appreciated.
Thanks in advance,
Ido Friedman
.
- Prev by Date: Re: identity on / off
- Next by Date: Re: identity on / off
- Previous by thread: identity on / off
- Next by thread: Re: Connectivty problem from NON domain users
- Index(es):
Relevant Pages
|
