Viewing 15 posts - 7,276 through 7,290 (of 9,244 total)
also what operating system are you using on the machine you are installing sql server on to
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2011 at 1:00 pm
nadabadan (1/31/2011)
If the data is constantly changing as the OP stated, using snapshots on mirrored dbs would not be a good idea.
the OP doesn't actually state that anywhere, but, it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2011 at 12:57 pm
Details will be provided in the setup log, it gives you the path and filename to this log on the failure screen
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2011 at 7:11 am
vadon97
This time, I took note of my settings on the Server Configuration->Service Accounts tab, I had NT AUTHORITY\SYSTEM designated for the Server Agent, Server Database Engine, and SSIS.
This is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2011 at 1:06 am
you could mirror the database and then take regular snapshots of the mirror to allow users to read data
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2011 at 2:03 pm
regardless of the utility, once you restore the database 'WITH RECOVERY' no further backups may be applied!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2011 at 1:25 pm
start the sql server instance from the command prompt in single user mode. Open a second command prompt and connect to the instance using SQLCMD
sqlcmd -Sinstancename
Reset the password using
alter login...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2011 at 1:22 pm
do not startup the instance in single user mode by adding -m or -f to the startup options for the SQL Server service itself. You should stop all services, open...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2011 at 10:56 am
no, he just needs to find out what is using the single user connection and kill it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2011 at 9:09 am
are you using windows 2003 or windows 2008?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2011 at 8:22 am
vadon97 (1/29/2011)
2011-01-28 16:03:58.06 Logon Login failed for user 'HPXP1\AG'. Reason:...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2011 at 6:21 am
Oberion (1/28/2011)
high availability, clustering, and database mirroring.
although mirroring only support synchonous mode in high safety.
Enterprise mainly offers online features, in most cases standard is fine. what features do you need?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2011 at 7:29 pm
How are you starting SQL server single user mode. What command are you using?
Honestly I wouldn't mess with single user at this time you do not have the experience....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2011 at 5:42 pm
You don't create accounts you add existing windows accounts into the sysadmin role.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2011 at 1:46 pm
vadon97 (1/29/2011)
Perry, on the Account Provisioning tab, I selected Mixed Mode. Any more ideas as to what I can do to log in? Thanks a lot!
Which windows account(s)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2011 at 12:53 pm
Viewing 15 posts - 7,276 through 7,290 (of 9,244 total)