Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 VS2008 and SQL Server problem

Author  Topic 

rjolly1971
Starting Member

3 Posts

Posted - 2008-12-17 : 22:07:52
I wanted to get feedback from the SQL Server community before I decided to begin any work. Currently our production server uses MS SQL Server 2005 and currently I am in the process of developing a new DB solution which will also incorporate asp.net on my local machine. Unfortunately however I am running into a number of problems. I currently have MS SQL Server 2005 Developers Edition on my local and I have been having difficulty getting VS 2008 to connect to the instance. For the life of me, I cannot understand the problem. I either get an error stating that the instance is locked by more than one user or when I try to import a New solution I receive an error that SQL Server 2005 Express is not installed. Therefore my questions are:
1) Why would this be occurring if I already have SQL Server Dev Edition installed?
2) If I decided to uninstall SQL Server 2005 Dev Edition and install SQL Server 2008 express, should I anticipate production issues down the line due to our production environment?

My preferred option is to keep SQL Server 2005 Dev Edition since I use BI studio for another project however I am really running out of patience. If I could please get suggestions to resolve this issue, I would greatly appreciate it.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-17 : 23:13:40
Please post the exact error messages so that we can help you with your problem.

Do not install 2008 if you plan to use 2005 in production.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -