Difficulty Uninstalling SqlExpress
Apr 30, 2007
Hi,
I installed SqlExpress with Advanced services on to a server running Small Business server 2003.
I needed to uninstall SqlExp, and thought I did so through Add/Remove programs. For some reason it did not seem to uninstall. Foolishly I did not check, and then tried to install another copy in a different directory. I've then ended up with complete mess.
Tried to do another uninstall, but again, ended up with two incomplete versions of express.
Is it possible that part of my problem revolves around the fact I have a mirrored drive with Raid 1 installed.??
Whatever, I need to know how to clean up the mess and start again. Preferably without having to do a format and reinstall SBS.
Tailor
View 1 Replies
ADVERTISEMENT
Jul 1, 2007
I have been running SQL Server 2005 Express (basic) Instance MSSMLBIZ in conjunction with Microsoft Office Accounting 2007 Professional.
I want to make a "clean install" of SQL Server 2005 Express Advanced, SQL Server2005 Express Tools, in order to create additional Reports in Microsoft Office Accounting 2007 Professional.
I ran uininstall on the basic SQL Server 2005 Express, but Native Client did not uninstall; the following message was posted:
"An installation package for the product Microsoft SQL Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'."
I then attempted to install SQL Server 2005 Express Advanced, but it failed to load Native Client. I then uninstalled all instances, deleted the SQL Server Express Files in Programs, and ran "CC Cleaner" to clear the Registry.
I then attempted to uninstall Native Client again, and received the following message:
"This action is only valid for products that are currently installed."
I the returned to CCCleaner Tools to attempt to delete the residuals and received the following message
"Cannot delete msi installer."
I ran "Search - *.msi" and there is no instance of sqlncli.msi visible.
I have Removed Registry Entries for SQL Express,
except HKEY_CLASSES_ROOT instances.
Should I delete these?
Have I forgotten or omitted something??
Please Help.
View 4 Replies
View Related
Mar 13, 2007
I can't start SQLEXPRESS.
The SQL ERRORLOG shows: Error is 3414, Severity 21, State 2 and says: "An error occurred during recovery, preventing the database 'model' (database ID 3) from restarting." Just prior to this, I get a warning: "did not see LP_CKPT_END".
Any thoughts why this might be and how I can fix this?
View 3 Replies
View Related
Sep 21, 2006
hiya,
I have sqlExpress and sqlServerManagementStudio on my XP pro box.
Will the installation of sqlExpress (Advanced Services) cause any problems?IS thereanything that I shold be aware of in advance?
many thanks,
yogi
View 3 Replies
View Related
Jan 19, 2007
Hi All,
I have created an installation application which will install the application with SQL Express and .NET Framework 2.0.
If i install this application in a Fresh system(i.e which is not having SQL Express), it is installing the application with new database instance successfully.
But if i try to install the same in a system which is already having SQL Express, throwing "Object reference exception" because it is not able to create the new database instance.
Can anybody help me out .
Regards,
Doppalapudi.
View 2 Replies
View Related
Mar 21, 2006
Because of numerous problems trying to get sqlexpress working, I uninstalled it with the intention of reinstalling (via Add or Remove Programs). However, now when I try to reinstall it, I get a message that the I am not making a changes so it won't let me install it.
I do have sql server 2005 developer's edition installed; is that the reason? and does that mean I cannot have both installed on the same machine?
View 1 Replies
View Related
Dec 25, 2006
I use this in a new query script in SSMS:
use dbtest1
bcp mycsvtable1 in 'C:myDevSQLCSVprojectmyCSV.txt' -T -c
but i get the error:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'bcp'.
I also tried:
myDatabase.dbo.mycsvtable1 and I got the same error
any help pls?
View 4 Replies
View Related
Jul 14, 2007
I have created a a web application on computer1 and I have now transferred it to computer2. I am trying to attach my database (db1) in VS but I get this error: "Cannot open user default database. Login failed for user: username1". However when I use Management Studio Express I am able to access db1. I'm a newbie on this.
View 3 Replies
View Related
Jan 24, 2008
Hi, I've got two tables. One is a table of metal types:
MetalID | MetalName
--------------------
1 | Gold
2 | Silver
3 | Platnum
The other is a linking table of an object's assigned metals:
ObjectID | MetalID (FK) | Weight
---------------------------------
1 | 1 | 2.00
I'd like to select all metal types, and the weight of any metal that has a matching record for a given object ID. So for ObjectID 1, I want a result set like this:
MetalID | MetalName | Weight
----------------------------
1 | Gold | 2.00
2 | Silver |
3 | Platnum |
I've tried a left outer join on the assigned metals table, but only got the one matching record back. Also if possible, the ideal result would also indicate if it had a match:
MetalID | MetalName | Weight | IsAssigned
-----------------------------------------
1 | Gold | 2.00 | 1
2 | Silver | | 0
3 | Platnum | | 0
Any help is appreciated!
View 3 Replies
View Related
Oct 28, 2005
Hey guys, I am a newbie here, so please bear with me. I have installed SQL Server 2005 CTP on Machine A and MSDE on Machine B. Both these contain the PUBS database beside others. On Machine C, I have installed "ASP.Net Web Matrix" and I want to be able to connect to either Machine A or B to access the PUBS database. It connects to Machine B, when I put in the Servers IP address. But everytime I try to connect to Machine A, it gives me an error saying, "Unable to connect to the database. To connect to this server you must use SQL Server Management Studio or SQL Server Management objects(SMO) ". I heard that connection strings are needed to access the SQL Server 2005 but I have no idea where to begin. Do I need to create special users to access the Server or will Windows authentication work ? Could anyone help me out in connecting to the SQL Server 2005 CTP?
View 15 Replies
View Related
May 25, 2006
I am trying to transfer data into SQL Server from Excel using DTS.
I get error for a particular field:
Data for Source Column 3('Col3') is too large for the specified buffer size.
I gathered from other resources, that this error is due to some record in the excel sheet for which that particular field is too big.
and it reads only the first 8 records to determine a data type.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281517
the fix is to chnage the registry value, as mentioned in the above link. But hat is not an option for me, as that slows down the process a lot.
Does any body else has any other suggestion for this?
I have an idea, that worked, but for that I have to manually insert a record on the top in the excel sheet, with a big size data in that field (which gives problem), and then run DTS, later delete that record.
To automate this idea, I tried to do a DTS from a dummy table (with a record with big data in it) to this excel sheet, but it puts the record at the bottom of the sheet. Is there any way to put this record on the top?
Any help in this regard will be greatly appreciated.
Thanks
Nicky
View 3 Replies
View Related
Dec 11, 2007
We are using a system that has uses four instances. On each client to the server we used the ODBC settings to connect to the different instances. We have since reinstalled the server, and now we are unable to find or 'see' any of the databases, except for locally.
E.g. The first database we install is named Foo, with database Bar. It is set up on port 1433.
The second named instance is Foo2, with database Bar2. It is set up on a dynamic port.
We now try to connect to the database with ODBC. We connect to SERVERFOO, and then select the BAR db. It works fine.
We then try to connect to the database SERVERFoo2, it lets us in, and then all we can select is the BAR db. I don't know what is causing this. We never before had to edit the settings in the client config for the odbc settings (e.g. to set manually to TCP port 1433) and I have checked the sql config manager to ensure that tcpip settings are allowed and will "ListenAll".
What more do we need to do? I think the browser should be installed, but my collegue disagrees.
Any ideas as to why we can only see the database referenced to 1433 port, and why no other port works, when we never had to do that before?
Thanks a bunch in advance,
Regards
Carl
View 2 Replies
View Related
Jun 3, 2007
Hello frdz, I have two tables in sqlserver 2005. I have created the stored procedure for insert,update data.I m creating my application in asp.net with C# Table-1 CUSTOMERFields:customerid int identity,cardid int,customername varchar(20) not null,address varchar(20) not null,city varchar(20) not null,emailid varchar(20) Table-2 CARDFields:cardid int identity,cardtype varchar(20) not null,carddetails varchar(20) not null INSERT INTO CUSTOMER (customername ,address,city,emailid) VALUES (@customername,@address,@city,@emailid) SELECT @customerid = SCOPE_IDENTITY()/* HELP HERE NOT ABLE TO GET DATA OF CARD */ SELECT @cardid = cardid from CARD where customerid =@cardid Pls tell me how to insert the data ...There is only one cardid for only one customerid both should be unique no duplication....One customer can have only one and one card...
View 5 Replies
View Related
Aug 28, 2007
I am trying to create stored procedure i Query analyzer in visual studio 2005. I am havingdifficulty though. Whenever I press the execute button, here is the error message I get:
Msg 102, Level 15, State 1, Procedure MarketCreate, Line 21Incorrect syntax near 'MarketName'.
Here is the stored procedure. Note that the very first column in named "MarketId" but I did notinclude it in the stored procedure since it should be auto generated.
USE [StockWatch]GO/****** Object: StoredProcedure [dbo].[MarketCreate] Script Date: 08/28/2007 15:49:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO
CREATE PROCEDURE [dbo].[MarketCreate]
( @MarketCode nvarchar(20), @MarketName nvarchar(100), @LastUpdateDate nvarchar(2), @MarketDescription nvarchar(100))
ASINSERT INTO Market( MarketCode MarketName LastUpdateDate MarketDescription)VALUES( @MarketCode @MarketName @LastUpdateUser @MarketDescription)
View 2 Replies
View Related
Feb 7, 2005
I created a web form where the user fills in some data and when he submits the form, I do an insert into he database table. The problem is, how can I get the data from the form into the insert statement?. here is the code:
Dim Message As String
Dim connStr As String
Dim myConnection As SqlConnection
Dim mySqlCommand As SqlCommand
connStr = "server=SIMIVSdotNET;Trusted_Connection=yes;database=AeroSea"
myConnection = New SqlConnection(connStr)
mySqlCommand = New SqlCommand("INSERT INTO TravelRequestEntry (CustomerID,Name) Values (1,name.text)", myConnection)
If I execute the above code, then nothing gets updated. When I change the insert staement into the following,
mySqlCommand = New SqlCommand("INSERT INTO TravelRequestEntry (CustomerID,Name) Values (1,'myname')", myConnection) then,
value 1 for customerID field and myname in the namefield is added.
I know I am doing something stupid, but can't figure it out.
I am confused. please help me.
View 2 Replies
View Related
Dec 1, 2005
This is probably a very simple question but i am having problems with inserting information into database
The function takes the values "FirstName" And "LastName" from A table Called "Customer" and the value "ProductID" from a table called "Products" and inserts them into a table called " NewOrder".
Everything compiles ok but when I press the button the information is not uploaded to thedatabase. ( There is no error message)
This is the stored procedure
CREATE PROCEDURE SP_NewOrder(@CartID char (36), @CustomerID Varchar (50))AS
INSERT INTO NewOrder (FirstName, LastName, ProductID)
SELECT Customer.FirstName, Customer.LastName, Products.ProductID
From Customer,Products Join ShoppingCart ON Products.ProductID =ShoppingCart.ProductIDWHERE ShoppingCart.CartID = @CartID AND Customer.CustomerID = @CustomerIDGO
This is the Function
Public Shared Function CreateOrder() AS String Dim customerID As integer Dim connection as New SqlConnection(connectionString) Dim command as New SqlCommand("SP_NewOrder",connection) command.CommandType = CommandType.StoredProcedure command.Parameters.Add("@CartID", SqlDbType.Char,36) command.Parameters("@CartID").Value = shoppingCartID command.Parameters.Add("@CustomerID", SqlDbType.Varchar,36) command.Parameters("@CustomerID").Value = customerID Try
connection.Open() command.ExecuteNonQuery() Finally connection.Close()
End TryEnd Function
This is the page code
Sub btn3_Click(sender As Object, e As EventArgs)Dim cart as New ShoppingCart()Dim shoppingCartID As IntegerDim customerID As Integer = Context.Session("worldshop_CustomerID")cart.CreateOrder()End Sub
Can Anyone see where I am going wrong
Many thanks
martin
View 2 Replies
View Related
Aug 21, 2006
I'm new to SQL Server and I'm using 2005 Express with SSMSE, and having trouble adding a record to a table "manually" by typing in the data.
I find I can change most of the fields by viewing the table in SSMSE and just clicking on the field and editing it then clicking "execute SQL" but for some reason the changes don't "take" when a date field is involved.
Is there a special or proper way to enter a date that I'm not aware of? I'm not having much success figuring out this online help stuff from within SSMSE, I keep getting to help on the help system itself (oops).
TIA!
View 3 Replies
View Related
Aug 27, 2007
I am probably missing something simple here but...
I have a CLR Stored Procedure where I am attempting to execute multiple SQL commands. Here is what happens.
Case One
1. Stored Procedure is invoked.
2. Create SQL Connection.
3. Open the connection.
4. Begin Transaction.
5. Create Command from Connection.
6. Set Command objects Transaction property to transaction created above.
7. Set Command Text Property to SQL Query.
8. Execute Query via ExecuteReader and get SQLReader.
9. Read query result set.
10. Close QueryReader.
11. Set Command Text Property to another SQL Query.
12. Execute Query
This is where I get one of two exceptions.
1. An Exception stating that I cannot have parallel transactions.
or
2. An Exception that I have an open SqlReader that must be closed.
Case Two
1. Stored Procedure is invoked.
2. Create SQL Connection.
3. Open the connection.
4. Begin Transaction.
5. Create Command from Connection.
6. Set Command objects Transaction property to transaction created above.
7. Set Command Text Property to SQL INSERT command.
8. Execute Insert command.
9. Set Command Text Property to SQL Query command.
10. Execute Query Command via ExecuteReader.
At this point the stored procedure appears to hang.
Could someone please enlighten me if I have missed something obvious while reading the manual, regarding what you can and cannot do?
Thanks in advance.
View 2 Replies
View Related
Nov 30, 2006
Panicked, as usual. Who says it's great being a sole proprietor?Using MS-SQLServer:Three tables: A_Appointment, AX_Appointment_Entity and E_Entity.AX_Appointment_Entity is an intersect/association table betweenA_Appointment and E_Entity. One appointment may have many attendees(Appointment_Entity). One attendee (Entity) may have manyappointments.My task is to delete all appointments and relatedAX_Appointment_Entity rows where the number of attendees is one orless.I'm great at standard select or delete queries. Because this straddlestables in a way I'm less skilled in, I'm pleading for help.Thanks for any ideas. fwiw, I'm using Transact-SQL.BLink--------------------------"The worst thing about censorship is [redacted]"
View 6 Replies
View Related
Apr 16, 2007
Dear Experts,I've worked with Oracle since 1995. I have gonevery deep into many of the Oracle features, includingsqlloader, and export/import. And I've done datamodelling even longer.At the same time, I have done ETL since 1995.Although, at the Proc, and PLSQL, sqlloader, level.Map the data. Take data from the source, do anymodifications/transformations that are required,and insert or update. Easy. The hard part isdetermining the mappings.But I have not been given the opportunity towork much with ETL tools such as:Informatica, DataStage, Ascential, Ab InitioThe little bit of experience that I do have,showed that Informatica was -incredibly- easy to use.It's a GUI. It's SUPPOSED to be simple!!!I have missed out on a number of opportunitiesbecause I didn't have a few YEARS of experiencewith ETL tools. Which seems odd, because thetool looks like it requires a max of a week to learn!Just how difficult are these ETL tools to learn?Especially if you have already been working withOracle, and doing data mappings and loads since 1995?I'm thinking that it can't be difficult at all.When you search for newsgroups, there are no newsgroupsfor these tools. Although the companies who makethem, might have their own newsgroup.There are also not many books on these tools.If you search for books on Oracle, or SQL Server,you will find a lot of very big, and detailedbooks. But there is next to nothing specificallyon the various ETL tools.Any certifications for any of these tools lookto be much simpler than Oracle's.To me, the real issue is the mappings. If youcome into a new environment, the data mappingsare completely esoteric to those systems.No amount of experience with an ETL tool, or anytool, is going to tell you what the mappings should be.Questions:- Just how difficult are these ETL tools to learnfor an experience Oracle pro like myself?- Other than a GUI, making everything simple to use,just what are the advantages of using ETL tools?- what built in functionality do ETL toolshave, that can't be done in PLSQL?Thanks a lot!
View 19 Replies
View Related
Jul 7, 2006
I'm developing an application in VB 2005 Express using SQL 2005 Express. I need to put a timestamp into my table each time I create a row...
The following is a snippet...
Dim DDate As [SqlDateTime] = Now()
Dim TheQuery As String = "INSERT INTO Groups (PC_Name_Stamp, OperatorNo, Group_Type, Date_Time) VALUES ('Development', '2', 'Test',' " & DDate & " ')"
Which won't work as I am attempting to concatinate a SqlDateTime into a string.
My best guess is that I need to somehow to use a DEFAULT value in the table that persists so each time a row is created the datetime it was created is saved with the row, rather than being re-calculated each time the table is opened. There are probably several other ways of doing it and this may not be the easiest.
I'm not a programmer, just an Engineer, so I can only read Help for 5 minutes at a time.
View 6 Replies
View Related
May 4, 2006
Hi...
I am new to MS SQL 2000. I need to generate reports using the SQL2000 database and exporting the data to Excel. Currently i started using the DTS services and was fine..But i have constraints that Excel can hold only 65K records..My records can go up to 80K +.Is there a way i can split the sheet depending the number of records..or is there a better way to do this...I do not have reporting services as we r using SQL 2000...Could anyone please help...
If there is any other way of doing this please guide me as to how to go about or any reference websites...
Thanks in advance
Banu
View 12 Replies
View Related
Oct 28, 2007
I have a real installation mess n my hands. I'm attempting to install Sql Server Developer edition on a new Thinkpad with Vista Ultimate. There are no issues with limited resources. This copy of Vista Ultimate came with a trial copy of Office 2007 and SQLExpress was intalled with it. I unistalled SQLExpress being unaware of the Vista Compatibility problems. SQL Developer did not install after I removed SQLE. After researching this on the net, I read that developer could be installed as an upgrade if SQLE is on the system. So Installed SQLE with advanced tools deliberately not installing the tools. That installation went well. So then I tried to reinstall SQL Developer and received a message about having to setup via command line because of an exisiting instance. So I installed Developer with the folowing command line from an MSDN DVD.
E:ENGLISHSQL2005DEVELOPERSQL Server x86Servers>start /wait setup.exe ADDLOC
AL=SQL_Engine INSTANCENAME=MHASQLE UPGRADE=SQL_Engine SKUUPGRADE=1 /qb
I chose the advanced options specifiying that the tools be installed. That installation failed to install the tools and I believe there was an error in the core data engine installation. I received an error message to check the logs but to be honest, there are meagbytes of log files and I don't really know what to check.
The core log looked like this:
Microsoft SQL Server 2005 Setup beginning at Mon Oct 29 11:11:04 2007
Process ID : 4816
E:ENGLISHSQL2005DEVELOPERSQL Server x86Serverssetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/9/29 11:11:3
Complete: LoadResourcesAction at: 2007/9/29 11:11:3, returned true
Running: ParseBootstrapOptionsAction at: 2007/9/29 11:11:3
Loaded DLL:E:ENGLISHSQL2005DEVELOPERSQL Server x86Serversxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/9/29 11:11:4, returned true
Running: ValidateWinNTAction at: 2007/9/29 11:11:4
Complete: ValidateWinNTAction at: 2007/9/29 11:11:4, returned true
Running: ValidateMinOSAction at: 2007/9/29 11:11:4
Complete: ValidateMinOSAction at: 2007/9/29 11:11:4, returned true
Running: PerformSCCAction at: 2007/9/29 11:11:4
Complete: PerformSCCAction at: 2007/9/29 11:11:4, returned true
Running: ActivateLoggingAction at: 2007/9/29 11:11:4
Complete: ActivateLoggingAction at: 2007/9/29 11:11:4, returned true
Running: DetectPatchedBootstrapAction at: 2007/9/29 11:11:4
Complete: DetectPatchedBootstrapAction at: 2007/9/29 11:11:4, returned true
Running: LaunchPatchedBootstrapAction at: 2007/9/29 11:11:4
Error: Action "LaunchPatchedBootstrapAction" threw an exception during execution. Error information reported during run:
"c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1706
Aborting queue processing as nested installer has completed
Message pump returning: 1706
I believe residual office files are throwing the installation off but that could be an erroneous conclusion as the OWC portion always fails with a 1706.
What I need is basic SQL functionality and it's really important that I have the Studio Management Console.
Does anyone have any suggestions as to what log to check toward getting a core data engine installed along with the olls and documentation for SQL Developer?
View 10 Replies
View Related
Feb 17, 2005
I setup the databse and Visual Web Developer to use
stored procedures when the insert command is used. The
database also uses the field UserName that I pass using a
SessionParameter within the InserParameter block from the
Membership.GetUser.Username from the aspnet_ tables.
My difficulty is when using the "Formview" as the body to
with which to insert (I wanted the design versatility of
FormView) I get an error: "system.formatExpression: Input
string was not in a correct format" when I leave the
textboxes empty and invoke the insert command. I first
assumed that the bound textboxes are not being converted
correctly when left blank, so I used the
ConvertEmptyStringToNull=True, with no success. I then
coupled that with the Type=[correct format] still with
the same error. Alas, my final attempt was to set
defaults in the "ALTER PROCEDURE" within the stored
procedure itself.
Any help would be most appreciated. Thanks.
.
View 2 Replies
View Related
Jul 1, 2006
Hi All,I've been struggling with this for hours...Could someone please advise me on how to convert my current File based SQL Server Express website to a Server based SQL Express one.Particularly interested in what I need to do in the SQL Express management tool, changes I need to make the projecvt itself and changes needed to get IIS to understand things have been changed.Thanks,Martin.
View 1 Replies
View Related
Mar 11, 1999
No, I'm not having any problems(yet) with servicepack 5a. However, in order to fine-tune an installation script, I need to install 5a on my test server several times.
So....how do I uninstall it? I was going from sp 3 to 5a. TIA
View 2 Replies
View Related
Mar 31, 2006
I am trying to use this database thing. with visual basic express 2005 but It sais before I have to uninstall all this stuff. what will happen If don't uninstall it. do I have to uninstall it to get this software????
View 1 Replies
View Related
Dec 17, 2003
I'd like to uninstall the MSDE SQL desktop files off my local harddrive, and then re-install. What is the safest way to do this?
Thankx
Chum
View 1 Replies
View Related
May 22, 2001
Hi!
I'm trying to uninstall SQL Server 7.0 going through Add/Remove Program and getting message "sqlserver.exe in use".
All my applications are closed, SQL Server service is stopped and Agent is stopped also.
What else should I check to be able to uninstall it?
Thanks
Lena
View 4 Replies
View Related
Apr 3, 2006
I downloaded the SQLEVAL but did not install it on my computer. It is not something I am going to need to use. Can I just delete the file folders to remove it, or do I have to finish the install, then go through the uninstall process? I would rather avoid the install because it has caused problems for a co-worker and I don't want to run into similar issues.
This may be the silliest question you guys see on the boards, but I would rather look stupid then to do something I shouldn't and screw up my computer.
If you need to know I am running Windows XP with SP2 installed.
Thanks in adavance for your help!
View 2 Replies
View Related
Dec 4, 2007
Hi,
I tried to uninstall SSRS and SQL Server from my machine. I removed it using ADD/REMOVE Program. Now I can not see SQL Server in ADD/REMOVE Program. But Still SSRS is runing in my machine. But I can not initiate SSRS in configuration manager. It says smthing abt WMI error. When I try to install SQL, it says another service is running.
Now I think If I remove SQL and SSRS from my machine smhow, and install it again I can fix this. But now I can not either install it or uninstall it. Can smone please help me?
Thanks
View 4 Replies
View Related
Nov 15, 2005
I am trying to uninstall SQL Server 2005 CTP version before installing Beta version and keep getting an ARP Wrapper Error message that states "Registry Enumeration Failed". I ran Registry Mechanic, etc, but there are no indications of a problem.
View 3 Replies
View Related
Apr 21, 2008
I have to uninstall Sql Express because of a problem that arose after I tried to make a connection from VS2008 Server Explorer to SqlExpress ( connection strings run from C3 code worked fine). I began getting weird errors and the issue has not been resolved after a long thread I ran in this forum.
It turns out there are plenty of dire warnings on the web and MSDN not to do this or that before you tried to uninstall. To tell you the truth I have uninstalled Sql Express in the past quite a few times but every time you fight new challenges and it is difficult to learn from experiecne. I have always done it headlong without considering consequences, eventually this bulldozed approach worked every time but there is a chance that with the .NET getting more complicated this time I may get in trouble.
I am referring to this article on MSDN: before you uninstalled Sql Express:
http://msdn2.microsoft.com/en-us/library/ms143365.aspx
which is awfully unclear. It seems it recommends uninstalling ALL versions of .NET from 2.0 on.
These are versions on my Vista machine:
v1.0.3705, v1.1.4322, v2.0.50727, v3 .0, v3.5
Do I have to uninstall any? I don't think I've done it before.
Now, those .NET versions I listed above are just folders in my WindowsMicrosoft.NETFramework directory. When I try to open Turn Windows features On & Off I can see only .NET 3.0 Framework, nothing else. Not even .NET 3.5!
Also there is this frightening link:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.server&tid=0187b017-4ea2-4b32-aa28-6f6778d6b47b&mid=925c9341-fcc3-4678-ba53-80f30ee7aa28&cat=en_US_671e06d0-f20d-4bb3-9c6a-42c825ddb1dc&lang=en&cr=US&sloc=&p=1
Any comments will be appreciated.
Thanks.
View 3 Replies
View Related
