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 |
|
mparter
Yak Posting Veteran
86 Posts |
 Posted - 2005-03-10 : 19:33:36
|
I've finally got the solution outlined at http://www.sql-server-performance.com/sql_server_log_shipping.asp to work. The problem now, is with the standby database on the development server. It's in read-only mode as it should be but if I try and read any of the data in the tables from EM, I receive the following error:-Connection failed:SQLState: '08004'SQL Server Error: 4060Server rejected the connection; Access to the selected database has been deniedIf, I try and access any table in the same database from QA, it works fine  I'm logged into the server as a local administrator so I'm not sure that it's a permissions issue. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-10 : 19:58:57
|
| Not sure why you'd want to view them inside Enterprise Manager, but I would suggest running SQL Profiler to determine what the problem is. Make sure to include the Exceptions event class in the trace.Tara |
 |
|
|
mparter
Yak Posting Veteran
86 Posts |
Posted - 2005-03-11 : 03:09:36
|
| OK, thanks, I'll give that a try. |
|
|
|
mparter
Yak Posting Veteran
86 Posts |
Posted - 2005-03-11 : 04:26:24
|
| OK, ran the profiler and all I got was a list like so:- SPID------------------Exception 54Exception 54Exception 54Is there any way to get a more descriptive output? |
|
|
|
|
|
|
Custom Log Shipping