Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sql Server 2000 (MSDE) User connection

Status
Not open for further replies.

rr3news

Programmer
Apr 15, 2003
15
0
0
BR
I installed a SQL Server 2000 (MSDE Edition) in Windows XP Home Edition.

How can I access a MSDE Edition from other station without using a GUEST user ?

I create other user and I grant the privilegies to them, but the problem occurs when a trying connection with this new user. So How can I resolve this problem ?


ODBC
When I use a ODBC (DSN) with NT Autentication Option. The operation is OK. When I used SQL Autentication the error below occurs.
The Error Message is:
Connection
SqlState 28000
Sql Server 18452
[Microsoft][Odbc Sql Server Driver][SQL Server]Login failed for user 'Eventos'. Reason: Not associated with a truster SQL Server connection

Thanks
from Brazil
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top