Showing posts with label edition. Show all posts
Showing posts with label edition. Show all posts

Thursday, March 29, 2012

can't connect 2005 reporting server...need help

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

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

Thursday, March 22, 2012

Can't add a SQL Database (2005 Express Edition) to a C# Project over RDP

Good Afternoon.

I installed C# with SQL Server 2005 Express Edition. Everything works fine on the account I installed it on, on the local machine. However.

1) I can't connect using RDP to that same account and use SQL. It times out.
2) Other users on that computer cannot make user of SQL. Also times out.

I couldn't find documentation on these issues.

Thanks,

Philski

When you first set up the SQL Express edition the system installs with the networking systems turned off. You will need to activate the remote connections on the sql server express system by using the SQL Server Configuration Manager tools. (These should have also been installed when you installed the sql express system)

|||Didn't work.

Not sure why i should need to open TCP or memory pipes anyways, since RDP is just a reflection of the desktop, and local users do not need a network connection.

I get the same error message when I try to add a database to my C# project, "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed"

Thanks,

Philski|||

Phil, here is a thread from the DB Engine forum that seems to address this issue. Were you logged into the box through TS or on the box locally?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=116459&SiteID=1

Thanks,
Sam Lester (MSFT)

sql

Thursday, March 8, 2012

Cannot uninstall sql server express

I have sql server express installed in my computer, but I want to uninstall it and install sql server 2005 entreprise edition.
I have successfully uninstalled instance of sql server, but I cannot uninstall the workstation.

here are the log that I have :

=== Verbose logging started: 11/23/2006 13:06:11 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: E:\Original\SQL2005Ent\32 bit\Servers\setup.exe ===
MSI (c) (04:28) [13:06:11:021]: Resetting cached policy values
MSI (c) (04:28) [13:06:11:021]: Machine policy value 'Debug' is 0
MSI (c) (04:28) [13:06:11:021]: ******* RunEngine:
******* Product: E:\Original\SQL2005Ent\32 bit\Servers\Setup\SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (c) (04:28) [13:06:11:021]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (04:28) [13:06:11:021]: Grabbed execution mutex.
MSI (c) (04:28) [13:06:11:036]: Cloaking enabled.
MSI (c) (04:28) [13:06:11:036]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (04:28) [13:06:11:068]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (c) (04:28) [13:06:11:068]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (04:28) [13:06:11:068]: MainEngineThread is returning 1618
=== Verbose logging stopped: 11/23/2006 13:06:11 ===

Please help

What error are you seeing? Can you search your install/uninstall logs for the text string "value 3" and post the error message a few lines above?

Thanks,
Sam Lester (MSFT)

|||

Uninstall workstation?

What workstation you're referring.

|||

Error 1618 means: Another installation is already in progress. Complete that installation before proceeding with this install.

There was another installation running at the same time you tried to uninstall SQL Express. Uninstall will work when you kick off setup later again.

Cannot uninstall sql server express

I have sql server express installed in my computer, but I want to uninstall it and install sql server 2005 entreprise edition.
I have successfully uninstalled instance of sql server, but I cannot uninstall the workstation.

here are the log that I have :

=== Verbose logging started: 11/23/2006 13:06:11 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: E:\Original\SQL2005Ent\32 bit\Servers\setup.exe ===
MSI (c) (04:28) [13:06:11:021]: Resetting cached policy values
MSI (c) (04:28) [13:06:11:021]: Machine policy value 'Debug' is 0
MSI (c) (04:28) [13:06:11:021]: ******* RunEngine:
******* Product: E:\Original\SQL2005Ent\32 bit\Servers\Setup\SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (c) (04:28) [13:06:11:021]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (04:28) [13:06:11:021]: Grabbed execution mutex.
MSI (c) (04:28) [13:06:11:036]: Cloaking enabled.
MSI (c) (04:28) [13:06:11:036]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (04:28) [13:06:11:068]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (c) (04:28) [13:06:11:068]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (04:28) [13:06:11:068]: MainEngineThread is returning 1618
=== Verbose logging stopped: 11/23/2006 13:06:11 ===

Please help

What error are you seeing? Can you search your install/uninstall logs for the text string "value 3" and post the error message a few lines above?

Thanks,
Sam Lester (MSFT)

|||

Uninstall workstation?

What workstation you're referring.

|||

Error 1618 means: Another installation is already in progress. Complete that installation before proceeding with this install.

There was another installation running at the same time you tried to uninstall SQL Express. Uninstall will work when you kick off setup later again.

Cannot uninstall reporting services

Hi,
I am trying to install reporting services client tools onto my desktop PC.
It appears that reporting services enterprise edition have been installed on
here before but there is nothing listed in add/remove programs for RS.
An excerpt of the install log is below, I am not sure what is setting the
paths for the reporting services databases to be on "d:\program files" as
this is not on my PC. I have searched through the registry with no joy.
Can anyone tell me how I can completely remove RS and start again? Oh yes
and I have checked for the COM objects prescence on my PC too and there are
not there.
Thanks in advance for your help,
Nick
-- excerpt from installation log
Property(C): DataBases.3882F579_1BCB_4C44_991C_060D38C9C09D = D:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Databases\
Property(C): SamplesDB1 = AdventureWorks2000
Property(C): CostingComplete = 1
Property(C): OutOfDiskSpace = 0
Property(C): OutOfNoRbDiskSpace = 0
Property(C): PrimaryVolumeSpaceAvailable = 0
Property(C): PrimaryVolumeSpaceRequired = 0
Property(C): PrimaryVolumeSpaceRemaining = 0
Property(C): _FeatDescription = Report Server
Property(C): _DefaultInstance = Installed
Property(C): SQL_SHOWLIC = 1
Property(C): RSAutoStart = 1
Property(C): _Service = RS
Property(C): Asp_Net_Accout_For_GUI_Display = URSUS\ASPNET
Property(C): WizardDialog = StartCopyDlg
Property(C): DisableBack = MaintenanceDlg
Property(C): SqlMaintType = 1
=== Logging stopped: 28/02/2006 15:11:48 === MSI (c) (30:20) [15:11:48:982]: Note: 1: 1729
MSI (c) (30:20) [15:11:48:982]: Product: Microsoft SQL Server 2000 Reporting
Services Enterprise Edition -- Configuration failed.
MSI (c) (30:20) [15:11:48:992]: Grabbed execution mutex.
MSI (c) (30:20) [15:11:48:992]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (30:20) [15:11:48:992]: MainEngineThread is returning 1603
=== Verbose logging stopped: 28/02/2006 15:11:48 ===Hi,
replying to my own post!!
I actually eventually found some rogue entries in the registry with the help
of "regmon". There were alittle obscure, well that's my excuse and I'm
sticking to it!
Nick
"Nick Long" wrote:
> Hi,
> I am trying to install reporting services client tools onto my desktop PC.
> It appears that reporting services enterprise edition have been installed on
> here before but there is nothing listed in add/remove programs for RS.
> An excerpt of the install log is below, I am not sure what is setting the
> paths for the reporting services databases to be on "d:\program files" as
> this is not on my PC. I have searched through the registry with no joy.
> Can anyone tell me how I can completely remove RS and start again? Oh yes
> and I have checked for the COM objects prescence on my PC too and there are
> not there.
> Thanks in advance for your help,
> Nick
> -- excerpt from installation log
> Property(C): DataBases.3882F579_1BCB_4C44_991C_060D38C9C09D = D:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Databases\
> Property(C): SamplesDB1 = AdventureWorks2000
> Property(C): CostingComplete = 1
> Property(C): OutOfDiskSpace = 0
> Property(C): OutOfNoRbDiskSpace = 0
> Property(C): PrimaryVolumeSpaceAvailable = 0
> Property(C): PrimaryVolumeSpaceRequired = 0
> Property(C): PrimaryVolumeSpaceRemaining = 0
> Property(C): _FeatDescription = Report Server
> Property(C): _DefaultInstance = Installed
> Property(C): SQL_SHOWLIC = 1
> Property(C): RSAutoStart = 1
> Property(C): _Service = RS
> Property(C): Asp_Net_Accout_For_GUI_Display = URSUS\ASPNET
> Property(C): WizardDialog = StartCopyDlg
> Property(C): DisableBack = MaintenanceDlg
> Property(C): SqlMaintType = 1
> === Logging stopped: 28/02/2006 15:11:48 ===> MSI (c) (30:20) [15:11:48:982]: Note: 1: 1729
> MSI (c) (30:20) [15:11:48:982]: Product: Microsoft SQL Server 2000 Reporting
> Services Enterprise Edition -- Configuration failed.
> MSI (c) (30:20) [15:11:48:992]: Grabbed execution mutex.
> MSI (c) (30:20) [15:11:48:992]: Cleaning up uninstalled install packages, if
> any exist
> MSI (c) (30:20) [15:11:48:992]: MainEngineThread is returning 1603
> === Verbose logging stopped: 28/02/2006 15:11:48 ===>|||If you're re-installing all of SQLServer, make sure you delete all the
MSSQL folders.
For RS, you may want to check and confirm that everything is gone out
of IIS as well.
Jim

Wednesday, March 7, 2012

Cannot Subscribe Using Windows Synchronization Manager

Hi,
I'm using two instances of SQL Server 2005 Developer Edition (SP2) on the
same machine. One instance is Publisher and Distributor and the other is
Subscriber. When I try to use Windows Synchronization Manager to subscribe
to the publication, I get this error:
The SQL Server publication uses features that the current version of the
Subscriber does not support. The subscriber should be upgraded to 'Unknown
version of Microsoft SQL Server'.
Any help would be greatly appreciated,
Leila
Can you check the compatibility level of the subscription database?
Also see if you can do a simple pull subscription to see if that works.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23ESWMUCTHHA.1200@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I'm using two instances of SQL Server 2005 Developer Edition (SP2) on the
> same machine. One instance is Publisher and Distributor and the other is
> Subscriber. When I try to use Windows Synchronization Manager to subscribe
> to the publication, I get this error:
> The SQL Server publication uses features that the current version of the
> Subscriber does not support. The subscriber should be upgraded to 'Unknown
> version of Microsoft SQL Server'.
> Any help would be greatly appreciated,
> Leila
>
|||compatibility level is 9, pull subscription without Synchronization Manager
works!
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%234mNP4DTHHA.4404@.TK2MSFTNGP03.phx.gbl...
> Can you check the compatibility level of the subscription database?
> Also see if you can do a simple pull subscription to see if that works.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23ESWMUCTHHA.1200@.TK2MSFTNGP02.phx.gbl...
>
|||Sounds like something is wrong with Windows Synchronization Manager. Can you
try from another machine?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:OJC3wRFTHHA.4956@.TK2MSFTNGP04.phx.gbl...
> compatibility level is 9, pull subscription without Synchronization
> Manager works!
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%234mNP4DTHHA.4404@.TK2MSFTNGP03.phx.gbl...
>
|||I'll try that!
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23OP$xzFTHHA.5108@.TK2MSFTNGP06.phx.gbl...
> Sounds like something is wrong with Windows Synchronization Manager. Can
> you try from another machine?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:OJC3wRFTHHA.4956@.TK2MSFTNGP04.phx.gbl...
>
|||I'll try that!
One more thing: BOL says that interactive conflict resolution is not
available when you synchronize via SSMS. Then why is there such an option
when you create the subscription in SSMS?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23OP$xzFTHHA.5108@.TK2MSFTNGP06.phx.gbl...
> Sounds like something is wrong with Windows Synchronization Manager. Can
> you try from another machine?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:OJC3wRFTHHA.4956@.TK2MSFTNGP04.phx.gbl...
>
|||It is for subscriptions that you will pull through WSM. Note you have to
also enable interactive conflict resolution in WSM as well
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23w5nP4HTHHA.2124@.TK2MSFTNGP06.phx.gbl...
> I'll try that!
> One more thing: BOL says that interactive conflict resolution is not
> available when you synchronize via SSMS. Then why is there such an option
> when you create the subscription in SSMS?
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23OP$xzFTHHA.5108@.TK2MSFTNGP06.phx.gbl...
>
>

Cannot start the Reporting Service

I am currently working on a windows 2003 server with SQL2000 (developers edition). My Sqlserver and Report Server are on two different machines.

This was working yesterday but frustratingly not this morning.

Everytime I try to start the Reporting Server service, it gives me the following message:

"The Report Server service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service.

Is there a way around this? - any help would be greatly appreciated .

Anyone?|||If you are still seeing this issue...I found a solution for a similiar error (a different service, but the same error). Had to clear out the Application log in Event Viewer. See if that helps.|||Possibly best not to delete the contents of the event logs, as this may provide a pointer towards solving your problem. Open the eventlogs, then start the service, find the error that is logged for it. If you post that here it may give more of an idea.
|||

I'm facing a very similar problem. I've installed, uninstalled and reinstalled SQL server 2005 Developer Edition twice now. In each case Report Server can't be started. I've looked in the logs and the pertinent errors seem to be the following:

ReportingServicesService!library!4!6/16/2006-15:28:33:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'E1705\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'E1705\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!6/16/2006-15:28:33:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'E1705\ASPNET' is not recognized.

In the other log file is the following error:

