Recent content by katekis

I am trying to create a stored procedure or SQL Job to run the following command. use Master GRANT ALTER ANY LOGIN TO "domain\login" GO I can run the above command just find manually from a SQL Query but when I try to creat a SQL Job and run the command I get a syntax error? Does anyone...

I am having some issues with securing my SQL Server Reporting Services. I are using SQL Server 2008 R2 and Report Builder 3.0. I are using the Native Mode. In the rsreportserver.config I am using <RSWindowsNTLM/>. The SSRS Service runs as Domain\mssql123. I am the DBA and my login is...

I am having some issues with securing my SQL Server Reporting Services. I are using SQL Server 2008 R2 and Report Builder 3.0. I are using the Native Mode. In the rsreportserver.config I am using <RSWindowsNTLM/>. The SSRS Service runs as Domain\mssql123. I am the DBA and my login is...

The problem is Report Manager looks like it is set correctly but still everyone with access to the webserver has access to everything. For example I have a folder labeled "Data Processing", if I look at the folder settings it looks like only the RS_DataProcessing group has access to the...

I moved from SQL Server 2005 Reporting Services to SQL Server 2008 R2 Reporting Services. Since I Upgraded now everyone has access to do whatever they want in reporting services. In the ReportServer table I see UserName: Everyone, UserType: 1, AuthType: 1 I am not sure how this got there...

I have multiple SQL Servers. On each of the SQL Servers I have Alerts setup. One of them is for Insufficient Permissions. I am using SQL Server 2005 SP3 On some of my SQL Servers if their is a login Failure the alert works just fine. The Notify Operators receive the Email saying Login...

I have 'Netapp SnapManager for SQL Server Management Console' installed on my Server but I have never used it. I do all my database backups using Quest Litespeed. My server Admin wants to uninstall the Netapp SnapManager. Is there any reason I need Netapp SnapManager and it should not be...

Can someone tell me what 'My Reports' and the 'User Folders' security is normally set to by default?

I upgraded from SQL Server 2005 SP3 to SQL Server 2008 R2. I am having an issue with our Report Services - My Reports Folder. Users have a 'My Reports' folder but they can not see their reports. I can go to 'Users Folders' and see their folder with the reports in it. If I type in...

I am using SQL Server 2005 - with Service Pack 3.

Is there a way to uninstall SQL Server but not uninstall the Tools and Components? Do I need to uninstall SQL Server and then re-install the SQL Server Components and Tools?

I have a similar question We have one SAN with the following volumes. We have both the Database (.mdf) and the Log (.ldf) on the same volume mapped to the same drive. Current Setup Example: Server1 - MiscDBs - e:\ Server2 - MiserBA - g:\ Server2 - AppXndr - h:\ Server2 - MiscDBs - i:\...

According to my notes for SQL Server 2005 Set 'Maximum Server Member (In MB)' to 1 GB less then the amount of RAM on the Server. Example: 32 GB – 1 GB = 31 GB * 1024 = 31,744 MB, then round it to the nearest thousand Is this correct? Any other feedback? In our SQL Server Monitoring...

I found the answer top my own question. This fixed the problem. alter database DBNAME set multi_user

I backed up one of my databases and restored it with a new name. I do this each monthend. I backup database xyz and restore it as YYYY_MM_xyz. This month for some reason the database name has (Restricted User)? The database looks like: 2010_12_xyz (Restricted User) I have never seen a...