Trusted Connection from VB

[krotha]

Hi All
We have VB Application which connect to Database(Sqlserver2000) using OLEDB connectivity. This application is running fine in most of our clients except one client. This client and Server are connected in Test network environment that means it doesn’t have any domain, and connected between a switch.
Server is installed Mixed mode. From client I can able to connect to the database using Sql User login to the Enterprise Manager, Sql Query Analyzer and ODBC connection , But when I run my application with same user I used to connect for Sql query Analyzer /EM/ODBC, it gives error: 18452 Not Associated with a trusted SQL server connection.

Any Help will be Greatly Appreciated.

Thanks.

 

[cpaige]

Hi,
I currently have a SQL 2000 Server that is setup as SQL Authentication. I have been reading about Mixed Mode authentication and wondering how exactly it worked.

If the SQL 2000 Server is using SQL authentication , is it already using Mixed Mode?

When using Mixed Mode does the server check both the SQL Login and the Windows Login?

In Mixed Mode, is that password transfered to the SQL Server in plan text?

Thanks,



Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"

 

[cpaige]

Sorry, I meant to post this as a new message

Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"

 

[SQLBill]

krotha,

When you run your application, is SQL Server asking for a login and password? Is your application sending a login and password to SQL Server?

-SQLBill

 

[ClaireHCM]

I think what you mean by "setup as SQL Authentication"
Is during installation ,there is one of the dialog is asking about which authentication mode you want to use to connect to SQL Server.But actually it's only for "setup".Because for security,you will see only 2 choices one is Windows authentication,the other is mixed mode which include windows and sql server authentication.

If you right click on the server name in Enterprise manager,go to security tab,you will see two choices ,if you select Mixed mode ,you can connect to sql server in 2 ways .
Go to Query analyzer,you will be asking about the way to connect to sql server,you can either check "Windows Authentication" and click "OK" or SQL Server Authentication and insert the login name and pwd.
If you just choose Windows Authentication,you can only check windows authentication and click ok.

 

[krotha]

Thanks Guys for your replies, I have multiple named instances running on a sql server, One of them(which i was trying to connect) was Windows mode, I changed to mixed mode. now it works fine.