This will be little busy. This will be our consolidated server with multiple instances. I tried to look up for possible issues with this combination...
Thank you for the response! We are planning to build a new sql server cluster for our SQL Server 2008 R2 databases. We are planning to use a blade...
Hi, Can we configure sql server 2008 r2 database clustering between blade server and a rack-mounted server?
Thank you for the reply. Yes, I was refering to creating a Maintenance plan job (using a wizard). Is there any way we can open and tweak the SSIS...
Hi, I would like to setup Multi Server Administration in our environment. I would like to create a maintenance plan for all the dbs on the master...
I found exactly what i was looking for. The script below gets the vlfs for all the databases on your server in one hit. ref:...
Hi, I would like to create a query that runs dbcc loginfo command on all the databases and returns only the no. of rows returned for each database....
Thank you for your replies. My concern was the error message mentions the secondary server as the primary server. I checked the...
Hi, I have configured logshipping for a database. The primary server is in PST and secondary is in EST time zone. I see some false errors thrown from...
Hi, We have reports on development server right now which we want to move to production server. The developers have created the reports on their...
Hi, I find the following error in the error log:DESCRIPTION: SSPI handshake failed with error code 0x8009030c while establishing a connection with...
Hi, I was able to find the solution and just wanted to post it for others. The issue resolved when I added my self to the admin group on the server...
Thank you for your reply. I tried to connect using report server url in the management studio and it gave the following error. TITLE: Connect to...
Hi, We have made files only installation for reporting services on a server with out installing the database on the local server. The report server...
Hi, We have a report server and i would like to set up security and permissions on that. I see that every one is able to access the link and run the...
It worked when i changed the security setting on the default website on iis to use anonymous settings. But i think it is not advisable. Is there any...
The Configuration manager looks good. No errors on that.
Hi, We have installed and configured reporting services, we are able to connect to report server url from server however with same user when we try...
Hi, Thank you for your reply. I dont find any error logged in the error log. And there is no domain issue on the server also. I got it verified and...
Hi, When I am trying to create a new login using GUI on a server and try to serach for the windows accounts i am getting the following error: The...
Separate names with a comma.