ReportingServicesService!library!8!6/16/2006-15:28:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights., ;
Info:

Looking at the time stamp, I believe the later is just a result of the UnknownUserNameException:

SQL Server works fine, I can work with the database in the Management Studio and access them through ASP.NET without a problem (or at least I could before I uninstalled a couple of times!!)

.Net framework 2.0 is installed. I have a Gig of RAM, plenty of hard disk and XP Prof Ed SP 2.

I'm at a total loss on how to get it to work on this machine. Any help would be greatly appreciated!!

Bob O'Dell

|||

The problem seems to be that the default ASP.NET user is not present. Are you able to find ASPNET user on your local machine E1705? Re-registering asp.net might help.

aspnet_regiis.exe -i -enable

|||

ASPNET user did appear as a user and I tried different permissions to no avail. What finally worked was to uninstall Report Services (actually I uninstalled ALL of SQL server) and then reinstalled the .NET framework. After that I reinstalled SQL Server and Report Services. Everything seemed to work after that. I'm not sure what was wrong, but I'm off and running now!

Thanks for the help

|||

James Wu - MSFT wrote:

The problem seems to be that the default ASP.NET user is not present. Are you able to find ASPNET user on your local machine E1705? Re-registering asp.net might help.

aspnet_regiis.exe -i -enable

This was the 'trick' I was looking for. Now I'm able to start the Reporting Service. Many thanks!!

Cannot start the Reporting Service

I am currently working on a windows 2003 server with SQL2000 (developers edition). My Sqlserver and Report Server are on two different machines.

This was working yesterday but frustratingly not this morning.

Everytime I try to start the Reporting Server service, it gives me the following message:

"The Report Server service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service.

Is there a way around this? - any help would be greatly appreciated .

Anyone?|||If you are still seeing this issue...I found a solution for a similiar error (a different service, but the same error). Had to clear out the Application log in Event Viewer. See if that helps.|||Possibly best not to delete the contents of the event logs, as this may provide a pointer towards solving your problem. Open the eventlogs, then start the service, find the error that is logged for it. If you post that here it may give more of an idea.
|||

I'm facing a very similar problem. I've installed, uninstalled and reinstalled SQL server 2005 Developer Edition twice now. In each case Report Server can't be started. I've looked in the logs and the pertinent errors seem to be the following:

ReportingServicesService!library!4!6/16/2006-15:28:33:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'E1705\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'E1705\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!6/16/2006-15:28:33:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'E1705\ASPNET' is not recognized.

In the other log file is the following error:

ReportingServicesService!library!8!6/16/2006-15:28:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights., ;
Info:

Looking at the time stamp, I believe the later is just a result of the UnknownUserNameException:

SQL Server works fine, I can work with the database in the Management Studio and access them through ASP.NET without a problem (or at least I could before I uninstalled a couple of times!!)

.Net framework 2.0 is installed. I have a Gig of RAM, plenty of hard disk and XP Prof Ed SP 2.

I'm at a total loss on how to get it to work on this machine. Any help would be greatly appreciated!!

Bob O'Dell

|||

The problem seems to be that the default ASP.NET user is not present. Are you able to find ASPNET user on your local machine E1705? Re-registering asp.net might help.

aspnet_regiis.exe -i -enable

|||

ASPNET user did appear as a user and I tried different permissions to no avail. What finally worked was to uninstall Report Services (actually I uninstalled ALL of SQL server) and then reinstalled the .NET framework. After that I reinstalled SQL Server and Report Services. Everything seemed to work after that. I'm not sure what was wrong, but I'm off and running now!

Thanks for the help

|||

James Wu - MSFT wrote:

The problem seems to be that the default ASP.NET user is not present. Are you able to find ASPNET user on your local machine E1705? Re-registering asp.net might help.

aspnet_regiis.exe -i -enable

This was the 'trick' I was looking for. Now I'm able to start the Reporting Service. Many thanks!!

Cannot start the Reporting Service

I am currently working on a windows 2003 server with SQL2000 (developers edition). My Sqlserver and Report Server are on two different machines.

This was working yesterday but frustratingly not this morning.

Everytime I try to start the Reporting Server service, it gives me the following message:

"The Report Server service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service.

Is there a way around this? - any help would be greatly appreciated .

Anyone?|||If you are still seeing this issue...I found a solution for a similiar error (a different service, but the same error). Had to clear out the Application log in Event Viewer. See if that helps.|||Possibly best not to delete the contents of the event logs, as this may provide a pointer towards solving your problem. Open the eventlogs, then start the service, find the error that is logged for it. If you post that here it may give more of an idea.
|||

I'm facing a very similar problem. I've installed, uninstalled and reinstalled SQL server 2005 Developer Edition twice now. In each case Report Server can't be started. I've looked in the logs and the pertinent errors seem to be the following:

ReportingServicesService!library!4!6/16/2006-15:28:33:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'E1705\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'E1705\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!6/16/2006-15:28:33:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'E1705\ASPNET' is not recognized.

In the other log file is the following error:

ReportingServicesService!library!8!6/16/2006-15:28:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights., ;
Info:

Looking at the time stamp, I believe the later is just a result of the UnknownUserNameException:

SQL Server works fine, I can work with the database in the Management Studio and access them through ASP.NET without a problem (or at least I could before I uninstalled a couple of times!!)

.Net framework 2.0 is installed. I have a Gig of RAM, plenty of hard disk and XP Prof Ed SP 2.

I'm at a total loss on how to get it to work on this machine. Any help would be greatly appreciated!!

Bob O'Dell

|||

The problem seems to be that the default ASP.NET user is not present. Are you able to find ASPNET user on your local machine E1705? Re-registering asp.net might help.

aspnet_regiis.exe -i -enable

|||

ASPNET user did appear as a user and I tried different permissions to no avail. What finally worked was to uninstall Report Services (actually I uninstalled ALL of SQL server) and then reinstalled the .NET framework. After that I reinstalled SQL Server and Report Services. Everything seemed to work after that. I'm not sure what was wrong, but I'm off and running now!

Thanks for the help

|||

James Wu - MSFT wrote:

The problem seems to be that the default ASP.NET user is not present. Are you able to find ASPNET user on your local machine E1705? Re-registering asp.net might help.

aspnet_regiis.exe -i -enable

This was the 'trick' I was looking for. Now I'm able to start the Reporting Service. Many thanks!!

Saturday, February 25, 2012

Cannot start service

