thanks for the reply, I'm not the SQL expert, just the network admin trying to keep a handle on permissions (both for SQL and file systems) and was hoping to...

ok, thanks. And Commvault does work well, it's an enterprise solution that does back up and restores, replication, log shipping, deduplication, disaster recovery, etc., all perfectly across our environment....

Ok, thanks, is there a way to use windows (2012r2) to do it with a command-line? Just trying to automate it without having to install extra software on a...

found this article online (http://blogs.technet.com/b/mdegre/archive/2010/08/29/the-server-principal-quot-sqlloginname-quot-is-not-able-to-access-the-database-quot-mydatabasename-quot-under-the-current-security-context.aspx)

and it seems to point to the sys.syslogins database. When I run this query against a database the user can access correctly,...

thanks for the reply. Im actually using Commvault to back up my production database, and then using scheduled commvault jobs to restore the logs to my reporting database copy....

thanks for the reply. It is in "Standby / Read-Only" mode

that worked great, thank you!

Thanks, but the data has personal information in it (full names, and phone numbers) so I was trying to avoid putting that on the internet.

Ok, thanks. This is my call data table:

INSERT INTO [Cisco_CallManager].[dbo].[CDR]

([datetimeorigination]

...

Sorry, thanks for the help. The first query is from a custom SQL database, the results of the query give me this:

reviewer accountid accounttypeid ...

excellent! Thanks for the sample!

Just in case anyone runs into this issue, it is definitely a SQL 2008 r2 issue with the default driver. I compared the registry values and matched it to...

From the same server, I can go to the ODBC connections window and make an ODBC connection to the remote server no problem. But I just can't do it...

It's a completely different network, connecting over the internet, not internally. Ping is turned off though, b/c I cannot ping even from the SQL server that works. Again,...

thanks for the reply, the error is below. However, I CAN connect from a different SQL 2008 server

TITLE: Connect to Server

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

Cannot connect to 207.245.109.91.

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

ADDITIONAL INFORMATION:

A network-related or instance-specific error...