RE: MSSQL 7 Emergency

Wed, 23 Mar 2005 17:09:51 -0800

thanks, it put the user in without a password; now to get the restores to attach and work.


At 06:39 PM 3/23/2005 -0600, you wrote:

sp_addlogin @loginame = 'bob', @password = 'bobsstupid', defdb =
'ilikethisdb'

Or do it through enterise manager security, or look in BOL under 'users'

Jacob

Jacob Cameron
Blue Lantern, Inc.
(972) 226-9595
[EMAIL PROTECTED]
http://www.blue-lantern.com

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of [EMAIL PROTECTED]
Sent: Wednesday, March 23, 2005 6:20 PM
To: [email protected]
Subject: RE: MSSQL 7 Emergency

I cannot seem to put my finger on where I resetup my sql user logins... I
have the repair complete and sql starts but I need to then connect... I am
using the sql login not nt user login.

thanks.



At 05:34 PM 3/23/2005 -0600, you wrote:

>I, fortunately, have never been in that situation. AFAIK, you will lose
>your SQL user logins, permission settings and some other things. You
>can still restore your databases individually.
>
>
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Behalf Of [EMAIL PROTECTED]
>Sent: Wednesday, March 23, 2005 4:59 PM
>To: [email protected]
>Subject: RE: MSSQL 7 Emergency
>
>
>Looking for it; what if I cannot find ?
>
>At 04:53 PM 3/23/2005 -0600, you wrote:
>
> >Do you not have a backup of the master DB??
> >
> >
> >-----Original Message-----
> >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> >Behalf Of [EMAIL PROTECTED]
> >Sent: Wednesday, March 23, 2005 4:36 PM
> >To: [email protected]
> >Subject: OT: MSSQL 7 Emergency
> >
> >
> >All,
> >
> >Having a 5 alarm fire:
> >My master log file (ldf) has gotten corrupted and now the SQL Server
> >will not restart leaving a ton of databases unaccessable.
> >
> >I guess that I have to reinstall... correct ???
> >
> >Will this not delete any databases that are present?
> >
> >Precautions, Hints, Etc. Appreciated.
> >
> >Bob Coalter
> >InterNet Partners
> >
> >
> >--
> >No virus found in this outgoing message.
> >Checked by AVG Anti-Virus.
> >Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005
> >
> >----------------------------------------------------------
> >To post, send email to [email protected] To unsubscribe:
> >    http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
> >To subscribe:
> >    http://www.dfwcfug.org/form_MemberRegistration.cfm
> >
> >
> >
> >
> >
> >----------------------------------------------------------
> >To post, send email to [email protected] To unsubscribe:
> >    http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
> >To subscribe:
> >    http://www.dfwcfug.org/form_MemberRegistration.cfm
> >
> >
> >
> >
> >--
> >No virus found in this incoming message.
> >Checked by AVG Anti-Virus.
> >Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005
>
>
>
>--
>No virus found in this outgoing message.
>Checked by AVG Anti-Virus.
>Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005
>
>----------------------------------------------------------
>To post, send email to [email protected] To unsubscribe:
>    http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
>To subscribe:
>    http://www.dfwcfug.org/form_MemberRegistration.cfm
>
>
>
>
>
>----------------------------------------------------------
>To post, send email to [email protected] To unsubscribe:
>    http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
>To subscribe:
>    http://www.dfwcfug.org/form_MemberRegistration.cfm
>
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005

----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
   http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
   http://www.dfwcfug.org/form_MemberRegistration.cfm




----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
   http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
   http://www.dfwcfug.org/form_MemberRegistration.cfm




--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005




--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005

----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm

Reply via email to