I cant create an empty SQL database .mdf for local data  
Author Message
ddongdog\(JinHyungLee\)





PostPosted: Sun Nov 25 00:11:32 PST 2007 Top

SQL Server Developer >> I cant create an empty SQL database .mdf for local data

I have SQL Server 2005 installed from my School's MSDN Academic Alliance and
I'm having trouble creating a database .mdf file in VS 2005. I keep getting
this error:

"Connections to SQL Server files (*.mdf) requires SQL Server Express 2005 to
function properly. Please verify the installation of the component or
download from the URL" then a link to SQL 2005 Express downloads and SP
updates.

I had SQL Server 2005 Express before and I got the same errors do any know
how to fix this? I am running 32-bit Vista (no SP1 beta update) with VS 2005
Pro.

Jason

SQL Server293  
 
 
Uri





PostPosted: Sun Nov 25 00:11:32 PST 2007 Top

SQL Server Developer >> I cant create an empty SQL database .mdf for local data Jason
Perhaps the installation went wrong



>I have SQL Server 2005 installed from my School's MSDN Academic Alliance
>and I'm having trouble creating a database .mdf file in VS 2005. I keep
>getting this error:
>
> "Connections to SQL Server files (*.mdf) requires SQL Server Express 2005
> to function properly. Please verify the installation of the component or
> download from the URL" then a link to SQL 2005 Express downloads and SP
> updates.
>
> I had SQL Server 2005 Express before and I got the same errors do any know
> how to fix this? I am running 32-bit Vista (no SP1 beta update) with VS
> 2005 Pro.
>
> Jason
>


 
 
Erland





PostPosted: Sun Nov 25 01:30:36 PST 2007 Top

SQL Server Developer >> I cant create an empty SQL database .mdf for local data
> I have SQL Server 2005 installed from my School's MSDN Academic Alliance
> and I'm having trouble creating a database .mdf file in VS 2005. I keep
> getting this error:
>
> "Connections to SQL Server files (*.mdf) requires SQL Server Express
> 2005 to function properly. Please verify the installation of the
> component or download from the URL" then a link to SQL 2005 Express
> downloads and SP updates.
>
> I had SQL Server 2005 Express before and I got the same errors do any
> know how to fix this? I am running 32-bit Vista (no SP1 beta update)
> with VS 2005 Pro.

Which edition(s) of SQL Server do you have installed? When you say
"from my School's MSDN..." I take it that is Developer Editions. Later
you said that you had Express installed in the past. Have you
uninstalled Express?

Are you able to connect to SQL Server from Mgmt Studio? Can't you use
Mgmt Studio to create the database?


--


Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx