Enterprise Manager Hangs Trying To Show TEMPDB Properties
May 10, 2007
Hi there -
I am trying to look at TEMPDB properties in Enterprise Manager but it just hangs forever. I can look at props for all other databases on that server OK. The server is working OK but users reporting performance problems.
Also, how to increase the size of TEMPDB in T-SQL - I can see it is approx 200MB plus 300MB for the transaction log at the moment.
(Microsoft Windows 2003 Std Edition SP1, SQL Server 2000 Std Edition SP3)
Thanks for helping,
Michael
View 3 Replies
ADVERTISEMENT
Aug 17, 1998
Hi,
SQL Enterprise Manager hangs when any action related to devices is performed. Note that ISQLw works perfectly.
To solve this problem we started by increasing allocated RAM for SQL Server and the the problem was solved for a while, then it is back again.
What factors that make SQL Enterprise Manager hangs in our case ?
Note that the server is never down and clients are connected to databases successfully.
Prompt response and advice will be highly appreciated.
Regards,
Einas (DBA)
View 6 Replies
View Related
May 22, 2008
We are on SQL Server 2000 SP2 version.
I have 3 DTS packages that are running successfully every day.
We need to change them as the source side tables are going to be changed pretty soon.
When I go into the designer view Enterprise Manager hangs when I do any of the following:
1. click on Properties for the transformation task
2. Click on Disconnected Edit
3. Click on Properties of connection 1(IBM DB2/400 Source), properties window pops up, now change the userid/pwd and click ok.
Any help will be greatly appreciated.
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
Sep 15, 2004
When I select All Actions>Backup Database and then click the ... button to choose a location on the hard drive, SQL Enterprise Manager Hangs and I have to kill it from Task Manager.
All other areas of EM browse the disk drive without a problem. (DTS, File Groups, etc.)
Anyone ever run into a similair problem?
Thanks
View 2 Replies
View Related
Jul 20, 2005
I thought I'd give the SQL Server 2000's log shipping wizard a try (inthe past I've always done it with Perl scripts), so I attemted to setit up on one of my servers. But in the maintenance plan wizard, Idon't get the checkbox at the bottom of the window to "Ship thetransactions logs to other SQL Servers (log shipping)" as it shows inthis article:http://www.microsoft.com/technet/pr...n/logship1.mspxCan anyone tell me what's wrong here? Please post to the newsgroup.Thanks,Steve
View 7 Replies
View Related
Dec 31, 2007
Hi all,
I have two problems.
1. I downloaded ChartFXRSTrial and created one chart, and able to deploy it in ReportServer, but the problem is the reports are not showing there, i checked the configuration of .dll files in the help provided by chartFX, but couldn't get anything, so could help me on this.
2. How to give Tooltip for the X- axis or Y- axis values in the ReportServer , i tried using chartproperties of .rdl file, but didnt understand it. can help me on this, and one more i tried with Dundas too, If im giving tooltip as #valy then, it is showing samething in reportserver instead the values of 'Y-axis'.
Thanks,
Mahesh Manthena
View 1 Replies
View Related
May 19, 2004
Hi,
I hope someone out there can help, cos i really need it.
We have a 2 node cluster + SAN that will be used as our SQL 2000 servers.
We have setup the cluster ok, and have tested failover with no problems.
However, when we try to install SQL 2000, it just hangs.
I have copied the enterprise cd to the local drive, and am installing from there.
We run the setup.bat, create the Virtual Server, and assign an ip address. At this point, it just hangs.
Upon checking the SQLSTP.LOG file, this is the last entry in the log:
Begin Action : DialogShowSdDiskGroups
I have found the Microsoft Technet Article 293788, which gives me a possible soloution, but we dont have any Resource Names or Groups that have the same name.
Can someone PLEASE give me an answer on how to fix this, or at least point me in the right direction.
Many Thanks
Darren
View 1 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
Mar 29, 2007
hi,
I am using MS SQL Server 2000 SP3a on windows server 2000.
I have 4 FT indexs on 4 of my tables.
They are schedules to run every day once. For the last couple of days the jobs are hanged.
When I tried to open Catalogs by clicking on 'Full Text Catalogs' enterprice manager hangs( not responding). I had to go to taskmanager and then click on end task to re-open the enterprise manager.
Also when I right click on one of the tables enabled with FT indexing
Enterprise manager hangs up again.
If I cannt open FTCatalogs how can I rebuild them.
please respond,
mpk
View 3 Replies
View Related
Sep 14, 2005
When i will try to install SQL Server Express Manager in W2K SP4, its fail with error in Event Viewer:
View 1 Replies
View Related
Jan 12, 2007
Hi,
in one of our team projects users whom are members of the reporting services €œcontent manager€? role are not able to get onto the €œsql server€™s reporting services€? properties page of their team project. Instead of that page they receive the following error message:
The permissions granted to user '<UserName>' are insufficient for performing this operation. (rsAccessDenied)
With four eyes we double checked that the users really have the content manager role, we also tried all kinds of role combinations with no success.
The interesting thing is that as soon as they €˜only€™ in the Browser role they have access to that particular page €“ but as expected are unable to administer their team projects reporting services.
The reporting services forum doesn€™t really offer any answers to this problem, neither did goolge nor this forum.
Could anyone explain this behavior to me?
Pls let me know if you need additional information on this.
Thanks,
Tom
View 4 Replies
View Related
Aug 24, 2010
How to use variables in Connection Manager's properties? I see some replies through Configuration Package. But what if, it is still in development stage? I mean, can I use the Variable tab and create some variables like
User::DBUserNameSource, User::DBPasswordSource,
User::DBuserNameDestination, User::DBPasswordDestination,
Then put them in Password and UserName property of Connection Manager? If this is possible, how and how can I set the values of those variables I mentioned when I am going to deploy the package in the Production?
View 26 Replies
View Related
May 29, 2006
Dear fellows,
I know that I think as sql2k programmer-dba yet but I can€™t avoid.
I€™ve got Flat File Connection Manager Editor dragged with a text file as €˜ragged right€™ format and CRLF as header row limiter. When from properties page and Columns option I€™m going to alter just a few colums I am not be able.
It seems that you must erase all of them in order to define one or two. And in the case you€™d have 50????
When I ran sql2k DTS designer did that without problems, alter columns again and again.
As far as I know it€™s a lose of flexibility, or not? Or is there any way for do that without deleting nothing else?
View 3 Replies
View Related
Jan 18, 2003
Hi,
I use MSsql server 2000 and analysis service for create cube.But when I drilldown many Dimension on Analysis manager it can not show all level.
If I drilldown some level it can show data but when I drilldown many level so it have many row (I test about 60,000) it can not show result.
How can I show all result in Analysis manager or other tool ?
Thank you :D
View 1 Replies
View Related
Oct 16, 2015
I'm working on a newly installed windows 2012 R2 server which has SQL Server 2012 and SSMS installed on it. What has been odd is that when I open the "restore database" dialog, in the "Select Backup Devices", "Locate Backup File" dialog, only the immediate folders off of the root of the E: drive are visible. E: is where sql server data and backup files are stored.
The account I am logged in with is supposed to have Enterprise Admin rights. How is can I not see these folders and files? The files are certainly there and are visible to me on that login with windows explorer. I am able to backup via SSMS without issue.
When I look at the folder's permissions everything seems normal. If I add "Everyone" to that folder's permissions the folders and files become visible. The SQL Server service is running on the NT ServiceMSSQLSERVER account, which is normal for my other installations of sql server.
View 12 Replies
View Related
Dec 16, 2005
I've created a very simple custom connection manager, and I followed the deployment instructions at http://msdn2.microsoft.com/en-us/library/ms345276.aspx. Basically, that was just copying the assembly to %programfiles%Microsoft SQL Server90DTSConnections, and then registering the asssembly in the gac.
However, when I open VS, right-click on the connection manager pane, and then choose new connection, my custom manager does not appear. What am I missing?
Here is the class:
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using System.Data.SqlClient;
using System.Xml;
namespace MyCoolCompany
{
[DtsConnection(DisplayName="Sharepoint Connection Manager",
Description="Connect to Sharepoint lists",
ConnectionType="Sharepoint",
ConnectionContact="My Cool Company",
UITypeName="SPDataFlowComponent, MyCoolCompany.SharepointConnectionManagerUI")]
class SharepointConnectionManager: ConnectionManagerBase
{
}
}
View 6 Replies
View Related
Jan 24, 2008
I've read posts that state it is impossible to remove the "Show Details" button on the tool bar in Report Manager.
I created a new role assignment for an individual on a folder with the "Browse" role only.
When that individual navigates to the folder and clicks the "Show Details" button, the "Delete" and "Move" buttons also appear on the tool bar, with a checkbox next to each report item.
I can't have a folder where my users have the ability to delete or move my published reports!
Am I missing a setting? Again, the user has the "Browse" role only on the folder.
Thanks.
View 10 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
Nov 8, 2001
We had database corruption and cannot access the Enterprise Manager. DBCC returned errors 9000 to 9999 which I can't get any suggestions on how to handle from BOL. Any ideas!!!!! Thanks.
View 4 Replies
View Related
Mar 13, 2001
Hi,
I would like to know if we can present users to access details database information about the databases on a server through Enterprise Manager.
If you create a SQL login and do NOT give it access to any database, if someone logons on your server with enterprise manager, even though he does not have access to any database, he will still see the list of all database on your servers plus tons of sensitive information like database owner.
Is is possible to limit enterprise manager to only view information about database that the user has access to?
Thanks
Mark
View 2 Replies
View Related
Nov 26, 1999
How can I force users of Ent Manager 6.5 to enter a name/password when connecting to a server that has been registered? I dont want to use the sa name and password so that anyone could use my workstation to access our servers.
View 2 Replies
View Related
