Viewing 15 posts - 31 through 45 (of 136 total)
Roy Ernest (10/1/2009)
Then the normal users will not be able to connect to the DB V-LAN with their excel and access.
But we all know the users have got to connect...
October 1, 2009 at 7:20 am
It is probably poor practice, but though we keep our complex sa passwords secure, we tend to connect as sa to do a lot of DB Admin. It seems...
October 1, 2009 at 4:36 am
Nice catch - I should have checked: it uses CREATE LOGIN and turns off checking for null passwords. Though I would still rather correct that situation than leave...
August 13, 2009 at 9:38 am
dmw (7/29/2009)
You seem to be encouraged to have just one database instance and therefore one database per server.
Irrespective of the solutions being suggested, and with only occasional exposure to Oracle,...
August 13, 2009 at 8:11 am
I haven't done a migration from 2K to 2K5, so I'm speculating: perhaps the 2K5 server security policy will not accept a NULL password.
Just to get the accounts transferred, you...
August 13, 2009 at 2:32 am
RML51 (8/5/2009)
We had this same problem with log (.txt) files, and never did find a solution.
There was a bug until an SP2 hotfix. But it should be OK in...
August 6, 2009 at 2:59 am
Null password? sp_help_revlogin includes
ELSE BEGIN -- SQL Server authentication
IF (@binpwd IS NOT NULL)
BEGIN...
August 6, 2009 at 2:45 am
I reluctantly admit that face-to-face meetings have side-benefits in terms of getting to know people in coffee and lunch breaks. But most of my meetings are internal to the...
July 21, 2009 at 7:14 am
opc.three (7/8/2009)
sigh
I take it you are still hoping to get back to the question of existing research into what works better. Well, I suggested linguistics/language studies; you might look...
July 8, 2009 at 8:43 am
Lynn Pettis (7/8/2009)
July 8, 2009 at 7:29 am
With 2000 you can do that in the Security tab of SQL Enterprise Manager, though as I recall you can set the accounts per service directly in the computer Services...
July 1, 2009 at 7:38 am
river (7/1/2009)
can i use the same domain account for all the services of this two instances?
Works for me, though in my case one is 2000 and one is 2005. ...
July 1, 2009 at 4:57 am
What I thought was the best guidance I saw (it must have been up here somewhere) was to observe usage to estimate tempdb required, divide this equally between the files...
June 29, 2009 at 3:57 am
AlexSQLForums (6/19/2009)
it's probably 64 bit cause you cant have 8GB of RAM on a 32 bit system max is 4GB.
Sure you can. The post says SQL Server 2005 Enterprise...
June 25, 2009 at 2:21 am
So Henry VIII applied a dissolution solution?
And what the financial crisis needs is a liquidity solution??
I think I'm getting the hang of this - management beckons...
June 12, 2009 at 11:31 am
Viewing 15 posts - 31 through 45 (of 136 total)