How To Use Diff. Port W/Enterprise Manager? I Cant Get It To Work.
Mar 21, 2004
Im having a prob with enterprise manager and im hoping that you can help.
my host has moved my sql database to another server. They gave me a new IP address, but they said that I have to connect through a certain port through enterprise manager. That port is 1042 not the default 1433.
So, I created a new sql server registration using the ip address. it didnt connect, of course. I went ahead and told EM to keep the registration even though it wasnt completed. I heard that you can right click on the node on the left and choose properties to change the port number. Well every time that I right click on the bugger, it tries to connect to the sql database, not give me a choice of properties to change.
I also highlighted the thing and chose properties from the toolbar at the top. Still nothing. The only thing I do get is an option to type in the username/password. There is NO PLACE to change the port.
I even tried going into the registry and changing the default port of 1433 to 1042. NOTHING. EM still craps out and tells me the connection failed due to the db not being there or the connection was refused.
How do I get this thing to connect to the sql server?
Also, is there another program that will do what Entreprise Manager does, but isn't such a piece of......?
View 1 Replies
ADVERTISEMENT
Apr 23, 2007
After opening the Results Pane (though a query or open table); I frequently get the below message.
Is there any way to change the settings so the results pane will stay active for a long length of time?
Message
SQL Server Enterprise Manager
_______________________
Some time ago, you retrieved data from the database with the query or view whose name is XXXX. The returned rows appear in the Results Pane and the database continues to retain the result set in its local memory; which consumes valuable server resources. Because you have not recently used the Results pane, it will be AUTOMATICALLY CLEARED IN ONE MINUTE. The will empty the results pane, discard unsaved changes, and free resources on the database server. Then if you want to REESTABLISH the result set, you can rerun the query or view.
DO YOU WANT TO PROLONG YOUR WORK WITH THE RESULTS PANE AND CONTINUE TO CONSUME RESOURCES ON THE DATABASE SERVER?
--------------------------------------------------------------------
I want this to default to Yes, without this message comming up and if I don't click yes fast enough, my results are gone. I kinow the work arounds, but how can I default this to Yes or so this message stops displaying.
Thank you
watxnd@hotmail.com
View 1 Replies
View Related
Aug 1, 2007
Hello all,
I need help concerning a differential backup on a MSDB database.
I received this message when I tried to backup it
Log from Windows
Event Type: Error
Event Source: SQLVDI
Event Category: None
Event ID: 1
Date: 8/1/2007
Time: 2:03:37 PM
User: N/A
Computer: XXX
Description:
SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=9028. Thread=5928. Client. Instance=. VD=GlobalData Protector_(DEFAULT)_msdb_14_00_21.
Log from DataProtector
Normal] From: XXX "(DEFAULT)" Time: XXX
SQL statement:
BACKUP DATABASE [msdb] TO
VIRTUAL_DEVICE = "Data Protector_(DEFAULT)_msdb_06_00_14"
WITH NAME = 'Data Protector: 2007/08/01 0064', DIFFERENTIAL, BLOCKSIZE = 4096, MAXTRANSFERSIZE = 65536;
[Warning] From: XXX "(DEFAULT)" Time: XXX
Error has occurred while executing a SQL statement.
Error message: '<Microsoft SQL-DMO (ODBC SQLState: 42000):bdb>
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot perform a differential backup for database "msdb", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.'
Ive tried to do a full followed straight after by a diff but doent help.
Thank you for your help
View 7 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
Feb 27, 2007
Hi, I hope someone can help me! I changed the TCP port that the default instance of SQL 2005 x64 SP1 is listening on and now SQL server won't start as the port is being used - no problem I say to myself, I'll just change it again, however I can't!
My problem is that I can not change the TCP Port back again using Configuration Manager - no matter what values I put in, after a restart of the instance it comes up with this in the IP Addresses tab for TCP/IP Properties and SQL Server won't start:
IP1
Active Yes
Enabled No
IP Address aaa.bbb.ccc.111
TCP Dynamic Ports
TCP Port 0
IP2
Active Yes
Enabled No
IP Address aaa.bbb.ccc.222
TCP Dynamic Ports
TCP Port 0
IP3
Active Yes
Enabled No
IP Address aaa.bbb.ccc.333
TCP Dynamic Ports
TCP Port 0
IP4
Active Yes
Enabled No
IP Address 10.1.1.1
TCP Dynamic Ports
TCP Port 0
IP5
Active Yes
Enabled No
IP Address 127.0.0.1
TCP Dynamic Ports
TCP Port 0
IPALL
TCP Dynamic Ports 2020
TCP Port 2020
Interestingly, the ip address that the server is listening on aaa.bbb.ccc.444 is not reported in the list of IP addresses in the configuration manager for this instance, yet it is when I view the available IP addresses for the other two instances - is this significant?
I have tried failing to the other node, changing it there, changing it at the console and also while logged onto the the virtual machine remote desktop, rebooting both nodes, etc, etc. There are two other instances on this cluster that are still working fine but I hvae not attempted to change the TCP ports they listen on.
I used the same method to change this default instance as I did for a named instance on a similarly configured cluster and it worked fine. How to fix this?
Regards, Mike
2007-02-27 12:03:17.69 Server Server is listening on [ aaa.bbb.ccc.444<ipv4> 2020].
2007-02-27 12:03:17.71 spid9s Starting up database 'tempdb'.
2007-02-27 12:03:17.72 Server Error: 26023, Severity: 16, State: 1.
2007-02-27 12:03:17.72 Server Server TCP provider failed to listen on [ aaa.bbb.ccc.444<ipv4> 2020]. Tcp port is already in use.
2007-02-27 12:03:17.75 Server Error: 17182, Severity: 16, State: 1.
2007-02-27 12:03:17.75 Server TDSSNIClient initialization failed with error 0x2740, status code 0xa.
2007-02-27 12:03:17.75 Server Error: 17182, Severity: 16, State: 1.
2007-02-27 12:03:17.75 Server TDSSNIClient initialization failed with error 0x2740, status code 0x1.
2007-02-27 12:03:17.75 Server Error: 17826, Severity: 18, State: 3.
2007-02-27 12:03:17.75 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2007-02-27 12:03:17.77 Server Error: 17120, Severity: 16, State: 1.
2007-02-27 12:03:17.77 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
View 11 Replies
View Related
Oct 29, 2007
Hello,
We have an SSIS job that runs once a day and sends emails.
For security reasons, IT switched the send-mail porton the smtp server from 25 to a different number (let's say 1234).
So, I changed the SSIS SMTP Connection Manager's smtpServer string to smptserver:1234
However, this does not seem to be working. I keep getting 'Send Mail Failure' error.
Any ideas how to set the port number for sending emails using SSIS?
thanks much,
Muhammad
Cobalt Group
View 3 Replies
View Related
Feb 12, 1999
I need to write a 'select' statement to fetch data from different tables, which are located on different servers.
Can any one help in writing this 'select' statement with out moving the tables on to same server.
Thanks in Advance.
Murali Raparla.
View 2 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
Oct 10, 2003
Does anyone know how to turn off or disable the auto discovery for Enterprise Manager. Apparently our Network group is complaining that Enterprise Manager is generating noise on the network, it is not signifcant in volume but they complain it impacts there ability to detect hacking attempts on our network because it causes some false positives. I generally keep Enterprise Manager running because I will always have some manual job running from it and we have so many servers it takes awhile for them to all load when I first fire it up.
Thomas
View 3 Replies
View Related
Dec 26, 2007
Hello guys,
Just wondering if i can use CPU, Memory usage, I/O or wait events for SQL trace. I am having difficulty in finding theses events on SQL trace.
Also is it possible to show the SQL trace file output in graphical format.
Thanks
View 5 Replies
View Related
Jul 16, 2002
Hi,
I have SQL server 2000 client machine on my XP desktop which worked fine
until yesterday.
Yesterday, I tried to set up client access (a tool from IBM to access AS400) unsuccesfully. Since ever, Each time I try to open a table in enterprise manager, I get the following error message
"The query cannot be executed because some files are either missing or not
registered. Run setup again to make sure the required files are registered".
While when I issue a query in analyzer it works fine.
I did that several times without success. Even, I removed the whole SQL 2000
setup, rebooted my machine, ran set up again for client tools which gave the
same result. Also, I re-setup MDAC2.6 SP2 but no way.
Which files are corrupted ?and I don't understand after doing all that,
setup goes smoothly without indicating any errors, but still when you open a
table in enterprise manager, it gives the same error.
Thanks in advance
View 3 Replies
View Related
Nov 15, 2004
Hi,
Using MS SQL Server 7. When I go into a table in design view and order by date created, it only orders on the day and not the date (Enterprise Manager) e.g.
29/08/1981, 11/12/2004, 31/12/2003
should be
11/12/2004
31/12/2003
29/08/1981
but it's this instead
31/12/2003
29/08/1981
11/12/2004
Please help.... is this a bug
View 3 Replies
View Related
Jun 7, 2006
Hi,
My Question is regarding the Query Analyzer.
When we click on the Query Analyzer Shortcut, it will prompt for a user id and password.but when we expand the databases node from EM and clicks on Tools->Query Analyzer Menu, after selecting a database node, the QA does not prompt for the user id and password. Can any one explain this behaviour of QA..
I am using Mixed mode authentication for my db server.
View 6 Replies
View Related
Jun 19, 2007
Hi All,
When I view the database properties using Enterprise Manager, some of the databases on the server are reporting that there is zero space available while others have space available. Does anybody know why?
View 2 Replies
View Related
Feb 28, 2004
Does anyone know where I can get a copy of Enterprise Manager? I have the trial copy of 2000, but I need to administer data on a SQL 7 server, and I cannot create stored procedures, add users, or create DTS packages in 2000 that will work on SQL 7.
Thanks!
View 14 Replies
View Related
Sep 18, 2005
Is it possible to add custom columns to the design table interface.
For example could I add custom column for some data on want to store under a table column. I am used to vb.net and I am able to add custom properties to a control. Is this type of customization possible for SQL Server. Is it possible to add a custom tab to the tab control where columns are located at the bottom of the designer?
View 2 Replies
View Related
Apr 19, 2006
I installed SQL Server Developer Edition on Windows 2003 server for our sales force.
I don't want them to have acces to enterprise Manager and Query Analyser.
How to disable these?
Thx
Venu
View 6 Replies
View Related
Sep 15, 2006
Hi all, I am not over familiar with SQL, I am a VB Programmer, however I need to achieve the following.
In Enterprise Manager I have 2 tables A and B.
I need to get a column from A and then scan the entire contents of B to see whether the content, the value from the column in A actually exists in B. The get the next value from A and repeat the process.
Any Help Would be appreciated.
Many Thanks
View 3 Replies
View Related
Feb 5, 2008
MMC cannot open the file C:Program FilesMicrosoft SQL Server80ToolsBINNSQL Server Enterprise Manager.MSC
This may be because the file does not exist, is not an MMC Console, or was created by a later version of MMC. This may also be because you do not have sufficient rights to the file
Note: I had admini rights on PC, and Network, I am able to run Query Analyzer....
I can remote into other boxes and run Ent. Manager also.
NEED HELP PLEASE
View 1 Replies
View Related
