Enterprise Manager Appears To Slow My Dial Up Connection
Jul 23, 2005
I am using a dial up connection to the Internet and to an online SQL
Server database.
I have a problem in that when I use Enterprise Manager to access even
my local server , or even, it appears, when it is just open with no
connection to any SQL Server, I experience very slow data transfer
over my normal dial up connection.
I am reasonably sure it is Enterprise Manager causing the problem as
when I close it and redial I have an acceptable rate of data transfer
using my dial up connection.
Can anyone:
a. support my conclusion that Enterprise Manager is the probable
cause of the slow connection.
b. suggest a solution
Best wishes, John Morgan
View 1 Replies
ADVERTISEMENT
Sep 9, 2004
I have had a problem with Enterprise Manager connecting to SQL Server. At first this problem was experienced with one particular network user... whichever PC he logged onto, Enterprise Manager took ages to connect to SQL Server and every operation was painfully slow. Creating a new Windows NT logon fixed the problem.
I now have this same problem but only on my PC. It doesn't matter which Windows NT logon I use, using Enterprise Manager is painfully slow. I've tried creating a new Windows NT profile, checking the hard drive for errors, defragmenting the disk, reinstalling Enterprise Manager etc but nothing works.
What is strange is that connections from VB applications on my PC are fast. It is only Enterprise Manager that is slow.
I am using the latest service pack for SQL Server.
I thought it could be a problem with the Enterprise Manager registry values but don't want to start messing with them!
Has anyone else experienced this problem? Any advice would be great as I can't find any help from microsoft other than installing the latest service pack for SQL Server.
Thanks
View 4 Replies
View Related
Jul 20, 2005
Hi,I am seeing very slow connections from some client enterprise managersto server. Even at server level it takes 1 minute or less to open adatabase. I have adjusted some of the memory for the SQL server, butthere are only about 60 Dbs on the server, totalling about 2 GBs.CPU is very low at all times, 1 GB of ram, p3 1.4Ghz. SQL 2k.I know I should refrag the disk, but is there anything else I can doto speed up SQL operation via enterprise manager--ODBC connections is fairly fast, as well as query analyzer.Adam
View 2 Replies
View Related
Jul 20, 2005
Hi,I have a table with about 70k rows. When I use open table --> returnall rows and then edit a field Enterprise Manager then says it has toreturn the entire result set for the update to take place.This can take a long time and makes editing data a slow process. Isthere any way to get Enterprise Manager just to update the one row??Thanks Tom
View 1 Replies
View Related
May 26, 2004
Hi ;)
I have a database on my server provider ..and i connect via Enterprise Manager ...the thing i want to know is if theres a way to connect direct to my own database ..instead of having all databases in the tree layout and then selecting mine
is there a way in Enterprise Manager to point the Register Sql Server direct to my database ??
Thanks
View 1 Replies
View Related
Jan 6, 2006
I want to set up a tunneled ssh connection to a sqlserver in the enterprise manager. I can register the server, but when i want to connect the following error pops up:
invalid connection
connection open (parse connection params).
Anybody any idea as what is going on?
View 1 Replies
View Related
Nov 27, 2007
hi everybodyi have a problem while trying to connect to my sql server database1st i have created my database from my HELM control paneldatabase name :ramy
IP Address: 74.52.76.178 Local Port: 1433 Remote Port: 1501 thats all but now iam trying to open it via ms sql server enterprise manager but i cant1st i click on register serverthen he ask me for available servers i write : 74.52.76.178then i select sql server login info then he asks about username and passwordusername : ramypassword : 5402248 (these are correct values ) use it freely its just for trialsi get error message that he cant connect or login faliuremy question nowwhere i put the ip address and where to put the portthanks
View 3 Replies
View Related
Jul 26, 2000
When I startup EM it automatically starts up the console
root which contains the server groups (and servers within
the groups).
How do I specify whether I want to connect to a server
as a trusted NT connection or connect using SQL server
login facilities?
I can right click the server (withing a server group) and
get a popup menu which says CONNECT or DISCONNECT
depending on the current connection state.
But I can not modify the CONNECT sub-menu item.
Instead of choosing the CONNECT or DISCONNECT I can
choose the PROPERTIES sub-menu and from there select
the SECURITY tab.
However the SECURITY tab shows that the circle for
"SQL Server and Windows NT" authentication as
being selected.
I am trying to find if it has the same capability as SQL
QUERY ANALYZER where you pick the method of login:
As an NT trusted connection or as a SQL Server login.
Thanks for any help, suggestions, etc.!!
View 4 Replies
View Related
May 11, 1999
I designed a DTS package with eleven different connections. When I try to see the proberties of a connection the enterprise manager immediatly closes without giving me a warning. This happens only with two connections (in my example M1 and M2). This mistake has no influence to the execution of the package. In my opinion it is a fault of the DTS package desinger but may be that I made something wrong.
Is there anybody who knows this mistake? Thanks for your help.
View 1 Replies
View Related
Jul 23, 2005
I have Enterprise Manager version 8.0When I try to register an online databse provided by an ISP I get thefollowing error message:"SQLServer does not exist or access denied[]ConnectionOpen(Connect()"I have tried it many times and checked user name, password, port 1433(as required by ISP), all to no avail.I am running SQL Developer and I have no other versions of SQL or MSDEon my computer,I would be most grateful for any help than anyone can give in solvingthe problem,Best wishes, John Morgan
View 2 Replies
View Related
Oct 26, 2006
Hi,I have an interesting scenario. I have a SQL Server 2000 Standard Edition instance running on Computer A. I'm trying to access it through computers B and C.Computer B has Sql Server 2005 Express Edition installed and I was able to use its Management Studio and connect to instance on Computer A.Computer C has SQL Server 2000 Standard Edition installed. When I try to connect to the instance on Computer A, I get connection failed message.I checked some settings. Both TCP/IP and Named pipes are enabled on the instance in A. The TCP/IP port is set to 1433 for both client and server.Please give me some ideas as to how I can solve this problem. -Thanks
View 5 Replies
View Related
Dec 1, 2007
Hi
I have picked up the same problem that quite a few folks have identified.
I have created a SSRS Solution and have a report which I am trying to deploy to the Report Manager.
The project 'builds' locally but when I try to deploy it, a User Login Box pops up.
Has any one been able to ascertain what causes the problem and how does one go about resolving the problem.
I am using Window Authentication on WIndows XP SP2 with SQL Server 2005 Developers Edition and Visual Studio 2005 Professional
I have not 'tinkered' with IIS,.
Any help would be greatly appreciated.
regards Steve
View 7 Replies
View Related
Mar 24, 2008
I am using SSIS 2005 on Windows 2003 server. Using Excel Source to dump the data for staging database.
I am getting following error while I execute it through BI studio's execute button.
Please help.
- Sachin
View 2 Replies
View Related
Mar 11, 2008
I have deployed my packages into Sql Server and I am using Configuration File. As my Data Source is Excel, I have changed the connection string during deployment with Server Path. But I am getting the following errors. Actually the File Exist in Path. May I know What is cause of the issue? Do I need to give any permission to execute the package.
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
component "Excel Source Service Contract Upload" (1) failed validation and returned error code 0xC020801C.
One or more component failed validation.
There were errors during task validation.
DTS_E_OLEDBERROR, Error Code: 0x80004005 Source: "MS JET DB Engine" Description : Path is not valid
View 27 Replies
View Related
Jul 20, 2005
On one of our machines, all of the SQL Server 2000components except for the main Server component (SQL Servercore) itself were installed (Management tools, etc) a while agoand everything was running fine. Now I go and add/install theServer component and then Service Pack 3a.It seems that Service Manager won't start up (I get an hourglass cursor)and now I find that Enterprise Manager won't run as well. No errormessages appeared and I don't think I saw anything unusual inthe log file.However, I can use Enterprise Manager on a differentmachine and connect to the database (so the databaseitself seems to be running).Any suggestions as to what the problem might be and how tofix it? I like to see if I can repair this without havingto do a reinstall.Thanks.PF
View 2 Replies
View Related
Dec 6, 2006
IF someone can assist me. Everytime I load up enterprise manager the service manager turns off. And the enterprise manager can't connect to the local database. But everytime i turn it back on and try to connect again it shuts it off and around and around we go. Help would be appreciated. Thanks.
View 2 Replies
View Related
Dec 27, 2007
Hi,
I am working on SQL Server 2005 (x64) with Windows Server 2003 (x64) operating system. I am having a major issue in SSIS. Here is the detailed explanation of the issue :
I have an EXCEL file in 2003 / 2007 version. It contains some data. I want to import the data using SSIS into SQL Server 2005 (x64) database table. I have taken "EXCEL FILE SOURCE" and "SQL Server DESTINATION". It was failed on importing data. Surprisingly it works fine in SQL Server 2005 (x32). Can you please explain why it is NOT woking on (x64) ?
Here is the error code i am getting:
[Excel Source [1]] Error: The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.
Appreciate your time and patience !!
Thanks
View 3 Replies
View Related
Mar 17, 2008
Greetings,
I have an SSIS package that I need to modify. It was developed in Visual Studio 2005 and runs faithfully in production on SQL Server 2005. Suddenly, I can't open the package on my own workstation. I see a big red "X" image and a message stating "Microsoft Visual Studio is unable to load this document." The real reason the document can't be loaded appears to be:
Error loading DataWarehouseLoader.dtsx: The connection type "OLEDB" specified for connection manager "Warehouse Logging OLE DB" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
Does anyone know what causes this and what I can do? The package has been in production for 9 months and I've never seen this problem before.
Thanks,
BCB
View 10 Replies
View Related
Mar 8, 1999
I have installed SQL7 Gold on a client running W98. Every time I boot a dial-up window loads and pauses the boot process. Pressing Esc removes it. Is there a SQL 7 registry setting that can stop this?
View 2 Replies
View Related
Jul 21, 2006
... right clicking on a registered server?
I work from home, over a DSL link. Reasonably, if not hugely, fast. Everything Ent Mgr or Query Analyzer does is quite responsive, except, when I right click on a registered server. Then, there is an long wait, with no visual feedback (no hourglass) and frequently the result is nothing happens. Sometimes it takes two or even three right clicks, all spaced 15 to 20 seconds or more apart, before I get the menu. What in the heck is Enterprise Manager doing or waiting on, and why, so often, does it do nothing at all??? I realize this is a minor detail in the schema of things (sorry, couldn't resist), but it's annoying in part because it seems like it should require no outside communications and be lightning fast to just throw up a menu. I've long wondered what's happening behind the scenes on that right click......
View 2 Replies
View Related
Jul 20, 2005
Hi to all,I've recently installed SQL Server 2000 on Dell Power Edge 1600sc withdual processor (2.8ghz) and 1 gig of ram, to use a CRM application(Maximizer Enterprise 8.0)and since we make the install every time auser is trying to access data it take about 5 to 10 second to see therequested data. The performance of the SQL server less than thepervise version of Maximizer.I've made a typical install of SQL server 2000 and SP3.Analysis Services as been installed too.I've seen a strange memory workload this week, the used memory wasabout 740,390 kb, from my knowledge of SQL, i think this is very notnormal.Any help will be welcomeThanks in advanceV. MesitiNetwork AdminRenmark Financial
View 1 Replies
View Related
Feb 6, 2008
I have a package that uses a for loop to iterate through an unknown amount of excel files and pull their data into a table. However, there will be cases when the file is corrupted or has some sort of problem so that either the transformation will fail or the excel data source will fail with an oledb connection error.
Could anyone suggest a clean way to trap these errors? Specifically, the "Cannot Aquire Connection from Connection Manager", which is the excel connection.
Thanks,
John T
View 3 Replies
View Related
Nov 30, 2006
Hi
has anyone used this tool to upload sql databases to a web host
i'm struggling
cheers!!!
Adrian
View 2 Replies
View Related
Sep 10, 2005
I installed SQL Server MSDE 2000 but I can't find how to start it. Does this package include an Enterprise Manager or not? I thought that maybe it was a standard XP Pro feature. I had no problem finding it in W2000 Pro.
View 1 Replies
View Related
Mar 21, 2001
When I open databases, there is nothing there - not even Master, Model, Temp, Pubs, etc.
When I open the query analyzer, however, they all appear in the drop down.
What is up with that? and how can I remedy?
OP sys:Win98
SQL Server 7
View 2 Replies
View Related
Jun 11, 2001
Has anyone encountered this error: When you are in Enterprise manager and you select a database then the tables tab and then you select a table and go to open table- select all rows, I get an error--An unexpected error happened during this operation-Query Designer encountered a query error! Please let me know if you have seen this. Also, when I access this from one networked computer I get the same error, then when I access it from another I do not!! The servers are interacting with Pivotal. The one that works does not!!
View 3 Replies
View Related
Jun 12, 2001
Hi all,
I have SQL 7.0 desktop addition installed on my local win NT workstation. I am able to connect to my local server using Quary Analyser but when i am trying to connect using EM, i am not able to connect. I am receiveing the following error message.
__________________________________________________ ___________________________
A conncetion could not be established to "servername" - Specified SQL Server not found. ConnectionOpen(CreateFile()).
Please verify SQL server is running and check your SQL Server registration properties(by right clicking "servername" node) and try again.
__________________________________________________ ___________________________
I have tried as said in the error message and also tried connecting with "sa" but its not working. I can see that the server is running and i am able to connect through QA.
any help is highly appriciated.
View 1 Replies
View Related
Jun 20, 2001
We can no longer open tables in EM. The error message is;
An unexpected error happened during this operation
[Query] - Query Designer encountered a Query error:
Unspecified error
The tables are fine - can access them other ways.It looks as if the fault is in the script used by EM. Anyway to clear this ??
View 2 Replies
View Related
Sep 26, 2001
I am fairly new sql dba in a company and I am sure Enterprise Manager is installed on PC's and it shouldn't. Is there a way of finding out other then visiting each workstation. Thanks in advance..
View 1 Replies
View Related
Jul 28, 2000
I am considering upsizing my Access 2000 DB to a SQL 7 server. I was told that having SQL 7 Enterprise Manager is highly prefferd but not essential as I can maintain the upsized DB with Access 2000. The only way that I have been able to find JUST enterprise manager seems to be with purchasing the whole SQL 7 program for $1300! Microsoft cannot be that cruel, that you have to buy the whole program just for Enterprise Manager!
My questions are:
Can I download just MS SQL 7 Enterprise Manager anywhere for a reasonable fee or free?
and
if not, can I continue to use Access 2000 to maintain the SQL 7 upsized DB?
View 5 Replies
View Related
Jan 25, 2001
I have access to a SQL 7 server via my ISP Hosting account. I know Enterprise manager comes with the server software, but how can I get a copy of JUST Enterprise Manager?
JD
View 1 Replies
View Related
Apr 17, 2000
Is non-SA account able to view the SQL Enterprise Manager?
Thanks in advance!
Plum
View 3 Replies
View Related
Aug 3, 1998
Is it possible to administer both 6.5 and 7.0 databases from the same SQL Enterprise Manager? I have read that you cannot do this because the 7.0 "plug-in" to the MMC wont work with 6.5 databases.
View 2 Replies
View Related
