| Author |
Topic |
|
bferriter
Starting Member
34 Posts |
 Posted - 2005-04-26 : 13:40:55
|
| if this is the wrong place for these posts, sorry in advance.when i connect to the sql server from a computer that is not the local machine with enterprise manager, I cannot save edits to dts packages, and trying to look at the properties box for the sql registration frequently locks up the enter server. I am using the same account to login that i use on the local machine.. I can edit tables, and view the rest..second issue, some of my sql agent jobs are failing (specifically optmization, backups, and integrity checks).. The packages have the same owner and create as the other packages that constantly run successfully. The only error that populates is that the job failed.. is there somewhere i can view the error better to find out whats happening?third issue (while i have your attention), i specified myself as an operator on the server, created a mail account and added it to outlook 2000. I can link through the server, and send the test mail. I have "email to 'myself'" set for failed jobs.. the jobs are failing and im not getting the email (also nothing is saved in the sent items or outbox in outlook, even when its open). --------------------BrianOne man with 5 hats. |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-26 : 17:52:28
|
| Uninstall and reinstall EM on the client. Make sure you apply all the appropriate services packs and patches. Locks up the server or the EM on the client?Right click on the failed agent jobs and select View Job History. You will be able to expand the job history for each step. Also check your SQL error log.Your SQL agent service must be set to login with the same account that has access to the mailbox in Outlook. |
 |
|
|
bferriter
Starting Member
34 Posts |
Posted - 2005-04-27 : 08:09:03
|
| The client locks initially, but then the server will stop responding. After 5 mins I end up killing the process but then I have to reboot the server for it to be reachable again.Where is the SQL error log? It's a written text file in the mssql directory?Which account has to be the same to have access? You mean if I run the SQL agent with the sa account, I have to make a sa@domain.com email account?Thanks--------------------BrianOne man with 5 hats. |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-27 : 10:17:31
|
| That lock up is worrisome. Is your SQL server fully patched? What happens if you run sp_configure from the client in QA (might want to check this after hours)? The log is usually located under the SQLroot\log\ERRORLOG. If you check the properties of the server you should be able to see where the log is by checking the startup parameters.The account that owns the mailbox should be the same account that the SQL Server agent SERVICE starts with. Check the properites of the service. |
|
|
|
bferriter
Starting Member
34 Posts |
Posted - 2005-04-27 : 12:04:33
|
| I am reinstalling EM on my computer.The error message for all of the failed processes is "ran with user domain\account : sqlmaint.exe failed" or something to that effect. The owner for the process has been set as the SA account, but it runs under the domain login?I used Outlook 2000 instead of express and I did get emails from last night. I have to have Outlook open I guess...--------------------BrianOne man with 5 hats. |
|
|
|
bferriter
Starting Member
34 Posts |
Posted - 2005-04-27 : 12:30:46
|
| After the reinstalled EM, I still get the "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." error message when I open a DTS package, view a SQL task and try to close it by hitting OK (or trying to save it).. The SQL server is uptospeed with (Build 2195: Service Pack 4). Is there a patch for the client side? I searched on msn but pulled bupkis..--------------------BrianOne man with 5 hats. |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-27 : 12:33:41
|
| No, you don't have to have Outlook open. Is your SQL server setup to support Windows authentication? If so, you need to setup a special Windows account for the SQL Agent service. Use this account to start the service. Then create a special mailbox just for this account. Login under the account on the server. Setup a mail profile. Modify the SQL Mail setup to use this profile. The process will run under the SQL Agent account. Since it is a service you don't need to be logged in. |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-27 : 12:38:27
|
quote:
Originally posted by bferriter
After the reinstalled EM, I still get the "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." error message when I open a DTS package, view a SQL task and try to close it by hitting OK (or trying to save it).. The SQL server is uptospeed with (Build 2195: Service Pack 4). Is there a patch for the client side? I searched on msn but pulled bupkis..--------------------BrianOne man with 5 hats.
The latest SQL server service pack is 3a. "Build 2195" is your OS service pack level... |
|
|
|
bferriter
Starting Member
34 Posts |
Posted - 2005-04-27 : 12:43:55
|
| I ran "SELECT @@version" off the analyzer.. It does have pack 3a, I still have the downloaded patch on the server I installed.All of my clients use Windows Auth to access the server. The server is logged in under a domain account. The SQL Agent is setup to run under this domain account. I can wait on this one till tommorrow to see if it works or not.--------------------BrianOne man with 5 hats. |
|
|
|
|
remote enterprise manager issues