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?
Thanks
Dan.
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).
http://www.microsoft.com/express/sql/download/
---------------------------------------
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)
------------------------------
ADDITIONAL INFORMATION: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
------------------------------
BUTTONS:OK
------------------------------
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
http://support.microsoft.com/kb/922708
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)
