Hi,
I am trying to locate my SSRS log files to troubleshoot some report problems.
I run Microsoft Visual Studio when designing reports using Report Designer, from a local installation of MSSQL Developer Edition on my notebook. The data source I work on is on a remote SQL Server.
I expect to find the SSRS Log Files on my local installation but I am having trouble locating it.
Please help.
Thanks in advance.
regards,
Kenny
SQL SERVER 2008R2
The number of files to retain for SQL Server Logs is set to 99. When I expand the SQL Server Logs node in SQL Server Mgt Studio it shows the current log file through Archive#49. The oldest archive file is dated 2015/05/26. If I select that archive in SQL Server Mgt Studio it shows me the details and entries of that archive file. Yet when I go to the directory on SQL Server for the log files there are only the 5 most recent files. I have searched for '.trc' files on the entire drive and have found no other files.
How can SQL Server Mgt Studio show archive files that have no corresponding archive file in the directory that is supposed to contain the log files?
I am trying to reorganise the log files on a server, (long story short they are fragmented so I want to shrink and reset the initial size and growth) and I am unable to shrink them. When I run the following:
use test
DBCC SHRINKFILE(test_log, TRUNCATEONLY)
--or
use
DBCC SHRINKFILE(test_log,2, TRUNCATEONLY)
I get the following message:
Msg 8985, Level 16, State 1, Line 1
Could not locate file 'test_log' for database 'test' in sys.database_files. The file either does not exist, or was dropped.
I get this message for every database on the server. I got the logical name of the file using sp_helpfile and have checked it against sys.masterfiles, sys.database_files and sys.sysaltfiles, all match up and confirm the name 'test_log'.
I rebooted the server last night and was able to shrink the first couple of .ldf's I tried so I presumed it was fixed. This morning when I try again i get the sanme error, I don't see anything in the SQL server or system logs that indicates a change.
I am able to add new log files and remove log files, however if I add a new log file (test_log2) and then try and truncate that file I get the same error.
Hello Friends,
I have created few reports in SSRS 2005 on Windows 2003 Standard. Previouly I was not able to view reports from my .ASPX page which contained a ReportViewer, after going throuhg some other threads I was able to create a snap-shot for my reports . But still I'm not able to view reports, each time I try to view the page I get a message box with a error as : "Unable to locate control SSRS 2005: oReportCell" the same error is displayed when i try to access my reports from "http://localhost/reports.....".
But the funny thing is I'm able to view the reports when I use the following URL: "http://localhost/reportserver/pages/reportviewer.aspx?/<report>". I have applied all the Hotfixes & installed the latest Service packs. Any suggestions ???????
Can I create reports with Crystal Reports and Deploy them in SSRS?
Thanks in advance,
saied
I have SSRS Log files under
c:MSSQLMSRS11.MSSQLSERVERReporting ServicesLogFiles
I am getting frequently errors in report manager. When I open that log files, I can see some old logfiles in 2013. So now how to enable that logging feature again.
i.e. before that they enabled the logging in reportserver and disabled now?
I am working with vs2013 and have developed ssrs report in ssdt that creates RDL files, I want to view this report in asp.net web page using vs 2013 Reportviewer control. How do I do that? What are the proper steps to configure reportviewer control.so I can view ssrs report through vs2013 ultimate edition.
View 2 Replies View RelatedWe have the following requirement :
1. In daily basis auto loop through each item in the invoice table.
2. passing invoice number into a Summary SSRS report as parameter.
3. Auto download ALL generated PDF reports into a window folder with a special file name format i.e. <INVOICE_NO>_<DATE>.pdf
how to achieve this via SSRS, Store Procedure or Power Shell?
I have just loaded some tables to our main db.there is a col in one table called MAPCONCEPTID.I want to know how to find where MAPCONCEPTID field in one of the table is mapped to.
View 3 Replies View RelatedHi,
Can someone help me, I installed SQL 2005 Enterpirse Editon on windows clustered servers. Then after the installation
I want to change the path of my DB logs but the problem was, I can not see the other drives. I can see only the drive where the DB was located. Is there any special configurations that should be done.
Thanks.
Russell
How can I get my hands on the Microsoft SQL Server resource kit?
In particular, I need the "Load Simulator" application.
Any information would be greatly appreciated.
Jim
I am creating a table on the fly and then trying to associated the table
inside of a cube, using vbs script. For some reason I get a table not found
error when I try and open the cube, but when I look at the SQL server I am
able to see the table and I can insert the table via analysis manager, but I
get Unable to retrieve the list of columns for the <table name> table.
Any Ideas why I am not able to add the table from the analyzer?
Hey there, could someone please help me!!
I had created a database in sql server but since then installed windows xp pro and now when i go through the microsoft sql server dsn configuration the database is not valid and therefore i cannot change the default database as it says it doesn't exist.
So then when i type in command prompt use 'db' it says it doesn't exist but when i try to create 'db' it says that the database already exists.
I get the error message, could not locate entry in sysdatabases for 'cti' (database name).
When i look in mysql - data - along with master etc there is my cti.mdf and log files??
I'm stuck???
Is it that the files just aren't registering through sql server???
Please help!
Is there a query that I can run in SQL to find all the table names? I have a certain table I am trying to locate.
View 1 Replies View RelatedI have created a new filegroup,and i want to add existing table to the file group.
I don't have the appropriate syntax for this.
Please Help.
Regards Mr. Mumin
Thanks All,
I have a sql table containing names of departments. Is there a way after a user has typed a department in a textbox on a web page I can search for it in the sql table and if it isn't there then add it. I am using asp.net for the web page.
View 3 Replies View Relatedwhen we get something like this in QA:
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near ','.
I only have 3 lines inclusing only one insert. How do I know what value or keyword is wrong from the error message above.
Thanks
Part of our product will be using several SSIS packages. One of our installers wants to be able to create a .cmd file that will run DTEXEC against one of the packages, with the correct config file specified. It had been assuming that SQL Server was installed in the Program Files special directory, but that's not always the case.
What is the correct way to locate the installation of SSIS? In fact:
What is the correct way to determine whether SSIS is installed?
What is the correct way to determine the version and SP that is installed (I want to require SP2)
I had been using the values under HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90DTSSetup until I found an SP2 machine with SSIS installed which did not have these keys. Where's the right place to look?
Hi All,
looking for some views about where to place these catalogs. The manual says they work more effiecntly on a different drive to the database, which is understandable.
I'm in the processes of designing a new database application which is to be avaiable via the internet, and extranet app. But as I'm planning to host the app and the main database on a shared server but to have the catalogs on another server held in house. The app will have search facilities as its main use. They will obviously be some performace issues, but is this a good idea?
Thanks for any comments..
Regards
Davej
How to locate last occurrence of character in string?
View 1 Replies View RelatedHi Folks,
Getting the following error after a DBCC CHECKDB
Server: Msg 8906, Level 16, State 1, Line 1
Page (3:15010) in database ID 9 is allocated in the SGAM (3:3) and PFS (3:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Trying to located the object that the allocation has gone to pot over.
Any quick way to resolve a datbase object using a page ID?
Thank In Advance
Hi
Im considering several options as to where to place the SQL Server and the web server in our organization's network I would like to hear your insights about the subject and the following options:
Option 1:
Placing the SQL Server inside the domain while the web servers are outside in the DMZ
Pros: SQL Server is in the domain, its harder to hack and its easier to manage inside the domain
Cons:the DMZ must allow access inside the domain so that the web servers can access the SQL Server this is not very secure.
Option 2:
Placing both SQL Server and the web servers in the DMZ
Pros: Fast access from web servers to the SQL Server. no traffic is allowed from the DMZ into the domain so the domain is completely secured.
Cons: The SQL Server is not very secured, its harder to administer it outside the domain.
I would love to hear of more options suggestions
thanks.
I am using SQL 2005 and I'm trying to find a T-SQL command that will allow me to retrieve a sub string based on the token. For instance, if I had a string like this:
abc^defgh^ij^klmnop^qrs
Let assume the token is the ^ and I want to get the string at the third token klmnop.
is there a simple one line command that I can use to retrieve this data?
Dear all,
I have installed JDE E1 Demo to my computer, which use SQL Server 2000. And the OS of my computer is Vista Home Prerium.
When I start the JDE, I met an error message, "Unable to locate security server". Cause this version of JDE could be running on XP, I guess if the problem is because of the combination of Vista+SQLServer2K.
I have checked that IIS is ok installed, the computer services are started automatically. But I have one strange phenomenon that after computer started, it seems that the SQL server service manager couldn't find the right server & service, so that server couldn't been started automatically.
Could you make some sense and show me some hint about this problem? Or could you tell me how the SQL service manager find the the server and service?
I have installed SQL Server 2005 in my computer but in different root, in addition.
Many thanks and Regards,
Viesta
Hi, as the subject suggest.
Thanks in advance
Hi
According to BOL, dbcreator should able to create, restore, backup, and etc.
But when i tried to restore with dbcreator's server role, it displayed this error message
TITLE: Locate Backup File - XXXX
------------------------------
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackup
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.
If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.
May I know what i had missed out?
Thanks In advance
hello everyone,I am using VS 2005 and sql server 2000. I have a web application which uses a connectionstring with a user id and pwd. Everything is fine, I can execute normal sql statements from the code behind. I cannot execute a stored procedure...I get this error. Could not locate entry in sysdatabases for database 'exec usp_add2DB (my parameters are included here, deleted for simplicity reasons)No entry found with that
name. Make sure that the name is entered correctly. I have given execute permission for the user, and the name of the storedproc is correct. the name of the server is also correct....pls pls help me what is wrong here...
SQL 2k, DDL below.I have a simple table with the following data:fldYear fldCode1 fldCode22000 ABC1 ABC122000 ABC1 ABC132001 ABC1 ABC122002 ABC1 ABC122002 ABC1 ABC13I need to know, for every distinct combination of fldCode1 andfldCode2, if there are any years missing.For example,SELECT DISTINCT fldCode1, fldCode2 FROM MyTablereturnsABC1 ABC12ABC1 ABC13I need to know that in 2001 there was no entry for ABC1/ABC13Thanks!Edwardif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MyTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[MyTable]GOCREATE TABLE [dbo].[MyTable] ([fldYear] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[fldCode1] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[fldCode2] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL) ON [PRIMARY]GO
View 2 Replies View RelatedAccess 2003 Data exported to SQL Express , great.
How do I then link the tables to the new database, I only seem to be able to link to system tables etc ??
Any ideas ?
My C# asp.net web application is throwing an exception and the message is the following:
RAISERROR could not locate entry for error 60002 in sysmessages.
The error occurs in the stored procedure. Can anyone tell me what I need to do to fix this problem? Note that if I manually run the stored procedure, I get the following error message:
Msg 2758, Level 16, State 1, Procedure GetPortalSettings, Line 74
RAISERROR could not locate entry for error 60002 in sysmessages.
Any idea what this error is?
error 911: could not locate entry in sysdatabases for database 'msdb'. No entry found with that name
Thanks.
Sa
I am having Windows 2012R2 Std with SQL2012SP2. Trying to add SQL cluster node2 but unable to locate the instance name when I click on drop down button.Understand that SQL Server Agent is required but it is not listed as cluster resource. Therefore, I perform the followingFrom Windows Power Shell with Administrator rights
1. Import-Module FailoverClusters
2. Add-ClusterResourceType "SQL Server Agent" c:windowssystem32SQAGTRES.DLL
Error: Add-ClusterResourceType : Unable to locate the cluster service executable on node1.The network name cannot be found.No problem to ping all cluster related names as well as fail-over to and from next available node.
Hi All,
I am truncating Transactionlog€¦ following the steps mentioned in MSKB.. what is the problem?
Use master
Go
Backup log xxx with truncate_only
go
Dbcc shrinkfile(xxx_Log)
Go
Msg 8985, Level 16, State 1, Line 1
Could not locate file 'xxx_Log' for database 'master' in sys.database_files.
The file either does not exist, or was dropped.
Please help me.
Thanks in advance