Is SQL Server 2008 supported on Windows 7 / Windows Server 2008 R2?

Hi,

I turned off the firewall and then runned the setup.exe again. Then it worked!

Thank you for submitting this cool story - Trackback from DotNetShoutout

Kudos for a great Sql Server article - Trackback from SqlServerKudos

Thanks! I just moved to Win 7 x64 and thought I was screwed. Whew! Restarting the install worked like a champ. :-)

Thanks...usfull info :)

Thansk thorhalvor for your valuable tips.

hey guys me too had the same problem while installing sql server 2008

i followed the link given below and i'm able to complete my installation too. i hope this would be useful for u too...

http://www.sql-server-performance.com/articles/dba/Steps_to_Install_SQL_Server_2008_p1.aspx

I turned off the firewall and then runned the setup.exe again. Then it worked like champ

hey, i'm running my program in Win7 32bit. my program is use VB 6.0, SQL Server 2008 and CR 10. then i get this msg " Invalid procedure call or argument"

first, i guess that the error come from my program, but when i install it to the XP SP2 nothing wrong with it.

then why can't i running it in Win7

When trying to install SQL Server 2008 on Windows 7, during "installation progress" this will be stoped for a long time.

It is at almost 80% of full installation and it is blocked in the function "SqlEngineDBStartConfigAction_install_configrc_Cpu32".

Is this a known issue, how can I solve it?

Kind Regards

Miguel

PingBack from http://sev17.com/2009/08/installing-sql-server-2008-on-windows-7/

When you say:" Rest assured, you can safely ignore this warning, just make sure to install SP1 before you do anything else."

Are you saying leave the dialog open and install SP1 or Press "Run Program", install it, then install SP1?

Excellent, Thanks. I had a feeling, but just wanted to be 100% sure. Thanks for the fast reply.

PingBack from http://morningreading.wordpress.com/2010/04/22/ms-sql-2008-installition-issue/

SQLServer2008SP1-KB968369-IA64-ENU.exe

SQLServer2008SP1-KB968369-x64-ENU.exe

SQLServer2008SP1-KB968369-x86-ENU.exe

I have Win 7 32 bit ,

So there is a question For me to Ask , Which One of those Link I Have to Download ???? The THIRD one ???

PLZ HELP

alireza7219@yahoo.com

Yes, x86 = 32-bit

x64 = 64-bit

IA64 = Itanium 64-bit (pretty rare these days)

IS there any difference between Instaling visual studio 2008 first then Sql

and  at first install Sql and then visual studio 2008?????

Personally, I would install SQL Server and then Visual Studio.  When installing Visual Studio, make sure to not install the Express Edition of SQL Server that is part of the install.  If you already have an instance of SQL Server locally (I assume Developer Edition) then there is little reason to add an additional Express instance.  You can do things the other way around if you want, but I remember the 2005 versions had a real problem in that case, and I rebuilt one machine because of it (and heard of several other similar stories).  I'm not sure that I trust all of these issues to be fixed in the 2008 editions.

Thanx Alot , Such a fast answering, Here is better than My university fo asking My Question.

StackOverflow is probably a better place.  The author of a blog will see comments from a post that is a year old, but nobody else will, so starting a new thread there will get a lot more audience and a lot better chance at good answers and discussion.

I have installed SQL server 2008 enterprise in my Window 7 Professional x64. When I am opening SQL Server Management Studio on Connect to Server popup combo box I can't see SQL 2008 I have installed, but can see all others (2000, 2005...). Is anybody know where I can find my SQL 2008 Database Engine?

Thanks

Arthur, is it possible that the SQL Browser service is not running?

http://msdn.microsoft.com/en-us/library/ms181087(v=SQL.100).aspx

Anyway if you remember the instance name you created then you can simply type in the name yourself:

.\instance_name

i write these code in my form load  :

Dim objConnection As SqlConnection = New SqlConnection()

       objConnection.ConnectionString = "Data Source=HADES-PC\Hades;Initial Catalog=C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\first.mdf;Integrated Security=True"

       objConnection.Open()

but When i run the program Says

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Could u help me

First, validate that your named instance is in fact called "Hades". What do you see in regedit.exe > HKEY_LOCAL_MACHINE / SOFTWARE / Microsoft / Microsoft SQL Server / Instance Names / SQL ?

Second, either change your computer name so it doesn't have a bad character (-) or get used to putting square brackets around it every time you use it.  Also consider using localhost or 127.0.0.1 instead of the name, or adding an alias to your hosts file and/or configuration manager.

Third, try connecting to your instance using Management Studio or something.  Code just adds layers to your testing and should be the next step after you know what your instance name is called and that it actually accepts connections.

Finally, post your questions on StackOverflow.  I don't mind providing a bit of guidance but this is certainly not a support forum.

Hi Aaron,

Thanks for your response.

I just typed instance name and hurray! I was able connect to my SQL 2008 server.

Thanks again, that was grate help!

Sorry for 'grate', of course great!

Would it be possible To introduce me a webpage To answer my questions in vb 2008 and sql 2008 , ?? a froum,

http://stackoverflow.com/questions/tagged/vb.net

http://stackoverflow.com/questions/tagged/sql-server-2008

Note about BSOD:

You killed SMSS.EXE (Windows Session Manager), not SSMS.EXE (SQL Server Management Studio).

SMSS.EXE is a critical process. Killing critical process causes BSOD.

how can i delete a row(a record) from my Db which i connect to the SQL By the Connected Mode.

these codes are Mine , but it Doesnt work Would it be possible to Help Me???

In my form i have 2 textboxes, and a Button (Name=BtnDel) and a Listview.

In these Codes i select a Row from Listview And save it in Deltext(String), so It has to Delete The row (record)Form My DB (Categories)which Has  2 Fields(Col) 1-ccode 2-Category.

But It Doesnt Work Would You PLZ help ME???

string deltext;

               ListViewItem.ListViewSubItem[] IT =new ListViewItem.ListViewSubItem [2];

               deltext = listView1.FocusedItem.SubItems[1].ToString();

               SqlCommand cmdDel = new SqlCommand();

               cmdDel.Connection = new myConnection().Cnn;//comment//A class which give me the connection Sting and Open it For ME .

               cmdDel.CommandText = "delete from categories where Category=@cat";

               cmdDel.Parameters.AddWithValue ("@cat", deltext);

               cmdDel.ExecuteNonQuery();

               this.GetRecords();   //Comment//this is a method which i get all of my record by this

Hat on to you for providing such a great article on SQL Server 2008 Installation issues.

It helped me a lot.

Thanks again.

hi

i have windows 7 on my pc 32 bit. and i installed sql server 2005 standard edition but its not working. which version of sql server is compatibl with windows 7..

Hye Aaron and others.

I had tried several times installing Sql Server 2008 in my Windows 7 Ultimate (32-bit) but this kind of errors (below) keep occurring. I also tried to install SQL Server 2008 SP1 but as you said, many complaint that error 'it could not find any components to update' occured. I've checked whether i've chosen the right language, and Yes! i chose English. How can i solve this problem? Please help me with step by step guide as I need it to be done installed within this several days. Please.......Thanks for your help.

The following notes apply to this release of SQL Server only.

Microsoft Update

For information about how to use Microsoft Update to identify updates for SQL Server 2008, see the Microsoft Update Web site <http://go.microsoft.com/fwlink/?LinkId=108409>">http://go.microsoft.com/fwlink/?LinkId=108409> at http://go.microsoft.com/fwlink/?LinkId=108409.

Reporting Services

The Reporting Services installation options that you specified in Setup determine whether additional configuration is required before you can access the report server. If you installed the default configuration, the report server can be used immediately. If you installed the program files only, you must run the Reporting Services Configuration tool to deploy the report server.

To install the Reporting Services Add-in for SharePoint Technologies, start the rsSharePoint.msi in the Setup folder on the SQL Server 2008 installation media after SQL Server Setup is complete.

Documentation and Samples

To install the .NET Framework SDK, see “Installing the .NET Framework SDK” in SQL Server 2008 Books Online <http://go.microsoft.com/fwlink/?LinkId=114089>">http://go.microsoft.com/fwlink/?LinkId=114089> at http://go.microsoft.com/fwlink/?LinkId=114089.

