Error: Cannot open database requested in login projectAllocations. Login fails. Login fail

Hi,
Im getting this error when attempting to retrieve data from an sql database.

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.Data.SqlClient.SqlException: Cannot open database requested in login 'projectAllocations'. Login fails. Login failed for user 'sa'.

Source Error:

Line 13: objConn = New SqlConnection( "Server=LAB303-066\NETSDK; Database=projectAllocations; User ID=sa;Password=mypassword")
Line 14: objCmd = New SqlCommand("SELECT * FROM project_descriptions", objConn)
Line 15: objConn.Open()
Line 16: objRdr = objCmd.ExecuteReader()
Line 17: While objRdr.Read()

Source File: C:\finalyearproject2\sample.aspx Line: 15

Please Help!! Im a beginner to this, so if anyone knows the answer, take baby steps when explaining. Thanksas the message says you prbly need to give permissions to the user to access the database. in your enterprise manager, if you xpand the databases tab and then the db you are working on, there's a Users tab. click on it and in the panel to your right you would see a list of users. You might need to add the user "projectAllocations" to the list here and give permissions to the user to access the tables/stored procs and other objects..

hth|||Hi,
Thanks for the response. When I login to the web data administrator and expad the database im workin on, there is no users tab. Does the database have to be empty to do this?|||>>in your enterprise manager, if you xpand the databases tab

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?

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!

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!