Thursday, March 29, 2012
can't connect 2005 reporting server...need help
window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
admin and got error when i try to connect report server:
Cannot execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
anyone knows about this and thanks alot for a help
Karen,On Apr 27, 1:50 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
wrote:
> We installed sql 2005 server and reporting services (standard edition) on
> window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> admin and got error when i try to connect report server:
> Cannot execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information about
> the error and where it originated in the code.
> Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
> execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> Source Error:
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
> anyone knows about this and thanks alot for a help
> Karen,
I received your email and noticed that you posted here as well. If you
do not have the .NET 2.0 framework installed, this might be the
problem.
Regards,
Enrique Martinez
Sr. Software Consultant
Can't connect 2005 reporting server
window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
admin and got error when i try to connect report server:
Cannot execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
anyone knows about this and thanks alot for a help
Karen,On Apr 27, 2:24 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
wrote:
> We installed sql 2005 server and reporting services (standard edition) on
> window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> admin and got error when i try to connect report server:
> Cannot execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information about
> the error and where it originated in the code.
> Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
> execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> Source Error:
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
> anyone knows about this and thanks alot for a help
> Karen,
Please refer to my previous post at:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9efeaacdc0875e6d/7ce06f2ec8a78f36#7ce06f2ec8a78f36
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique,
Thanks your replay and i do have .NET 2.0 installed. I feel like its
security issue.
What is security context of .NETservice account (NT
Authority\NetworkService)? and how do you confiure this account for web
service identity?
"EMartinez" wrote:
> On Apr 27, 2:24 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
> wrote:
> > We installed sql 2005 server and reporting services (standard edition) on
> > window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> > admin and got error when i try to connect report server:
> > Cannot execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> > Description: An unhandled exception occurred during the execution of the
> > current web request. Please review the stack trace for more information about
> > the error and where it originated in the code.
> >
> > Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
> > execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> >
> > Source Error:
> > An unhandled exception was generated during the execution of the current web
> > request. Information regarding the origin and location of the exception can
> > be identified using the exception stack trace below.
> >
> > anyone knows about this and thanks alot for a help
> >
> > Karen,
>
> Please refer to my previous post at:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9efeaacdc0875e6d/7ce06f2ec8a78f36#7ce06f2ec8a78f36
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Hi Enrique,
Thanks your replay and we do have .Net 2.0 installed. I feel like that this
problem related to security issue.
How do you configure your web service account (NT Authoriry/NetworkServices)
?
Karen,
"EMartinez" wrote:
> On Apr 27, 2:24 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
> wrote:
> > We installed sql 2005 server and reporting services (standard edition) on
> > window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> > admin and got error when i try to connect report server:
> > Cannot execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> > Description: An unhandled exception occurred during the execution of the
> > current web request. Please review the stack trace for more information about
> > the error and where it originated in the code.
> >
> > Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
> > execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> >
> > Source Error:
> > An unhandled exception was generated during the execution of the current web
> > request. Information regarding the origin and location of the exception can
> > be identified using the exception stack trace below.
> >
> > anyone knows about this and thanks alot for a help
> >
> > Karen,
>
> Please refer to my previous post at:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9efeaacdc0875e6d/7ce06f2ec8a78f36#7ce06f2ec8a78f36
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Tuesday, March 27, 2012
Can't change name of report
Good Morning Guys,
Can anybody tell me how to change the name Property of a report on the Report Server?
When im using the standard Webpage, i can change all the properties i want.
But when i try the same in code. Changing the name property gets me a read-only exception.
The description does change but i actually want the name to change.
public string setProperties(string property,string value, string itemPath)
{
try
{
Property[] props = new Property[1];
Property setProp = new Property();
setProp.Name = property;
setProp.Value = value;
props[0] = setProp;
rpServer.SetProperties(itemPath, props);
}
catch (SoapException ex)
{
throw ex;
}
return "";
}
Is there an easy way around this, or do i have to solve it by creating a new report with a new name, and delete the old one?
Thanks in advance,
You need to call the MoveItem API.|||Tnx Teo,I still think its strange to have a function to set properties.
And you cant set the most important property :)
Greetings
PS: the blond girl name was to draw attention, cause this issue was quite high prio. ;) Sorry for that.|||
The name isn’t really a property in that it changes the path in the namespace. For example, you can’t have two things with the same path, etc.
PS: How disappointing :-)
Tuesday, March 20, 2012
cant access report manager options
i installed sql server 2005 standard edi with reporting services on win2003 server.
i can open report manager page in IE but i cant access anything i mean report builder,upload file link option etc., they are disabled for some reason.
Yes i went to site settings(interestingly i can access this !!) and gave all rights i see there to the user but no avail.
interestingly i can access all options from IIS manager !
any ideas how to fix this ?
am using IIS6its still a problem !!
any help much appreciated. Thanks|||Does giving yourself Local Administrator on the server machine help?
Or Domain Administrator
By default you should be
Hi Jerry
Actually i logged in as domain administrator. what i dont understand is i cant access any options on report manager page (except site settings) in IE but i can access everything in IIS's management console!!
i even tried deleting virtual directories and reconfigured reporting services still made no difference.!
|||finally got it workingi added relevant user on "properties" page that we see reportmanager home page. everything fine now :)
cant access report manager options
i installed sql server 2005 standard edi with reporting services on win2003 server.
i can open report manager page in IE but i cant access anything i mean report builder,upload file link option etc., they are disabled for some reason.
Yes i went to site settings(interestingly i can access this !!) and gave all rights i see there to the user but no avail.
interestingly i can access all options from IIS manager !
any ideas how to fix this ?
am using IIS6its still a problem !!
any help much appreciated. Thanks|||Does giving yourself Local Administrator on the server machine help?
Or Domain Administrator
By default you should be
Hi Jerry
Actually i logged in as domain administrator. what i dont understand is i cant access any options on report manager page (except site settings) in IE but i can access everything in IIS's management console!!
i even tried deleting virtual directories and reconfigured reporting services still made no difference.!
|||finally got it workingi added relevant user on "properties" page that we see reportmanager home page. everything fine now :)
Monday, March 19, 2012
Cant access (local) server
I installed the .Net Enterprise Architect and SQL Reporting Services. My SQL instance is still running, but I can't get to it through EM and SQLServerAgent won't start. When I try to start SQLServerAgent manually, it gets about halfway through the process, then shuts itself down again. I also have an MSDE instance that is not complaining at all.
I can get to the server from my applications. I can also register it in EM with the IP and get to it that way.
Here's what's in sqlagent.out:
2007-01-02 16:34:41 - ! [298] SQLServer Error: 6, Specified SQL server not found. [SQLSTATE 08001]
2007-01-02 16:34:41 - ! [298] SQLServer Error: 11004, ConnectionOpen (Connect()). [SQLSTATE 01000]
2007-01-02 16:34:41 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start
2007-01-02 16:34:42 - ? [098] SQLServerAgent terminated (normally)
I did confirm in the registry that the port is set to 1433. It's not blank or incorrect. I am also working with a local account that is in the administrators group. There is no AD structure at work.
Many thanks for any ideas. This one feels like a little needle in a big haystack.
EaglesYouc an't have a 2k and an msde instance both named local... one of them HAS to be a named instance. Which one is named?|||The MSDE instance is named. The SQL Server 2000 instance is local.|||what server name do you use to connect to msde?|||One question (which will lead to others..) Were the two instances (Both MSDE and SQL Server existing before all the other installs? And happily co-existing?|||Yes, the 2 instances have been happily co-existing for over a year and things have been very stable. Since it's all the SQL instances are test environment, there's quite of bit of database creation and deletion in both the SS2K and MSDE instance. I also freqently register my clients SQL servers when I'm on-site also. There is actually a third instance which is another MSDE instance. Here's a snippet of them:
(local) - SS2k WITH sp3a. Currently houses a database for Project server and several small company databases for an accounting app. This instance starts automatically. It has been in place for ever a year.
acsob- MSDE instance with several company databases for an accounting application. This instance and it's accompanying sqlserver agent start automatically. It has been in place for over year.
quickalerts - MSDE instance with an interface application to the SS2K accounting application. This instance and accompanying sqlserveragent are set to start manually and are rarely running. This instance was installed 2 weeks ago. It was running constantly during initial configuration and testing.
All these servers are test environments with very low usage. I use them to do software demos, training, and testing. There's rarely more than one user logged in to any of the servers.
Last night after I opened this thread I registered the local sql server instance using the machine IP (assigned by the DHCP server). I was able to get it using the IP address but not as (local). That brought to light another piece of possible useful info. About a month ago, I enabled the mail role on this machine so I could send mail when I'm on the road. That all worked fine with one exception. I can not send email to my own domain account. I can send email to any other domains. I can also receive email to myself that I send from my providers webmail. Not sure if this is relevant, but it's starting to feel like a dns issue somewhere.
Thanks.
Eagles|||I can now get to the the sql instance through EM. The hosts file contained the following entry:
127.0.0.1 localhost
I added this entry:
127.0.0.1 local
A network admin at a client site suggested this.
The sqlserveragent still starts and immediately shuts down.
Wednesday, March 7, 2012
Cannot start SQLEXPRESS
I have just had to reinstall all my SQLServer instances (SQL2005 Standard, BCM2007, and SQLEXPRESS).
The first two have started fine, but I cannot get the SQLExpress instance to start. When I start in the Management Studio, the error I get is:-
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Loating Server/Instance Specified) (Microsoft SQL Server)."
Can anyone tell me what I have to do to correct this problem:?
I have looked in the Add or Remove Programs window and cannot see ANY instance relating to SQL Server Express 2005.
Hi,
First, if you have installed SQLExpress on your local machine then it should allow you to connect. If not try to configure it to allow remote connections. Following links will help you to do so.
And last, if you want to know about SQLEXpress instance, go to services in management console and there you can find if SQLExpress service is running or not and at the same location you can find the SQLExpress instance information.
Links are:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1712017&SiteID=1
http://techno-geeta.blogspot.com/2007/04/sql-server-2005-remote-connections.html
Mayur Tendulkar
Microsoft Student Partner
Asst. Manager: Pune User Group For Students
|||Unfortunately, none of these suggestions can be implemented. SQLEXPRESS does NOT appear in either the Surface Area Configuration menu, nor in the Configuration Manager module in MMC.
It does appear in the services tab, but when I attempt to start it, I get the response:-
"Could not start the SQL Server (SQLEXPRESS) service on local computer. Error 3: the system cannot find the path specified."
How do I reconfigure this to allow it to work?
|||Hi.
It seems that your SQLExpress installtion has problems. Please try to reinstall it. It may solve the problem.
Mayur Tendulkar
Microsoft Student Partner
Asst. Manager: Pune User Group For Students
|||Mayur
Thanks for that information.
I tried the installation again, and all tasks completed successfully other than the last one "SQL Server Database Services" where it reported an error:-
"The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "Howto view SQL Server setup log files" and "Starting SQL Server manually"."
This repeats when I retry. When I cancel, the install process finishes, but the SQLExpress instance does not appear.
This install generated an error report that is apparently sent to Microsoft. However, this does NOT help me with getting SQLExpress to actually WORK.
How do I rectify this issue? I need to have this instance running so that I can support my clients with another package that depends upon this working.
I am including the last part of the summary installation log which may help with your examination:-
Failed to install package
Fatal error during installation.
Setting package return code to: 29503
Complete: InstallSqlAction at: 2007/5/17 14:45:10, returned false
Error: Action "InstallSqlAction" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Skipped: InstallToolsAction.10
Skipped: Action "InstallToolsAction.10" was not run. Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "tools", install will be skipped as a result.
Skipped: InstallASAction
Skipped: Action "InstallASAction" was not run. Information reported during analysis:
No install request found for package: "as", install will be skipped as a result.
Skipped: InstallRSAction
Skipped: Action "InstallRSAction" was not run. Information reported during analysis:
No install request found for package: "rs", install will be skipped as a result.
Skipped: InstallToolsAction
Skipped: Action "InstallToolsAction" was not run. Information reported during analysis:
No install request found for package: "tools", install will be skipped as a result.
Skipped: RepairForBackwardsCompatRedistAction
Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis:
Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Error: Action "UninstallForMSDE2000Action" failed during execution. Error information reported during run:
Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchMSDE2000" failed due to a precondition.
Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run:
Action: "UninstallForSQLAction" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchLibertySql" failed due to a precondition.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:
Condition "The Clustered SQL Server instance that hosts is installed." returned false.
Running: ReportChainingResults at: 2007/5/17 14:45:10
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 3
Error Code: 0x80070003 (3)
Windows Error Text: The system cannot find the path specified.
Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults:erform
Source Line Number: 3521
- Context --
sqls::HostSetupPackageInstallerSynch:ostCommit
sqls::HighlyAvailablePackage:reInstall
led due to cancel code received from cancel source: 29539
Hi,
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=175249&SiteID=17
I'm bit confused too but this may solve your problem.
Mayur Tendulkar
Microsoft Student Partner
Asst. Manager: Pune User Group For Students
|||Mayur
This may have some bearing on my problem. Yesterday, because I was having problems updating SQLExpress with SP2, I decided to uninstall SQL Server entirely. However, I did NOT remove the various MSSQL* sub-directories. Could it be that SQL Express is getting confused with which of these it should instantiate? The sub-directories I have now are:-
MSSQL - containing what looks like my SQL Express databases - this was previously a MSDE2000 instance.
MSSQL.1 - containing what looks to be the SQL Standard edition databases. This has an OLAP sub-directory.
MSSQL.2 - does not contain any databases. This instance does have Reporting Services and OLAP sub-directories.
MSSQL.3 - also does not contain any databases.
MSSQL.4 - seems to be only Reporting Services.
MSSQL.5 - has some empty default databases.
Do you think that I should re-install SQL Server SE and SQL Server Express again, having removed the entire directory structure again? (clearly after backing up the databases I need - which I did do yesterday, of course).
|||Hi,
I too think that, it would be a great solution. Also remove all SQL Client tools, SQL-XML and other tools that gets installed with SQL. There is no specific order in which you can install SQL Server's diff editions. However, I would recommend from older to newer and Express edition first before SQL SE 2005.
I guess, this will solve your problem.
Mayur Tendulkar
Microsoft Student Partner
Asst. Manager: Pune User Group For Students
Saturday, February 25, 2012
Cannot specify 'dimension' for: Maintenance plan remove files older than
OS: Windows Server 2003 Standard Edition. MSDE 2000.
SQL Server Enterprise Manager Version 8.0.
The Maintenance Plan Wizard will not allow me to specify a value for the 'Remove Files...' I can enter a number but there is nothing in the drop down e.g. 3 'DAYS' perhaps?
Create then plan and then edit - yields the same result.
Any ideas on why there is no 'dimension' for Remove Files Older than ?
Appreciate any tips, ideas, etc.
Thank.s
Anybody have issues trying to specify a dimension for 'Remove Files...' either during Maintenance Wizard (create) or afterwards - edit properties?
The drop down - where you would expect a list of values like: day, week, month - is completely blank?
|||I'm experiencing the exact same problem with my MSDE database. I cannot specify anything as to days, weeks, etc. It also will take other information, such as scheduling, directory, extension name, and actually create the jobs correctly, but then when you go back to the Maintenance Plan, you find the information has disappeared. If you try to modify any other aspect of the plan, you get an error, because this information is now missing. This is the only MSDE db I have, all the rest are standard or enterprise and work normally from the same Enterprise Manager.
I have not found any explanation or work-around for this problem.
Cannot specify 'dimension' for: Maintenance plan remove files older than
OS: Windows Server 2003 Standard Edition. MSDE 2000.
SQL Server Enterprise Manager Version 8.0.
The Maintenance Plan Wizard will not allow me to specify a value for the 'Remove Files...' I can enter a number but there is nothing in the drop down e.g. 3 'DAYS' perhaps?
Create then plan and then edit - yields the same result.
Any ideas on why there is no 'dimension' for Remove Files Older than ?
Appreciate any tips, ideas, etc.
Thank.s
Anybody have issues trying to specify a dimension for 'Remove Files...' either during Maintenance Wizard (create) or afterwards - edit properties?
The drop down - where you would expect a list of values like: day, week, month - is completely blank?
|||I'm experiencing the exact same problem with my MSDE database. I cannot specify anything as to days, weeks, etc. It also will take other information, such as scheduling, directory, extension name, and actually create the jobs correctly, but then when you go back to the Maintenance Plan, you find the information has disappeared. If you try to modify any other aspect of the plan, you get an error, because this information is now missing. This is the only MSDE db I have, all the rest are standard or enterprise and work normally from the same Enterprise Manager.
I have not found any explanation or work-around for this problem.
Friday, February 24, 2012
Cannot shrink tempdb
HI There
I have a strange problem.
This is on Sql Server 2005 Standard Edition X64.
Tempdb ran out of space, ok cool no problem i know why we fixed it.
However temodb grew to the size of the disk when this happened. So now i just need to shrink the tempdb file on disk.
But no matter what i try it wont shrink.
The temodb data file is 29Gigs on disk. When i right click on th DB and you to tasks and go to shrink file, the GUI says that the file is 15 Gigs with 15 Gig free space available, i select the option to shrink to 15Gig. I click ok. Afterwards the file is still 29Gig on disk.
SO i ran sp_spaceused , it reports that tempdb has 29Gig free space, so i ran DBCC SHRINKFILE for the tempdb data file to 15 Gig, the command completely successfully , however afterwards the file is still 29Gig on disk.
My first problem is that management studio, thinks the file 15 gig not 29 gig, and i cannot shrink the file with management studio or tsql, even though they report that there is plenty of free space.
PLEASE HELP?
Thanx
You can start here.http://support.microsoft.com/kb/307487|||...and don't forget to read up on this excellent whitepaper on tempdb.
http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx
Sunday, February 19, 2012
Cannot send attachment using sp_send_dbmail
I've been scraching my head on this for so long. We have two servers (both
running SQL 2005 64-bit Enterprise Edn SP2 on Windows 2003 Standard 64-bit),
one of the servers is able to send the attachment in the email, whereas the
other is failing with Msg 22051 error:
Msg 22051, Level 16, State 1, Line 0
Attachment file
\\srvr2\data$\Departments\Administration
1\Finance\shared1\New
Test\NewProd\Backup\test.txt is invalid.
The hardware configuration of both of these servers is exactly the same and
the SQL 2005 configuration is also exactly the same. Here is the command
which runs fine on one server but doesn't on the other server:
msdb.dbo.sp_send_dbmail
@.profile_name = N'LOCAL',
@.recipients = N'smarty@.testworld.com',
@.subject = N'TEST',
@.body = N'TEST',
@.file_attachments =
N'\\srvr2\data$\Departments\Administrati
on1\Finance\shared1\New
Test\NewProd\Backup\test.txt'
Database Mail settings on both the servers is also exactly the same. If I
don't specify the attachment, I receive the email in my inbox. I have also
tried mapping the drive, but still the same error. The strange thing is that
it works on the other server. Very odd. Did anybody come across this
situation..'
Thanks,My guess would be that the account that sql server runs under on the server
in which this fails does not have access to that share. Is it a domain
account and does that account have the correct perms to access that share.
Andrew J. Kelly SQL MVP
"Smarty" <Smarty@.discussions.microsoft.com> wrote in message
news:B0A66154-E4A3-49AA-9729-68C840868A9C@.microsoft.com...
> Hi,
> I've been scraching my head on this for so long. We have two servers (both
> running SQL 2005 64-bit Enterprise Edn SP2 on Windows 2003 Standard
> 64-bit),
> one of the servers is able to send the attachment in the email, whereas
> the
> other is failing with Msg 22051 error:
> Msg 22051, Level 16, State 1, Line 0
> Attachment file
> \\srvr2\data$\Departments\Administration
1\Finance\shared1\New
> Test\NewProd\Backup\test.txt is invalid.
> The hardware configuration of both of these servers is exactly the same
> and
> the SQL 2005 configuration is also exactly the same. Here is the command
> which runs fine on one server but doesn't on the other server:
> msdb.dbo.sp_send_dbmail
> @.profile_name = N'LOCAL',
> @.recipients = N'smarty@.testworld.com',
> @.subject = N'TEST',
> @.body = N'TEST',
> @.file_attachments =
> N'\\srvr2\data$\Departments\Administrati
on1\Finance\shared1\New
> Test\NewProd\Backup\test.txt'
> Database Mail settings on both the servers is also exactly the same. If I
> don't specify the attachment, I receive the email in my inbox. I have also
> tried mapping the drive, but still the same error. The strange thing is
> that
> it works on the other server. Very odd. Did anybody come across this
> situation..'
> Thanks,
>|||Here is your answer Smarty.
Database Mail uses the Microsoft Windows security context of the current
user to control access to files. Therefore, users who are authenticated with
SQL Server Authentication cannot attach files using @.file_attachments.
Chris
"Smarty" <Smarty@.discussions.microsoft.com> wrote in message
news:B0A66154-E4A3-49AA-9729-68C840868A9C@.microsoft.com...
> Hi,
> I've been scraching my head on this for so long. We have two servers (both
> running SQL 2005 64-bit Enterprise Edn SP2 on Windows 2003 Standard
> 64-bit),
> one of the servers is able to send the attachment in the email, whereas
> the
> other is failing with Msg 22051 error:
> Msg 22051, Level 16, State 1, Line 0
> Attachment file
> \\srvr2\data$\Departments\Administration
1\Finance\shared1\New
> Test\NewProd\Backup\test.txt is invalid.
> The hardware configuration of both of these servers is exactly the same
> and
> the SQL 2005 configuration is also exactly the same. Here is the command
> which runs fine on one server but doesn't on the other server:
> msdb.dbo.sp_send_dbmail
> @.profile_name = N'LOCAL',
> @.recipients = N'smarty@.testworld.com',
> @.subject = N'TEST',
> @.body = N'TEST',
> @.file_attachments =
> N'\\srvr2\data$\Departments\Administrati
on1\Finance\shared1\New
> Test\NewProd\Backup\test.txt'
> Database Mail settings on both the servers is also exactly the same. If I
> don't specify the attachment, I receive the email in my inbox. I have also
> tried mapping the drive, but still the same error. The strange thing is
> that
> it works on the other server. Very odd. Did anybody come across this
> situation..'
> Thanks,
>|||> Database Mail settings on both the servers is also exactly the same. If I
> don't specify the attachment, I receive the email in my inbox. I have also
> tried mapping the drive, but still the same error.
Mapping a drive creates a drive letter for *your* profile. You need to make
sure the SQL service account has access to the share, not you.
> The strange thing is that
> it works on the other server. Very odd.
Most likely the service accounts are different... one is a domain account
thathas access to the share, and the other one is a local account that does
not.|||Thanks Andrew for your answer. The account SQL server runs under is a Domain
Service Account with high-level privileges and it has full permissions on th
e
server. Both the servers run under the same Domain Service Account
"Andrew J. Kelly" wrote:
> My guess would be that the account that sql server runs under on the serve
r
> in which this fails does not have access to that share. Is it a domain
> account and does that account have the correct perms to access that share.
> --
> Andrew J. Kelly SQL MVP
> "Smarty" <Smarty@.discussions.microsoft.com> wrote in message
> news:B0A66154-E4A3-49AA-9729-68C840868A9C@.microsoft.com...
>
>|||Hi Chris,
We have Windows Authentication enabled on the server. Currently we are
testing this server and there are no users accessing this server except
myself and I have admin permissions on the box and to the share. I also trie
d
logging in to the server using the Domain Service Account under which SQL
Server and SQL Agent runs, but still I get the same error.
Thanks..
"Chris Wood" wrote:
> Here is your answer Smarty.
> Database Mail uses the Microsoft Windows security context of the current
> user to control access to files. Therefore, users who are authenticated wi
th
> SQL Server Authentication cannot attach files using @.file_attachments.
> Chris
> "Smarty" <Smarty@.discussions.microsoft.com> wrote in message
> news:B0A66154-E4A3-49AA-9729-68C840868A9C@.microsoft.com...
>
>|||Thanks Aaron for your answer. I tried creating mapped drive using my account
and as well as the SQL Service account, but still no luck. The service
account has full access to the share.
The service accounts under which SQL Server and SQL Agent runs are same on
both the servers, and it is a domain accuont with access to the share. I hav
e
checked it so many times, I am going insane.
"Aaron Bertrand [SQL Server MVP]" wrote:
> Mapping a drive creates a drive letter for *your* profile. You need to ma
ke
> sure the SQL service account has access to the share, not you.
>
> Most likely the service accounts are different... one is a domain account
> thathas access to the share, and the other one is a local account that doe
s
> not.
>
>
Cannot send attachment using sp_send_dbmail
I've been scraching my head on this for so long. We have two servers (both
running SQL 2005 64-bit Enterprise Edn SP2 on Windows 2003 Standard 64-bit),
one of the servers is able to send the attachment in the email, whereas the
other is failing with Msg 22051 error:
Msg 22051, Level 16, State 1, Line 0
Attachment file
\\srvr2\data$\Departments\Administration1\Finance\ shared1\New
Test\NewProd\Backup\test.txt is invalid.
The hardware configuration of both of these servers is exactly the same and
the SQL 2005 configuration is also exactly the same. Here is the command
which runs fine on one server but doesn't on the other server:
msdb.dbo.sp_send_dbmail
@.profile_name = N'LOCAL',
@.recipients = N'smarty@.testworld.com',
@.subject = N'TEST',
@.body = N'TEST',
@.file_attachments =
N'\\srvr2\data$\Departments\Administration1\Financ e\shared1\New
Test\NewProd\Backup\test.txt'
Database Mail settings on both the servers is also exactly the same. If I
don't specify the attachment, I receive the email in my inbox. I have also
tried mapping the drive, but still the same error. The strange thing is that
it works on the other server. Very odd. Did anybody come across this
situation..?
Thanks,
My guess would be that the account that sql server runs under on the server
in which this fails does not have access to that share. Is it a domain
account and does that account have the correct perms to access that share.
Andrew J. Kelly SQL MVP
"Smarty" <Smarty@.discussions.microsoft.com> wrote in message
news:B0A66154-E4A3-49AA-9729-68C840868A9C@.microsoft.com...
> Hi,
> I've been scraching my head on this for so long. We have two servers (both
> running SQL 2005 64-bit Enterprise Edn SP2 on Windows 2003 Standard
> 64-bit),
> one of the servers is able to send the attachment in the email, whereas
> the
> other is failing with Msg 22051 error:
> Msg 22051, Level 16, State 1, Line 0
> Attachment file
> \\srvr2\data$\Departments\Administration1\Finance\ shared1\New
> Test\NewProd\Backup\test.txt is invalid.
> The hardware configuration of both of these servers is exactly the same
> and
> the SQL 2005 configuration is also exactly the same. Here is the command
> which runs fine on one server but doesn't on the other server:
> msdb.dbo.sp_send_dbmail
> @.profile_name = N'LOCAL',
> @.recipients = N'smarty@.testworld.com',
> @.subject = N'TEST',
> @.body = N'TEST',
> @.file_attachments =
> N'\\srvr2\data$\Departments\Administration1\Financ e\shared1\New
> Test\NewProd\Backup\test.txt'
> Database Mail settings on both the servers is also exactly the same. If I
> don't specify the attachment, I receive the email in my inbox. I have also
> tried mapping the drive, but still the same error. The strange thing is
> that
> it works on the other server. Very odd. Did anybody come across this
> situation..?
> Thanks,
>
|||Here is your answer Smarty.
Database Mail uses the Microsoft Windows security context of the current
user to control access to files. Therefore, users who are authenticated with
SQL Server Authentication cannot attach files using @.file_attachments.
Chris
"Smarty" <Smarty@.discussions.microsoft.com> wrote in message
news:B0A66154-E4A3-49AA-9729-68C840868A9C@.microsoft.com...
> Hi,
> I've been scraching my head on this for so long. We have two servers (both
> running SQL 2005 64-bit Enterprise Edn SP2 on Windows 2003 Standard
> 64-bit),
> one of the servers is able to send the attachment in the email, whereas
> the
> other is failing with Msg 22051 error:
> Msg 22051, Level 16, State 1, Line 0
> Attachment file
> \\srvr2\data$\Departments\Administration1\Finance\ shared1\New
> Test\NewProd\Backup\test.txt is invalid.
> The hardware configuration of both of these servers is exactly the same
> and
> the SQL 2005 configuration is also exactly the same. Here is the command
> which runs fine on one server but doesn't on the other server:
> msdb.dbo.sp_send_dbmail
> @.profile_name = N'LOCAL',
> @.recipients = N'smarty@.testworld.com',
> @.subject = N'TEST',
> @.body = N'TEST',
> @.file_attachments =
> N'\\srvr2\data$\Departments\Administration1\Financ e\shared1\New
> Test\NewProd\Backup\test.txt'
> Database Mail settings on both the servers is also exactly the same. If I
> don't specify the attachment, I receive the email in my inbox. I have also
> tried mapping the drive, but still the same error. The strange thing is
> that
> it works on the other server. Very odd. Did anybody come across this
> situation..?
> Thanks,
>
|||> Database Mail settings on both the servers is also exactly the same. If I
> don't specify the attachment, I receive the email in my inbox. I have also
> tried mapping the drive, but still the same error.
Mapping a drive creates a drive letter for *your* profile. You need to make
sure the SQL service account has access to the share, not you.
> The strange thing is that
> it works on the other server. Very odd.
Most likely the service accounts are different... one is a domain account
thathas access to the share, and the other one is a local account that does
not.
|||Thanks Andrew for your answer. The account SQL server runs under is a Domain
Service Account with high-level privileges and it has full permissions on the
server. Both the servers run under the same Domain Service Account
"Andrew J. Kelly" wrote:
> My guess would be that the account that sql server runs under on the server
> in which this fails does not have access to that share. Is it a domain
> account and does that account have the correct perms to access that share.
> --
> Andrew J. Kelly SQL MVP
> "Smarty" <Smarty@.discussions.microsoft.com> wrote in message
> news:B0A66154-E4A3-49AA-9729-68C840868A9C@.microsoft.com...
>
>
|||Hi Chris,
We have Windows Authentication enabled on the server. Currently we are
testing this server and there are no users accessing this server except
myself and I have admin permissions on the box and to the share. I also tried
logging in to the server using the Domain Service Account under which SQL
Server and SQL Agent runs, but still I get the same error.
Thanks..
"Chris Wood" wrote:
> Here is your answer Smarty.
> Database Mail uses the Microsoft Windows security context of the current
> user to control access to files. Therefore, users who are authenticated with
> SQL Server Authentication cannot attach files using @.file_attachments.
> Chris
> "Smarty" <Smarty@.discussions.microsoft.com> wrote in message
> news:B0A66154-E4A3-49AA-9729-68C840868A9C@.microsoft.com...
>
>
|||Thanks Aaron for your answer. I tried creating mapped drive using my account
and as well as the SQL Service account, but still no luck. The service
account has full access to the share.
The service accounts under which SQL Server and SQL Agent runs are same on
both the servers, and it is a domain accuont with access to the share. I have
checked it so many times, I am going insane.
"Aaron Bertrand [SQL Server MVP]" wrote:
> Mapping a drive creates a drive letter for *your* profile. You need to make
> sure the SQL service account has access to the share, not you.
>
> Most likely the service accounts are different... one is a domain account
> thathas access to the share, and the other one is a local account that does
> not.
>
>
Tuesday, February 14, 2012
Cannot save maintenance plans
I am running SQL 2005 standard SP2 and I cannot save maintenance plans. Using the wizard I create the plan but it always fails with the following error messages:
An exception occurred while executing a Transact_SQL statement or batch
Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server , Error: 207)
Invalid column name 'msx_job_id'. (Microsoft SQL Server, Error: 207)
Thanks
Todd
The column names you mention were added in SP2. This indicates that there is a mix of SP2 and earlier functionality involved in this problem.
Bring all elements up to SP2. If you have done so already, inspect installler logs to see if sp2 setup ran without error.
Good luck,
jkh
Sunday, February 12, 2012
Cannot run Datamining query task in standard edition of Integration Services
Hi
We are using SQL Server 2005 Standard Edition. I have SSIS package which uses 'Data Mining Query Task'. I am using this task to run the predictions using the mining model I have deployed. When I run this SSIS package from IDE , everything is fine. But I deployed this SSIS to msdb, and when I right click on the package and run it from MSDB I get error message saying ,
'Cannot run this task in this edition of Integration Services. It requires higher level edition'.
Altimately we want to execute this SSIS from an API which is written in C#. Can you please suggest any workaround for doing so?
Thanks,
Vikas
You should be able to use the Data Mining Query Task in SQL Server Standard Edition - the Data Mining Query Transform is only available in Enterprise Edition. This may be an issue with running from msdb - I'm assuming the DB server is SE and not Workgroup or Express?
Regarding running a package stored in a DB from C#, please ask on the Integration Services forum.
Cannot restore sql user id?
I'm using MSSQL 2000 Standard Edition. I perform a full
database backup and restore to another server (same
version) with same database name.
Every things is OK except the sql user id I created on the
source id. Is not showing in the destination server user
id.
I try to create back the user id in the destination server
with same user name and password but still fail.
What I need to do is delete the user in the database and
recreate plus set back the permissions again!
It is any ways to backup and restore not only the table
and data but also the user id and permission even I
restore to another server?
Thanks.
ChaiWhen you restore or attach a database from another server, the mapping
between syslogins and sysusers for SQL logins gets out-of-sync. The
database userid is still there but it may be either orphaned or mapped to
the wrong login.
You can correct the mismatch with sp_change_users_login. See the Books
Online <tsqlref.chm::/ts_sp_ca-cz_8qzy.htm> for details.
Hope this helps.
Dan Guzman
SQL Server MVP
"Chai" <anonymous@.discussions.microsoft.com> wrote in message
news:89b801c404bb$2df36da0$a401280a@.phx.gbl...
> Hi there,
> I'm using MSSQL 2000 Standard Edition. I perform a full
> database backup and restore to another server (same
> version) with same database name.
> Every things is OK except the sql user id I created on the
> source id. Is not showing in the destination server user
> id.
> I try to create back the user id in the destination server
> with same user name and password but still fail.
> What I need to do is delete the user in the database and
> recreate plus set back the permissions again!
> It is any ways to backup and restore not only the table
> and data but also the user id and permission even I
> restore to another server?
> Thanks.
> Chai