Nothing.

I checked out your link, but it's pretty much the same as in the book "Enabling Remote Connections in SQL Server) I have already done this.

################################################## ######
Cannot connect to (local)\SqlExpress.
------------------------------
ADDITIONAL INFORMATION:
This version of Microsoft SQL Server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)

################################################## ######
Cannot connect to .\SqlExpress.
------------------------------
ADDITIONAL INFORMATION:
This version of Microsoft SQL Server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)
################################################## #####

I'm only speculating:
I installed VS 2008 with VWD 2008 already installed on this machine, maybe there could be 2 instances of sql server??...causing the problem i'm having??

I would like to resolve this issue before I continue with the book, by the way, great chapter on managing styles in VS! ...de-mystified alot of things for me!

thanks, Kevin

Take a look at this: Do you get this error in the client tools of SQL Server? That is, in SQL Server Management Studio? If so, check the Help | About box. What versions do you see listed there?

The error message seems to suggest that you are using the *2005* version of the client tools to connect to a *2008* instance of SQL Server Express. If that's the case, grab a copy of the new 2008 client tools here: http://www.microsoft.com/express/sql/download/

Hope this helps,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

I'm going to try it Imar, yes I did get that error message in Sql Server Mgmt studio Express(it is the 2005 tools version)

Should I un-install the 2005 tools first? before installing the 2008 tools?

Thanks

Don't know for sure..... I think you do.

If I were you, I'd try installing the new version and see if it prompts you to uninstall the old version. You can use the 2008 version to connect to 2005, so it's OK to uninstall the old version.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Well, SQL Server 2008 would not install.

...so I un-installed 2005

I am installing SQL Server 2008 with tools now but have come to a window in setup where I don't know what to select:

Server Configuration:
SQL Server Database Engine: Account Name/Password

I'm lost...

Did you check out the Books Online for SQL Server (http://msdn.microsoft.com/en-us/library/bb510412.aspx) or the documentation or readme's that come with the installation? It's a bit difficult for me to suggest something if I don't know what screens you're seeing.


Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!