Thursday, March 8, 2012

Cannot integrate SQL Server 2005 with Visual Studio 2005

Hi,

I have a question that I hope someone can help me with.

I' have installed VS2005 Beta 2 on my XP machine. I've also installed SQL Server 2005 and uninstalled SQL Express (though the instance still seems to appear even though it no longer works!)

So basically I'm trying to get VS2005 to work with SQL Server 2005. However when I go into solution explorer, I :-

Right click on the project name
Select ADD
NEW ITEM
SQL Database
<name.mdf>
now from what I've seen in online demo's, it should then fire up some connection wizard. Mine just sits there for about 30 seconds and then tells me it's timed out. I then find the .mdf file added to my project is totally useless and hangs for another 30 seconds everytime I select it until I delete the thing.

In server explorer, I type in the name of my server (my PC's name) and the test connection appears to work fine.

Can anyone tell me why this is happening and how I can fix it?

Many thanks in advance

Jocky.

It sounds like you've got some registry badness going on. De-install all SQL Server, following this link:

http://msdn2.microsoft.com/en-us/library/aa337087.aspx

And then reinstall. That should clear it up for you.

Buck Woody

No comments:

Post a Comment