Cannot EXPORT a REPORT to EXCEL

Hi,
I created a report which works just fine. But when I try to export to excel,
i get the following error:
Reporting Services Erro
----
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Object reference not set to an instance of an object.
Any ideas?
Thanks
--
pmudif you're using RS2000 do u have sp2?
"pmud" wrote:
> Hi,
> I created a report which works just fine. But when I try to export to excel,
> i get the following error:
> Reporting Services Error
> ----
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Object reference not set to an instance of an object.
> Any ideas?
> Thanks
> --
> pmud

Cannot edit maintenance plan created in SQL 2005, SP1

Hello,

I have created a simple maintenance plan in SQL Studio. When I double-click on the task boxes (ie 'Rebuild Index', 'Backup') to just make changes or to look, I get the following message:

Cannot show editor for this task

Additional information:

Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

I also cannot save any change that I make in the schedule of the plan.

I HAVE installed Integration Services, which at least enabled me to initially SAVE the plan. I just can't edit the tasks or change the schedule.

Any help is most appreciated!

Eunice Griffin

I get the same thing - I finally solved all the integration services got to create a backup maint. plan now I can't edit it - what a pain.

Cannot edit maintenance plan created in SQL 2005, SP1

Hello,

I have created a simple maintenance plan in SQL Studio. When I double-click on the task boxes (ie 'Rebuild Index', 'Backup') to just make changes or to look, I get the following message:

Cannot show editor for this task

Additional information:

Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

I also cannot save any change that I make in the schedule of the plan.

I HAVE installed Integration Services, which at least enabled me to initially SAVE the plan. I just can't edit the tasks or change the schedule.

Any help is most appreciated!

Eunice Griffin

I get the same thing - I finally solved all the integration services got to create a backup maint. plan now I can't edit it - what a pain.

Cannot edit jobs

i am get this error message every time I try to remove some old jobs that
were created on a different server:
error 14274: cannot add, update,or delete a job (or its step or
schedules) that originated from an msx server
What do I need to do to remove these jobs?
Either remove them from the master server. Or hack msdb..sysjobs (originating_server column to the
name for your server). Some info found here (adapt to your needs):
http://www.karaszi.com/SQLServer/inf...erver_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Takia" <Takia@.discussions.microsoft.com> wrote in message
news:527F2E42-BDF8-4968-B717-4BDA27347FDB@.microsoft.com...
>i am get this error message every time I try to remove some old jobs that
> were created on a different server:
> error 14274: cannot add, update,or delete a job (or its step or
> schedules) that originated from an msx server
> What do I need to do to remove these jobs?
>

Cannot edit jobs

i am get this error message every time I try to remove some old jobs that
were created on a different server:
error 14274: cannot add, update,or delete a job (or its step or
schedules) that originated from an msx server
What do I need to do to remove these jobs?Either remove them from the master server. Or hack msdb..sysjobs (originatin
g_server column to the
name for your server). Some info found here (adapt to your needs):
http://www.karaszi.com/SQLServer/in...server_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Takia" <Takia@.discussions.microsoft.com> wrote in message
news:527F2E42-BDF8-4968-B717-4BDA27347FDB@.microsoft.com...
>i am get this error message every time I try to remove some old jobs that
> were created on a different server:
> error 14274: cannot add, update,or delete a job (or its step or
> schedules) that originated from an msx server
> What do I need to do to remove these jobs?
>

Cannot edit jobs

i am get this error message every time I try to remove some old jobs that
were created on a different server:
error 14274: cannot add, update,or delete a job (or its step or
schedules) that originated from an msx server
What do I need to do to remove these jobs?Either remove them from the master server. Or hack msdb..sysjobs (originating_server column to the
name for your server). Some info found here (adapt to your needs):
http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Takia" <Takia@.discussions.microsoft.com> wrote in message
news:527F2E42-BDF8-4968-B717-4BDA27347FDB@.microsoft.com...
>i am get this error message every time I try to remove some old jobs that
> were created on a different server:
> error 14274: cannot add, update,or delete a job (or its step or
> schedules) that originated from an msx server
> What do I need to do to remove these jobs?
>

Cannot drop type

Cannot drop a type event though it is not in use.

The type was created via create type and is an non-nullable nvarchar. It should have been nullable.

