SQL Express 2005 install and removal

[pachjo]

I have rather belately found out that this is the replacement/new version of MSDE.

I not that when I look at add and remove programs I see no entry for SQL Express 2005?

I found the managment tools kit that will help me solve some of the problems I have been having.

Can someone help me with the following please?

How do I uninstall my current version to reinstall from the files I can download from MS?

If I do this will the setup for my current application be stuffed?

Can I use this and dump MSDE?


Thanks

 

[JohnH]

Sql Express is listed as "Microsoft SQL Server 2005" (+ some more entries) in Add/Remove list if installed.

 

[pachjo]

Thanks, I have it all removed and installed.

I can see my corp servers as well as my local sql express server.

I am trying to run a select staement to insert to sql express database from a corp server database.

I guess I gotta create the corp as a linked serevr?

But when I try to do this choosing SQL Server as server type I get this error:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

"The linked server has been created but failed a connection test. Do you want to keep the linked server?"

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

The OLE DB provider "SQLNCLI" for linked server "virtue" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "virtue".
OLE DB provider "SQLNCLI" for linked server "virtue" returned message "Invalid authorization specification". (Microsoft SQL Server, Error: 7399)

For help, click: http://go.microsoft.com/fwlink?Prod...42&EvtSrc=MSSQLServer&EvtID=7399&LinkId=20476


If I try other datasource type I dont know what to enter as the corp server is an Microsoft SQL Server Enterprise Edition one.

Am I not going to be able to connect to it?

I'm totally lost on this one