SQL Server 2000 Service Pack 4
Client is using XP Service Pack 1
When the user opens the database folder in EM no databases appear. However,
I have XP Service Pack 1 and I can see all the databases. The difference is
I am a SysAdmin.
Has anyone seen this before. I had the client install SQL sp 4 on his
workstation.System or user-defined databases? System databases can be hidden in the
registration properties. Does the user have permissions to the user-defined
databases (i.e., a database user account)?
HTH
Jerry
"T Man" <TMan@.discussions.microsoft.com> wrote in message
news:BF678997-E93D-4FC4-8AE2-1451136068AA@.microsoft.com...
> SQL Server 2000 Service Pack 4
> Client is using XP Service Pack 1
> When the user opens the database folder in EM no databases appear.
> However,
> I have XP Service Pack 1 and I can see all the databases. The difference
> is
> I am a SysAdmin.
> Has anyone seen this before. I had the client install SQL sp 4 on his
> workstation.|||All databases, we did further checking if we give sysadmin privalages to the
user they can see the databases. I also found out this issue occurred
earlier and another DBA resolved the issue with a reboot of the sql server.
THis time a reboot did not work. I verified the user has access to his
default database on the server
"Jerry Spivey" wrote:
> System or user-defined databases? System databases can be hidden in the
> registration properties. Does the user have permissions to the user-defined
> databases (i.e., a database user account)?
> HTH
> Jerry
> "T Man" <TMan@.discussions.microsoft.com> wrote in message
> news:BF678997-E93D-4FC4-8AE2-1451136068AA@.microsoft.com...
> > SQL Server 2000 Service Pack 4
> > Client is using XP Service Pack 1
> >
> > When the user opens the database folder in EM no databases appear.
> > However,
> > I have XP Service Pack 1 and I can see all the databases. The difference
> > is
> > I am a SysAdmin.
> >
> > Has anyone seen this before. I had the client install SQL sp 4 on his
> > workstation.
>
>|||Have you tried deleting and re-registering the SQL Server?
"T Man" <TMan@.discussions.microsoft.com> wrote in message
news:447CCB04-487E-43AF-93F7-F5E4DF058E1F@.microsoft.com...
> All databases, we did further checking if we give sysadmin privalages to
> the
> user they can see the databases. I also found out this issue occurred
> earlier and another DBA resolved the issue with a reboot of the sql
> server.
> THis time a reboot did not work. I verified the user has access to his
> default database on the server
> "Jerry Spivey" wrote:
>> System or user-defined databases? System databases can be hidden in the
>> registration properties. Does the user have permissions to the
>> user-defined
>> databases (i.e., a database user account)?
>> HTH
>> Jerry
>> "T Man" <TMan@.discussions.microsoft.com> wrote in message
>> news:BF678997-E93D-4FC4-8AE2-1451136068AA@.microsoft.com...
>> > SQL Server 2000 Service Pack 4
>> > Client is using XP Service Pack 1
>> >
>> > When the user opens the database folder in EM no databases appear.
>> > However,
>> > I have XP Service Pack 1 and I can see all the databases. The
>> > difference
>> > is
>> > I am a SysAdmin.
>> >
>> > Has anyone seen this before. I had the client install SQL sp 4 on his
>> > workstation.
>>