By default, sample databases and sample code are not installed as part of SQL Server Setup. To install sample databases and sample code for non-Express editions of SQL Server 2008, see the CodePlex Web site <http://go.microsoft.com/fwlink/?LinkId=87843>">http://go.microsoft.com/fwlink/?LinkId=87843> at http://go.microsoft.com/fwlink/?LinkId=87843. To read about support for SQL Server sample databases and sample code for SQL Server Express, see Databases and Samples Overview <http://go.microsoft.com/fwlink/?LinkId=110391>">http://go.microsoft.com/fwlink/?LinkId=110391> on the CodePlex Web site at http://go.microsoft.com/fwlink/?LinkId=110391.

For more information about late-breaking changes in this release of SQL Server, see the latest readme file <http://go.microsoft.com/fwlink/?LinkId=100093>">http://go.microsoft.com/fwlink/?LinkId=100093> at http://go.microsoft.com/fwlink/?LinkId=100093.

For information about SQL Server 2008 Surface Area Configuration, see the following SQL Server 2008 documentation topics:

In SQL Server 2008 Books Online: “Understanding Surface Area Configuration.”

In SQL Server 2008 Setup Help: “Minimize SQL Server 2008 Surface Area.”

   In SQL Server 2008 Books Online on MSDN: Understanding Surface Area Configuration <http://go.microsoft.com/fwlink/?LinkId=106282>">http://go.microsoft.com/fwlink/?LinkId=106282>     at http://go.microsoft.com/fwlink/?LinkId=106282.

oh im sorry. actually the errors occurred as database engine, analysis service,and  reporting service were not successfully installed.  but the others were successfully done installed.

My notebook is 2-years notebook, 32 bit WIndows 7 Ultimate. My friends can successfully installed SQL Server 2008 and Visual Studio 2008 in Windows 7 Ultimate, so im just trying to use this kind of x86 version.

This is the actual error come out.

"Attempted to perform an unauthorized operation."

The installation process stops at the SqlBrowserConfigAction_install_ConfigNonRC_CPU32

I uninstalled c#( because it didn't have a SP1 update) and it work. Give it a try.

Cannot connect to shithil-PC/SQLEXPRESS.

===================================

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

------------------------------

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

------------------------------

Error Number: 67

Severity: 20

State: 0

when I m installing Sql server2008,i am finding the error like this:

Unable to open windows installer file D:\Sql server2008\x86\setup\sql_engine_core_inst_loc_msi\1033\sql_engine_core_inst_loc.msi

Windows installer error message:The system can not open the device or file specified.

Please help me....

I tried installing SQL Server 2008 x64 on Win 7 SP1. I did get error of "Invoke or revoke..." first time but when i tried running it for second time I get error: ---------------------------

SQL Server Setup

---------------------------

The loading and initialization of 'setup.rll' failed with error code: 0x80070002

SQL Server Setup will now exit.

---------------------------

OK  

---------------------------

Any help appreciated

Maybe try this KB

http://support.microsoft.com/kb/910336

When installing SQL Server 2008 R2 on a machine with Windows 7 installation error code is 289 740 454

hello

i when installing sqlserver 2008r2 massage .net application security

please i help .

thank you

My sql server 2008 installation stops in between without any error.plss help

I'm glad I read your blog first before trying to install SQL Server 2008. What you suggested about re-booting after getting that "Invoke or Begin Invoke" error worked. I re-booted was able to move on through the install with no problem. Thank you.

I'm sure you've mistakenly killed smss.exe, NOT SSMS.exe.

i have install SQL sarver 2005 in may laptop in windows 7 but can not working.which virsion is compatibal for windows 7.please help me if any

one can know about this.plz plz

i installed sql server 2008 n sp2.it was working fin but due to certain problems i uninstalled it.now wen i reinstall it i'm not getting any server instances.any good help is appreciated

d

Hi Aaron,

     We have SQL2008 r2 installed in Windows 7 system.We have couple of our Windows services also starting up along with SQL server with the system boot up.

2 of the windows services connects to the database.Now we encounter the issue of Synchronizing were the SQL server is not fully up and my client services starts connecting to it and fails.

Apart from waiting for the SQL server to be fully up and then trying connection.I wanted to know is there any other way i could optimize the start up of SQL server?

Thanks in advance

Any easy way to slipstream sql 2008 installation media?

I found a blog by Peter Sadow which is confusing to my end users.

@Oliver 14 steps are confusing?

ok try this GUI version http://sqlslipstreamer.codeplex.com/

I havent tried it though