I have removed all dependencies on the type, by dropping tabes, stored procs etc, but still cannot drop it. SSMSE says the type cannot be dropped because it's in use. SSMSE shows no dependencies on the type.

Any help?

Can you run these queries

select object_name(object_id), * from sys.columns where user_type_id=type_id('Your_type_name')

select object_name(object_id), * from sys.parameters where user_type_id=type_id('Your_type_name')

and see if they return any rows back. If they do then there are still some dependencies left in the database on the type. The object_id is the object which has those dependencies.

Thanks

Asvin

|||

Many thanks Asvin, that got it.

Turned out an old view was still referencing the type. Strange that SSMSE did not see this dependency.

|||

Also, check out this very good blog by Umachandar titled "Direct Dependencies on column"

http://blogs.msdn.com/sqltips/archive/2005/07/05/435882.aspx

Cannot drop type

Cannot drop a type event though it is not in use.

The type was created via create type and is an non-nullable nvarchar. It should have been nullable.

I have removed all dependencies on the type, by dropping tabes, stored procs etc, but still cannot drop it. SSMSE says the type cannot be dropped because it's in use. SSMSE shows no dependencies on the type.

Any help?

Can you run these queries

select object_name(object_id), * from sys.columns where user_type_id=type_id('Your_type_name')

select object_name(object_id), * from sys.parameters where user_type_id=type_id('Your_type_name')

and see if they return any rows back. If they do then there are still some dependencies left in the database on the type. The object_id is the object which has those dependencies.

Thanks

Asvin

|||

Many thanks Asvin, that got it.

Turned out an old view was still referencing the type. Strange that SSMSE did not see this dependency.

|||

Also, check out this very good blog by Umachandar titled "Direct Dependencies on column"

http://blogs.msdn.com/sqltips/archive/2005/07/05/435882.aspx

Cannot Drop Index and PK Constraints

I am trying to create a new column on a table, but realized that there is already an PK index created. I am unable to drop the PK, or even delete the table. I also am unable to delete the index.Please be more specific - what error messages are you receiving ? Is it because of a system error or a constraint error (like you are deleting a primary key which is a foreign key in another table(s)) ?

Cannot Deploy Cube to Server

Hi,

I have created a new Cube where the data source itself is not on a SQL Server (DB2 in my case). Now if I try to deploy my Cube it brings an error messages:

(Translated from German)

System error: Login failed: Unknown user or bad password

I could break down the problem until the point that I assume it has to do with the fact that during the deployment process the BI Studio tries to use the same account defined in my data source to access the non SQL Data source as well as the login for the SQL Server 2005 database to store the analysis data.

How can I change the deployment process so it will use one account for the source data and another one as a login for the analysis database?

Thanks.

Ertan

I would guess that connection is attempted under your Analysis Sever service account.

Check if that has sufficient privileges.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Where do I have to set or check this?|||

To see the account your Analysis Server is running you can use SQL Server Configuration Manager application installed SQL Installation->Configuration and Tools.

See what user Analysis Server is running under and try connecting to your Oracle database under it's credentials.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Also, what is the impersonation account specified for your data source? You can set this either to Service Account or a specified user account - this would enable you to specify a user account to connect to the underlying data source (giving this account the appropriate permissions) rather than giving these permissions to the Analysis Services service account.|||

Actually let me correct myself here.

Connecting to Oracle you should check:

First. The account under which your data source connection is impersonated should have sufficient privileges to connect Oracle machine. Deepened on the way you specified data source can be impersonated under service account or under specific user credentials you specified as part of your data source.

Second. When connecting to Oracle machine, you should specify correct user name and password as part of your connection string.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Cannot Deploy Cube to Server

Hi,

I have created a new Cube where the data source itself is not on a SQL Server (DB2 in my case). Now if I try to deploy my Cube it brings an error messages:

(Translated from German)

System error: Login failed: Unknown user or bad password

I could break down the problem until the point that I assume it has to do with the fact that during the deployment process the BI Studio tries to use the same account defined in my data source to access the non SQL Data source as well as the login for the SQL Server 2005 database to store the analysis data.

How can I change the deployment process so it will use one account for the source data and another one as a login for the analysis database?

Thanks.

Ertan

I would guess that connection is attempted under your Analysis Sever service account.

Check if that has sufficient privileges.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Where do I have to set or check this?|||

To see the account your Analysis Server is running you can use SQL Server Configuration Manager application installed SQL Installation->Configuration and Tools.

See what user Analysis Server is running under and try connecting to your Oracle database under it's credentials.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Also, what is the impersonation account specified for your data source? You can set this either to Service Account or a specified user account - this would enable you to specify a user account to connect to the underlying data source (giving this account the appropriate permissions) rather than giving these permissions to the Analysis Services service account.|||

Actually let me correct myself here.

Connecting to Oracle you should check:

First. The account under which your data source connection is impersonated should have sufficient privileges to connect Oracle machine. Deepened on the way you specified data source can be impersonated under service account or under specific user credentials you specified as part of your data source.

Second. When connecting to Oracle machine, you should specify correct user name and password as part of your connection string.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Cannot Deploy Cube to Server

Hi,

I have created a new Cube where the data source itself is not on a SQL Server (DB2 in my case). Now if I try to deploy my Cube it brings an error messages:

(Translated from German)

System error: Login failed: Unknown user or bad password

I could break down the problem until the point that I assume it has to do with the fact that during the deployment process the BI Studio tries to use the same account defined in my data source to access the non SQL Data source as well as the login for the SQL Server 2005 database to store the analysis data.

How can I change the deployment process so it will use one account for the source data and another one as a login for the analysis database?

Thanks.

Ertan

I would guess that connection is attempted under your Analysis Sever service account.

Check if that has sufficient privileges.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Where do I have to set or check this?|||

To see the account your Analysis Server is running you can use SQL Server Configuration Manager application installed SQL Installation->Configuration and Tools.

See what user Analysis Server is running under and try connecting to your Oracle database under it's credentials.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Also, what is the impersonation account specified for your data source? You can set this either to Service Account or a specified user account - this would enable you to specify a user account to connect to the underlying data source (giving this account the appropriate permissions) rather than giving these permissions to the Analysis Services service account.|||

Actually let me correct myself here.

Connecting to Oracle you should check:

First. The account under which your data source connection is impersonated should have sufficient privileges to connect Oracle machine. Deepened on the way you specified data source can be impersonated under service account or under specific user credentials you specified as part of your data source.

Second. When connecting to Oracle machine, you should specify correct user name and password as part of your connection string.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

cannot deploy analysis services tutorial db

i am using sql server developer 2005 .... i follow a tutorial example and attempt to deploy a created analysis services project to the analysis server .... but when i attempt to deploy i get the following:

Error 1 The following system error occurred: Key not valid for use in specified state. . 0 0

i have looked a bunch of different places and found references to this error and have tried things like deleting & creating a new data connection but this does not have any effect .... also these references i have found on the web dont look like they matche my particular situation (deploying to the analysis server) ..... does anyone know how I can get around this ? unfortunately i have not been sucessful in executing the most rudimentary task in sql server ...

thanks

Daver, this error message typically appears in scenarios where the SQL Server Analysis Services service account has been changed to Local Service or if there was an inappropriate change in the service startup account. Can you run your AS service as "Local System" or some valid domain user that has permissions to the relational database referenced in your project’s data source? To change the service account, please use the SQL Server Configuration Manager utility that ships with the product.

Hope this helps,

Artur

sql

Cannot Delete Report

