Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: MS SQL 2008 Express

23 Oct 2009   #1
oblio98

Windows 7 Ultimate
 
 
MS SQL 2008 Express

I downloaded and installed MS SQL 2008 Express into my new W7 Ultimate system. I also installed the SP1, which was mentioned in a info window when I installed the SQL.

After a reboot, the PC seemed to take a long time to start, then I started SQL Server Management Studio but could not login to a database.

Upon further investigation, it appears that a database was not created. If I go to the SQl Configuration Manager and select SQL Server Services, I can see that 'SQL Server (SQLEXPRESS) is in a running state, and the icon is the same as the old MSDE Icon that would display down by the clock when SQL was running on XP and Vista.

On this PC, it is not down there, but I'm not sure if that's a W7 thing or not.

Does anyone have any experience with this?

THANKS

:-jon


My System SpecsSystem Spec
.
24 Oct 2009   #2
F8XX6

windows 3000
 
 

When you use SSMS login to SQL Server,the server name is (local)\sqlexpress
My System SpecsSystem Spec
24 Oct 2009   #3
oblio98

Windows 7 Ultimate
 
 

THANKS! - That was it. I tried just a dot (the old symbol for local), I tried the text 'local', I tried the computer name, but I did not try that!

I wonder why it wasn't in there as a default?

Anyway, THANKS THANKS THANKS!!!

(I hope this thread helps out other fellow clueless folks who run into this issue)

:-jon
My System SpecsSystem Spec
.

24 Oct 2009   #4
F8XX6

windows 3000
 
 

Because that's a named instance , not default instance
My System SpecsSystem Spec
Reply

 MS SQL 2008 Express




Thread Tools




Similar help and support threads
Thread Forum
Where to download Visual Studio 2008 Express CD (Offline) ?
Hello SF members, Today I want to find Visual Studio 2008 (offline). I can't find it, on Microsoft site I can find only VS2012 and 2012, but I need 2008 for my work. Where to download that CD or ISO ? Trinty :)
Software
SQL SERVER EXPRESS 2008 will not allow New Database
I have installed SQL EXPRESS Management Tools but I cannot get it to do anything. If I try to create a new database, I just get an error saying "Access to the database file is not allowed". Also the object browser screen ( on the left ) is completely empty. I have no existing files to...
Software
Remote Access to SQL Server Express 2008 Windows 7
Hello, I have installed SQL Server Express 2008 on my desktop and am attempting to connect to it from my lap top. I have enabled remote connections for SQL Server and opened up a port on my desktop. When I attempt to connect to the server instance from my laptop via ipaddress\sqlserver with...
System Security
SQL Server Express 2008 - Can't uninstall/repair
Hey I installed SQL Server Express 2008. It gave some error messages during installation that I passed by (oops!) I'm trying to uninstall but get the following error message: TITLE: SQL Server Setup failure. ------------------------------ SQL Server Setup has encountered the following...
Software
32-bit W7 and SQL Server 2008 Management Studio Express
Installation fails. Google finds some "solutions", but they don't help. TITLE: SQL Server Setup failure. ------------------------------ SQL Server Setup has encountered the following error: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code =...
Software
SQL server 2008 express
Hello, Hum. I've got a question. I want install SQL server 2008 + SQL management express 2008 to my Computer. If I'm trying that, it says me somewhat with Service pack. Can someone help me? Here some screens: http://img5.imagebanana.com/img/ezhyy9ga/screen.png...
Software


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 09:09.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App