sql express 2008 database to sql server 2008 database what bits do I need to download

I need a client program for my pc so I can put my sql express 2008 database on a sql server 2008.  My SQL server is off on some generic web host.

I tried management studio 2005 express version won't open my .mdf file but it opens my web host database.

I tried to download full version of sql server 2008 but couldn't find the management studio program in the download.   

Is there a trial or a preview I can download from microsoft that has the bits?



I don't ask many questions but I'm trying to partisipate in this community.

Good Luck

0 Danny117 12/24/2008 1:03:25 PM

Haven't tried it yet, but one of the downloads comes with 'tools,' one of which is management studio (basic, they call it now, instead of express).



MCP - Web Based Client Development .NET 2.0
0 ps2goat 12/24/2008 1:33:17 PM

I'll retry those bits.


Good Luck

0 Danny117 12/24/2008 1:59:25 PM

There not working I get the studio up but somewhere along the line I can't open the aspnet.mdf for my site membership and get it onto my server.  I even guiennia piged the publish shared hosting wizzard as best I could.

The management studio comes up now. but I get this.

TITLE: Microsoft SQL Server Management Studio

Create failed for Database 'dan1'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476


I'm just hosed so I'll come back to this next week.


Good Luck

0 Danny117 12/24/2008 5:25:18 PM

I'm just going to bet that SQL express product wasn't tested on vista ultimate using the default security config.  Once I reinstalled and specified a directory outside of "program files" for the data files.  Which I'm told is pretty common in a production environment for sql server.  The management studio was able to open my aspnetdb.mdf after I moved it to the data directory.

I should be good from here.

Good Luck

0 Danny117 12/24/2008 6:23:11 PM

Hi Danny,
From your description, it seems that you would like make migration between servers for ASPNETDB.MDF, right?

I think you can refer to the blog below:


As far as I know, there is no problem to run SQL Server 2008 Express Edition in Windows Vista.

For the reason of User Account Control (UAC) feature, sometimes we need right-click the program icon and click Run as administrator to run a program as an administrator in Windows Vista.

How to use User Account Control (UAC) in Windows Vista

Jian Kang
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
0 Jian 12/29/2008 3:33:38 AM

(Thread closed)