Tuesday, March 20, 2012
Cant access Northwind database
I then entered the following on my IE browser:
http://<IIServer>/nwind?sql=SELECT FirstName, LastName FROM Employees FOR XML AUTO&root=root
the result is:
"The page cannot be displayed..."
I'd appreciate any help.
Thanks,
Pathttp://<IIServer>/nwind?sql=SELECT FirstName, LastName FROM Employees FOR XML AUTO&root=root
Is that a typo, or are you trying to pass a variable to a directory? when you say /nwind?sql='foo' then you should get page cannot be displayed, right? Don't you have to say /nwind/default.asp?sql='foo' ??
or will the virtual directory/IIS understand what you mean?sql
Thursday, March 8, 2012
Cannot Upgrade MSDE 2000 Sp3 to SP4
Hi!
Here's the scenario:
I have a MSDE 2000 installation running, already patched to SP3. Instancename is "STO". I've downloaded SQL2000.MSDE-KB884525-SP4-X86-ENU.exe and extracted the archive to C:\SQL2KSP4.
After starting setup from the command prompt with "setup /upgradesp sqlrun DISABLENETWORKPROTOCOLS=0 /L*V C:\MSDELog.log" i get a message box, telling me "The product is not installed". This happens even if I specify the exact instancename and supply the sa user and pwd!
Any ideas?`
Thanks in advance and regards
Clemens
In your command line, you need to specify the instance name and sa pass word. Would you try the following command line?
start /wait setup.exe /qb INSTANCENAME=sto SAPWD="<sa pass word>" SECURITYMODE=SQL
|||Thx for your reply, but if you look at my post above, you'll see that i also tried that! ;-)
Quote:
"This happens even if I specify the exact instancename and supply the sa user and pwd!"
Rgds
Clemens
|||In your command line, you do not specify the instance name. It is required for an upgrading. Would you check and try?cannot upgrade management studio
Hi,
I have clean install of Vista and Orcas March CTP. Vista automatically downloaded SP2 for SQL services. It does not come with Management Studio however, so I have to download it from web. There is only unupdated version for download, so I downloaded it and installed it. It does not work of course, but when I run the SP2 pack, it wrote me that half of the products are already updated and half of them are not updatable by the pack.
What should I do?
SQL Server SP2 does update the enterprise Management Studio, so I assume you are talking about Management Studio Express.
You should be able to uninstall Management Studio Express and then install Management Studio Express SP2 from this web site: http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en If you've already done that, you can verify that you have Management Studio Express SP2 by starting the application and then looking at the Help > About... dialog. SP2 is version 9.0.3042.
Hope this helps,
Steve
|||As explained you can accomplish as per the explanation above, if you are using ENterprise Management studio then you might try again applying the Service pack2.
cannot upgrade management studio
Hi,
I have clean install of Vista and Orcas March CTP. Vista automatically downloaded SP2 for SQL services. It does not come with Management Studio however, so I have to download it from web. There is only unupdated version for download, so I downloaded it and installed it. It does not work of course, but when I run the SP2 pack, it wrote me that half of the products are already updated and half of them are not updatable by the pack.
What should I do?
SQL Server SP2 does update the enterprise Management Studio, so I assume you are talking about Management Studio Express.
You should be able to uninstall Management Studio Express and then install Management Studio Express SP2 from this web site: http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en If you've already done that, you can verify that you have Management Studio Express SP2 by starting the application and then looking at the Help > About... dialog. SP2 is version 9.0.3042.
Hope this helps,
Steve
|||As explained you can accomplish as per the explanation above, if you are using ENterprise Management studio then you might try again applying the Service pack2.Saturday, February 25, 2012
Cannot start SQL Server 2005 management express studio CTP?
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
--
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:
> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
> >I downloaded it from the link in
> > http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> > version.
> > And it cannot be run on two machines. Both installed VS 2003.
>
>|||No. SQL Express is RTM. SSME is CTP.
--
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:
>> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
>> --
>> William Stacey [MVP]
>> "nick" <nick@.discussions.microsoft.com> wrote in message
>> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>> >I downloaded it from the link in
>> > http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
>> > version.
>> > And it cannot be run on two machines. Both installed VS 2003.
>>
Cannot start SQL Server 2005 management express studio CTP?
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.
http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.
|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:
> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>
>
|||No. SQL Express is RTM. SSME is CTP.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...[vbcol=seagreen]
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:
Cannot start SQL Server 2005 management express studio CTP?
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:
> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>
>|||No. SQL Express is RTM. SSME is CTP.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...[vbcol=seagreen]
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:
>
Sunday, February 19, 2012
Cannot show requested dialog Error on View Database Permissions
I am having issues with the database permissions on SQL Server Express. I downloaded the SQL Server 2005 Express Edition with Advanced Services SP1 and everytime I try to view database/schema permissions I get an error "Cannot show requested dialog." I have 3 different installs of Sql Express 2005 on different machines and they all throw the same error. The error happens in a couple locations but one way is going databases > select any database > Security > Schemas > Select and right click on a schema > permissions > and click view database permissions, I get the error message below. Does anyone else have this problem?
Thanks
Scott
===================================
Cannot show requested dialog.
===================================
Could not load file or assembly 'file:///c:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlManagerUi.dll' or one of its dependencies. The system cannot find the file specified. (mscorlib)
Program Location:
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoadFrom(String assemblyFile, Evidence securityEvidence, Byte[] hashValue, AssemblyHashAlgorithm hashAlgorithm, Boolean forIntrospection, StackCrawlMark& stackMark)
at System.Reflection.Assembly.LoadFrom(String assemblyFile, Evidence securityEvidence)
at System.Activator.CreateInstanceFrom(String assemblyFile, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo)
at System.Activator.CreateInstanceFrom(String assemblyFile, String typeName, Object[] activationAttributes)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.SqlMgmt.FormLauncher.OnCreateAndShowForm(IServiceProvider serviceProvider, XmlDocument xml)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()
Seems like a managment studio issue. I'm going to move this question to the Tools forum.
Mike
Cannot show requested dialog Error on View Database Permissions
I am having issues with the database permissions on SQL Server Express. I downloaded the SQL Server 2005 Express Edition with Advanced Services SP1 and everytime I try to view database/schema permissions I get an error "Cannot show requested dialog." I have 3 different installs of Sql Express 2005 on different machines and they all throw the same error. The error happens in a couple locations but one way is going databases > select any database > Security > Schemas > Select and right click on a schema > permissions > and click view database permissions, I get the error message below. Does anyone else have this problem?
Thanks
Scott
===================================
Cannot show requested dialog.
===================================
Could not load file or assembly 'file:///c:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlManagerUi.dll' or one of its dependencies. The system cannot find the file specified. (mscorlib)
Program Location:
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoadFrom(String assemblyFile, Evidence securityEvidence, Byte[] hashValue, AssemblyHashAlgorithm hashAlgorithm, Boolean forIntrospection, StackCrawlMark& stackMark)
at System.Reflection.Assembly.LoadFrom(String assemblyFile, Evidence securityEvidence)
at System.Activator.CreateInstanceFrom(String assemblyFile, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo)
at System.Activator.CreateInstanceFrom(String assemblyFile, String typeName, Object[] activationAttributes)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.SqlMgmt.FormLauncher.OnCreateAndShowForm(IServiceProvider serviceProvider, XmlDocument xml)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()
Seems like a managment studio issue. I'm going to move this question to the Tools forum.
Mike
Sunday, February 12, 2012
Cannot run apparently successful installation of SQL Server Express
I have downloaded SQL Server Express and cannot figure how to start it up! SQL Server Management Studio Express CTP does nothing when I try to run it.
No doubt this is a very simple error or series of errors by me, but I would appreciate help.
Many thanks.
Nick
I am assuming you are installed it with default value, where express would be installed as instance sqlexpress.
1. Did you see express in Obj Explorer of MS Express ("<machine-name>\SQLEXPRESS") ? If so you could just right click on that node -> Start.
2. Alternatively, try to start it from command line by:
net start mssql$sqlexpress
|||Many thanks for your help Hungfu. I am trying your solutions which report back that SQLSever Express is running. I suspect my remaining problems are related to the CTP version!Regards
Nick
Cannot run apparently successful installation of SQL Server Express
I have downloaded SQL Server Express and cannot figure how to start it up! SQL Server Management Studio Express CTP does nothing when I try to run it.
No doubt this is a very simple error or series of errors by me, but I would appreciate help.
Many thanks.
Nick
I am assuming you are installed it with default value, where express would be installed as instance sqlexpress.
1. Did you see express in Obj Explorer of MS Express ("<machine-name>\SQLEXPRESS") ? If so you could just right click on that node -> Start.
2. Alternatively, try to start it from command line by:
net start mssql$sqlexpress
|||Many thanks for your help Hungfu. I am trying your solutions which report back that SQLSever Express is running. I suspect my remaining problems are related to the CTP version!
Regards
Nick