SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 sqlagent node does not show after running package
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

srm
Starting Member

3 Posts

Posted - 05/10/2013 :  03:18:08  Show Profile  Reply with Quote
I created ssis package with simple execute sql task with select statement.Then I tried to run package in ssms which ran successfully but the thing is when I reopened ssms I could not see sql server agent node.
and also now I am not able to create or modify any object in ssms it gives error for permission denied for my machinename/administrator account.
Can anybody highlight the solution?

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 05/10/2013 :  07:09:57  Show Profile  Reply with Quote
did the package had any task which deals with permissions?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

srm
Starting Member

3 Posts

Posted - 05/10/2013 :  09:34:34  Show Profile  Reply with Quote
No it was simple select statement.Is it because I added machinename/administrator which is default windows account into sqlserveragentoperator role in msdb and also by mistake I think I have removed it from sysadmin role in security folder.so now I am denied permissions?
It is actually two different problem I am facing.Not able to see sql agent node and not getting permission for crating objects at server level.it gives error no:262
TITLE: Microsoft SQL Server Management Studio
------------------------------

Create failed for Database 'db2'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)

This was soon after I ran a package scheduled in ssms under machinename/administrator account.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 05/13/2013 :  02:21:05  Show Profile  Reply with Quote
i think issue is with removal of permissions from account. Can you reinstate it?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000