I just installed SQL Server 2005 Developer. I uninstalled the Express version first. I don't know per se if that was the best method, but I did have to install IIS before installing the developer edition. I will note how to install IIS in the next posting.
The one problem I am running into is that all the SQL scripts I wrote under Express are in the Express folder of SQL Server Management Studio where the new version is in a separate folder. That is, all the old scripts are there (whew! At first, I thought it had erased all my scripts.) but in the Express folder, not the now default SQL Management project folder.
The other problem now is my Cost Recovery application now gives errors after compiling:
I will work this out. At the moment, I will install the Visual Studio 8.0 pro... Wish me luck!Server Error in '/CostRecovery' Application.
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified)
Footnote:
I fixed the error. It is in this post.

No comments:
Post a Comment