Viewing 15 posts - 421 through 435 (of 6,104 total)
noeld (10/21/2009)
Although certainly cool, there should be very little value of this on SQL Express
In a regular production environment I would tend to agree. This came out of the comments...
K. Brian Kelley
@kbriankelley
October 21, 2009 at 1:41 pm
Roberto Filippi (10/21/2009)
to me on Express 2008 it still says that DAC isn't enabled, though the log says that it's enabled. I don't understand
I had to do the work around...
K. Brian Kelley
@kbriankelley
October 21, 2009 at 1:39 pm
What would probably be better is if you wrote an article or blogged about it. That would make it more accessible.
K. Brian Kelley
@kbriankelley
October 20, 2009 at 4:53 pm
The interface has to be aware of the password change ability. So if you're using an older client (not SQL Server Native Client), they'll get the error that says they...
K. Brian Kelley
@kbriankelley
October 20, 2009 at 4:51 pm
Silverfox (10/8/2009)
not used sqlping in that context before.So sqlping will report on blank passwords or weak passwords for all of the databases on a server?
SQLPing can do blank password and...
K. Brian Kelley
@kbriankelley
October 8, 2009 at 10:08 am
I would use SQLPing.
K. Brian Kelley
@kbriankelley
October 8, 2009 at 9:50 am
Yes, on smaller systems. We may investigate on our larger servers, but that hasn't happened yet. Another resource you may engage is the PASS Virtualization Virtual Chapter[/url].
K. Brian Kelley
@kbriankelley
October 8, 2009 at 9:49 am
Or to use SQL Server based logins for that purpose that don't correspond to any real person.
K. Brian Kelley
@kbriankelley
October 7, 2009 at 8:23 pm
The problem is you can't stop them. If you don't encrypt your stored procedures and the like, they can simply view the defintions of them. Even if you do, there...
K. Brian Kelley
@kbriankelley
October 7, 2009 at 7:28 pm
You want to properly institute file system security. If you do that, only an administrator can override you. And if the person is an administrator, they can get access to...
K. Brian Kelley
@kbriankelley
October 7, 2009 at 6:39 pm
Totall agree with Lynn here. You'll want to make sure the objects don't belong to an actual person. Probably need to institute that as a standard in your environment. That...
K. Brian Kelley
@kbriankelley
October 7, 2009 at 6:37 pm
The 0x1B indicates that the server principal is valid for user-to-user only. The thing that stands out to me is the service name. I'm not sure why it's the same...
K. Brian Kelley
@kbriankelley
October 7, 2009 at 6:35 pm
Yes, for ESX Server 3.5 Update 2 and above.
Here is the Microsoft support policy for non-Microsoft virtualization environments. Here is the support policy for SQL Server 2005/2008 in virtualized environments....
K. Brian Kelley
@kbriankelley
October 7, 2009 at 6:25 pm
Are there any errors in the OS system event log indicating the server is having problems locating the domain or talking to the domain controller? That's the first place I'd...
K. Brian Kelley
@kbriankelley
October 3, 2009 at 9:31 pm
You should always try to grant permissions to a role you've created and then put the appropriate users in that role. If you also want the role to have execute...
K. Brian Kelley
@kbriankelley
October 3, 2009 at 5:36 pm
Viewing 15 posts - 421 through 435 (of 6,104 total)