Re: FN-FORUM: Sql server problems

date posted 1st August 2005 22:28

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
>
>