If there is delay from the DC or over the network you can get this.

I recall setting 3 registry keys on all machines in the network.

MaxPacketSize was one, but there...

It could be a UAC issue. You could try having the developer right click on BIDS and then select Run As Administrator and try to deploy the reports.

Sue

andrzejthc (10/11/2016)

---

Wasn't SQLBrowser introduced in SQL2005?

In SQL 2000 there is no such service...

extract from internet:

in SQL Server 2000 the first instance to start up on the server starts the SQL...

andrzejthc (10/10/2016)

---

Thanks for your replay.

Generally I found the reason - there is no listener on UDP 1434...

But can someone tell me why after manual restart, server did not start...

sgmunson (10/7/2016)

---

Finally got past the version difference by editing the package on the server where it was failing, and then after a couple other quick edits, it worked okay. ...

Glad it got resolved Juan - thanks for posting back the resolution.

Sue

Thanks for posting back - glad it worked out.

Most people don't know there is a difference. I stumbled upon some MS blogs that went through it years back. Could...

Try doing a Run As Administrator to open SSMS.

It's not the same as being in the Administrators group.

Sue

dbaforever (10/6/2016)

---

I have moved the SSISDB database to a new instance which is 2014 (SP1 CU5). Visual Studio 2013 is installed.

The packages show in the new SSIS Catalog but I'm...

Hi Sue,

Thanks for your comment, but when I query the view msdb.dbo.sysmail_faileditems, the column recipients has a valid email address for all items, so it doesn't make sense the error...

So what is the issue with the results if you do exactly what you...

You need to install ODAC 12c for your environment to get the latest drivers.

Here is a walkthru on doing it for a 64-bit SQL:

https://blogs.msdn.microsoft.com/dbrowne/2013/10/02/creating-a-linked-server-for-oracle-in-64bit-sql-server/

Sue

jcvv76 (10/6/2016)

---

RVSC48 (10/6/2016)

---

Hi, are you running a query similar to this one and still getting the recipients error message?

USE msdb

GO

EXEC sp_send_dbmail @profile_name='DBServerAlerts',

@recipients='some.user@acme.com',

@subject='Test message',

@body='Congrats, Database Mail received by you...

I don't know exactly what's going on with your issue but did note what you are trying to do in the first post.

If you use dbcreator server role, members...

I like the approach of restoring the Prod database to another environment and then running CHECKDB. It also helps with testing restores, backups. But it's also not always feasible for...