Enterprise manager problem

hi, i've just installed sql server2000 on my home pc, im using to connect to
a sql server at my work. My query analyser works fine, but enterprise manger
seems to freeze and ultimatly not respond when i try to open the data base
folder, I downloaded that latsest server packs, but evey time i rry to run
them I get a PackageForTheWeb error.
My home computer is using xp pro
im new comer to sql server, so if u have any suggestions please give like ur
explaining to a complete novice.
Thanks guysTry adjusting your connection parameters -- try SQL Server authentication
credentials or Windows credentials. I would say go into SQL Client Network
utility, but I don't know what more that would offer when Query Analyzer
connects.
The one other thing to check is your version of ADO (look at properties for
c:\program files\common files\system\msado\msado15.dll). If it is less than
2.6 or 2.7, you might want to go to http://www.microsoft.com/ado and
grabbing the MDAC 2.8 release.
****************************************
*********
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
This posting is provided "as is" with
no warranties and confers no rights.
****************************************
*********
"airwalker" <airwalker@.discussions.microsoft.com> wrote in message
news:1BB646CB-0EB7-4B70-9AC7-59538924B1E4@.microsoft.com...
> hi, i've just installed sql server2000 on my home pc, im using to connect
> to
> a sql server at my work. My query analyser works fine, but enterprise
> manger
> seems to freeze and ultimatly not respond when i try to open the data base
> folder, I downloaded that latsest server packs, but evey time i rry to run
> them I get a PackageForTheWeb error.
> My home computer is using xp pro
> im new comer to sql server, so if u have any suggestions please give like
> ur
> explaining to a complete novice.
> Thanks guys

Enterprise manager problem

hi, i've just installed sql server2000 on my home pc, im using to connect to
a sql server at my work. My query analyser works fine, but enterprise manger
seems to freeze and ultimatly not respond when i try to open the data base
folder, I downloaded that latsest server packs, but evey time i rry to run
them I get a PackageForTheWeb error.
My home computer is using xp pro
im new comer to sql server, so if u have any suggestions please give like ur
explaining to a complete novice.
Thanks guys
Try adjusting your connection parameters -- try SQL Server authentication
credentials or Windows credentials. I would say go into SQL Client Network
utility, but I don't know what more that would offer when Query Analyzer
connects.
The one other thing to check is your version of ADO (look at properties for
c:\program files\common files\system\msado\msado15.dll). If it is less than
2.6 or 2.7, you might want to go to http://www.microsoft.com/ado and
grabbing the MDAC 2.8 release.

*************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
This posting is provided "as is" with
no warranties and confers no rights.
*************************************************
"airwalker" <airwalker@.discussions.microsoft.com> wrote in message
news:1BB646CB-0EB7-4B70-9AC7-59538924B1E4@.microsoft.com...
> hi, i've just installed sql server2000 on my home pc, im using to connect
> to
> a sql server at my work. My query analyser works fine, but enterprise
> manger
> seems to freeze and ultimatly not respond when i try to open the data base
> folder, I downloaded that latsest server packs, but evey time i rry to run
> them I get a PackageForTheWeb error.
> My home computer is using xp pro
> im new comer to sql server, so if u have any suggestions please give like
> ur
> explaining to a complete novice.
> Thanks guys

Enterprise manager

hi,i have a SQL server2000,there are some databases on the
server,what I try to achieve is to limit access of each
user. When they log into the server through "Enterprise
manager", they can only view their own database but not
all of them on the server.
thanksYou cannot limit the databases that a user sees through EM. If you want to
do this then you will have to roll your own using something like SQLDMO.
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"pfx" <panfx@.bizcn.com> wrote in message
news:007501c33f80$561e5ca0$a001280a@.phx.gbl...
> hi,i have a SQL server2000,there are some databases on the
> server,what I try to achieve is to limit access of each
> user. When they log into the server through "Enterprise
> manager", they can only view their own database but not
> all of them on the server.
> thanks