I have been using Reporting Services 2000 for a couple of years with
no issues. Now have verion 2005 installed and building some reports. I
created a report that no longer want and when I went to delete it by
"showing details", selecting the correct checkbox and clicking delete,
I am prompted to confirm that I want to delete but am getting the
following error: "An internal error has occured on the Report Server.
See the error log for more details. (rsInternalError)."
I checked the logs and have the following but it does not seem to
specify the reason for throwing the error:
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: An internal error
occurred on the report server. See the error log for more details. --
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details.
at
Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
condition, String componentName)
at
Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
condition)
at
Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
Item)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
Item)
at
Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
Item)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean
asyncCall)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
Item)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
Item)
at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
at
Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
sender, EventArgs e)
at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
at
Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> I have been using Reporting Services 2000 for a couple of years with
> no issues. Now have verion 2005 installed and building some reports. I
> created a report that no longer want and when I went to delete it by
> "showing details", selecting the correct checkbox and clicking delete,
> I am prompted to confirm that I want to delete but am getting the
> following error: "An internal error has occured on the Report Server.
> See the error log for more details. (rsInternalError)."
> I checked the logs and have the following but it does not seem to
> specify the reason for throwing the error:
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: An internal error
> occurred on the report server. See the error log for more details. --
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details.
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
> condition, String componentName)
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> condition)
> at
> Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
> Item)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
> Item)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> Item)
> at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> at
> Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> sender, EventArgs e)
> at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> at
> Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> postData)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
want to install it on the Report Server. This link might provide some
insight. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
>
>
> > I have been using Reporting Services 2000 for a couple of years with
> > no issues. Now have verion 2005 installed and building some reports. I
> > created a report that no longer want and when I went to delete it by
> > "showing details", selecting the correct checkbox and clicking delete,
> > I am prompted to confirm that I want to delete but am getting the
> > following error: "An internal error has occured on the Report Server.
> > See the error log for more details. (rsInternalError)."
> > I checked the logs and have the following but it does not seem to
> > specify the reason for throwing the error:
> > System.Web.Services.Protocols.SoapException:
> > System.Web.Services.Protocols.SoapException: An internal error
> > occurred on the report server. See the error log for more details. --
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogExcept=ion:
> > An internal error occurred on the report server. See the error log for
> > more details.
> > at
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Asser=t(Bo=ADolean
> > condition, String componentName)
> > at
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> > condition)
> > at
> > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteIt=em(S=ADtring
> > Item)
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteIt=em(S=ADtring
> > Item)
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(S=trin=ADg
> > Item)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapC=lien=ADtMessage
> > message, WebResponse response, Stream responseStream, Boolean
> > asyncCall)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters)
> > at
> > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteIt=em(S=ADtring
> > Item)
> > at
> > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> > Item)
> > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > at
> > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > sender, EventArgs e)
> > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> > at
> > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> > eventArgument)
> > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > sourceControl, String eventArgument)
> > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > postData)
> > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> want to install it on the Report Server. This link might provide some
> insight. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
We did apply SP2 but it did not help the issue.|||I've seen the same thing, and I think it is a bug. Just click Edit from the
details view, and use the Delete function on that page.
--
Tom Garth
"davestub@.gmail.com" wrote:
> On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> >
> >
> >
> >
> >
> > > I have been using Reporting Services 2000 for a couple of years with
> > > no issues. Now have verion 2005 installed and building some reports. I
> > > created a report that no longer want and when I went to delete it by
> > > "showing details", selecting the correct checkbox and clicking delete,
> > > I am prompted to confirm that I want to delete but am getting the
> > > following error: "An internal error has occured on the Report Server.
> > > See the error log for more details. (rsInternalError)."
> >
> > > I checked the logs and have the following but it does not seem to
> > > specify the reason for throwing the error:
> >
> > > System.Web.Services.Protocols.SoapException:
> > > System.Web.Services.Protocols.SoapException: An internal error
> > > occurred on the report server. See the error log for more details. --
> >
> > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > > more details.
> > > at
> > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Bo-olean
> > > condition, String componentName)
> > > at
> > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> > > condition)
> > > at
> > > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> > > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(S-tring
> > > Item)
> > > -- End of inner exception stack trace --
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(S-tring
> > > Item)
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(Strin-g
> > > Item)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClien-tMessage
> > > message, WebResponse response, Stream responseStream, Boolean
> > > asyncCall)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > methodName, Object[] parameters)
> > > at
> > > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(S-tring
> > > Item)
> > > at
> > > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> > > Item)
> > > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > > at
> > > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > > sender, EventArgs e)
> > > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> > > at
> > > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> > > eventArgument)
> > > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > > sourceControl, String eventArgument)
> > > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > > postData)
> > > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> >
> > If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> > want to install it on the Report Server. This link might provide some
> > insight. Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> >
> > - Show quoted text -
> We did apply SP2 but it did not help the issue.
>|||On Sep 26, 9:36 am, Tom Garth <TomGa...@.discussions.microsoft.com>
wrote:
> I've seen the same thing, and I think it is a bug. Just click Edit from t=he
> details view, and use the Delete function on that page.
> --
> Tom Garth
>
> "daves...@.gmail.com" wrote:
> > On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> > > > I have been using Reporting Services 2000 for a couple of years with
> > > > no issues. Now have verion 2005 installed and building some reports=. I
> > > > created a report that no longer want and when I went to delete it by
> > > > "showing details", selecting the correct checkbox and clicking dele=te,
> > > > I am prompted to confirm that I want to delete but am getting the
> > > > following error: "An internal error has occured on the Report Serve=r=2E
> > > > See the error log for more details. (rsInternalError)."
> > > > I checked the logs and have the following but it does not seem to
> > > > specify the reason for throwing the error:
> > > > System.Web.Services.Protocols.SoapException:
> > > > System.Web.Services.Protocols.SoapException: An internal error
> > > > occurred on the report server. See the error log for more details. =--
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogEx=ception:
> > > > An internal error occurred on the report server. See the error log =for
> > > > more details.
> > > > at
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.A=ssert(Bo=AD-olean
> > > > condition, String componentName)
> > > > at
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Bo=olean
> > > > condition)
> > > > at
> > > > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionN=ow()
> > > > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.Dele=teItem(S=AD-tring
> > > > Item)
> > > > -- End of inner exception stack trace --
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.Dele=teItem(S=AD-tring
> > > > Item)
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteIt=em(Strin=AD-g
> > > > Item)
> > > > at
> > > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(S=oapClien=AD-tMessage
> > > > message, WebResponse response, Stream responseStream, Boolean
> > > > asyncCall)
> > > > at
> > > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > > methodName, Object[] parameters)
> > > > at
> > > > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.Dele=teItem(S=AD-tring
> > > > Item)
> > > > at
> > > > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(S=tring
> > > > Item)
> > > > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > > > at
> > > > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > > > sender, EventArgs e)
> > > > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs= e)
> > > > at
> > > > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(Stri=ng
> > > > eventArgument)
> > > > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > > > sourceControl, String eventArgument)
> > > > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > > > postData)
> > > > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > > > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> > > If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> > > want to install it on the Report Server. This link might provide some
> > > insight. Hope this helps.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant- Hide quoted text -
> > > - Show quoted text -
> > We did apply SP2 but it did not help the issue.- Hide quoted text -
> - Show quoted text -
Just tried to delete from the properties page and received the same
error. Thanks for the suggestion.|||You have global "NOCOUNT" turned on on the SQL Server. Turn that off.
Reporting Services requires NOCOUNT off so that it knows that items/records
were actually deleted.
--
SQL Server Developer Support Engineer
"davestub@.gmail.com" wrote:
> I have been using Reporting Services 2000 for a couple of years with
> no issues. Now have verion 2005 installed and building some reports. I
> created a report that no longer want and when I went to delete it by
> "showing details", selecting the correct checkbox and clicking delete,
> I am prompted to confirm that I want to delete but am getting the
> following error: "An internal error has occured on the Report Server.
> See the error log for more details. (rsInternalError)."
> I checked the logs and have the following but it does not seem to
> specify the reason for throwing the error:
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: An internal error
> occurred on the report server. See the error log for more details. --
> >
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details.
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
> condition, String componentName)
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> condition)
> at
> Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
> Item)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
> Item)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> Item)
> at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> at
> Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> sender, EventArgs e)
> at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> at
> Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> postData)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
>

