.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Enterprise manager is not found in sql 2000!!!

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server


anybody knows about this.. EnterpriseManager is not display in SQL folder in startup windows. I tried for using run: mmc in that also there is no way to open..

View Complete Post

More Related Resource Links

unable to create new table in sql server 2000 enterprise manager on windows7(Operating system)

i have successfuly installed sql server 2000 on windows7 and i am able to browse all the tables and edit aswell(on enterprise manager) but i have a problem while creating new tables it says ' MMC has detected an error in a snap-in' and provides options to either continue with the error or send a report to microsoft ,   Please help regarding this compatibility issue   Thanks in advance !

SQL Server 2000 Enterprise Manager no longer displays DTS packages

SQL Server 2000 Enterprise Manager no longer displays DTS packages and the SQL Server Agent jobs that use the DTS packages now fail. The affected servers are running Windows Server 2003 SP2 and SQL Server 2000 SP4 and all update patches for both the OS and SQL Server. The DTS packages are ActiveX scripts that read data from a database table and output that data to a text file on the same server.  They include the database connection string and the SQL account used by the connection string has not changed. I've determined that the DTS packages still exist by trying to re-create them with the same name, but they don't appear in the Local Packages window and they no longer function when the scheduled job that uses then runs. The SQL Server Agent Job error is as follows: Executed as user: <server admin user account>. DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 11 (B) Error string: [DBNETLIB][ConnectionRead (recv()).] General network error. Check you network documentation. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context 0. Process Exit Code 1. The step failed. The job has working perfectly for the last 5 years, until about a week ago when it started failing. I have two other servers with the exact same configuration running the same DTS packages and job that still work and the DTS packages show up in Enterprise

SQL 2000 Enterprise manager

We have a SQL 2000 server that we are maintaining but the issue is we have upgraded our desktops to windows 7 64bit and the install we have does not work.  i have read in other forums that you can use enterprise manager from SQL2005 express to access and manage it but before i do that and mess up the entire DB i wanted to ask and see if they were correct.

"Logon failed. Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no def

When i attempt to fill my Crystal Report -named limitler.rpt and it is under the sub-folder Oraburslar of my project -, i get the following error; "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Error in File C:\DOCUME~1\KEMAL~1.ESM\LOCALS~1\Temp\limitler {148B6FE6-D5BE-4BC3-A13A-47CCCB79D78B}.rpt: Unable to connect: incorrect log on parameters." How can i handle this pro? Thanks in advance... Here is how i connect to database to fill the Crystal Report:string database = ConfigurationManager.AppSettings["Database"].ToString(); string password = ConfigurationManager.AppSettings["Password"].ToString();string username = ConfigurationManager.AppSettings["Username"].ToString(); string server = ConfigurationManager.AppSettings["Server"].ToString();ReportDocument report = new ReportDocument();report.Load(Server.MapPath("~/Oraburslar/limitler.rpt")); report.SetDatabaseLogon(username, password); CrystalReportViewer1.ReportSource = report; CrystalReportViewer1.BackColor = System.Drawing.Color.White;

SQL Server Enterprise Manager for SQL Server 2008



I need to install SQL Server Enterprise Manager to run with SQL Server 2008 to define the email settings which will help me to send email through transact sql. Can anyone any link from Microsoft to download ?

Also, Is there any other way to define settings for SQL Email which should not include any further installation with the current SQL Server 2008 ?


Sohaib Khan | http://muhskhac.spaces.live.com

SQL 2000 Enterprise Rollback


We have a problem with one of our live production systems which runs in SQL 2000 Standard.  The issue is relating to memory utilisation.  We are upgrading to SQL 2000 Enterprise this evening in order to increase memory from 2GB.  However I'm a little concearned as I'm not sure if (In case of major issues) we could revert the SQL 2000 Enterprise database back to SQL 2000 standard.


In theory we will not need to do this, but I need to understand if this is possible for our rollback position.


Any help would be greatfully appriciated.



Where is 'Change query type' (Enterprise manager) equivalent in the Management Studio


In sql server 2000 Enterprise manager, there was a ‘Change Query type’ icon and on clicking it, it gave you the option of changing the current query to a

Insert into
Insert From
Create Table

I can’t seem to find this in SQL Server Management Studio, does it exist somewhere or is there an equivalent way of doing it. Any help would be appreciated.




