Policy Based Management and non-default sql port number

Question

Policy Based Management and non-default sql port number

e90fleet

Default port

Points: 1450
More actions
March 21, 2011 at 6:49 pm

#237132

Hi all,
We modified default sql port 1433 to something else and now when i create Policy and choose to evaluate this policy by on Schedule the job is not created. What can i do to prevent this from happenning?
Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

UMG Developer SSChampion Points: 13482 More actions · Answer 1

Use the standard port? 😉

Here is a recent Microsoft CSS blog about using non-standard ports, they don't recommend it: http://blogs.msdn.com/b/psssql/archive/2011/03/17/to-1433-or-not-to-1433-that-is-the-question.aspx

e90fleet Default port Points: 1450 More actions · Answer 2

Unfortunatelly this is not an option, thanks for the blog.

Actually i made a mistake and posted a wrong information. SQL Job is actually created but there is nothing created for the step 2 (powershell command).