Error: Data Mining message

This may well be embarrasingly simple but....

I get this massage from Management Studion when I try to run any MDX

Error (Data mining): Either the user, LEONARD\Will Riley, does not have permission to access the referenced mining model, Contribution_Interest, or the object does not exist.

Is there something really simple I have missed?

Most likely you made syntax error in your MDX up tp a degree that it actually looks more like DMX than MDX, so AS tries to find mining model instead of cube. If you will paste your MDX statement, the forum should be able to help and fix it.|||

Yep, you got it

Once I plugged in what I knew to be some correctly structured MDX, the issue went away.

Cheers, Will

Error: Cannot display activity

TITLE: Microsoft SQL Server Management Studio Express (CTP Nov)

OS: Both XP SP2 and Win2003 SP1

Cannot display activity for database 'SomeDBName'.

ADDITIONAL INFORMATION:

Could not load file or assembly 'ActivityMonitor, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (mscorlib)

To reproduce:

Try to detach a database which has at least one active connection. On the Detach Database dialog click on: 1 Active connection.

Hi, this issue has already been found and resolved. You should not see this on the RTM version.|||

Hi

This is the only place in the entire world I have found reference to this problem. I have the same problem and I'm running MS SQL Server 2005 Express SP1 running on XP SP2.

Help > About on SSMSE shows:

Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

I found a KB article a while back about changing the registry key HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\TlbAutoRepair\mscorlib.tlb TlbPath value of %CLRVERSION% to v2.0.50727 but that didn't fix it. I've since tried repairing .Net Framework 2.0 and SSMSE but still have the problem.

Any ideas where to go next?

Mick

Error: Cannot display activity

TITLE: Microsoft SQL Server Management Studio Express (CTP Nov)

OS: Both XP SP2 and Win2003 SP1

Cannot display activity for database 'SomeDBName'.

ADDITIONAL INFORMATION:

Could not load file or assembly 'ActivityMonitor, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (mscorlib)

To reproduce:

Try to detach a database which has at least one active connection. On the Detach Database dialog click on: 1 Active connection.

Hi, this issue has already been found and resolved. You should not see this on the RTM version.|||

Hi

This is the only place in the entire world I have found reference to this problem. I have the same problem and I'm running MS SQL Server 2005 Express SP1 running on XP SP2.

Help > About on SSMSE shows:

Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

I found a KB article a while back about changing the registry key HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\TlbAutoRepair\mscorlib.tlb TlbPath value of %CLRVERSION% to v2.0.50727 but that didn't fix it. I've since tried repairing .Net Framework 2.0 and SSMSE but still have the problem.

Any ideas where to go next?

Mick

Error: 5123 CREATE FILE encountered operating system error 5A(Access denied.)

HI ,

This is a problem I encountered when I had to detach a database file (type .mdf):

1) I went to the MS SQL Management Server Studi and detached my database file successfully from a connection called Workhorse.

2) I needed to place the .mdf database file into a zip file in order to put it on a remote server. I did this using Shared Portal. This was also successful

3) However when I tried reattaching the database file, I got this error:

CREATE FILE encountered operating system error 5A(Access denied.) while attempting to open or create the physical file "C\Program Files\MSSQL Server\MSSQL\Data\<databasename>.mdf'

Q) The database file and log file (ldf) exist in the correct directory so I don't know what happened. Can any one help?

Thanks much

Tonante

Dear Tonate,

Please, take a look on the following link and might be it will help you :)

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=120536&SiteId=1

|||

Hi Tonate,

I got the solution for this. I proud this is my first blog to provide the answer on internet

I got the same error too:

CREATE FILE encountered operating system error 5A(Access denied.) while attempting to open or create the physical file "C\Program Files\MSSQL Server\MSSQL\Data\<databasename>.mdf'

the solution is:

set the Operating system permission on that .mdf file to full permission to 'Everyone' in new server.

this will helps me to attach the database in other server..

Have a Great Day..

vino...

|||

Well that could be a security issue, its better to give permission to the SQL Server account.

Error: 5123 CREATE FILE encountered operating system error 5A(Access denied.)

HI ,

This is a problem I encountered when I had to detach a database file (type .mdf):

1) I went to the MS SQL Management Server Studi and detached my database file successfully from a connection called Workhorse.

2) I needed to place the .mdf database file into a zip file in order to put it on a remote server. I did this using Shared Portal. This was also successful

3) However when I tried reattaching the database file, I got this error:

CREATE FILE encountered operating system error 5A(Access denied.) while attempting to open or create the physical file "C\Program Files\MSSQL Server\MSSQL\Data\<databasename>.mdf'

Q) The database file and log file (ldf) exist in the correct directory so I don't know what happened. Can any one help?

Thanks much

Tonante

Dear Tonate,

Please, take a look on the following link and might be it will help you :)

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=120536&SiteId=1

|||

Hi Tonate,

I got the solution for this. I proud this is my first blog to provide the answer on internet

I got the same error too:

CREATE FILE encountered operating system error 5A(Access denied.) while attempting to open or create the physical file "C\Program Files\MSSQL Server\MSSQL\Data\<databasename>.mdf'

the solution is:

set the Operating system permission on that .mdf file to full permission to 'Everyone' in new server.

this will helps me to attach the database in other server..

Have a Great Day..

vino...

|||Well that could be a security issue, its better to give permission to the SQL Server account.|||Greetings SQL Server users, I rarely post to forums but think I probably should start doing so. I know this problem was probably solved, but just in case it wasn't, this was my solution to the exact same problem when attempting to do exactly what you tried (detaching, zipping, then re-attaching the database file *.mdf) using SQL Server 2005 with Mgmt Server Studio. First, Stop all SQL services, Secondly, go to the sql folder (default: MSSQL) and right click on it and see if you can change your folder and all subfolder atrributes to NOT read only (unchecked). I noticed that on my server, the log and data files could not be changed. So I immediately went to those files *.ldf and *.mdf and took ownership of both of them (the permissions can easily get wacked). Once I did that, I was able to zip them and move them to safer ground. I then restarted all SQL Services, and was able to re-attach the *.mdf file. If you are like me, you probably log in using a few different usernames and move files around a lot. For some odd reason, our permissions get hosed up from time to time. I hope this helped.

Error: 18456, Severity: 14, State: 11 when logging in

I just installed SQL Server 2005 with SP2 on Vista. When I try to login from SQL Server Management Studio, I get the following error message in the log:

2007-09-15 18:58:02.23 Logon Error: 18456, Severity: 14, State: 11.
2007-09-15 18:58:02.23 Logon Login failed for user '<computer name>\<user account>'.[CLIENT: <local machine>]

Since I can't login, I can't try some of the stuff I have seen here, such as creating new logins etc.

I installed Analysis Server and Integration Services at the same time. Logging in to them both works fine.

I use windows authentication. I don't know if changing that helps, as I don't know how to change it without logging in in the first place...

I think you entered in Windows with an account (<computer name>\<user account>) that hasn't a SQL login.

If your windows account should have administrator privillege it should enter with SQL login named "Builtin\administrators"

To the other part reading this the builtin administrator is disabled by default in Vista.

So repair first this.

|||

Gigi is correct. You can also read about this issue here: http://msdn2.microsoft.com/en-us/library/Aa905868.aspx.

Thanks

Laurentiu

Error: 18456, Severity: 14, State: 11 when logging in

I just installed SQL Server 2005 with SP2 on Vista. When I try to login from SQL Server Management Studio, I get the following error message in the log:

2007-09-15 18:58:02.23 Logon Error: 18456, Severity: 14, State: 11.
2007-09-15 18:58:02.23 Logon Login failed for user '<computer name>\<user account>'.[CLIENT: <local machine>]

Since I can't login, I can't try some of the stuff I have seen here, such as creating new logins etc.

I installed Analysis Server and Integration Services at the same time. Logging in to them both works fine.

I use windows authentication. I don't know if changing that helps, as I don't know how to change it without logging in in the first place...

I think you entered in Windows with an account (<computer name>\<user account>) that hasn't a SQL login.

If your windows account should have administrator privillege it should enter with SQL login named "Builtin\administrators"

To the other part reading this the builtin administrator is disabled by default in Vista.

So repair first this.

|||

Gigi is correct. You can also read about this issue here: http://msdn2.microsoft.com/en-us/library/Aa905868.aspx.

Thanks

Laurentiu

error: 0 - No process is on the other end of the pipe

I can use SQL Server Management Studio Express to connect to my local database SQL 2005 database on bknji\sqlexpress.

I am also able to connect to the database from Visual Studio, and this is where I copied the following connection string to be used in my C# code

string myConnectString = "Data Source=BKFNJI\\SQLEXPRESS;" +

"Initial Catalog=cmiCompatibilityDataBase" +

"Integrated Security=True;Pooling=False";

// specify SQL Server Specific Connection string

SqlConnection cmiDBCompConnection = new SqlConnection(myConnectString);

cmiDBCompConnection.Open();

when I attempt to run the apps, I get the

"System.Data.SqlClient.SqlException was unhandled
Message="A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)".....

any idea what I am doing wrong, given that the connection string works using other means? I am using Windows authentication.

To add, the error in my log shows:

2007-03-17 21:10:55.82 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: <local machine>]

Thanks,

Klaus

Seems although the server is expecting Windows Authentication, either no username was passed to the server internally or you are using a different connectionstring than the one posted above. Could you descrive your environment ? Are you in a domain, is the machine you are connecting from the same machine as the development machine ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error with SQL Server 2K5 "Cannot connect... Instance failure"

I am getting the following error when trying to connect to SQL Server
2005 Express through Microsoft SQL Server Management Studio Express
CTP.
"Cannot connect to SERVER\SQLEXPRESS
Additional Information:
Instance Failure. (System.Data)"
One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
start automatically yet, it wasn't started. I tried to start it, but
kept receiving a message that the service was started and then stop for
a rerason along the lines "if a service isn't need, it stops itself".
So...
I stopped the following services and restarted them:
MSSQL$SHAREPOINT
MSSQLSERVER
SQL Server Browser
and it finally let me start "SQL Server (SQLEXPRESS)" !!
After stopping and starting the 4 services above, it let me in again.
This is the 3rd time this has happened to me. Anyone have any ideas?
Hi
This sounds like you are using a user instance?
This may help
http://msdn.microsoft.com/library/de...xpuserinst.asp
What is the exact error number and message in the SQL Server log?
John
"ATJaguarX" wrote:

> I am getting the following error when trying to connect to SQL Server
> 2005 Express through Microsoft SQL Server Management Studio Express
> CTP.
> "Cannot connect to SERVER\SQLEXPRESS
>
> Additional Information:
> Instance Failure. (System.Data)"
>
> One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
> start automatically yet, it wasn't started. I tried to start it, but
> kept receiving a message that the service was started and then stop for
> a rerason along the lines "if a service isn't need, it stops itself".
> So...
>
> I stopped the following services and restarted them:
>
> MSSQL$SHAREPOINT
> MSSQLSERVER
> SQL Server Browser
>
> and it finally let me start "SQL Server (SQLEXPRESS)" !!
>
> After stopping and starting the 4 services above, it let me in again.
> This is the 3rd time this has happened to me. Anyone have any ideas?
>
|||I am not sure if I am running a user instance. I have yet to design an
application to hit my database, I have only been logging into the
management tool.
My error logs are all empty. Is there something I need to do to turn
these on?
|||Hi
If you had a user instance the database would only be attached when it was
connected to.
You can use SSEUtil to connect to the instance.
John
"ATJaguarX" wrote:

> I am not sure if I am running a user instance. I have yet to design an
> application to hit my database, I have only been logging into the
> management tool.
> My error logs are all empty. Is there something I need to do to turn
> these on?
>

Error with SQL Server 2K5 "Cannot connect... Instance failure"