[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


trying to install sql server2005 on a windows 2003 server box.

getting msg below at the sql server .  i looked at other posts on trying to uninstall  SQL Native Access Client and norton antivirus.  i could never find the snac on the add - remove programs and this server does not have a virus protection program yet.

here's the history of the installs on the server:

wanted to test a 2005 upgrade so:

  1) installed sql server 2000 then sp4 then restored some databases to it - all OK

  2) tried to upgrade to sql 2005 but ran into problems and left it at that.

had a disk drive crash on the d drive so lost the installs but not the operating system

when the drive was replaced, left alone for a while

then wanted to test a straight 2005 install

  1) removed the broken 2005 attempt

  2) removed the 2000

  3) installed 2005 and got the error on the subject line:

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in S

Unable to find enterprise manager after installation....despite following msdn instructions...


I have installed SQL Server 2008 R2 Standard (32-bit)

I am unable to find enterprise manager after installation..

i have met all the requirements ...listed in the msdn
Hardware and Software Requirements for Installing SQL Server 2008 
Follwing is what i have on machine..

.NET Framework 3.5 SP1
 Microsoft Windows Installer 4.5 
Windows Xp sp3


Error 1706 - No valid source could be found for product Visual Studio.NET Enterprise Architect 2003


Error 1706 -  No valid source could be found for product Visual Studio.NET Enterprise Architect 2003 - English.

The Windows installer connot continue.

-----This error occured while Build Solution of my Window Service project created to export data from xml file to sql server database.

Please help me regarding this.Thanks for everyone of you.


SSRS 2000 report not able to show any data in ie6 and ie7 although found working in ie8 and firefox


we have a SSRS report which was working till few weeks backs on all the ie and started to show Diagnose the Internet connection error on ie6 and permission denied on ie7. although the report is running fine on ie8 and firefox with same security settings. There has been no recent changes done to the report. tried it through fiddler but gives a 200 status for http. IS also connecting to URL and is making connect to the DB. HAve tried to check the script and activex settings also and found nothing absurd which can stop the functionality.I have tried reducing the security to low also but with success. Can someone please help.

sql 2000 Enterprise RTM upgrade to 3a



We plan to upgrade existing sql server enterprise 2000 RTM to SP3a(Chinese Traditional). Since we want to keep all the data after upgrading, can we use the original database backup(RTM) and restore to new version(Sp3a) without any error?

P.S: The RTM database backup have only basic item such as table, storeproc, index, without any replication items.

Thanks and regards,




[Microsoft][ODBC Driver Manager] Data Source name not found and no device driver specified

I get the above error message when running my VB6 sp4 application on a new Win7 workstation (32 bit machine). The app runs fine on a WIn xp sp3 workstation. The app does require a DSN setup in the ODBC section and I setup the SQL connection the same as I do on an XP machine. I also test the connection on the WIN & machine and it "test successfully". After the error above the app returns a runtime error -2147467259 (80004005). I am attaching my connection string:
Connection string being used by ADO Data Control (part of VB6):
Any help would be appreciated.


How can I hide the SQL instance from appearing in Enterprise Manager > connect > Network servers lis


I can find all sql instances in the network in Enterprise Manager > connect > Network servers list.

How can I hide my instances to appear in the list or in the network?


Config Manager gives error "The specified module could not be found. [0x8007007e]"

I've been using SQL Server 2008 Express Edition on my development pc for several months now.  It has recently started giving me an error when I attempt to run the SQL Server Configuration Manager  (SQLServerManager10.msc).  I have uninstalled completely and reinstalled twice which has not solved the problem.  I can run the Management Studio just fine and everything works, I just can't run the Configuration Manager which is an issue.

Full error message is as follows:

Cannot connect to WMI provider.  You do not have permission or the server is unreachable.  Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
The specified module could not be found. [0x8007007e]

I have tried the workaround listed here: https://connect.microsoft.com/SQLServer/feedback/Workaround.aspx?FeedbackID=443459 however I did not have a sqlmgmproviderxpsp2up.mof file in my local install.  I copied the one from my production installation and ran the mofcomp.exe program successfully but it did not solve the issue.

How to run eglobal.sql on SQL Server Enterprise 2000



In Project Server 2007 running with SQL Server, there is a script "eglobal.sql" which generates the file "Enterprise Global" :

C:\Program Files\Microsoft Office Servers\12.0\Sql\Project Server\CORE\1033\eglobal.sql.

 But when I tried to load it in one of my servers with SQL Server 2000 (I didn't tried on SQL Server 2005), I got the error message:
"The file ....CORE\1036\eglobal.sql contains a long row, which exceed the 64 K limit."
So, how to run this script?

Thanks for your help

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend