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 |
|
chrisbarrett
Starting Member
5 Posts |
 Posted - 2007-10-05 : 07:09:23
|
| Dear All,We've had SQL2000 running on windows 2003 server quite happily for a number of months now but all of a sudden today we're not able to connect to the datase from the asp.On opening Enterprise manager to look at the database then when we drill down into Local then we're getting a "Login failed" error, and so can't see any databases.SQL is set up to use windows logon information and was working quite happily.I'm using Enterprise logged on as Windows Adminstrator .. Any help would be greatly appreciated .. it's kind of frustrating !!!many thanks in advanceChrisps: the windows administrator password WAS changed about a week ago by ops apparently ... although I have now changed it back to previous password, but at present I still can't get to databases in EM, or SQL Query ...Any suggestions how I can get back in??? |
|
|
chrisbarrett
Starting Member
5 Posts |
Posted - 2007-10-05 : 07:19:32
|
| Exact error message I get is:"A connection could not be established to (local)Reason: login failed for user GIBTELECOM_WEBS\Administratorplease verify SQL Server is running and check your SQL server registration properties by right clicking on (local node) and try again"If I right click on local node and edit registratio properties I am using windows authentication, which is what I wantedAny thoughtskrChris |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-06 : 00:14:27
|
| Replace local with host name then try again. |
|
|
|
chrisbarrett
Starting Member
5 Posts |
Posted - 2007-10-06 : 15:22:26
|
| Hi rmiao,Thanks for input .. have tried that and to no avail ..I have though managed to make mdf and ldf files off system and attach to another installation ..Which has brought to light another problem, manely all user tables have been deleted .... so I think we can put the original error down to malicious access |
|
|
|
chrisbarrett
Starting Member
5 Posts |
Posted - 2007-10-06 : 15:32:36
|
| Can I change this question please .. getting the userid wouldn't help as the user tables have been dropped (see post above :-( )So the scenario now is that userids won't help, what I need to do is re-create the database.I have the ldf file (and obviously the mdf) but I ALSO have the backup that was used to create the database originally (via a restore).So logically the original backup plus the ldf should give me my new database I think.The only problems are:a) the original backup was from a different databaseb) I don't want to apply all transactions in the ldf, just up until a series of table dropsIs this possible ... I have tried using restore and stop at, but so far with no luck ...thanks in advanceChris |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-06 : 19:57:46
|
| You can restore db from backup or reattach db with db files, but not mixed up. Couple of questions to understand your issue:1. is GIBTELECOM_WEBS domain name or host name?2. what's host name of sql instance?3. what's sql instance name?4. is GIBTELECOM_WEBS\Administrator valid sql login?5. what's your real problem now? |
|
|
|
chrisbarrett
Starting Member
5 Posts |
Posted - 2007-10-06 : 20:17:32
|
| OK, problem solved .. have managed to rebuild a copy of database.In essence the fundamental problem seems to have been a security issue, which led to all the user tables being dropped maliciosly.Luckily we had the ldf, and mdf but unforunatley no complete backup at all, so nothing to base it forward from.Did, though, have the backup used to create the database in the first place, but this was off a different machine and so I couldn't get them to combine together.Solution was SQL Log Rescue from www.red-gate.com ... so in case this ever happens to anyone else, what I did (on another machine was)1) re-attach mdb/ldf to a database (A)2) restore to another database (B) the backup from another machine used to create (A) many moons ago ..3) use SQL Log Rescue on database A BUT point it at the full backup used in 2) 4) select to reapply all transactions up before the drop's5) create script and then apply it to database BSo effectively I got a script to take B and convert it to AI did try some other tools but they couldn't cope with this scenario, SQL Log Rescue was actualy free and did manage this scenario ...The only problem if you want to do this and have no complete backup of any kind is that it wants one ....But it would mean that even if you had an only dev copy of a database then there would be a good chance you might get something back .. which might be better than nothing.Anyway, thanks for you helpChris |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2007-10-10 : 14:16:11
|
| I'm curious. Was this a SQL injection attack? |
|
|
|
|
|
|
|
|
Enterprise Manager Can't Open Local Database Group