RE: FN-FORUM: Sql server problems

date posted 1st August 2005 22:35

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)=20

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