Re: FN-FORUM: Sql server problems

date posted 1st August 2005 23:20

OK - thanks - I will try reinstalling the tools in the morning. Reinstalling
sql server itself earlier today didn't sort it out. They both have Window
authentification only at the moment which works for one but not the other.


Pam



----- Original Message -----
From: "Andy Macnaughton-Jones" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Monday, August 01, 2005 11:10 PM
Subject: RE: FN-FORUM: Sql server problems


>
> I'd suggest reinstaling the SQL server tools on both machines. You
> shouldn't really need to have sql server tools on both machines - just
> have them on the master machine and connect that way. You might need to
> set up both machines to allow both windows and sql server logins and
> then create a sys admin type login for both (you could use the sa
> account if they're just local)
>
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of PAMELA
> WHITTAKER
> Sent: 01 August 2005 23:04
> To: Andy Macnaughton-Jones
> Subject: Re: FN-FORUM: Sql server problems
>
>
> How can I tell and how can I see what the permission are and change
> them? I am pretty sure you right as I can't access remote sql servers
> either. I also get "snap in failed to initialise" followed by a clsid
> number for local users and groups when I access computer management in
> the control panel. I don't know if that is part of the same problem but
> I haven't a clue how to find out why. Google hasn't been any help.
>
>
> Pam
>
>
>
> ----- Original Message -----
> From: "Andy Macnaughton-Jones" [EMAIL REMOVED]
> To: [EMAIL REMOVED]
> Sent: Monday, August 01, 2005 8:24 PM
> Subject: RE: FN-FORUM: Sql server problems
>
>
>>
>> You're probably using windows security to authenticate them and one
> has
>> permissions that the other doesn't.
>>
>> Not sure if you can switch to SQL authentication for the little start
> /
>> stop applet, but yuou can certainly connect using Enterprise manager
> and
>> start / stop them.
>>
>> -----Original Message-----
>> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of
> PAMELA
>> WHITTAKER
>> Sent: Monday, August 01, 2005 7:33 PM
>> To: Andy Macnaughton-Jones
>> Subject: FN-FORUM: Sql server problems
>>
>>
>> I have SQL server on both my Pc's which are attached to each other
> with
>> a cross over cable. On my back up PC I can restart both servers but on
>> my main PC I can only restart the one on that Pc. If I try and restart
>> the one on my Back up PC I get Access denied. Why and how do I get
>> access please.
>>
>>
>> Thanks
>> Pam
>>
>>
>> --
>> Freelancers, contractors earn more with Prosperity4 Call 0870 870 4414
>> or visit www.prosperity4.com and benefit from Inland Revenue approved
>> expenses today.
>>
>> To advertise here: http://www.freelancers.net/advertising.html
>>
>>
>> --
>> Freelancers, contractors earn more with Prosperity4
>> Call 0870 870 4414 or visit www.prosperity4.com
>> and benefit from Inland Revenue approved expenses today.
>>
>> To advertise here: http://www.freelancers.net/advertising.html
>>
>>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>