Friday, May 16, 2008

New VS 8.0 Pro and SQL Server 2005 DVDs in!

First of all, my apologies. Normally, I am writing to document any new information or knowledge that gained while developing this Cost Recovery database application. In this case, I am noting the receipt and installation on Visual Studio 8.0 Professional and SQL Server 2005 Developer edition!
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:

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)

I will work this out. At the moment, I will install the Visual Studio 8.0 pro... Wish me luck!

Footnote:

I fixed the error. It is in this post.

No comments: