Difficulty uninstalling Native Client

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.

Try the link below for another option to remove Express from your box , another option is to use System Restore to roll your system back to the point before your first install now I am not sure if your registry utility have removed entries that may not allow the roll back. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/download/advanced/default.aspx|||

hi,

you can try manually "fixing" SQL Native Client installing the last package you can find here.. then you can go on installing SQLExpress with Advanced Services..

regards

|||

I am trying to manually "fix" but I don't know where to go next, hence my post.

I simply want to remove all traces of SQL Server 2005 Express from my machine before I Install the SP2 Advanced version.

I need some real help, not more download options that are not identified.

|||

hi,

I do understand your comprehensible irritation, but often comes you can not completely remove a piece of software.. my advice is to fix the Native Client component, as it often causes problems when installing SQL Server as well..

the provided link i not "not identified" as it is a supported and well known Microsoft link to a Microsoft released package.. it's then up to you..

with kind regards

Different instances of SQL Server

Hi there,

I was wondering if it's possible to create a new instance in the SQL Server something like this:

(Local)\\MSSMLBIZ

(Local)\\BUSINESS

Thank you

yes you can create as Server name \\ instance name where the Server name can be the same.......i have 3 instances where my server name is Deepak\\instance1 similarly instance2 and instnace3

|||

you can have multiple instances on one physical machine. One Defualt instance and all others are called Named Instance. Default instance will have same physical machine name. all other will have Physical machine name \Name of the instance

sql server 2005

sql server 32 bit 64 bit

Instances per computer

50 instances on a stand-alone server for all SQL Server 2005 editions except for Workgroup Edition. Workgroup Edition supports a maximum of 16 instances.

SQL Server 2005 supports 25 instances on a failover cluster.

50 instances on a stand-alone server.

25 instances on a failover cluster

http://technet.microsoft.com/en-us/library/ms143432.aspx

Madhu

|||

Does it apply to SQL Server Express? if yes how do I create (Local)\Myinstance in C#? or if I can't do it in C#, how do I create it manually?

Thank you

|||

Yes. You need to re-run setup to create a new instance of sql server with instance name = "MyInstance". The instance name page is on one of pages in the setup wizard. There is no way to automate creating a new instance with C# with an API like SMO. You can invoke setup with parameters to specify things like instance name, and run setup without user intervention. There is more information in BOL.