Re: urgent help with sql
From: bassem (anonymous_at_discussions.microsoft.com)
Date: 05/30/04
- Next message: cpchan: "Could not Re-index !"
- Previous message: Bassem: "Re: urgent help with sql"
- Maybe in reply to: Bassem: "urgent help with sql"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 30 May 2004 01:48:36 -0700
what's weird that evry thing is working fine from the sql
query analyser, about the client SP3 i tried from client
with or without it and same, i was thinking to rebuild the
registry , but not sure if this will cause more damage at
least things still working and i do administration
throught the query, but i will try this MDAC may be? any
other suggestion?
Regards,
>-----Original Message-----
>Hi,
>
>First Un Register and Reregister the SQL server in
Enterprise manager. If
>the problem is still theren then,
>
>Second- Can you install SP3 or 3a in the client machine
you are having
>issues.
>
>If you still have issues try updating the latest MDAC.
you can download the
>latest MDAC from
> http://msdn.microsoft.com/data/Default.aspx
>
>
>Note:
>How many database you have in your server.If you have a
large count of
>databases and if the Auto close option
>is checked you will get this type of issues. If Auto
close options is
>checked please uncheck and try opening.
>
>Did you check the other options like management /
Security .....in
>enterprise manager?
>
>Thanks
>Hari
>MCDBA
>
>
>"Bassem" <anonymous@discussions.microsoft.com> wrote in
message
>news:150ff01c44611$48429d10$a301280a@phx.gbl...
>> i am using windows auth, and it have no problem with
auth
>> at all as i explained i can access all the databases
>> throught the query analyzer, and the service is running
of
>> course because the user have no problem with the
>> application and i have no problem with query analyzer,
but
>> it is just the enterprise manager that show nothing,
while
>> from teh same server i connect throught the same
>> enterprise to a different sql and it is fine?
>>
>>
>> >-----Original Message-----
>> >U are using Windows Auth or SQL Auth?
>> >
>> >If Windows Auth then it should show up.
>> >If you are using SQL Auth, you should reconnect.
>> >
>> >Check the Service Account with which MSSQLSERVER
service
>> is running.
>> >
>> >If your windows account is different from the one
present
>> over there, then
>> >give access permissions to data and log files folder to
>> ur Windows account.
>> >
>> >--
>> >Ganesan Subramanian
>> >Microsoft Technologies and Solutions
>> >
>> >
>> >"Bassem" <anonymous@discussions.microsoft.com> wrote in
>> message
>> >news:14f8401c44607$d8ed9220$a401280a@phx.gbl...
>> >> Dear All
>> >>
>> >> i cannot view any databases under the enterprise
manager
>> >> (it just say no item) while i can see the databases
from
>> >> the query analyser, i restarted the server and the
same,
>> >> the users are working fine and i can acess the
databases
>> >> from the application to any idea?
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: cpchan: "Could not Re-index !"
- Previous message: Bassem: "Re: urgent help with sql"
- Maybe in reply to: Bassem: "urgent help with sql"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