Cannot Delete or Overwrite reports

I cannot delete the first report I created. The Server CPU goes to 100%
utlisation and practically cripples the server (simple sql queries take
forever). Eventually the delete operation times out. I have managed to delete
other reports with success. I see some other people are having the same
problem. I have tried creating a report with the same name and overwriting
but then the designer times out also when I try to deploy it over the old
report.
What sort of behaviour is this? A simple DELETE operation does not work! Is
this product fundamentally flawed or what?Can you post the RDL file which reproduces the behavior? Which version of
Reporting Services are you using?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hyper" <Hyper@.discussions.microsoft.com> wrote in message
news:1D2BF7D1-FE58-4280-BA9A-1F4699CF3619@.microsoft.com...
> I cannot delete the first report I created. The Server CPU goes to 100%
> utlisation and practically cripples the server (simple sql queries take
> forever). Eventually the delete operation times out. I have managed to
delete
> other reports with success. I see some other people are having the same
> problem. I have tried creating a report with the same name and overwriting
> but then the designer times out also when I try to deploy it over the old
> report.
> What sort of behaviour is this? A simple DELETE operation does not work!
Is
> this product fundamentally flawed or what?sql

Cannot Delete Maintenance Plans - SQL 2005

A consultant created a maintenance plan that isn't in use and is not
enabled. I want to delete the plan but get the following error.
TITLE: Microsoft SQL Server Management Studio
Drop failed for Job 'Maintenance II'. (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdN...b&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The DELETE statement conflicted with the REFERENCE constraint
"FK_subplan_job_id". The conflict occurred in database "msdb", table
"dbo.sysmaintplan_subplans", column 'job_id'.
The statement has been terminated. (Microsoft SQL Server, Error: 547)
For help, click:
http://go.microsoft.com/fwlink?ProdN...7&LinkId=20476
BUTTONS:
OK
I"m such a noob, how can i delete this plan?
tia,
Randy
>From what I can tell from the error msg, the job you are trying to
delete has a subplan that references it and you can't delete it until
you get rid of the subplan.
How I would do this:
1.) get job id #
2.) look up job id# in the system table in question
3.) find the subplan for the job id #
4.) delete subplan
4.) delete job
proceed with caution and don't delete anything unless 100% sure !
you should back up your jobs first, too in case something blows up
perhaps there is an easier way to do this through the menus in
Management Studio
Randy H wrote:
> A consultant created a maintenance plan that isn't in use and is not
> enabled. I want to delete the plan but get the following error.
> TITLE: Microsoft SQL Server Management Studio
> --
> Drop failed for Job 'Maintenance II'. (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...b&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The DELETE statement conflicted with the REFERENCE constraint
> "FK_subplan_job_id". The conflict occurred in database "msdb", table
> "dbo.sysmaintplan_subplans", column 'job_id'.
> The statement has been terminated. (Microsoft SQL Server, Error: 547)
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...7&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I"m such a noob, how can i delete this plan?
> tia,
> Randy
|||Is there an easier way through the menus?
I am not having any luck finding the sub plan for the job id #
<tootsuite@.gmail.com> wrote in message
news:1160078499.215907.169040@.k70g2000cwa.googlegr oups.com...
> delete has a subplan that references it and you can't delete it until
> you get rid of the subplan.
> How I would do this:
> 1.) get job id #
> 2.) look up job id# in the system table in question
> 3.) find the subplan for the job id #
> 4.) delete subplan
> 4.) delete job
> proceed with caution and don't delete anything unless 100% sure !
> you should back up your jobs first, too in case something blows up
> perhaps there is an easier way to do this through the menus in
> Management Studio
>
> Randy H wrote:
>
|||Here is the SQL to fix this:
http://www.gudenas.com/2007/04/20/sql-server-2005-delete-maintenance-plan-error/
From http://www.developmentnow.com/g/118_2006_10_0_0_831628/Cannot-Delete-Maintenance-Plans--SQL-2005.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Cannot Delete Maintenance Plans - SQL 2005

A consultant created a maintenance plan that isn't in use and is not
enabled. I want to delete the plan but get the following error.
TITLE: Microsoft SQL Server Management Studio
--
Drop failed for Job 'Maintenance II'. (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?Prod...ob&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The DELETE statement conflicted with the REFERENCE constraint
"FK_subplan_job_id". The conflict occurred in database "msdb", table
"dbo.sysmaintplan_subplans", column 'job_id'.
The statement has been terminated. (Microsoft SQL Server, Error: 547)
For help, click:
http://go.microsoft.com/fwlink?Prod...47&LinkId=20476
BUTTONS:
OK
--
I"m such a noob, how can i delete this plan?
tia,
Randy>From what I can tell from the error msg, the job you are trying to
delete has a subplan that references it and you can't delete it until
you get rid of the subplan.
How I would do this:
1.) get job id #
2.) look up job id# in the system table in question
3.) find the subplan for the job id #
4.) delete subplan
4.) delete job
proceed with caution and don't delete anything unless 100% sure !
you should back up your jobs first, too in case something blows up
perhaps there is an easier way to do this through the menus in
Management Studio
Randy H wrote:
> A consultant created a maintenance plan that isn't in use and is not
> enabled. I want to delete the plan but get the following error.
> TITLE: Microsoft SQL Server Management Studio
> --
> Drop failed for Job 'Maintenance II'. (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...ob&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The DELETE statement conflicted with the REFERENCE constraint
> "FK_subplan_job_id". The conflict occurred in database "msdb", table
> "dbo.sysmaintplan_subplans", column 'job_id'.
> The statement has been terminated. (Microsoft SQL Server, Error: 547)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...47&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I"m such a noob, how can i delete this plan?
> tia,
> Randy|||Is there an easier way through the menus?
I am not having any luck finding the sub plan for the job id #
<tootsuite@.gmail.com> wrote in message
news:1160078499.215907.169040@.k70g2000cwa.googlegroups.com...
> delete has a subplan that references it and you can't delete it until
> you get rid of the subplan.
> How I would do this:
> 1.) get job id #
> 2.) look up job id# in the system table in question
> 3.) find the subplan for the job id #
> 4.) delete subplan
> 4.) delete job
> proceed with caution and don't delete anything unless 100% sure !
> you should back up your jobs first, too in case something blows up
> perhaps there is an easier way to do this through the menus in
> Management Studio
>
> Randy H wrote:
>|||Here is the SQL to fix this:
http://www.gudenas.com/2007/04/20/s...s--SQL-2005.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Cannot Delete Maintenance Plans - SQL 2005

A consultant created a maintenance plan that isn't in use and is not
enabled. I want to delete the plan but get the following error.
TITLE: Microsoft SQL Server Management Studio
--
Drop failed for Job 'Maintenance II'. (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Job&LinkId=20476
--
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
The DELETE statement conflicted with the REFERENCE constraint
"FK_subplan_job_id". The conflict occurred in database "msdb", table
"dbo.sysmaintplan_subplans", column 'job_id'.
The statement has been terminated. (Microsoft SQL Server, Error: 547)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=547&LinkId=20476
--
BUTTONS:
OK
--
I"m such a noob, how can i delete this plan?
tia,
Randy>From what I can tell from the error msg, the job you are trying to
delete has a subplan that references it and you can't delete it until
you get rid of the subplan.
How I would do this:
1.) get job id #
2.) look up job id# in the system table in question
3.) find the subplan for the job id #
4.) delete subplan
4.) delete job
proceed with caution and don't delete anything unless 100% sure !
you should back up your jobs first, too in case something blows up
perhaps there is an easier way to do this through the menus in
Management Studio
Randy H wrote:
> A consultant created a maintenance plan that isn't in use and is not
> enabled. I want to delete the plan but get the following error.
> TITLE: Microsoft SQL Server Management Studio
> --
> Drop failed for Job 'Maintenance II'. (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Job&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The DELETE statement conflicted with the REFERENCE constraint
> "FK_subplan_job_id". The conflict occurred in database "msdb", table
> "dbo.sysmaintplan_subplans", column 'job_id'.
> The statement has been terminated. (Microsoft SQL Server, Error: 547)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=547&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I"m such a noob, how can i delete this plan?
> tia,
> Randy|||Is there an easier way through the menus?
I am not having any luck finding the sub plan for the job id #
<tootsuite@.gmail.com> wrote in message
news:1160078499.215907.169040@.k70g2000cwa.googlegroups.com...
> >From what I can tell from the error msg, the job you are trying to
> delete has a subplan that references it and you can't delete it until
> you get rid of the subplan.
> How I would do this:
> 1.) get job id #
> 2.) look up job id# in the system table in question
> 3.) find the subplan for the job id #
> 4.) delete subplan
> 4.) delete job
> proceed with caution and don't delete anything unless 100% sure !
> you should back up your jobs first, too in case something blows up
> perhaps there is an easier way to do this through the menus in
> Management Studio
>
> Randy H wrote:
>> A consultant created a maintenance plan that isn't in use and is not
>> enabled. I want to delete the plan but get the following error.
>> TITLE: Microsoft SQL Server Management Studio
>> --
>> Drop failed for Job 'Maintenance II'. (Microsoft.SqlServer.Smo)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Job&LinkId=20476
>> --
>> ADDITIONAL INFORMATION:
>> An exception occurred while executing a Transact-SQL statement or batch.
>> (Microsoft.SqlServer.ConnectionInfo)
>> --
>> The DELETE statement conflicted with the REFERENCE constraint
>> "FK_subplan_job_id". The conflict occurred in database "msdb", table
>> "dbo.sysmaintplan_subplans", column 'job_id'.
>> The statement has been terminated. (Microsoft SQL Server, Error: 547)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=547&LinkId=20476
>> --
>> BUTTONS:
>> OK
>> --
>> I"m such a noob, how can i delete this plan?
>> tia,
>> Randy
>|||Here is the SQL to fix this:
http://www.gudenas.com/2007/04/20/sql-server-2005-delete-maintenance-plan-error
From http://www.developmentnow.com/g/118_2006_10_0_0_831628/Cannot-Delete-Maintenance-Plans--SQL-2005.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comsql

