Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
srm
Starting Member
8 Posts |
 Posted - 2013-05-10 : 03:18:08
|
| 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
52326 Posts |
Posted - 2013-05-10 : 07:09:57
|
| did the package had any task which deals with permissions?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
srm
Starting Member
8 Posts |
Posted - 2013-05-10 : 09:34:34
|
| 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:262TITLE: 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. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-13 : 02:21:05
|
| i think issue is with removal of permissions from account. Can you reinstate it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
sqlagent node does not show after running package