VS2008 not working with SQL Server 2008

Question

Hello,

I installed SQL Server 2008 to my computer one day. Before that I had a SQL Server Express. After that Visual Studio won't recognize that I have SQL installed and prompts an error when I'm trying to add a database to my projects.

One way is to make the database from SQL Server and then import it to the project, but this is such a pain. Can anyone give me a working solution to fix this issue???

Link to the image with the error prompted - http://jaxx.pri.ee/error.jpg

Answer 1

Anyone can't help me with this problem???

Answer 2

Hi Evilone,

More clarification with you. What's your OS? What's the edition of your SQL Server Express?

Firstly, SQL Server 2008 support is available in Visual Studio 2008 Service Pack 1. So please upgrade your VS2008 to SP1 if it is not updated.
Please see: http://msdn.microsoft.com/en-us/library/cc440724.aspx#SQL_Serve_08_VS_05_08_top_4

Secondly, please try the workarounds as the following:

- In Visual Studio, go to Tools -> Options -> Database Tools -> Database Connections, fill the SQL Server Instance Name with the name of SQL Server 2008 Express instance.
For similar issue, please check: http://social.msdn.microsoft.com/Forums/en-US/vs2008sp1beta/thread/58f6bace-3024-492e-a21e-483ed761005c
http://forums.asp.net/t/1374059.aspx

- Here is a helpful blog about FAQ of SQL Server and VS2008:
http://blogs.msdn.com/sqlexpress/archive/2008/10/02/faq-error-creating-a-service-based-database-in-visual-studio-2008-sp1.aspx

If you are using Windows 7 RC, please read the following article for your reference:
Visual Studio and SQL Server on Windows 7 RC 

Let me know if it works.

Thanks

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 3

OS is Vista Business 32-bit version. SQL Server is not an express but SQL Server 2008. Visual Studio has SP1 installed. Instance name in the Visual Studio is changed from SQLEXPRESS to SQLSERVER.

I have read also blogs and forums about this issue, but still no help.

Answer 4

Hi Evilone,

Before that I had a SQL Server Express.

I mean what the edition of this SQL Server Express is. :)

Did you install VS2008 >> upgrade to VS2008 SP1 >> install SQL Server 2008?
Could you please try this workaround?
http://forums.asp.net/p/1336563/3135046.aspx#3135046

BTW, this forum is for the support of Visual Studio installation. Since your issue is related to SQL Server, I think the best consulting place should be SQL Server  forums. You can get quick response and more useful help there. :)

Thanks

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 5

Ok, now I uninstalled SQL Server 2008 and installed SQL Server 2008 Express. Changed settings in Visual Studio and got another error which looks like this http://jaxx.pri.ee/error2.jpg

What is the problem now?

Answer 6

Hi Evilone,

I am moving this thread from Base "Visual Studio Setup and Installation" forum to the "SQL Server Setup & Upgrade" forum, since the issue is related to SQL. There are more experts in the "SQL Server Setup & Upgrade" forum.

Thanks

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 7

Ok, but I uninstalled 2008 version and installed 2005 again and it works again...VS2008 and SQL Server 2008 don't really work together.