Re: Access Sql server 2005 from .net class library
- From: "bass_player [SBS-MVP]" <bass_player@xxxxxxxx>
- Date: Tue, 10 Jul 2007 13:02:43 +0800
No need for COM+/MTS. The important thing here is that the class library
has the capability to accept connection string parameters and switch them
when necessary. Refer to the Enterprise Application Block, particularly the
Dta Access Application Block for samples. As Roman mentioned, since you are
in a workgroup environment, mixed mode authentication is a bit simpler for
this - create the same account on both server and assign permissions for the
necessary securables
"Roman Rehak" <rrehak@xxxxxxxxxxx> wrote in message
news:%23peB3KqwHHA.4628@xxxxxxxxxxxxxxxxxxxxxxx
Just use regular connection string for Windows Authentication, you can
find the syntax at www.connectionstrings.com. Since you are in a
workgroup, you may have to use a mirrored account (same username/password
on both computers).
Roman
--
Roman Rehak
http://sqlblog.com/blogs/roman_rehak
"lankylad" <lankylad@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F4F155F9-1D2E-449F-A5FF-5FCD24CF1025@xxxxxxxxxxxxxxxx
I have Sql server 2005 running on a workgroup server and wish to access
the
data from another workgroup server using direct sql access (ie not ODBC).
The
code to access the data is written in visual studio 2005 and is within a
class library DLL. I wish to use Windows Authentication between the two
servers, but am not clear how to set the user within the code. Do I need
to
use Component Services (ie MTS) to do this?
.
- References:
- Re: Access Sql server 2005 from .net class library
- From: Roman Rehak
- Re: Access Sql server 2005 from .net class library
- Prev by Date: Re: Access Sql server 2005 from .net class library
- Next by Date: Re: DB Role and DBO
- Previous by thread: Re: Access Sql server 2005 from .net class library
- Next by thread: Re: Access Sql server 2005 from .net class library
- Index(es):
Relevant Pages
|
