Search results for query: *

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...

I am getting errors on just a few of my shared schedules for SQL Server Reporting Services. I can not figure out why some shared schedules are giving this error and why others are not. All in the properies on SQL Reporting Services Shared Schedule seem the same. All in SQL Server Database...

The SQL Full Text service is running. I restarted this service and the Backup finally STOPPED. THANKS YOU! Do I dare try to run backup again? I am cauious because I do not want to have the backup stuck again, can not easily restart SQL Server, production server. All other backups on the...

I am using SQL Server 2005 SP3.

My Database backup never ends. I was able to previously backup the database in less then a minute. Now my backup runs forever and never ends. It has a wait Type of "MSSEARCH" I stopped the backup. I then Killed the backup (kill spid). The Backup still shows in the Activity Monitor. The...

I need to uninstall SQL Server 2005 and then reinstall the program. Our current SQL Server has many databases I want retain once I have reinstalled SQL Server. I am assuming the uninstall will not delete my database files???? I currently have the SQL Server program and the databases all...