I have a windows service that does some distributed transcation
across 2 servers. One DB is SQL 2005 express and the other is SQL 2005.
My question is I have created a domain user account and I am
logging the service in as that account. Then I am adding permission to
the user acccount to both DB's.
If I use integrated security in my connection strings to the
DB's will they login as the domain user account and
everything be greart????
Windows service ... I have a windows service that does some distributed transcation ... across 2 servers.... One DB is SQL 2005 express and the other is SQL 2005. ... My question is I have created a domain user account and I am ... (microsoft.public.dotnet.languages.csharp)
Re: Accessing DB from windows service ... If the both servers are in the same domain, ... I have a windows service that does some distributed transcation ... One DB is SQL 2005 express and the other is SQL 2005. ... My question is I have created a domain user account and I am ... (microsoft.public.sqlserver.security)
Re: Windows service ...Bela Istok... I have a windows service that does some distributed transcation ... One DB is SQL 2005 express and the other is SQL 2005. ... My question is I have created a domain user account and I am ... (microsoft.public.dotnet.languages.csharp)
Re: Windows service ... across 2 servers.... One DB is SQL 2005 express and the other is SQL 2005. ... My question is I have created a domain user account and I am ... If I use integrated security in my connection strings to the ... (microsoft.public.dotnet.languages.csharp)
sql service password in cluster changed by wrong method ... Then she changed it back to the domain user account using ... the Services applet.... to be done within the SQL Enterprise Manager....Service Account through the SQL EM, tried to change the password and we get ... (microsoft.public.sqlserver.clustering)