I am getting the following error when trying to connect to SQL Server
2005 Express through Microsoft SQL Server Management Studio Express
CTP.
"Cannot connect to SERVER\SQLEXPRESS
Additional Information:
Instance Failure. (System.Data)"
One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
start automatically yet, it wasn't started. I tried to start it, but
kept receiving a message that the service was started and then stop for
a rerason along the lines "if a service isn't need, it stops itself".
So...
I stopped the following services and restarted them:
MSSQL$SHAREPOINT
MSSQLSERVER
SQL Server Browser
and it finally let me start "SQL Server (SQLEXPRESS)" !!
After stopping and starting the 4 services above, it let me in again.
This is the 3rd time this has happened to me. Anyone have any ideas?Hi
This sounds like you are using a user instance?
This may help
http://msdn.microsoft.com/library/d...>
userinst.asp
What is the exact error number and message in the SQL Server log?
John
"ATJaguarX" wrote:

> I am getting the following error when trying to connect to SQL Server
> 2005 Express through Microsoft SQL Server Management Studio Express
> CTP.
> "Cannot connect to SERVER\SQLEXPRESS
>
> Additional Information:
> Instance Failure. (System.Data)"
>
> One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
> start automatically yet, it wasn't started. I tried to start it, but
> kept receiving a message that the service was started and then stop for
> a rerason along the lines "if a service isn't need, it stops itself".
> So...
>
> I stopped the following services and restarted them:
>
> MSSQL$SHAREPOINT
> MSSQLSERVER
> SQL Server Browser
>
> and it finally let me start "SQL Server (SQLEXPRESS)" !!
>
> After stopping and starting the 4 services above, it let me in again.
> This is the 3rd time this has happened to me. Anyone have any ideas?
>|||I am not sure if I am running a user instance. I have yet to design an
application to hit my database, I have only been logging into the
management tool.
My error logs are all empty. Is there something I need to do to turn
these on?|||Hi
If you had a user instance the database would only be attached when it was
connected to.
You can use SSEUtil to connect to the instance.
John
"ATJaguarX" wrote:

> I am not sure if I am running a user instance. I have yet to design an
> application to hit my database, I have only been logging into the
> management tool.
> My error logs are all empty. Is there something I need to do to turn
> these on?
>

Error with SQL Server 2K5 "Cannot connect... Instance failure"

I am getting the following error when trying to connect to SQL Server
2005 Express through Microsoft SQL Server Management Studio Express
CTP.
"Cannot connect to SERVER\SQLEXPRESS
Additional Information:
Instance Failure. (System.Data)"
One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
start automatically yet, it wasn't started. I tried to start it, but
kept receiving a message that the service was started and then stop for
a rerason along the lines "if a service isn't need, it stops itself".
So...
I stopped the following services and restarted them:
MSSQL$SHAREPOINT
MSSQLSERVER
SQL Server Browser
and it finally let me start "SQL Server (SQLEXPRESS)" !!
After stopping and starting the 4 services above, it let me in again.
This is the 3rd time this has happened to me. Anyone have any ideas?Hi
This sounds like you are using a user instance?
This may help
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp
What is the exact error number and message in the SQL Server log?
John
"ATJaguarX" wrote:
> I am getting the following error when trying to connect to SQL Server
> 2005 Express through Microsoft SQL Server Management Studio Express
> CTP.
> "Cannot connect to SERVER\SQLEXPRESS
>
> Additional Information:
> Instance Failure. (System.Data)"
>
> One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
> start automatically yet, it wasn't started. I tried to start it, but
> kept receiving a message that the service was started and then stop for
> a rerason along the lines "if a service isn't need, it stops itself".
> So...
>
> I stopped the following services and restarted them:
>
> MSSQL$SHAREPOINT
> MSSQLSERVER
> SQL Server Browser
>
> and it finally let me start "SQL Server (SQLEXPRESS)" !!
>
> After stopping and starting the 4 services above, it let me in again.
> This is the 3rd time this has happened to me. Anyone have any ideas?
>|||I am not sure if I am running a user instance. I have yet to design an
application to hit my database, I have only been logging into the
management tool.
My error logs are all empty. Is there something I need to do to turn
these on?|||Hi
If you had a user instance the database would only be attached when it was
connected to.
You can use SSEUtil to connect to the instance.
John
"ATJaguarX" wrote:
> I am not sure if I am running a user instance. I have yet to design an
> application to hit my database, I have only been logging into the
> management tool.
> My error logs are all empty. Is there something I need to do to turn
> these on?
>

Error with Bit datatype.

I created a table called "test" with only one column of bit data type.

I opened the table using management studio and tried to enter the number "1" It is throwing the below error

Microsoft SQL Server Management Studio

Invalid value for cell (row 1, column 1).

The changed value in this cell was not recognized as valid.
.Net Framework Data Type: Boolean
Error Message: String was not recognized as a valid Boolean.

Type a value appropriate for the data type or press ESC to cancel the change.

OK Help

But when I enter true or false it accepts it as a valid value.

When I execute the query
insert into test values (1)
the insert goes fine.

I opened table via management studio I am seeing "true" "false" as values in the table.
When I do a select in the query analyzer I am getting "1" and "0" as results.

Is this the way it is indented to work?

Santhosh

Here is my take...

When SSMS (written in VS.NET) opens a table, it is using a datagrid -and the datagrid is converting to a boolean because VS.NET doesn't have a bit datatype.

If you open a query window, and execute a SQL query that returns the data from the table, you will see that the data is indeed stored as a bit datatype [ 0/1/NULL ].

|||Arnie,
Thanks for the reply. Doesnt it sound stupid?|||I agree that there could be a bit more information available about how SSMS is working behind the scenes.|||Thats because the different UIs are owned by different groups at MS. They *might* get aligned in the future.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error while trying to modify one Maintenance Plan

Hello,

I am trying to modify one of my Maintenance Plan in MS Server Management Studio, and I am getting the following error:

TITLE: Microsoft SQL Server Management Studio

Cannot show the editor for this task.

ADDITIONAL INFORMATION:

Value of '9/6/2007 12:00:00 AM' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'.
Parameter name: Value (System.Windows.Forms)

BUTTONS:

OK

INteresting that it used to work fine, but since I am not the only one who is using thise server, I do not know what has been changed. I asked around, and everybody said they did not do anything...

Please help

Check out this link for an explanation and work-around: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1483359&SiteID=1

I had the exact same error and it worked for me.

|||

I would suggest to test what has been referred on that post and if it doesn't work, you could try reinstalling the SQL tools and sp2 again in order to see whether this is not a tools glitch.

As a workaround you might try to do the same from another machine.

Error while trying to modify one Maintenance Plan

Hello,

I am trying to modify one of my Maintenance Plan in MS Server Management Studio, and I am getting the following error:

TITLE: Microsoft SQL Server Management Studio

Cannot show the editor for this task.

ADDITIONAL INFORMATION:

Value of '9/6/2007 12:00:00 AM' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'.
Parameter name: Value (System.Windows.Forms)

BUTTONS:

OK

INteresting that it used to work fine, but since I am not the only one who is using thise server, I do not know what has been changed. I asked around, and everybody said they did not do anything...

Please help

Check out this link for an explanation and work-around: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1483359&SiteID=1

I had the exact same error and it worked for me.

|||

I would suggest to test what has been referred on that post and if it doesn't work, you could try reinstalling the SQL tools and sp2 again in order to see whether this is not a tools glitch.

As a workaround you might try to do the same from another machine.

error while starting MSDTC service

hey experts!!
I got this from Microsoft Management Console when starting the MSDTC service.
Could not start the Distributed Transaction Coordinator Service on local computer
Error 1067: The process terminated unexpectedly.
Can someone plz tell me wht the hell this means and how can i fix it. it does not gives any other info.
thankscan someone plz help me here. if you need more information
at least derect me somewhere as i am new to this sql and
ms dtc stuff.
thnks

Error While Scheduling the SSIS Package

Hello Everyone,
When i try to scedule a job on SQL Server Management Studio it gives the Following Error:

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectkey'.(Micorsoft.SqlServer.Smo)

Can anyone tell me why ?

MS SQL Server Details:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Hi,

Do you have this file?

C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.SqlServer.Smo.dll

