Showing posts with label toa. Show all posts
Showing posts with label toa. Show all posts

Sunday, March 11, 2012

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