I am VERY NEW to SQL server. I hope you will pardon my total ignorance.
That said:
I have installed SQL Server 2000 Developer Edition on my local PC running
Windows XP Home Edition.
From the CD I installed everything under the "SQL Server 2000 Components"
menu item on the install disk.
I now have an icon in the system tray for the SQL Server Service Manager.
When I open that icon I see a server name (the network name of my local PC,
I have 2 computers on a small network)
I see SQL Sever in the Services box.
There's a message on the bottom of that window that says:
Stopped - \\700XL - MSSQL Server (700XL is my computer name)
When I click on the Start/Continue button I get the following error message:
ERROR
The service did not start due to logon failure.
When I click OK I get the following message:
SQL Server Service Manager
An error 1069 - (The service did not start due to a logon failure.)
occurred while perfomring this service operation on teh MSSQLServer service.
According to the Enterprise Manager I am using Windows Authentication.
I don't even know where to begin. Can anyone help me please?
Thank you
MarkThis is a Windows problem. Windows tries to start the service using the
account you have specified. However, the password that Windows is using is
incorrect, so it cannot login for the service. Administrative tools,
Services, and there you need to specify the correct password for the SQL
Server service.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
news:%23L1oHMD7DHA.2540@.TK2MSFTNGP11.phx.gbl...
> I am VERY NEW to SQL server. I hope you will pardon my total ignorance.
> That said:
> I have installed SQL Server 2000 Developer Edition on my local PC running
> Windows XP Home Edition.
> From the CD I installed everything under the "SQL Server 2000 Components"
> menu item on the install disk.
> I now have an icon in the system tray for the SQL Server Service Manager.
> When I open that icon I see a server name (the network name of my local
PC,
> I have 2 computers on a small network)
> I see SQL Sever in the Services box.
> There's a message on the bottom of that window that says:
> Stopped - \\700XL - MSSQL Server (700XL is my computer name)
> When I click on the Start/Continue button I get the following error
message:
> ERROR
> The service did not start due to logon failure.
> When I click OK I get the following message:
> SQL Server Service Manager
> An error 1069 - (The service did not start due to a logon
failure.)
> occurred while perfomring this service operation on teh MSSQLServer
service.
> According to the Enterprise Manager I am using Windows Authentication.
> I don't even know where to begin. Can anyone help me please?
> Thank you
> Mark
>
>
>
>|||Wohoo!! (In my best Homer Simpson voice).
When I set the MSSQL Server properties log on as "Local System account", it
worked.
I'm hoping that setting isn't going to cause me a different problem
elsewhere.
Thank you for the nearly instantaneous response,Tibor!
Mark :-)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ODeJySD7DHA.2064@.TK2MSFTNGP11.phx.gbl...
> This is a Windows problem. Windows tries to start the service using the
> account you have specified. However, the password that Windows is using is
> incorrect, so it cannot login for the service. Administrative tools,
> Services, and there you need to specify the correct password for the SQL
> Server service.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
> news:%23L1oHMD7DHA.2540@.TK2MSFTNGP11.phx.gbl...
> > I am VERY NEW to SQL server. I hope you will pardon my total ignorance.
> >
> > That said:
> > I have installed SQL Server 2000 Developer Edition on my local PC
running
> > Windows XP Home Edition.
> >
> > From the CD I installed everything under the "SQL Server 2000
Components"
> > menu item on the install disk.
> >
> > I now have an icon in the system tray for the SQL Server Service
Manager.
> >
> > When I open that icon I see a server name (the network name of my local
> PC,
> > I have 2 computers on a small network)
> >
> > I see SQL Sever in the Services box.
> >
> > There's a message on the bottom of that window that says:
> > Stopped - \\700XL - MSSQL Server (700XL is my computer name)
> >
> > When I click on the Start/Continue button I get the following error
> message:
> > ERROR
> > The service did not start due to logon failure.
> >
> > When I click OK I get the following message:
> > SQL Server Service Manager
> > An error 1069 - (The service did not start due to a logon
> failure.)
> > occurred while perfomring this service operation on teh MSSQLServer
> service.
> >
> > According to the Enterprise Manager I am using Windows Authentication.
> >
> > I don't even know where to begin. Can anyone help me please?
> >
> > Thank you
> > Mark
> >
> >
> >
> >
> >
> >
> >
>|||> Wohoo!! (In my best Homer Simpson voice).
LOL :-)
You might want to search in Books Online for "level token". That will lead you to the section which
descries the service account, and stuff like that.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
news:OnD2kkD7DHA.2556@.TK2MSFTNGP09.phx.gbl...
> Wohoo!! (In my best Homer Simpson voice).
> When I set the MSSQL Server properties log on as "Local System account", it
> worked.
> I'm hoping that setting isn't going to cause me a different problem
> elsewhere.
> Thank you for the nearly instantaneous response,Tibor!
> Mark :-)
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ODeJySD7DHA.2064@.TK2MSFTNGP11.phx.gbl...
> > This is a Windows problem. Windows tries to start the service using the
> > account you have specified. However, the password that Windows is using is
> > incorrect, so it cannot login for the service. Administrative tools,
> > Services, and there you need to specify the correct password for the SQL
> > Server service.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> >
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
> > news:%23L1oHMD7DHA.2540@.TK2MSFTNGP11.phx.gbl...
> > > I am VERY NEW to SQL server. I hope you will pardon my total ignorance.
> > >
> > > That said:
> > > I have installed SQL Server 2000 Developer Edition on my local PC
> running
> > > Windows XP Home Edition.
> > >
> > > From the CD I installed everything under the "SQL Server 2000
> Components"
> > > menu item on the install disk.
> > >
> > > I now have an icon in the system tray for the SQL Server Service
> Manager.
> > >
> > > When I open that icon I see a server name (the network name of my local
> > PC,
> > > I have 2 computers on a small network)
> > >
> > > I see SQL Sever in the Services box.
> > >
> > > There's a message on the bottom of that window that says:
> > > Stopped - \\700XL - MSSQL Server (700XL is my computer name)
> > >
> > > When I click on the Start/Continue button I get the following error
> > message:
> > > ERROR
> > > The service did not start due to logon failure.
> > >
> > > When I click OK I get the following message:
> > > SQL Server Service Manager
> > > An error 1069 - (The service did not start due to a logon
> > failure.)
> > > occurred while perfomring this service operation on teh MSSQLServer
> > service.
> > >
> > > According to the Enterprise Manager I am using Windows Authentication.
> > >
> > > I don't even know where to begin. Can anyone help me please?
> > >
> > > Thank you
> > > Mark
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>

Cannot start service

I am VERY NEW to SQL server. I hope you will pardon my total ignorance.
That said:
I have installed SQL Server 2000 Developer Edition on my local PC running
Windows XP Home Edition.
From the CD I installed everything under the "SQL Server 2000 Components"
menu item on the install disk.
I now have an icon in the system tray for the SQL Server Service Manager.
When I open that icon I see a server name (the network name of my local PC,
I have 2 computers on a small network)
I see SQL Sever in the Services box.
There's a message on the bottom of that window that says:
Stopped - \\700XL - MSSQL Server (700XL is my computer name)
When I click on the Start/Continue button I get the following error message:
ERROR
The service did not start due to logon failure.
When I click OK I get the following message:
SQL Server Service Manager
An error 1069 - (The service did not start due to a logon failure.)
occurred while perfomring this service operation on teh MSSQLServer service.
According to the Enterprise Manager I am using Windows Authentication.
I don't even know where to begin. Can anyone help me please?
Thank you
MarkThis is a Windows problem. Windows tries to start the service using the
account you have specified. However, the password that Windows is using is
incorrect, so it cannot login for the service. Administrative tools,
Services, and there you need to specify the correct password for the SQL
Server service.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
news:%23L1oHMD7DHA.2540@.TK2MSFTNGP11.phx.gbl...
> I am VERY NEW to SQL server. I hope you will pardon my total ignorance.
> That said:
> I have installed SQL Server 2000 Developer Edition on my local PC running
> Windows XP Home Edition.
> From the CD I installed everything under the "SQL Server 2000 Components"
> menu item on the install disk.
> I now have an icon in the system tray for the SQL Server Service Manager.
> When I open that icon I see a server name (the network name of my local
PC,
> I have 2 computers on a small network)
> I see SQL Sever in the Services box.
> There's a message on the bottom of that window that says:
> Stopped - \\700XL - MSSQL Server (700XL is my computer name)
> When I click on the Start/Continue button I get the following error
message:
> ERROR
> The service did not start due to logon failure.
> When I click OK I get the following message:
> SQL Server Service Manager
> An error 1069 - (The service did not start due to a logon
failure.)
> occurred while perfomring this service operation on teh MSSQLServer
service.
> According to the Enterprise Manager I am using Windows Authentication.
> I don't even know where to begin. Can anyone help me please?
> Thank you
> Mark
>
>
>
>|||Wohoo!! (In my best Homer Simpson voice).
When I set the MSSQL Server properties log on as "Local System account", it
worked.
I'm hoping that setting isn't going to cause me a different problem
elsewhere.
Thank you for the nearly instantaneous response,Tibor!
Mark :-)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ODeJySD7DHA.2064@.TK2MSFTNGP11.phx.gbl...
> This is a Windows problem. Windows tries to start the service using the
> account you have specified. However, the password that Windows is using is
> incorrect, so it cannot login for the service. Administrative tools,
> Services, and there you need to specify the correct password for the SQL
> Server service.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=...ublic.sqlserver
>
> "markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
> news:%23L1oHMD7DHA.2540@.TK2MSFTNGP11.phx.gbl...
running
Components"
Manager.
> PC,
> message:
> failure.)
> service.
>|||> Wohoo!! (In my best Homer Simpson voice).
LOL :-)
You might want to search in Books Online for "level token". That will lead y
ou to the section which
descries the service account, and stuff like that.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
news:OnD2kkD7DHA.2556@.TK2MSFTNGP09.phx.gbl...
> Wohoo!! (In my best Homer Simpson voice).
> When I set the MSSQL Server properties log on as "Local System account", i
t
> worked.
> I'm hoping that setting isn't going to cause me a different problem
> elsewhere.
> Thank you for the nearly instantaneous response,Tibor!
> Mark :-)
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:ODeJySD7DHA.2064@.TK2MSFTNGP11.phx.gbl...
> [url]http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver[/url
]
> running
> Components"
> Manager.
>

cannot start or verify that SQL 2005 is running

Hi,

I am new to sql 2005.

I have installed a trial version of 2005 enterprise edition.

After installing I went to Management Studio. I noticed that the server name

dropdown menu was blank so I tried to browse. No server names appear under local

or network servers. I then went to configuration manager and noticed that

although client protocols are listed under SQL client native config,

SQL server 2005 services and sql server 2005 network config are both blank. Is SQL

installed correctly? I hope this is enough info to illicit a helpful response.

Thank You.

Problem solved. I went to add remove apps and clicked change

on Microsoft SQL Server 2005 button. I am not sure what Microsoft

SQL Server Native Client is so I didn't mess with it. I saw that no instances

were listed under SQL Server 2005 instances so I clicked away until I had

added an instance - MSSQLSERVER. I am going to be using .net 2.0 framework

objects to connect to SQL so I am not sure if I messed up by Not installing in

mixed mode. Any advice on the mixed mode issue would be appreciated.

