Viewing 15 posts - 7,291 through 7,305 (of 9,253 total)
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...
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...
January 30, 2011 at 10:56 am
no, he just needs to find out what is using the single user connection and kill it
January 30, 2011 at 9:09 am
are you using windows 2003 or windows 2008?
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:...
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?
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....
January 29, 2011 at 5:42 pm
You don't create accounts you add existing windows accounts into the sysadmin role.
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)...
January 29, 2011 at 12:53 pm
SQL Dude-467553 (1/28/2011)
By default a new install adds local admins as sysadmins in SQL Server
Not in SQL Server 2008 it doesn't!
Vadon, during the installation you would have run through the...
January 29, 2011 at 12:18 pm
dan-572483 (1/26/2011)
However, this VM run...
January 28, 2011 at 8:15 am
when sql server is in single user mode you can only restore the master database!
single user mode is initiated by the following commands
sqlservr -m
sqlservr -f -T3608
Copy the tempdb files to...
January 28, 2011 at 4:18 am
am i correct in saying that you have deleted the model.mdf and model.ldf?
My bad, the only database that can be restored in single user mode is the master database. If...
January 28, 2011 at 3:50 am
\binn>sqlservr.exe -c;-m
This is not correct, it should be
\binn>sqlservr.exe -c -m
January 28, 2011 at 3:32 am
Hi
The command you need is
sqlservr.exe -c -m
Go to the DOS prompt and change directory to the Binn folder where SQL server is installed and run the command above. once...
January 28, 2011 at 12:26 am
Viewing 15 posts - 7,291 through 7,305 (of 9,253 total)