Regards,

Janos

|||Yes, File is there on the specified path.

|||

Well, I got the same error one time, as far as I remember, I repaired my installation of SQL Server client tool.

Try to repair it please.

regards,

Janos

|||thanks janos,

i have a local server installed on my workstation along with sp2.
Do you really think reinstalling the server will work ?
|||

Well, It worked for me

Maybe you just repair your installation will be enough.

Regards,

Janos

|||Is there any option for repairing the server ?
Coz i haven't seen any while installing.
|||Did you manage to find a solution for this problem? I get the same error when trying to create an Agent job. I've repaired the SQL Native Client but to no avail. I still get the error.
|||No, not yet !!! I am still working on it.
One of the forum member advised me to repair the server but for you if it did not work, then i am doubtful.
|||You can repair the application from "Programs and Features" (Vista) or "Add/Remove Programs" (XP) in control panel|||

Hi Vick,

I just realized something. I saw the error message contains the SQL build w/o service pack, but you wrote you have SP2 installed (but maybe just for database services and SSMS or just SSIS). Have you tried to install the SP2 to the SSIS or those, where not installed?

Regards,

Janos

|||No, Its not working even after repairing the server.

Thanks
Janos
|||Sorry Vick, I'm out of ideas. I tried to recreate the same error on a virtual machine, but no luck. I'm sorry.|||Hi Janos,

Sp2 is not specific to the service you are using. It upgrades all the services of server (EE, DE, SE, etc).

Check out the link
http://www.microsoft.com/downloads/details.aspx?familyid=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en
|||check out the post.

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

check if you are experiencing the same.

error while generating ad hoc model for Analysis Services Cube

hi,

I try to generate ad hoc reporting model for analysis services cube in reporting services.
in Management Studio I connected to reporting services, defined a data source to the analysis services database.
But If i try to generate model i get the error:
"While connection with a data source a mistake has appeared, or the query is invalid for the data source. (rsCannotPrepareQuery)(Report Services SOAP Proxy Source)"

Any ideas as to what may be the problem?
Thanks!

karaman

Moving to Reporting Services forum.|||I am having the same issue and can find no other reference to it, anywhere. Did you get this resolved?

error while generating ad hoc model for Analysis Services Cube

hi,

I try to generate ad hoc reporting model for analysis services cube in reporting services.
in Management Studio I connected to reporting services, defined a data source to the analysis services database.
But If i try to generate model i get the error:
"While connection with a data source a mistake has appeared, or the query is invalid for the data source. (rsCannotPrepareQuery)(Report Services SOAP Proxy Source)"

Any ideas as to what may be the problem?
Thanks!

karaman

Moving to Reporting Services forum.|||I am having the same issue and can find no other reference to it, anywhere. Did you get this resolved?

Error while creating a new database in SQL2005

Hello,

I am trying to create a new database through the SQL Server Management Studio and I am getting the following error:

Cannot show requested dialog.

Additional information:

Cannot show requested dialog. (SqlMgmt)

Method not found:'Microsoft.SqlServer.Management.Smo.Edition

Microsoft.SqlServer.Management.Smo.Information.get_EngineEdition()'.(SqlManagerUI)

Kindly help to resolve this issue.

Thanks

Ramesh

Could you please post the whole stack ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks Jens for replying.

I am copying the content shown under the show technical details button on that error dialog.

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

Cannot show requested dialog.

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

Cannot show requested dialog. (SqlMgmt)

Program Location:

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.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

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

Method not found: 'Microsoft.SqlServer.Management.Smo.Edition Microsoft.SqlServer.Management.Smo.Information.get_EngineEdition()'. (SqlManagerUI)

Program Location:

at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase.InitializeDataMembers(CDataContainer context)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase..ctor(CDataContainer context)

I am not sure if you were looking for this. Please let me know if you need any further info.

Thanks again

Kind regards

Ramesh

|||If you believe its SSMS tools problem, try to reinstall them again. If it still doesn't work

