PDA

View Full Version : Connection to sql server files


sujith
09-13-2006, 03:17 PM
I was trying to add a database
as a new item in solution exployer

But i am getting an error like this


Connection to sql server files (*.mdf)require SQL server 2005 to function properly.Please veryfy the instaltion of the component

what minght be the reason for this?

I have installed SQL server 2005 well and, controls like Datagrid view works fine in some other trials

Hope some one can help me

(NB:I have installed .net and sql server in diffrent partitions of my hard disk)
.net sujith

vinyl-junkie
09-14-2006, 04:04 AM
There is a solution listed here (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=521158&SiteID=1) on a Microsoft forum. Perhaps it will be of some help.

sujith
09-15-2006, 07:36 AM
There is a solution listed here (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=521158&SiteID=1) on a Microsoft forum. Perhaps it will be of some help.


"
The solution is:

In Visual Web Developer 2005 Express, select:

Tools -> Options -> Database Tools -> Data Connections

Change the setting: "SQL Server Instance Name (blank for default)" to "SQLEXPRESS". (where SQLEXPRESS is the default server instance name)
"

this is the solution given there but i have this setting allready in my system




Hope u will help me

.netsujith

vinyl-junkie
09-15-2006, 12:07 PM
(NB:I have installed .net and sql server in diffrent partitions of my hard disk)
.net sujith
Perhaps you need to put .NET and SQL server in the same partition? If that doesn't work, I'm out of ideas.