Cannot create or modify tables in any database ("The parameter is incorrect.")

Using SQL Server 2005 and Microsoft SQL Server Management Studio, I connect using windows authentication. On any database I have created or attached (from a previous version of SQL Server), if I try to add a new table or modify an existing table, I get an error. A dialog pops up that says, "The parameter is incorrect." And I realy can't go any further.

I tried to remedy the problem by applying SP1 (x64) to the installation but I still get the same error.

Has anybody got a clue as to why I get this error? This is not SQL Server Express but the standard version of SQL Server. Fabulous software, I just can't get this to work on this new server. SQL Server Express is wonderful on our test machines but we need to get past this issue to fully utilize the server version.

Thanks for any help somebody can give me.

Please file a defect report on http://connect.microsoft.com/sqlserver. Defects reported on the Connect site go directly into our internal issue tracking system.

The error message pop-up should have a button/icon at bottom to show technical details. This includes the detailed exception message and the call stack. This can help us diagnose the problem. Be sure to include the version number of management studio and the engine (use menu Help | About to see the management studio version, and use this T-SQL to get the engine version: select @.@.version) and the call stack from the error dialog in the defect report.

One thing I would check is whether the database you've attached has a valid owner in the new server. If the database doesn't have an owner, you can give it one using the database properties dialog in management studio (connect to the server, right click on the database in Object Explorer, and select Properties. The owner can be set on the Files page.) or by issuing the "ALTER AUTHORIZATION ON DATABASE::{your db} TO {server principal}" statement in sqlcmd or a management studio query window.

You also need fairly high privileges to modify tables. Can you modify tables if you log in as a database owner?

Thanks,
Steve

cannot create new sql express database

Hi,

I am trying to create a new Sql Express Database (.mdf file) from inside Visual Studio 2005. I did the following:

1) Created a Database Project in Visual Studio.

2) Choose Data Source to be Microsoft SQL Server Database File

3) Browse to a directory and enter a file name for the new database, say abc.mdf

4) When I click OK, Visual Studio prompts me if I want to create the database file, I click yes.

5) After a while, I get this error message:

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 Locating Server/Instance Specified)

Then I opened SQL Server Configuration Manager, and I enabled Named Pipes and TCP/IP for both SQLEXPRESS and MSSQLSERVER. It prompts me that the settings will not change until the service is re-started.

When I go to Administrative Tools -> Services, I see that SQLServer (MSSQLSERVER) is started, and SQL Server (SQLEXPRESS) is stopped. I can stop the MSSQLSERVER service. But when I tried to start SQLEXPRESS service, I get the following error message:

Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. For more information, review the System Event Lo9g. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 17058.

I have Visual Stuio 2005 and Sql Server 2005 Installed on my machine, and I believe I am logged on using an administrator account.

Can someone help me to figure out what's wrong please?

Thanks and regards,

Alice

It seems that something is wrong with your SQL Express isntallation if it won't start. You should check the error log to see if it give more details about the problem starting the service. The error log is generally located at C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG (Your InstanceID may be different).

When you check the error log, please also verify that you are not running a beta version of SQL Express. The version number should contain either 9.00.1399 or 9.00.2047.

Mike

|||

Hi,

It turns out SQL Express wasn't installed properly. I re-installed it and it works fine now. Thanks a lot.

Alice