sql server msde: Hi

I created a small test app that opens an sql database on the same machine
(TESTPC).

When i move the compiled app to another pc in the network i receive this
error:

Login failed for user TESTPC\Guest.


What should i do to make it work ?
Connection string ? or doe i need to created some account on the other
network PC ?

I also tried using SQL autentification , but receive an error : Not
associated with a trusted SQL Server connection.
how do i create such trusted sql server connection

(i run NET 2003 with the MSDE2000 on w2k machines )

Johan

hi Johan,
[quoted text, click to view]

the first exception you are reported with depends on the lack of credential
validation as you do not run on a domain but a workgroup, and 2 separated
PCs are not "trusted" this way, as the sid of the remote account can not be
validated by SQL Server against the local accounts...

you get the
[quoted text, click to view]
as MSDE installs by default disabling standard SQL Server authenticated
connections and allowing trusted connections only .. you have to modify this
behaviour as indicated in
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q285097 in the
"windows registry hacking" section...

in a workgroup environment, usually only standard SQL Server authenticated
connections are use, thus you have to modify you connection string
accordingly... http://www.connectionstrings.com
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Make sure the authentication is correct and connection string is correct too,
KBA http://support.microsoft.com/default.aspx?scid=kb;en-us;321698 fyi.
--
-----------------
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on
Performance topic.


[quoted text, click to view]