hi .everyone !
i have ms visual studio 2005 with sql sever 2005 management tools
anyway .. i want to use and install sql server 2000 in this machine .. i tried to install it, but when i tried to connect to the server .. it gives me this error:
"you must use sql server 2005 management tools to connect to this server"
can you help me ? plz !?
no one can help me ?
any suggestion ? help ? :(
I went to one of the Microsoft "Ready To Launch" events over a year ago. Microsoft was gracious and gave everyone who attended a free copy of Visual Studio 2005 and SQL Server 2005. I have installed the Visual Studio and use it all of the time. I also installed the SQL server 2005 but I can not find the application on my computer. After the install the only items that appear to have been installed are the following:
SQL Server Configuration tools(SQL Server Configuration manager,SQL Server Error and usage reporting, SQL Server surface area confiuration, Reporting Services configuration). There is also a menu icon labeled "Microsoft SQL server upgrade advisor" and SQL server upgraded wizard.
That is all. I can't find anything that is analogus to the Enterprise manager that was in SQL server 2000 or anything that is analogous to Query Analyzer of 2005.
Can someone help me out? We use SQL server 2005 so I know how it looks. I just can't see where it insalled. I don't think it did?
Hi;
It seems that u only installed SQL server you could check it from your services..
Anyway; you could install SQL server management studio fromwww.microsoft.com
But even without installing studio with the current configuration u could reach your DB from VS2005 but sure gotta check your services..
|||
Check the below link to download the SQL server 2005 studio management
Studio Management.
HC
I'm trying to open an Reporting Services project in Sql Server Business Intelligence Development Studio (which looks a lot like Visual Studio 2005). This project was copied from another computer where it runs normally. I get the following error when trying to open it...
Package Load Failure
Package 'DataWarehouse VSIntegration layer' has failed t load peoperly (guid = etc..). Please contact package vendor for assistance. Application restart is recommended, due to possible enfvironment corruption. Would you like to disable loadinug for this package in the future? you may use 'devenv /resetskippkgs' to re-enable package loading.
I also tried to create a new Reporting services project and I got the following error....
Could not load file or assembly 'Microsoft.ReportingServices.Designer, Version=9.0.242.0...blah blah.
Some of my research so far says the first message could be related to having ran a beta version of vs2005 on this system which I did. However the ordinary vs2005 asp.net project appear to run normally.
How can I fix this problem?
Thanks,
Gary
First thing would be for me trying to reinstall the Reporting Services package. If that doen not help, reinstall VS and the reporting package with prior removing all related stuff from the server. if you had beta products from VS / SQL Server installed use the cleanup utility from Microsoft. That often helps more than getting the old installation to work properly.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||"cleanup utility from Microsoft" ? What is that? How would I get it?
Thanks,
Gary
|||http://support.microsoft.com/default.aspx?scid=kb;en-us;290301-Jens.|||
Found it. Ran it. found install of beta vs2005 version and ran it on that. Didn't make any difference. Still have same error.
|||I had the same error messages (wouldn't let me open an existing BI project or create a new one). I spent at least 4 hours struggling with this and various other posts on this issue. I found it strange that microsoft's forums are full will this question but there is no official solution from them on this issue. I wish they published a knowledgebase article on this that took care of the issue for once and for all.
Anyway! What worked for me is that I installed Microsoft SqlServer Express client tools. I already had SqlServer 2005 (client tools) , Sqlserver 2005 express (database only), and Visual Studio 2005 professional installed. The order I had initially installed was that I had first installed VS.Net 2003, then installed SqlServer 2005 (client tools), then Visual Studio 2005, and inally SqlServer 2005 Express (database only). Somewhere in between I had installed the reporting services, however I don't remember exactly the sequence for this. To make the matter wors, I had installed some of these on D drive (to save on C space), as many of the posters have reported that this can also cause the issue.
Its unlikely that you may have the same problem as I, but just in case!
I'm trying to open an Reporting Services project in Sql Server Business Intelligence Development Studio (which looks a lot like Visual Studio 2005). This project was copied from another computer where it runs normally. I get the following error when trying to open it...
Package Load Failure
Package 'DataWarehouse VSIntegration layer' has failed t load peoperly (guid = etc..). Please contact package vendor for assistance. Application restart is recommended, due to possible enfvironment corruption. Would you like to disable loadinug for this package in the future? you may use 'devenv /resetskippkgs' to re-enable package loading.
I also tried to create a new Reporting services project and I got the following error....
Could not load file or assembly 'Microsoft.ReportingServices.Designer, Version=9.0.242.0...blah blah.
Some of my research so far says the first message could be related to having ran a beta version of vs2005 on this system which I did. However the ordinary vs2005 asp.net project appear to run normally.
How can I fix this problem?
Thanks,
Gary
First thing would be for me trying to reinstall the Reporting Services package. If that doen not help, reinstall VS and the reporting package with prior removing all related stuff from the server. if you had beta products from VS / SQL Server installed use the cleanup utility from Microsoft. That often helps more than getting the old installation to work properly.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||"cleanup utility from Microsoft" ? What is that? How would I get it?
Thanks,
Gary
|||http://support.microsoft.com/default.aspx?scid=kb;en-us;290301-Jens.|||
Found it. Ran it. found install of beta vs2005 version and ran it on that. Didn't make any difference. Still have same error.
|||I had the same error messages (wouldn't let me open an existing BI project or create a new one). I spent at least 4 hours struggling with this and various other posts on this issue. I found it strange that microsoft's forums are full will this question but there is no official solution from them on this issue. I wish they published a knowledgebase article on this that took care of the issue for once and for all.
Anyway! What worked for me is that I installed Microsoft SqlServer Express client tools. I already had SqlServer 2005 (client tools) , Sqlserver 2005 express (database only), and Visual Studio 2005 professional installed. The order I had initially installed was that I had first installed VS.Net 2003, then installed SqlServer 2005 (client tools), then Visual Studio 2005, and inally SqlServer 2005 Express (database only). Somewhere in between I had installed the reporting services, however I don't remember exactly the sequence for this. To make the matter wors, I had installed some of these on D drive (to save on C space), as many of the posters have reported that this can also cause the issue.
Its unlikely that you may have the same problem as I, but just in case!
I can create and edit DTSX packages in Visual Studio 2005, but I can't execute them because the start button is grayed out. Can someone help?
I am able to run them using the execution utility, but that's a hassle.
Kathy
Are you editing the packages stand-alone or are they part of a project/solution? You can only execute them if they are in a project.
-Jamie
I have a .rdl file which I opened in visual studio 2005. I answered Yes to the prompt Microsoft Report Designer. . . Do you want to convert this file? [Yes] Then I saved the file.
The issue is when I am in Visual Studio and click on the Preview tab, I get the following error:
[rsErrorLoadingCodeModule] Error while loading code module: ‘x.ReportDefinitionsHelper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'AdvancedMD.Report.ReportDefinitionsHelper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
There was a <CodeModule> which existed prior to the conversion and the preview worked fine.
I tried to re-add the reference by clicking on the Layout tab then go to the report properties tab. Then, under references I clicked on the collection and browsed to the file which I wanted to reference and clicked ok, but I still get the error above when I click on the Preview tab. I tried to remove the reference save then come back in and add it again, but it still gives the error above.
The file I am trying to add to <CodeModule> (x.ReportDefinitionsHelper) references the following:
System
System.Data
System.Xml
Any help would be greatly appreciated.
Thanks
(I can load the .rdl to reporting services 2005 and go into Reporting Services Manager and view the report without any issues.)
I just had to move the file I was referenceing to the following location:
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
|||This solved the problem for me too. I have part of the VS2005 installed on my D: drive instead of the C: drive. But regardless of this I think it is strange that we have to put our own dll's in the MS directories. I would like to have them in my own project files. I think it is a bug since the VS2005 has a project structure, and it seems this does not fit in.|||I had the same problem and however I have installed VS2005 in C: so that isn't the problem... the solution for me, as for TMK and Jelle, has been to put my dll in:
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
What i would like to know is the reason because of we have to put our dlls in that directory if in our references we specified another directory...
Can anyone explain it to us?
I have a .rdl file which I opened in visual studio 2005. I answered Yes to the prompt Microsoft Report Designer. . . Do you want to convert this file? [Yes] Then I saved the file.
The issue is when I am in Visual Studio and click on the Preview tab, I get the following error:
[rsErrorLoadingCodeModule] Error while loading code module: ‘x.ReportDefinitionsHelper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'AdvancedMD.Report.ReportDefinitionsHelper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
There was a <CodeModule> which existed prior to the conversion and the preview worked fine.
I tried to re-add the reference by clicking on the Layout tab then go to the report properties tab. Then, under references I clicked on the collection and browsed to the file which I wanted to reference and clicked ok, but I still get the error above when I click on the Preview tab. I tried to remove the reference save then come back in and add it again, but it still gives the error above.
The file I am trying to add to <CodeModule> (x.ReportDefinitionsHelper) references the following:
System
System.Data
System.Xml
Any help would be greatly appreciated.
Thanks
(I can load the .rdl to reporting services 2005 and go into Reporting Services Manager and view the report without any issues.)
I just had to move the file I was referenceing to the following location:
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
|||This solved the problem for me too. I have part of the VS2005 installed on my D: drive instead of the C: drive. But regardless of this I think it is strange that we have to put our own dll's in the MS directories. I would like to have them in my own project files. I think it is a bug since the VS2005 has a project structure, and it seems this does not fit in.|||I had the same problem and however I have installed VS2005 in C: so that isn't the problem... the solution for me, as for TMK and Jelle, has been to put my dll in:
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
What i would like to know is the reason because of we have to put our dlls in that directory if in our references we specified another directory...
Can anyone explain it to us?
Hi,
I've installed visual studio 2005 and sql server express and downloaded SSMSEE, but can't open it, I can still only see SQL server configuration manager. Any help would be greatly appreciated.
Thanks,
Chris
hi Chris,
did you install SSMSE as well?
regards
Hi,
I've installed visual studio 2005 and sql server express and downloaded SSMSEE, but can't open it, I can still only see SQL server configuration manager. Any help would be greatly appreciated.
Thanks,
Chris
hi Chris,
did you install SSMSE as well?
regards
when i installed visual web developer and sql management studio,i try to use sql management studio to connect to sql 2005 express,but a error ocurred.here is the error message.
TITLE: Connect to Server
----------
Cannot connect to DH\SQLEXPRESS.
----------
ADDITIONAL INFORMATION:
The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. (System.Data)
----------
The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception. (System.Data)
----------
The type initializer for 'System.Data.SqlClient.SqlPerformanceCounters' threw an exception. (System.Data)
----------
Configuration system failed to initialize (System.Configuration)
----------
Unrecognized configuration section system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Config\machine.config line 136) (System.Configuration)
and i wonder if anybody has experienced this error can tell me how to solve?
Can you post what in line 136 of your machine.config file?
|||the following is the part of machine.config
line 136<system.serviceModel>
<extensions>
<behaviorExtensions>
<add name="persistenceProvider" type="System.ServiceModel.Configuration.PersistenceProviderElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="workflowRuntime" type="System.ServiceModel.Configuration.WorkflowRuntimeElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="enableWebScript" type="System.ServiceModel.Configuration.WebScriptEnablingElement, System.ServiceModel.Web, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="webHttp" type="System.ServiceModel.Configuration.WebHttpElement, System.ServiceModel.Web, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="Microsoft.VisualStudio.Diagnostics.ServiceModelSink.Behavior" type="Microsoft.VisualStudio.Diagnostics.ServiceModelSink.Behavior, Microsoft.VisualStudio.Diagnostics.ServiceModelSink, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/></behaviorExtensions>
<bindingElementExtensions>
<add name="webMessageEncoding" type="System.ServiceModel.Configuration.WebMessageEncodingElement, System.ServiceModel.Web, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="context" type="System.ServiceModel.Configuration.ContextBindingElementExtensionElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</bindingElementExtensions>
<bindingExtensions>
<add name="wsHttpContextBinding" type="System.ServiceModel.Configuration.WSHttpContextBindingCollectionElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="netTcpContextBinding" type="System.ServiceModel.Configuration.NetTcpContextBindingCollectionElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="webHttpBinding" type="System.ServiceModel.Configuration.WebHttpBindingCollectionElement, System.ServiceModel.Web, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="basicHttpContextBinding" type="System.ServiceModel.Configuration.BasicHttpContextBindingCollectionElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</bindingExtensions>
</extensions>
<client>
<metadata>
<policyImporters>
<extension type="System.ServiceModel.Channels.ContextBindingElementImporter, system.workflowservices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL"/>
</policyImporters>
<wsdlImporters>
<extension type="System.ServiceModel.Channels.ContextBindingElementImporter, system.workflowservices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL"/>
</wsdlImporters>
</metadata>
</client>
<commonBehaviors><endpointBehaviors><Microsoft.VisualStudio.Diagnostics.ServiceModelSink.Behavior/></endpointBehaviors><serviceBehaviors><Microsoft.VisualStudio.Diagnostics.ServiceModelSink.Behavior/></serviceBehaviors></commonBehaviors></system.serviceModel>]
it's no problem.it guess it may be the problem of FrameWork.because when i try to conncet by visual web developer,an error occur.it says Request .net data provider,you may not install.but as we know the .net FrameWork contains the .net data provider. and the visual web developer 2008 beta2 contains .Net Framework 3.5,So i really don't understand.
|||Hi chance1,
After having consulted some of my collegues, it seems that your web.config file is somewhat corrupted.
The section "system.serviceModel" should be registered like the following (mine is from a 3.0 machine). <sectionGroup name="system.serviceModel" type="System.ServiceModel.Configuration.ServiceModelSectionGroup, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> <section name="behaviors" type="System.ServiceModel.Configuration.BehaviorsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <section name="bindings" type="System.ServiceModel.Configuration.BindingsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <section name="client" type="System.ServiceModel.Configuration.ClientSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <section name="comContracts" type="System.ServiceModel.Configuration.ComContractsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <section name="commonBehaviors" type="System.ServiceModel.Configuration.CommonBehaviorsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowDefinition="MachineOnly" allowExeDefinition="MachineOnly" /> <section name="diagnostics" type="System.ServiceModel.Configuration.DiagnosticSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <section name="extensions" type="System.ServiceModel.Configuration.ExtensionsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <section name="machineSettings" type="System.ServiceModel.Configuration.MachineSettingsSection, SMDiagnostics, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowDefinition="MachineOnly" allowExeDefinition="MachineOnly" /> <section name="serviceHostingEnvironment" type="System.ServiceModel.Configuration.ServiceHostingEnvironmentSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <section name="services" type="System.ServiceModel.Configuration.ServicesSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /></sectionGroup>
I would suggest you to install the same .Net Framework 3.5 on another machine and copied the "machine.config" from the good machine to the machine in question.See if this will work. Please feel free to let me know if you have any further questions. thanks.
|||
thank you Bo Chen .and i did what you suggest in a few days ago.but sadlly, it doesn't work. and later i reinstall xp and vs 2005. and the sql 2005 express works.later i try to install visual web developer express 2008.this time visual web developer 2008 can connect and use the sql 2005 express. but vs 2005 can't work now
.but thank you for the people who have helped me.
Hi ,
This problem might occur sometimes due to corrupt installation of sql server 2005. I was also facing the same problem.Uninstall Sql Server 2005 and reinstall it with a different instance(named). Dont try to install with the same instance which u had used previously.Try this and tell me if this works
Thanks & Regards
Keerti Somasundaram
|||
thank you.but before i install sql server 2005,i have reinstall windows xp.and there is no sql 2005 in it. and i think it may be theproblem of visual web developer2008 beta 2.
whenever i try to install SQL server EE, it is telling me that it has
found beta components. but i don't have any beta versions of SQL. I
tried uninstalling my Vb 6.0 thinking its causing the error, but same
thing happened.
The next thing I did is I uninstall my .net 2.0 and when i try to
install VB or VW 2005, i got to the step where it is trying to download
the .net framework 2.0 but it is taking so long. Question: is the
dotnetfix.exe which installed .net 2.0, different from the .net 2.0
that the setup.exe of VB2005 will download? if yes, may i know if there
is a direct site where i can manually download and install it so the
VB2005 will just skip that part and go on with the installation?
When i downloaded the exe files for SQL, .net 2.0, VB and VW, i did
select the SAVE option and saved them on my external mini hard drive so
I can install it at home. Does that make any difference? could that
cause the error?
pretty clear that i am a newbie with this stuff and i never thought
that it would be this hassle to install them heheheh any help, in a
detailed way if possible, would highly be appreciated.
thanks so much!
mannypine (mrehpine@.gmail.com) writes:
Quote:
Originally Posted by
hi! i just joined this group today after a colleague told me about it.
anyway, i'm new to SQL and haven't tried installing any version of it.
I do have vb 6.0 though on my pc. My problem is that I can't install
SQL server 05 EE, VB 2005 or VW 2005. I have downloaded all of the
installer from the Microsoft site as well as the dotnetfix which is
supposed to install the .net framework 2.0.
Quote:
Originally Posted by
The next thing I did is I uninstall my .net 2.0 and when i try to
install VB or VW 2005, i got to the step where it is trying to download
the .net framework 2.0 but it is taking so long. Question: is the
dotnetfix.exe which installed .net 2.0, different from the .net 2.0
that the setup.exe of VB2005 will download? if yes, may i know if there
is a direct site where i can manually download and install it so the
VB2005 will just skip that part and go on with the installation?
Did you ever install a beta of Visual Studio 2005? Apparently you did
install the beta of something since you get the message. And that would be
a beta of SQL 2005, .Net Fx or VS 2005.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||hi erland. Sorry for that one, i meant Express Edition (EE). Im sure I
did not install any beta versions of any kind for this matter as I just
have reformatted my hard drive cuz i upgraded my motherboard just 3
nights ago. also, I checked my .net 2.0 folder and yes, i do have the
v2.0.50727 directory. btw, im not sure if it will help, i have winxp
sp2.
Erland Sommarskog wrote:
Quote:
Originally Posted by
pine (mrehpine@.gmail.com) writes:
Quote:
Originally Posted by
hi! i just joined this group today after a colleague told me about it.
anyway, i'm new to SQL and haven't tried installing any version of it.
I do have vb 6.0 though on my pc. My problem is that I can't install
SQL server 05 EE, VB 2005 or VW 2005. I have downloaded all of the
installer from the Microsoft site as well as the dotnetfix which is
supposed to install the .net framework 2.0.
Quote:
Originally Posted by
The next thing I did is I uninstall my .net 2.0 and when i try to
install VB or VW 2005, i got to the step where it is trying to download
the .net framework 2.0 but it is taking so long. Question: is the
dotnetfix.exe which installed .net 2.0, different from the .net 2.0
that the setup.exe of VB2005 will download? if yes, may i know if there
is a direct site where i can manually download and install it so the
VB2005 will just skip that part and go on with the installation?
Quote:
Originally Posted by
hi erland. Sorry for that one, i meant Express Edition (EE). Im sure I
did not install any beta versions of any kind for this matter as I just
have reformatted my hard drive cuz i upgraded my motherboard just 3
nights ago. also, I checked my .net 2.0 folder and yes, i do have the
v2.0.50727 directory. btw, im not sure if it will help, i have winxp
sp2.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
C:\Program Files\Microsoft SQL Server\MSSQL\Binn
includes some exe files and I have tried to start them, but nothing
appears to happen. If I start sqlsrvr.exe I get a command prompt window
in which I see things like "Server Process ID is 182", "Logging SQL
server messages in file..." etc, but I have no idea how to go on from
there.
I tried installing the new 2005 Beta version but exactly the same
problem.
Why is this happening? How can I make it work?
Thanks in advance.
Bruno PanettaPS the installation probably doesn't even complete. The installation
window just disappears at some point, without saying that it completed
successfully.
Bruno Panetta wrote:
> I have tried to install MSDE 2000, first the normal version, then the
> one for developers using Visual Studio .NET. Each time the installation
> appears to complete, but there is no shortcut to start the program and
> it's not in the Start/Programs menu. However, if I look for it in "Add
> and Remove Programs" it's there.
> The directory
> C:\Program Files\Microsoft SQL Server\MSSQL\Binn
> includes some exe files and I have tried to start them, but nothing
> appears to happen. If I start sqlsrvr.exe I get a command prompt window
> in which I see things like "Server Process ID is 182", "Logging SQL
> server messages in file..." etc, but I have no idea how to go on from
> there.
> I tried installing the new 2005 Beta version but exactly the same
> problem.
> Why is this happening? How can I make it work?
> Thanks in advance.
> Bruno Panetta|||There is no UI tool for MSDE. MSDE is a database engine that can be
manipulated programmatically via the various APIs, using the OSQL command
line utility or using any of various third party utilities.
SQL 2005 Express (the product that replaces MSDE) does have a UI called
Express Manager but it's a separate download to the database engine product.
http://lab.msdn.microsoft.com/express/sql/
--
David Portas
SQL Server MVP
--|||Thanks but I'm afraid I don't understand since I'm a beginner to SQL
and am trying to install this program in order to learn it.
What should I do once I have installed MSDE 2000 in order to start
creating databases and running SQL queries?
Thank you very much.
Bruno
David Portas wrote:
> There is no UI tool for MSDE. MSDE is a database engine that can be
> manipulated programmatically via the various APIs, using the OSQL command
> line utility or using any of various third party utilities.
> SQL 2005 Express (the product that replaces MSDE) does have a UI called
> Express Manager but it's a separate download to the database engine product.
> http://lab.msdn.microsoft.com/express/sql/
> --
> David Portas
> SQL Server MVP
> --|||http://www.aspfaq.com/show.asp?id=2442
--
David Portas
SQL Server MVP
--
I'm using the disk that came with my Visual Web Developer for Dummies book. It installed on my XP Home machine, but when installing on my XP Pro machine, the fourth step, SQL Server Express, it fails. I cleaned up my hard drive (about ten gigs of free space), I followed the steps herehttp://msdn.microsoft.com/vstudio/support/readme/default.aspx to uninstall everything dot net related. Rebooted, checked my control panel, etc. Tried to install. It just fails. No error message.
Can anyone give me an idea of where to start?
Thanks
Try to install the version on msdn rather then on the CD and see if it works. Here is the link for the download.
http://msdn.microsoft.com/vstudio/express/sql/download/default.aspx
|||Ha ha ha. Never quit.
Banging my head against the wall, or trying to get this thing to work?
I was thinking about my gov't issued perpetual virus scan, and thought I'd disable it. And then some time ago I had to do something (that never worked) regarding permissions to the INETPUB folder. And another source also suggested a direct download. Which is what I'll try next. I think I'll try it first in the 'repair' mode if it's available (as it is on the disk - it recognizes that the first three options installed properly and offers up the fourth).
|||Success!
I had already disabled the virus scan, and so don't know if that had anything to do with it. But the download of just the SQL Server says it was successful. My dot net 2.0 framework was detected (it must be installed first), and it sailed thru like it should have in the first place.
As I think I mentioned in my first post, installation on my other laptop (wife's) with XP Home went perfect from the disk. A little weird that my old standby wouldn't work with it, but I'll accept it. And get started with what appears to be some very cool stuff.
|||I came across an issue on installing. When operating from the disk in the Visual Web Developer for Dummies book, the SQL Server just failed. No messages. When downloading from MicroSoft, I got a message that the c:\program files\microsoft sql server folder couldn't be compressed. So, while that message was up, I went thru explorer to change the properties of it. More than a few times, exe and dll files came up that were in use and couldn't be uncompressed. I finally hit the ignore all button and hoped for the best. When it was finished, I went back to the installation routine and hit continue. And it appears to have worked.hello sir/madam
i have been installed Visual web developer 2005 express edition. with that i have been installed .net framework 2.0 and SQL server 2005. Even then i can't enabled with the reporting services. i am doing my final year projects now. i am in the conclution stage. so i hav to design reports.But without enabling with reporting services nothing i can do...
Wht will be the problem
Have a look athttp://www.microsoft.com/technet/prodtechnol/sql/2005/usingssrswithsqlexpress.mspx
If you cannot get enough information from the Technet note, please reply, and I will have a look tonight (once I can connect from my lodgings ~ 18:00 UTC)
|||Did you get IIS working and confim that it was working, before you installed SQL Express and SQL Reporting Services?
