Search results for query: *

This has been solved by setting the server service to run as the 'Local System' account and the Server Agent service to run as a domain account. Sorry for the late respons on this thread and thanks to all who responded

Hello and sorry for my absence. I created a domainaccount which whom I specified as the account to start the SQl Agent with. The account I created is a member of the lokal administrator group and has been granted 'Act as part of operatinve system' rights via the local security policy. The...

Thanks for all replies. The account has been added to the local administrators group and is a member of the system administrators SQL role, so my conclution is that access is sufficient concerning the local server and the SQL instance. I ran a couple of tests to try out the servers...

Hello! The jobs which has domainaccounts specified as the job owner fails with the following error message: "The job failed. Unable to determine if the owner (domain\account) of job TestDB backup has server access (reason: Could not obtain information about Windows NT group/user...

I actually got this to work, hours after i posted this question. The problem wasn't the code itself, it was the LDAP string that didn't match the directory structure. After I corrected the LDAP string I was able to query the AD for information. I still got an error when I clicked on "tables" in...

Hi all I'm trying to get the "lastlogon" value from the "user" objectclass within our active directory using this query: SELECT lastLogon FROM OpenQuery(ADSI, 'SELECT lastLogon FROM ''LDAP://DC=mydomain,DC=com'' where objectClass = ''user''') but i get the following error message: Server...

Hi My goal is to setup a linked server towards our domain controller (w2k) in order to retrieve information from user accounts. I've executed the following code to setup the linked server. sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource' This...

SQLBill I'm trying to setup the DC as a linked server so i can query it from my SQL-server. So far i've had no success in the linked server configuration. Any help about how to configure the DC as a linked server would be greatly appreciated. snag57 Thanks for the examples. I'll try them out...

Thanks for the input. SQLBill: The data isn't stored in a MS SQL Server database, as far as know. There is a field named "E-Mail" under the "General" property window. within an account. What i'm trying is to get that field from each an every account within our domain. JayKusch: Yeah, maybe...

I'm trying to query our directory server for all the e-mail adresses within our domain. I know that i need to add the DC as a linked server and then use the OPENQUERY for the select statement. 1. I'm a little uncertain about the process of adding the linked server and what effects (if any?) it...

Hi I disabled a user account 13 months ago and when i enabled it again, the user can´t access it's mailbox. Error message saying something like "You're not authorized to logon". Thankful for all replyes.

Yes it seems like that property affects all queries run on the server. I´ll take it under consideration. Thanks for the reply.

I´ve created a query that consumes 100% of the CPU time when it executes and therefore i´ve scheduled it to run during off houres. Sometimes however, i need to run this query during daytime which brings the server to it´s knees and that is catastrophic since there are a lot of applications...

Ok, got it. I´m familiar with BOL but i didn´t understand the concept when reading it. Anyhow, i got it to work now. Thanks

I´m not an SQL-wizard and i had to try out what you´ve suggested, there´s a problem thou. How do i make a stored procedure out of an query? i´m not sure about it.

Glyndwr Ok, now i know why it remains. Thanks for the input.

SamGarland That was exactlly what i was looking for, it worked like a charm. Thanks for the help. Glyndwr Thanks for the reply, but i didn´t get it to work. The second time i executed the script i got an error message that said the table already existed. I thought putting an # infront of the...

Is there a way to see what kind of recovery model all my db´s have using T-SQL. At my company we´re using a third party backupsystem for our sql servers. The log backups fail on some db´s due to recovery model is being set to SIMPLE. There are many DB´s in my system and i don´t have the time...

Thanks for the input. I´ve tried both of the sullotions given and they worked just fine. I´m gonna go with the xp_sendmail and attach the results from the query. Thanks for the help.

Never mind. I found a workarond.