|||If you have no need for mixed mode, then don't install it. It kind of sounds like you don't so no worries.

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 show requested dialog Error on View Database Permissions

I am having issues with the database permissions on SQL Server Express. I downloaded the SQL Server 2005 Express Edition with Advanced Services SP1 and everytime I try to view database/schema permissions I get an error "Cannot show requested dialog." I have 3 different installs of Sql Express 2005 on different machines and they all throw the same error. The error happens in a couple locations but one way is going databases > select any database > Security > Schemas > Select and right click on a schema > permissions > and click view database permissions, I get the error message below. Does anyone else have this problem?

Thanks

Scott


===================================

Cannot show requested dialog.

===================================

Could not load file or assembly 'file:///c:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlManagerUi.dll' or one of its dependencies. The system cannot find the file specified. (mscorlib)


Program Location:

at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoadFrom(String assemblyFile, Evidence securityEvidence, Byte[] hashValue, AssemblyHashAlgorithm hashAlgorithm, Boolean forIntrospection, StackCrawlMark& stackMark)
at System.Reflection.Assembly.LoadFrom(String assemblyFile, Evidence securityEvidence)
at System.Activator.CreateInstanceFrom(String assemblyFile, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo)
at System.Activator.CreateInstanceFrom(String assemblyFile, String typeName, Object[] activationAttributes)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.SqlMgmt.FormLauncher.OnCreateAndShowForm(IServiceProvider serviceProvider, XmlDocument xml)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

Seems like a managment studio issue. I'm going to move this question to the Tools forum.

Mike

Cannot show requested dialog Error on View Database Permissions

I am having issues with the database permissions on SQL Server Express. I downloaded the SQL Server 2005 Express Edition with Advanced Services SP1 and everytime I try to view database/schema permissions I get an error "Cannot show requested dialog." I have 3 different installs of Sql Express 2005 on different machines and they all throw the same error. The error happens in a couple locations but one way is going databases > select any database > Security > Schemas > Select and right click on a schema > permissions > and click view database permissions, I get the error message below. Does anyone else have this problem?

Thanks

Scott


===================================

Cannot show requested dialog.

===================================

Could not load file or assembly 'file:///c:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlManagerUi.dll' or one of its dependencies. The system cannot find the file specified. (mscorlib)


Program Location:

at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoadFrom(String assemblyFile, Evidence securityEvidence, Byte[] hashValue, AssemblyHashAlgorithm hashAlgorithm, Boolean forIntrospection, StackCrawlMark& stackMark)
at System.Reflection.Assembly.LoadFrom(String assemblyFile, Evidence securityEvidence)
at System.Activator.CreateInstanceFrom(String assemblyFile, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo)
at System.Activator.CreateInstanceFrom(String assemblyFile, String typeName, Object[] activationAttributes)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.SqlMgmt.FormLauncher.OnCreateAndShowForm(IServiceProvider serviceProvider, XmlDocument xml)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

Seems like a managment studio issue. I'm going to move this question to the Tools forum.

Mike

Cannot setup SQL Server 2000 on W2003 Server

I have installed Windows Server 2003 Web Edition from scratch on a new system disk. I have updated with the latest service pack and security upgrades.

When I try to install SQL Server 2000 Standard Edition, the initial setup dialog Autoruns OK. I click on "SQL Server 2000 components", then on "Install Database Server". For a second or so a "Demoshield" pop-up appears, but that vanishes and nothing else happens.

Can anyone suggest what might be wrong? I am running on P4 1.7Ghz but only have 128Meg memory until the new chips arrive. I have around 15Gig disk space free on the drive I want to install on.

Thanks

Looks like this is not a supported configuration.

http://support.microsoft.com/default.aspx?scid=kb;en-us;819258

Thursday, February 16, 2012

Cannot see SQL Server in my pc

Hi - I just installed VS 2005, SQL Server 2005 Developer Edition. The install went fine with out any error messages.

all I can see is the configuration tools choice under Microsoft SQL Server 2005, and no way to access the SQL Server from my pc. I have a Windows XP Prof.

But I am able to access my server using VS 2005. But i am not used to creating the database thru this and more used to using the Enterprise manager to drive this.

Any help is much appreciated!

Thanks.

It sounds like you didn't ask to install the workstation components. By default, they're not selected when you go through the GUI install.

Go to Add/Remove Programs and select "change" for Microsoft SQL Server 2005. You'll see at a high level what's installed, and from there you can add new components if needed.

Paul