Possible owners are nodes which are allowed to host the service, so if there are four nodes, and nodes 1, 2, and 3 are possbile owners, the service will NEVER...

deon 30817 (9/13/2011)

---

Hi NJ-DBA

Thanks for your response.

Yes I could ping by server name and it returned the correct ip address.

Had a re-look on the server configuration as per your...

LOL, just FYI, it's NJ-DBA, or Warren is my name.... it's says "old hand" as my "level", like yours says "forum newbie"...

does it ping to the correct ip address when you ping by name? if not,

issue ipconfig /flushdns

if you are getting the right ip addres, then its at the sql...

Just use managment studio to create a second connection using the login you create...

Yes. that's correct.

You could test this by creating a new login which has a simple password, initally with no enforcement. Then changing it.

I'm sure there is a way you could do this with a variable, but when faced with a similar challenge, I took the easy way out and called a batch...

NJ-DBA (9/13/2011)

---

Enforce password expiration sets whether or not passwords expire after a given time period. enforce password policy sets whether or not sql passwords need to meet the complexity...

Enforce password expiration sets whether or not passwords expire after a given time period. enforce password policy sets whether or not sql passwords need to meet the complexity requirements...

I can't think of a way of preventing this kind of error from appearing in the errorlog, but maybe there is another way to accomplish your goal.

The best thing I...

ah, just reread your post... this will not PREVENT something frmo being entered into the log, but I used this in a multiserver query to read the logs and return...

This is how I do it:

---------------------

--Following block parses error log and produces interesting results

----------------------

CREATE TABLE #ErrorLog (

LogDate DATETIME,

ProcessInfo NVARCHAR(255),

LogText NVARCHAR(MAX)

);...

ooh, those look fun... need to secure some...

I think this is what you are looking for: http://technet.microsoft.com/en-us/library/ms142490.aspx

Please post the entire error message.