Re: Access Sql server 2005 from .net class library
- From: "Roman Rehak" <rrehak@xxxxxxxxxxx>
- Date: Mon, 9 Jul 2007 23:30:41 -0400
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?
.
- Follow-Ups:
- Re: Access Sql server 2005 from .net class library
- From: bass_player [SBS-MVP]
- Re: Access Sql server 2005 from .net class library
- Prev by Date: Re: SQL 2000 Sproc Role security bypassed when using QBF?
- Next by Date: Re: Access Sql server 2005 from .net class library
- Previous by thread: SQL 2000 Sproc Role security bypassed when using QBF?
- Next by thread: Re: Access Sql server 2005 from .net class library
- Index(es):
Relevant Pages
|
|
