Login deleted help me? urgent - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Author

Topic

jooorj
Posting Yak Master

126 Posts

Posted - 2011-07-02 : 10:33:43

when I generate script for database
and then I include script logins
then I run the script, all logins were deleted.
and the script stoped suddenly.
plz help me , how to restore login for sql server 2008 ,,, plz

jooorj
Posting Yak Master

126 Posts

Posted - 2011-07-02 : 18:59:42

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-02 : 19:13:29

Restore your master database to get the logins back, otherwise recreate them using the users in each database and use new passwords.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

jooorj
Posting Yak Master

126 Posts

Posted - 2011-07-12 : 03:20:34

Howw
I am not able to log , how can I restore Master DATA BASE...
I need to login firstly..
many bugs in sql server 2000 to 2008
I am repentant because I did not use Oracle.

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2011-07-12 : 08:10:17

We are also repentant that you did not use Oracle.

You have not stated ONE BUG with SQL Server, you have only shown that you have no clue how to use it.
The experts are TRYING to help, but you are having trouble understanding what they are explaining.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-07-12 : 08:36:44

The logins are not gone, your script just changed the password with another one.
See in the script which password that now is associated with your login.

N 56°04'39.26"
E 12°55'05.63"

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-07-12 : 08:49:05

quote:
Originally posted by jooorj

many bugs in sql server 2000 to 2008

You know, it's a poor workman who always blames his tools.

Thousands of people have done successfully what you're having trouble with. Why don't you just admit that you don't know how to do it and get help, rather than blaming the tools constantly?

Blaming others doesn't help you learn to do it right.

Post the script that you initially ran and maybe someone can figure out what you did.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources