Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. katekis

    Create Stored Procedure or SQL Job GRANT ALTER ANY LOGIN

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

    Security issues in SSRS 2008 R2.

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

    Security issues in SSRS 2008 R2.

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

    delete UserName everyone from ReportServer

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

    delete UserName everyone from ReportServer

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

    Alerts Setup but no Email is sent to Notify operators?

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

    Netapp SnapManager for SQL Server - Do I need it

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

    My Reports - SQL Server 2008 R2 issue Upgraded from 2005 SP3

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

    My Reports - SQL Server 2008 R2 issue Upgraded from 2005 SP3

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

    Uninstall SQL Server but leave SQL Server tools and Components

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

    Uninstall SQL Server but leave SQL Server tools and Components

    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?
  12. katekis

    Moving User Databases

    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:\...
  13. katekis

    Maximum Server Member (In MB) - question

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

    Database Restricted User

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

    Database Restricted 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...
  16. katekis

    shared schedule disabled login

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

    Backup never ends -- how to kill backup, kill/stop does not work

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

    Backup never ends -- how to kill backup, kill/stop does not work

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

    Uninstall and then Reinstall SQL Server 2005

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

Part and Inventory Search

Back
Top