I uninstalled the Beta2 version per the install instructions with the release edition. I have been taking the online learning up to lesson 08 in which we start doing something with sql2005. I cannot make a database in visual studio 2005 because it will not connect to the current instance of sql 2005. Starting sql2005 indicates that the default instance is running as a service on my computer. in lessons 1 through 7, everything worked as advertised so I'm pretty sure the visual studio part is working. Do I need to reinstall Sql Rename the instance
Thanks for any help you can give.
Mike
vb2005 exp ed will not connect to sql 2005 exp ed
Goos van Beek
You can download the SQL Server Management Studio Express CTP. That will allow you to look at the databases (if any), build databases, attach, detach, backup, etc. Similar to Enterprise Manager for previous versions of SQL Server. Specifically, it's graphical
.
The SSEUtil (I think) is a command line application - haven't used it, yet.
Hope that helps.
SJW
rcbailey56
Link to the SQL Server Management Studio Express CTP: http://www.microsoft.com/downloads/details.aspx FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en.
I just went through Lesson 08 that you mentioned above. Did you get the error when you try to add new item SQL Database into your project If you still cannot resolve the issue, can you post the full error message
Best regards,
Redburga
Thanks. However, I'm more confused than ever.
I downloaded the SSEUtil, but if it does anything I can't tell it. The .exe file just sits there when I double click it and nothing more happens.
If I go to SQL Server 2005 Exp Ed. through the Start button menu, I get the option of starting the configuration tools, but nothing else. Starting Configuration Manager tells me that SQL Server 2005 E.Ed. is running as a service as is SQL Server Browser, but I don't seem to be able to connect to either one either directly or through Visual Studio 2005 E. Ed. (We need shorter names for these things ... maybe "Fred" and "Wilma").
I appreciate your patience and assistance.
Mike
Agsathi
Hi,
This post may help http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=138156&SiteID=1.
Also, Antoine has a blog on working with local database using SQL Express that may help as well http://blogs.msdn.com/smartclientdata/archive/2005/08/26/456886.aspx.
Best regards,
corradMSDN
My Apologies to you and to SJW. I haven't been able to fool around with this for a couple of months and what little I learned has gotten rusty from disuse. Haven't tried to do Lesson 08 again yet. However, I did download the SSMSE and the SQL Server side of things is working. Don't know yet where I went wrong in the lesson. Will get back to you when I figure it out.
Thank you for your support!
Mike