Please file a bug on https://connect.microsoft.com/SQLServer/Feedback . Bugs filed on the connection center go straight into our defect tracking system. Since connection center bugs are filed by a customer, they have more weight than developer-filed bugs when it comes to deciding which bugs we'll fix next.

|||I received a similar error any time I try to "Modify" or "script" a stored proc from the SQL Server Management Studio. I can work around this by opening a query editor window and manually typing sp_helptext and the sp name. I did try reinstalling because I believed it to be related to some assemblies being accidentally deleted from the GAC, but no change on this error. Do you know of any assemblies that I should be looking for in the GAC and where to load them from if they're not there?

The actual msg I get is:
Method not found: 'Void Microsoft.SqlServer.Management.Smo.SqlSmoObject.Touch()'. (SQLEditors)

OR

Method not found: 'Void Microsoft.SqlServer.Management.Smo.ScriptingOptions.set_NoVardecimal(Boolean)'. (ObjectExplorer)

Thank you
-VG
|||

I have received a similar error ,too. please install 'SQLServer2005SP2-KB921896-x86-EN.exe' or'SQLServer2005SP2-KB921896-x64-EN.exe'.it's OK!

|||

I have the following OS installed: Windows Server 2003 - SP2

I have installed SQL Server 2005 with SP2.

But still I'm not able to fix the error and I'm not able to create a New Database using the SQL Management Studio. I'm not even able to run queries in the Qiery Window to create the Database.

How can this problem be fixed?

Is there any hotfix available?

Error while creating a new database in SQL2005

Hello,

I am trying to create a new database through the SQL Server Management Studio and I am getting the following error:

Cannot show requested dialog.

Additional information:

Cannot show requested dialog. (SqlMgmt)

Method not found:'Microsoft.SqlServer.Management.Smo.Edition

Microsoft.SqlServer.Management.Smo.Information.get_EngineEdition()'.(SqlManagerUI)

Kindly help to resolve this issue.

Thanks

Ramesh

Could you please post the whole stack ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks Jens for replying.

I am copying the content shown under the show technical details button on that error dialog.

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

Cannot show requested dialog.

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

Cannot show requested dialog. (SqlMgmt)

Program Location:

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.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

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

Method not found: 'Microsoft.SqlServer.Management.Smo.Edition Microsoft.SqlServer.Management.Smo.Information.get_EngineEdition()'. (SqlManagerUI)

Program Location:

at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase.InitializeDataMembers(CDataContainer context)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase..ctor(CDataContainer context)

I am not sure if you were looking for this. Please let me know if you need any further info.

Thanks again

Kind regards

Ramesh

|||If you believe its SSMS tools problem, try to reinstall them again. If it still doesn't work

Please file a bug on https://connect.microsoft.com/SQLServer/Feedback . Bugs filed on the connection center go straight into our defect tracking system. Since connection center bugs are filed by a customer, they have more weight than developer-filed bugs when it comes to deciding which bugs we'll fix next.

|||I received a similar error any time I try to "Modify" or "script" a stored proc from the SQL Server Management Studio. I can work around this by opening a query editor window and manually typing sp_helptext and the sp name. I did try reinstalling because I believed it to be related to some assemblies being accidentally deleted from the GAC, but no change on this error. Do you know of any assemblies that I should be looking for in the GAC and where to load them from if they're not there?

The actual msg I get is:
Method not found: 'Void Microsoft.SqlServer.Management.Smo.SqlSmoObject.Touch()'. (SQLEditors)

OR

Method not found: 'Void Microsoft.SqlServer.Management.Smo.ScriptingOptions.set_NoVardecimal(Boolean)'. (ObjectExplorer)

Thank you
-VG
|||

I have received a similar error ,too. please install 'SQLServer2005SP2-KB921896-x86-EN.exe' or'SQLServer2005SP2-KB921896-x64-EN.exe'.it's OK!

|||

I have the following OS installed: Windows Server 2003 - SP2

I have installed SQL Server 2005 with SP2.

But still I'm not able to fix the error and I'm not able to create a New Database using the SQL Management Studio. I'm not even able to run queries in the Qiery Window to create the Database.

How can this problem be fixed?

Is there any hotfix available?