gave up on vista installs

[cbrown777]

After checking directly with microsoft and much research on the internet I am to understand that my vista premium home edition(most new pcs) will not run anything but the sql server express edition.
I downloaded the management studio express tool and can build databases.
My question is will I be able to work with most areas of sql so I can study for the 70-431 sql server 2005 exam?
My laptop apparently does not support the drivers for xp so I cannot downgrade to the xp version.
Any ideas out there?

 

[mrdenny]

You can install the Express or Developer editions on client operating systems (Windows 2000 Pro, Windows XP, Windows Vista). You have to have a server OS to install the Workgroup, Standard or Enterprise editions.

I have the developer edition of SQL 2000 and SQL 2005 installed on my Vista Home Premium Laptop.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[cbrown777]

Thanks for the response, but when I tried to install the developer edition, nothing shows up on my laptop. What step(s) did I miss if anything.

 

[cbrown777]

I uninstalled sql server express believing it might conflict with the developer edition install and this time it completed. It gave me a warning about iis not being installed but I checked that out and it was. Also when I went to connect to the database it gave me an error. Don't know why because I could logon using sql server express with the same logon.

 

[mrdenny]

By default in Windows Vista the BUILTIN\Administrators group doesn't have access to the database. Download and install Service Pack 2. At the end of the service pack a vista security fixer will open up which will grant your windows login sysadmin rights to the SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[cbrown777]

Thanks. I will do that. In the meantime I discovered that if I run as administrator, it also works.