ODBC conection access2003 on sql express witgout domain

[Zanetti via AccessMonster.com]

Hio all i have huge problem....
I try to connect on sql express from another machine in workgroup i try to
avoid making domain. How can i do that. Client machine see my server but he
wont connect.Thanks all.

 

[Sylvain Lafontaine]

Use a SQL login account: put the authentication mode of the SQL Express to
the mixed mode, create a sql-login account with the necessary permissions
(or use the « sa » (for super user) as a start) and use it to connect to
your sql instance.

There is also a way to connect from a workgroup using a Windows account with
the Named Pipes protocole but this method is prone to error; see:

http://sqljunkies.com/WebLog/roman/archive/2004/11/28/5296.aspx

http://www.jasonfollas.com/wiki/(X(...Studio on Vista&AspxAutoDetectCookieSupport=1

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain aei ca (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[Zanetti via AccessMonster.com]

Tnx man