Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Wrangler
Starting Member
35 Posts |
 Posted - 2011-09-23 : 10:35:33
|
| I backed up all the databases (system and user) then attempted an upgrade from SQL 2008 SP2 to SQL 2008 R2 but the upgrade failed with strange RPC errors. The users had installed a few applications on the development box and I think they caused the errors. So I uninstalled SQL 2008 SP2 and did a fresh install of SQL 2008 R2. When finished I realized I lost the logins and jobs.I tried restoring my backup of master on another test box that was the same version (SP2) and it restored fine but I couldn't get SQL Server to start up. I was getting a 11713 error.I restored the master as a regular database and I can query all the tables but don't know what to look for to find the logins. Are they gone for good or is there something I can do?Thanks, |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-09-23 : 11:26:05
|
| Are you able to query sys.syslogins in the regular version?That table will hold details of loginsJunior DBA learning the ropes |
 |
|
|
Wrangler
Starting Member
35 Posts |
Posted - 2011-09-23 : 12:38:38
|
| I can query sys.syslogins but it only returns one sql login and the application owner indicated he had about 15 so I wasn't sure. If that is the table then it looks like he might not be telling the truth. hmmm.Thanks. |
|
|
|
|
|
|
lost logins & jobs