Do I need to add users for window Authentication?

I am trying to wrap the Windows Authentication in my brain. If I use window
authentication, do I add user through enterprise manager under Security tab
and logins. I want my user on my asp.net to login and connect to sql server,
but I windows Authentication. I don't want to add every single user. I'm I
on the right track?
thanks
Nick
Nick wrote:
> I am trying to wrap the Windows Authentication in my brain. If I use
> window authentication, do I add user through enterprise manager under
> Security tab and logins. I want my user on my asp.net to login and
> connect to sql server, but I windows Authentication. I don't want
> to add every single user. I'm I on the right track?
> thanks
> Nick
You can add a Windows Group that contains all the users.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Do I need to add users for window Authentication?

I am trying to wrap the Windows Authentication in my brain. If I use window
authentication, do I add user through enterprise manager under Security tab
and logins. I want my user on my asp.net to login and connect to sql server
,
but I windows Authentication. I don't want to add every single user. I'm
I
on the right track?
thanks
NickNick wrote:
> I am trying to wrap the Windows Authentication in my brain. If I use
> window authentication, do I add user through enterprise manager under
> Security tab and logins. I want my user on my asp.net to login and
> connect to sql server, but I windows Authentication. I don't want
> to add every single user. I'm I on the right track?
> thanks
> Nick
You can add a Windows Group that contains all the users.
David Gugick
Quest Software
www.imceda.com
www.quest.comsql

Do I need to add users for window Authentication?

I am trying to wrap the Windows Authentication in my brain. If I use window
authentication, do I add user through enterprise manager under Security tab
and logins. I want my user on my asp.net to login and connect to sql server,
but I windows Authentication. I don't want to add every single user. I'm I
on the right track?
thanks
NickNick wrote:
> I am trying to wrap the Windows Authentication in my brain. If I use
> window authentication, do I add user through enterprise manager under
> Security tab and logins. I want my user on my asp.net to login and
> connect to sql server, but I windows Authentication. I don't want
> to add every single user. I'm I on the right track?
> thanks
> Nick
You can add a Windows Group that contains all the users.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com

Distrubuted Transactions with AS400

Hi All
I have created stored procs that update SQL and AS400 (Linked server)
tables. I want to wrap both updates in a transaction, however when I do, I
get the error
"The operation could not be performed because OLE DB provider "MSDASQL" for
linked server "LinkedServerName" was unable to begin a distributed
transaction".
We are using Client Access ODBC driver (V5R2, SI06631).
All of the documents that I have read talk about MTS and MS DTC.
MS DTC is running on the SQL Server.
Is there any way of using Distributed Transaction processing without
requiring MTS ?
Thanks in advance.not enough info on the error.
here:
http://support.microsoft.com/kb/306212
you may want to look at the full error when you talk to DB2. like so
DBCC TRACEON (3604, 7300)
then run your sp and seewhat it does.
did you try just issue
BEGIN DISTRIBUTED TRAN
and see if the 2 data sources you are working with can be accessed?
and you the same authentication your application is going to call your sp
with.
Thanks, Liliya
"Jane" wrote:
> Hi All
> I have created stored procs that update SQL and AS400 (Linked server)
> tables. I want to wrap both updates in a transaction, however when I do, I
> get the error
> "The operation could not be performed because OLE DB provider "MSDASQL" for
> linked server "LinkedServerName" was unable to begin a distributed
> transaction".
> We are using Client Access ODBC driver (V5R2, SI06631).
> All of the documents that I have read talk about MTS and MS DTC.
> MS DTC is running on the SQL Server.
> Is there any way of using Distributed Transaction processing without
> requiring MTS ?
> Thanks in advance.|||Thanks for the response.
Yes - used the same auth as the app will use (windows auth)
Yes - just used BEGIN DISTRIBUTED TRAN
Used DBCC TRACEON (3604, 7300) & SET XACT_ABORT ON as per the link in a
Query Window then ran the updates again.
Ran DBCC TRACESTATUS (3604,7300) to check that the flags for the session
were set.
Still failing & still no extra error information.
Under "Configuration Issues" the link states ;
"Start the Distributed Transaction Coordinator (DTC or MSDTC) on all servers
that are involved in the distributed transaction".
I am not sure what needs to running on the AS400 for this to work.
"l" wrote:
> not enough info on the error.
> here:
> http://support.microsoft.com/kb/306212
> you may want to look at the full error when you talk to DB2. like so
> DBCC TRACEON (3604, 7300)
> then run your sp and seewhat it does.
> did you try just issue
> BEGIN DISTRIBUTED TRAN
> and see if the 2 data sources you are working with can be accessed?
> and you the same authentication your application is going to call your sp
> with.
> Thanks, Liliya
>
> "Jane" wrote:
> > Hi All
> >
> > I have created stored procs that update SQL and AS400 (Linked server)
> > tables. I want to wrap both updates in a transaction, however when I do, I
> > get the error
> > "The operation could not be performed because OLE DB provider "MSDASQL" for
> > linked server "LinkedServerName" was unable to begin a distributed
> > transaction".
> > We are using Client Access ODBC driver (V5R2, SI06631).
> > All of the documents that I have read talk about MTS and MS DTC.
> > MS DTC is running on the SQL Server.
> >
> > Is there any way of using Distributed Transaction processing without
> > requiring MTS ?
> >
> > Thanks in advance.|||OLEDB Errors in SQL Profiler shows ;
<hresult>-2147168246</hresult>
<inputs>
<punkTransactionCoord>0x624A0060</punkTransactionCoord>
<isoLevel>4096</isoLevel>
<isoFlags>0</isoFlags>
<pOtherOptions>0x00000000</pOtherOptions>
</inputs>|||> I am not sure what needs to running on the AS400 for this to work.
depend on what are you running on AS400. DB2 version. Here. how to set up
mts (0you have mentioned this one earlier in this thread)
http://www-03.ibm.com/servers/enable/site/db2/mts/mts.pdf
as about ms sql server side, it does not hurt to test if your sql side is
ok. Easy enough as long as you have couple ms sql's on the same domain etc.
if not, can install one on your ws, configure it and see if you can issue
distributed transactions. After all, it will give you a 'lab rat' s well to
experiment if you in need of one.
Thanks, Liliya