Viewing 15 posts - 7,186 through 7,200 (of 9,244 total)
The following will get you login names, SIDs and hashed passwords
select name, sid, password_hash from sys.sql_logins
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 3, 2011 at 1:19 pm
check the sql server log again carefully, if the backup command failed it will be in there!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2011 at 3:07 pm
if all the instances are registered under a SQL Server 2008 central management instance use the following query to add the group and assign sysadmin privileges
CREATE LOGIN [domain\group] FROM WINDOWS
EXEC...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2011 at 2:45 pm
the virtual network name already exists, ping it and see if it replies.
If it doesn't and to proceed and use this network name, delete the computer account from AD and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2011 at 2:39 pm
Group or application it amounts to the same thing. Either way I would do what I posted above 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2011 at 5:25 pm
for XP Home, boot into safe mode to set share\folder permissions via the share and security tabs and then reboot normally
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2011 at 5:09 am
are you attempting to add a node to an existing clustered instance of sql server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2011 at 4:15 am
AK1516 (3/31/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2011 at 3:54 am
what port numbers have you assigned to the mirroring endpoints on the principal and mirror instances
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2011 at 3:48 am
Brandie Tarvin (3/30/2011)
I appreciate the help you're trying to give me, but you're giving advice based on incorrect assumptions about my setup. This might be because I'm not stating it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 31, 2011 at 11:27 am
A database that is set as read_only is exactly that, can only be read no backups may be rstored. To write to the database you would need to perform
ALTER DATABASE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 31, 2011 at 11:02 am
annasql (3/31/2011)
But we use that the same service account on another server,
yes and that wil be fine, the service account is only disabled for use inside the sql server instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 31, 2011 at 10:44 am
launch the service pack installer and install on each passive node. Once this is done, Fail over the active node so it becomes passive and patch that.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 31, 2011 at 10:42 am
Hi
i use BCP to dump syslogins to a file, copy it to DR server and then import
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 31, 2011 at 10:32 am
annasql (3/30/2011)
see http://msdn.microsoft.com/en-us/library/ms345578.aspx
But we do want to keep the old login for other server's access. How can we make this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 31, 2011 at 10:29 am
Viewing 15 posts - 7,186 through 7,200 (of 9,244 total)