Have you tried creating an alias on your SQL Native Client configuration on the machine you are connecting from?

Great 🙂

what did you eventually do to fix it?

Thanks,

Justin

Are you sure its...

If you launch replication monitor and go and view the status of the subscription, what does it say?

Is the status "Not Running...."

if so, right click on it and say,...

You could also look at your file growth settings? is the default at 10% still? think how bad that is when you start reaching big sizes?

Maybe set the rate of...

Can you check and see how the articles are configured.

I think by default, the article is dropped and recreate from publisher when you push a snapshot.

You may find that with...

right click on the publisher, View Log Reader Agent Status... STOP

Have you looked at using PowerShell at all?

This can be called from within your C# application and PowerShell has AlwaysOn assemblies you could use for the database manipulation?

http://blogs.msdn.com/b/kebab/archive/2014/04/28/executing-powershell-scripts-from-c.aspx

Are you doing this as a form of Automation?

Just want to understand why you need to use C#?

What account was the SQL Server Engine running under?

Surely this account would need full access to the folder your data files were located?

What about creating an alias on the new instance name?

Whenever the old connection string is used, it can be diverted to the new name?

Why not set up Always On with a secondary read, or enable SQL mirroring between the two instances?

With Mirroring, you can create a daily snapshot of the mirrored db and...

This is a client based permissions issue and not a SQL Server permissions issue.

You will need to either add the user to local admin on their machine, or lower the...

have a look at PMB on codeplex (https://epmframework.codeplex.com/). There is a step where you can create SQL jobs that calls a PowerShell script to run and check policies....

Improved script can be found at http://www.sqlservercentral.com/scripts/powershell/97305/