Viewing 15 posts - 196 through 210 (of 541 total)
Did the server failover?
October 12, 2011 at 7:42 am
vprunic (9/26/2011)
September 26, 2011 at 11:12 am
I think it was -b or -V one of them or both of them are useful.
In help "SQLCMD -?" you can find out which one to use.
September 16, 2011 at 2:20 pm
Is your SQL Agent domain account in local admin group of the secondary server?
September 16, 2011 at 12:00 pm
You can use this Database Mirroring Troubleshooter CLICK HERE
August 30, 2011 at 12:18 pm
Vertigo44 (8/30/2011)
Why is the error trying to use mydomain\the SQL Server Agent...
August 30, 2011 at 10:43 am
If you have sql statements from that vendor app drop all those NC indexes and recreate only the ones you need.
August 26, 2011 at 8:25 am
are you using a load balancer?
August 17, 2011 at 12:17 am
Yes it works but it's safer to have SysAdmins do it.
Download tokensz.exe Tokensz.exe to find out your max size.
and then follow directions from above.
August 16, 2011 at 2:36 pm
You should check with your SysAdmins before making these changes.
17832:
The SQL Server computer was unable to process the client login packet. This may be because the packet was created improperly...
August 16, 2011 at 1:37 pm
Right click on Login >>>Delete.
Right click on Security >>>New>>>Login...Uncheck "User must change password at next login"
Choose authentication mode windows or SQL.
Select Default Database
Check serveradmin from Server Roles.
Click OK
August 5, 2011 at 9:52 am
nocode99 (8/5/2011)
GSquared (8/5/2011)
August 5, 2011 at 8:41 am
Marty
In policy management I think you can setup facet for "user must belong to a group" or something similar.
August 4, 2011 at 9:01 am
You can add AD groups in SQL Server
For multi server execution you can setup a SQLCMD script Multi-Server Execution
August 3, 2011 at 9:16 am
Viewing 15 posts - 196 through 210 (of 541 total)