SQL Server 2008 management tool and MSXML6 sp2 question

I would like to install the management tool on my WinXP SP3 machine.
When almost went through all processes, some error happened. And I checked it's because of the MSXML6 SP2. I need to uninstall the MSXML6, but just can't remove it from the Add/Remove program. I tried to reinsatll the MSXML6
but it said a newer version is already there.
How do I solve this problem?
Thanks for help.

More Related Resource Links

I've posted my problem in a few other categories. Sorry for that. I didn't see the security category until now.

I'm trying to use ASP.NET's built-in role/user management for a couple ASP.NET MVC 2 sites. I'm using the MVCMusicStore as my guide. I click on the Configuration Tool as the tutorial suggests, which launches the site administration page. Unfortunately when I click on the security tab, I get an error that it cannot connect to the data store. Attempting to test the AspNetSqlProvider gives me a similar error.

I've run the aspnet_regsql program as the error message suggested, and I have a role/user management database ready to go on the server. The proper tables are constructed, and all that. The configuration tool still doesn't see the data store.

As a test, I ran the MVCMusicStore demo in the debugger. Its role/user management functionality worked. I was able to add myself as a customer, and add/remove items from my cart with no errors or exceptions. However, when I attempted to access its security tab in the configuration tool, I received the same error as I get for my own project. How is it possible that role/user management works, but the configuration tool cannot change its settings?

-----------------------------Cannot
connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific
error occurred while establishing a connection to SQL Server. The server
was not found or was not accessible. Verify that the instance name is
correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified)----------------------------

I'm a bit new to installing and configuring, well, just about anything regarding databases, so please bear with me.
I'm currently building a couple of ASP.NET MVC 2 sites. I'm following along with the MVCMusicStore tutorial, and am trying to set up user management using ASP.NET's configuration tool. The problem is that ASP.NET can't 'see' the database.
I have SQL Server 2008 installed on my laptop. It's the version which is available on the Web Platform Installer (I believe it's Express). When I try running the aspnet_sqlreg.exe program to set up my user management database, it can't tell that
I'm running any version of SQL Server at all. I get an exception about 'named pipes', and some other things I don't understand at the moment.
Obviously, this is all a bit over my head. Is there an idiot proof guide or tutorial available that describes, step-by-step, how to:
1. Install SQL Server 2008 on a development PC
2. How to configure it to be used by Visual Studio 2010 Professional
3. How to properly upload/modify the db on the production server with what's on the development PC
Essentially, all the things that the ASP.NET tutorials gloss over. Any suggestions, links to documentation, or other nudges in the right direction would be immensely appreciated.

Been around SQL Server since 7.0 days.
In SQL Server 2008 Management Studio I don't seem to be able to display Created Date for Views. I can't really believe MS have taken this away so hence my Q.
I find it useful to see Created Data to script my recently developed View and other objects.
Robert, Edinburgh
Bob as MCSD.NET 2003

how do I uninstall "Management Tools - Basic in SQL Server 2008 R2? The regular remove program does not have this option highlighted. I am trying use some of the advance option and learn something more and now ssms is useless.
the discovery report tells me these are installed but I have no way of uninstalling. . I want to replace this with my developer edition that I purchased but have lots of trouble installing because of the express version. Please help.
I'd really appreciate it. "
Sql Server 2008
Management Tools - Basic
1033
Express Edition
10.50.1092.20
No
Sql Server 2008
Client Tools Connectivity
1033
Express Edition
10.1.2531.0
No
Sql Server 2008
Client Tools Backwards Compatibility
1033
Express Edition
10.1.2531.0
No
Sql Server 2008
Client Tools SDK
1033
Express Edition
10.1.2531.0
No
"

Sql 2008 r2 data sync, does it involve a db hosted by microsoft or does that involve us hosting the sync functionality locally? I know we have db's local that need to be sync'd across a wan but does that happen in a db hosted in the ms cloud or does
that have to do with a sync functionality that runs locally to keep my db's sync'd?
Thanks,
SL

I am using SQL Server 2008 (10.0.1600), now came across an issue to display Summary Windows but unfortunately found that F7 (Keyboard shortcut to display summary window)
is not working and even Summary windows is not available in View Menu of SQL Server Management Studio. Maybe it’s a minor issue but I failed to find solution.
Thanks (in advance) for the help.

Hi ,
i have install a application that use sql server express 2005 on a server with OS windows server 2008 r2.
My question is how to make automatic backup of my database , because i cant install
SQL Server 2005
Management Console on my server .
Please help me
Thanks

Hello,
I've got problems when I run a Query to a grid result using SQL server management studio 2008 under W7 pro. When I execute the query, the first part of the grid returns, but then it freezes. The query should present a double resultset and contains approx
6100 records, devided over 2 grids. Strange enough, the query runs fine when I export to TXT or to a file. It seems though that the problem is building the grid. When it occurs I cannot end the application bij shutting down de SSMS window, but have
to kill the Ssms.exe. In task manager I see only 25% CPU usage and approx 20% memory usage. Nothing exiting there I guess.
Suggestions anybody?
Microsoft SQL Server Management Studio 10.0.2531.0
Microsoft Analysis Services Client Tools 10.0.3798.0
Microsoft Data Access Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.7600.16385
Microsoft .NET Framework 2.0.50727.4952
Operating System 6.0.6001
regards,
Pim

Hello,I am new to this developing on this platform and having problems at work and home but different problems. At work when i try and view the aspx page it says unable to connect to the asp.net development server and also can't add the database to the app_data folder. Are there problems with visual studio 2008 /Sql server 2008?set up at work is belowL-06914 serverMicrosoft SQL Server Enterprise EditionMicrosoft Windows NT 5.1 (2600)At home, I was making a connection and almost bringing up the page but had an error the next day could not connect inside of sql server 2008. At home it is the same except for standard version server is my computer name Let me know if more information is needed. Thanks, SB

Hello,
I have been trying to figure out this problem for a while now so hopefully someone can help me out - I would really appreciate it!
Right now I have SQl Server Management Studio2005 installed on my computer for a SQL sever that we have. We recently got a 2008 sql server and if I remotely access the server, I can see that SQL Management Studio 2008 has been isntalled on the new server.
I need to build new databases but need SQL Management Studio 2008 on my computer and I have no idea how to get it.
I have a "Microsoft SQl Server 2008 R2" folder on my computer, and I have already tried clicking on "Configuration Tools" and then "SQL Server Installation center" and it isntalls a bunch of things, but none of them are "SQL Server Management Studio
2008." I also found a link on a Microsoft website that says it's SQL Server Management studio 2008 R2 but it was just the same bunch of programs I already downloaded.
How do I install Sql Server Managment Studio 2008 on my computer?!
Thanks in advance for any help you can provide.

When logging into SSMS 2008 to a SQL2008 database when I expand the tables in a database I only see a few tables listed.ÃÂ I can login to the same instance with SSMS 2005 and all of the tables are there.ÃÂ Is there a reason why this is this way?

I can do a select * from in a query window for any of the tables in the database via SSMS 2008 as well and it work fine.ÃÂ It just does not display the tables.