You can find more information here

I got it from querying the sysobjects table...

Hi Shine,

Looks like the Service Principal Name (SPN) for SQL Server is missing. I feel instead of the the server name, if you use localhost\InstanceName or .\Instance name, the package...

Thanks. Its mine

See this MS KB article.

You may find this link useful.

I think this snip should help you.

SELECT A.NAME,B.TOTAL_ELAPSED_TIME/60000 AS [Running Time],

B.ESTIMATED_COMPLETION_TIME/60000 AS [Remaining],

B.PERCENT_COMPLETE as [%],(SELECT TEXT FROM sys.dm_exec_sql_text(B.SQL_HANDLE))AS COMMAND FROM

MASTER..SYSDATABASES A, sys.dm_exec_requests B

WHERE A.DBID=B.DATABASE_ID AND B.COMMAND LIKE '%RESTORE%'

order...

Hi Art,

You may want to check the Service Principal Name (SPN) for the service account. More information about SPNs is available here

SetSPN utility can be downloaded from here

Art,

Please check whether "BUILTIN\Administrators" have access to the SQL Server and also try adding the user again as below.

Grant [domain\user]

EXEC sp_grantlogin [domain\user]

--Add that account to the sysadmins role:

EXEC sp_addsrvrolemember @loginame...

I disagree with this. I have tried using -E (Trusted connection) and it works well from...

To stop and start SQL Services, the user must belong to the "System Administrators" group. Is your SQL login part of that group?

Which Edition of SQL Server are you using and what is the Operating system?

You can also try executing DOS commands using xp_cmdshell

I am not sure about the option to "Enable/Disable" debugging on all queries. I doubt this could also be one of the reason.

The shortcut for debugging is "Alt + F5"

We...

Please try using the "Server Name" or the "IP Address" instead of "localhost".