|
|
 |
Re: FN-FORUM: Sql server problems
date posted 2nd August 2005 11:36
No - it just says access not allowed.
Pam
----- Original Message -----
From: "Andy Macnaughton-Jones" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Tuesday, August 02, 2005 12:08 AM
Subject: RE: FN-FORUM: Sql server problems
>
> Does it give you an error liks SSPI authentication failed ?
>
> If so I get that if the laptop downstairs has been in hibernation or
> been suspended and hten restarted wtihout loigging back into the domain
> so it looses any security credentials it has with the database. Stuff
> like outlook isn't affected, just SQL Server - it's a pain cos I then
> have to restart windows to re-force a login.
>
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of PAMELA
> WHITTAKER
> Sent: Monday, August 01, 2005 11:56 PM
> To: Andy Macnaughton-Jones
> Subject: Re: FN-FORUM: Sql server problems
>
>
> 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
>>
>>
> --
> 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
>
> |
|
|
