Problem connecting VWD Express 2008 to SQL Server Express 2005?

Just a regular ADO. NET connection? If so, what's your connection string?

Are you trying to use SMO (SQL Mgmt Objects)? This sounds like some of your SMO objects aren't available for some reason - you might want to download and reinstall those SMO components from here The files you want are quite a bit down the page, under the heading of Microsoft SQL Server 2005 Management Objects Collection files are called "SQLServer2005_XMO. Msi" (with some x64 variations) Does installing that MSI help at all?

Marc PS: okay, thanks, based on your comment - can you try this connection string here: string connectionString = @"Server=. \SQLEXPRESS2005;Database=DBName;Integrated Security=SSPI.

Just a regular ADO. NET connection? If so, what's your connection string?

Are you trying to use SMO (SQL Mgmt Objects)? This sounds like some of your SMO objects aren't available for some reason - you might want to download and reinstall those SMO components from here. The files you want are quite a bit down the page, under the heading of "Microsoft SQL Server 2005 Management Objects Collection" - files are called "SQLServer2005_XMO.

Msi" (with some x64 variations). Does installing that MSI help at all? Marc PS: okay, thanks, based on your comment - can you try this connection string here: string connectionString = @"Server=.

\SQLEXPRESS2005;Database=DBName;Integrated Security=SSPI.

My connection string is string connectionString = @"Data Source=ELDORA-08401090\SQLEXPRESS2005;Initial Catalog=DBName;Integrated Security=True;"; I installed the above MSI and I still get the error – Chakra Apr 15 '09 at 17:20 No. I tried with the connectionstring you suggested but it gave the same error. Thanks.

– Chakra Apr 15 '09 at 18:26 OK thanks - the error must be elsewhere - hmm..... – marc_s Apr 15 '09 at 19:14 I converted the web site to a web application and it worked out. I presume it was the download you suggested that did it. Thanks.

– Chakra Apr 15 '09 at 7:32.

If you are running SQL Sever Express locally another thing you may want to do check in the Services console (WinKey, Run, 'services. Msc') and verify that you have SQL Server and SQL Server Agent entries and that they are both running.

I think this problem is certainly with your connection string. Try doing this Run the SQL Management Express, and get the server instance name from it. Usually this problem occurs when the server instance name is wrong (on many computers it could be SQLEXPRESS).

In my case the instance name is SQLExpress2005 and that is what I use in the connectionstring – Chakra Apr 15 '09 at 17:23.

This sounds like some of your SMO objects aren't available for some reason - you might want to download and reinstall those SMO components from here. The files you want are quite a bit down the page, under the heading of "Microsoft SQL Server 2005 Management Objects Collection" - files are called "SQLServer2005_XMO. Msi" (with some x64 variations).

Does installing that MSI help at all?

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions