We had a server crash and had to rebuild everything and ever since then Reporting Services jobs have been failing with the same SETUSER error.  I've changed SQL permissions until...

Keep in mind Scan SQL Scan requires the user to be a domain administrator when it is used to target remote machines.  As for hiding the Server in the TCP/IP properties,...

Stacy,

If your goal is to have a reporting database then you probably need to stick with log shipping.  I've read that with the new database mirroring in 2005 that the database is always in...

In the SQL Server 2005 June CTP Books On Line under "Configuring Log Shipping" it says this:

Log shipping has the following requirements:

SQL Server 2005 Standard Edition, SQL Server 2005 Workgroup...

Are you using the same version of iSeries driver on the same operating system as the other servers that work?  Is the ODBC DSN set up exactly like the others?  In the...

A good place to start is Books On Line topic "Failover Clustering Architecture".  Then search on "cluster" or "failover" and you'll be reading for awhile 🙂

Linda

Are there other applications on the server other than SQL Server?  If so, you could check or increase the pagefile size.  Also, you may want to set up a SQL Server...

I've never had to restore the primary database yet, but I believe you would need to remove log shipping, restore, and set up from scratch.  The reason is that the LSN numbers...

You could just run EXEC master..xp_readerrorlog instead of loading it into EM to read.  You could also schedule a weekly job using dbcc errorlog to help maintain the size.  You...

Check out your Windows Application and System Logs and also your SQL Server errorlog.  There must be a clue somewhere.  Do you have to restart SQL Server or reboot to...

Why not have them log into Enterprise Manager each time?  You may need to create a standard SQL Server login for each person if you are only using Windows authentication.  On...

We are using Log Shipping and because the transaction logs grew so large, I ended up splitting up the tables to be reindexed.  It took a while to figure out...

We have a Windows 2003 server and also ended up adding the OLAP Administrators group to the share MSOlapRepository$ created by Analysis Services located here C:\Program Files\Microsoft Analysis Services\Bin.

Linda

You guessed it.  It's written for multiple platforms.  However, they haven't seen performance issues at other sites like we have here.  Of course our site is really stress-testing the application...

The scripts are not located on the database server, but a smaller server.  The application calls the scripts that contain T-SQL code.  We have run traces to capture, but it doesn't...