.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Window 7 Sql 2008

Posted By:      Posted Date: September 04, 2010    Points: 0   Category :Sql Server
Windows 7 Professional 64bit 2.45Ghz processor 4GB ram I am trying to complete a tutorial on ASP.NET on Lynda.com but they are using old versions and I cannot match up illustrations.  I have MS SQL server 2005 & 2008 with VS 2010 Express installed on my machine.  My question is where can I find a tutorial that will correspond with the setup I have configured on my computer as this is the way it came out of the box.  I am really excited to learn ASP.net.  I am intermediate skill level at HTML & CSS  I have limited exposure to Java Script C# PHP and MySQl  I have WAMP And Xamp installed on my machine.  I just have to find the tutorials lessons that are current with Windows 7 installation as I see it now MSSQL install and configuration seems to be WAY MORE complicated than WAMP Server that we used with PHP.  But I want to learn ASP.NET  Even the W3C school appears to be behind on the Windows 7 issues.   Please correct me where I have erred and steer me in the right direction.   Much Thanks in Advance, MIKE E"It's like déjà vu all over again." - Yogi Berra

View Complete Post

More Related Resource Links

Indexing services on window server 2008 is not working with .net

Hi, I am useing Microsoft indexing services in windows 2008 64 bit .I am getting error like "Exception from HRESULT: 0xC0000005" while i am createing  new catlog from .net 2.0.I am using  "ciodm.dll" for adding new catlog. i am using this code for create new catelog.   Dim Admin As New CIODMLib.AdminIndexServer   Admin.AddCatalog(varContractNo, txtCatelog.Text + "\" + varContractNo) Admin.Stop() Admin.Start() AddScope(txtDocFolderPath.Text, txtSite.Text, txtCatelogname.Text)   Please help me anybody have fixed this issue on window server 2008 64 bit.  

How can I access Command Window in SSMS 2008

Hello, I'm debugging some t-sql code, I can view locals, watches etc. but I've closed command window by mistake and i couldn't find it again. Is there a shortcut key for this window? How I can access this window? Thanks in advance.

Is PAE sufficient for SQL 2005 on Window 2008 32 bit

Hi, Environment: Windows 2008 32 bit, SQL 2005 with SP3 32 bit Standard edition, 24 GB RAM Need some clarification please. I know that using AWE - SQL Server can access more RAM than 4 GB using locked pages for caching etc. I also know the fact that for more than 16 GB of RAM usage the combination of PAE and AWE are required. However my question is related to PAE: a) If only PAE is enabled - Will SQL Server 2005 use more memory than 4 GB? b) From Control Panel - System - I see 24 GB of RAM and this is an indication that PAE is enabled. Is that correct? Or is there any other way to check if PAE is enabled on the system. c) From SQL Server Properties - I can see that SQL Server minimum and maximum memory are editable and one can change  the minimum and maximum RAM. However AWE is not enabled at this time. Will SQL use the amount or RAM specified in min and max Example: say 6 GB min and 10 GB max? If it will not use the >4GB memory specified (assuming PAE is enabled but AWE is NOT enabled)  then why are those two controls editable? Thanks, Mohan   follow me on twitter: http://twitter.com/mohantaneja

Getting a popup Window during the Silent uninstallation of SQL Server 2008 Dev R2

Hi, When i try to uninstall the SQL Server 2008 R2 silently, it openup a window with the options that Add, Repair or Remove. Is there any way to Hide this Window? The command i used for uninstallation is "%ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x86\setupARP.exe" /CONFIGURATIONFILE="%~DP0x86\UnInstall.ini" The content of the Uninstall.ini file is ;SQLSERVER2008R2 Configuration File [SQLSERVER2008] INSTANCENAME="MSSQLSERVER" ACTION="UNINSTALL" FEATURES=SQLENGINE,REPLICATION,FULLTEXT,AS,RS,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,OCS HELP="False" INDICATEPROGRESS="False" QUIET="True" QUIETSIMPLE="False" X86="True" I have tried with the following command also "%ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x86\setupARP.exe" /ACTION="UNINSTALL" /FEATURES=SQLENGINE,REPLICATION,FULLTEXT,AS,RS,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,OCS /INSTANCENAME="MSSQLSERVER" /QUIETSIMPLE  

report generate vwd 2008 - website data sources window empty

I need to create report in asp.net web application, I'm working on vwd 2008 express, installed report add-on i have create dataset file xxx.xsd and use storder procedure for data adapter. when I am trying to add columns into report body I cannot see dataset in website data sources window. when i right click on window it just show refresh option. how can I get my data set into window. and add columns in to report? please help... 

SQL Server 2008 R2 on Window Server 2008 Physical Memory keep growing


We are running SQL Server 2008 R2 on on Window Server 2008 (x64).

Once in every 2 weeks we end up restarting the SQL Server, due to  Physical Memory keep growing.

Is there a good way to pinpoint the problem what cause this Physical Memory to grow?

Thank you

Armine Bell

C# connect SQL server 2008 window authentication on workgroup


We have an application winform C# that connects to sql server 2008 with window authentication impersonation.
We need window authentication because of filestream requirement (we did not find other solution).

The application works fine in domain environnement. Our msi create same user on each computer and we use it to access to remote database.

But a lot of our customer are littre company (1 to 10 employees), they are in workgroup configuration, it is impossible to migrate them on domain environment.

We tried to impersonate but it doesn't works in workgroups :

public void Impersonate(string userName, string domainName, string password, LogonType logonType, LogonProvider logonProvider)
   IntPtr logonToken = IntPtr.Zero;
   IntPtr logonTokenDuplicate = IntPtr.Zero;
	// revert to the application pool identity, saving the identity of the current requestor
	_wic = WindowsIdentity.Impersonate(IntPtr.Zero);
	// do logon & impersonate
	if (Win32NativeMethods.LogonUser(userName,
		ref logonToken) != 0)
	 if (Win32NativeMethods.DuplicateToken(logonToken, (int)ImpersonationLevel.SecurityImpersonation, ref logonTokenDuplicate) != 0)
	  var wi = new WindowsIdentity(logonTokenDuplicate);

Closed form designer window in VS 2008, now cannot open again



I closed the Form1.Designer.vb tab in VS 2008.  If I click on Form1.vb in the Solution Explorer the View Designer button does not appear.  How can I open the designer window again?

Dos window flashes when installing SQL Server 2008 R2 on a Windows 7 Ultimate 64 machine - then does

I downloaded the iso for SQL Server 2008 R2 but it will not install on my Windows 7 Ultimate or Windows Home Premium  (I upgraded to Windows 7 Ultimate when I could not get it to install on the Home Premium - but still the same issue)

Does any one have a clue or seen this before?

Is it possible to have only 2 network adapters for 5 SharePoint web applications with 2008 R2 Window


Hi All,

I have an existing 2003 R2 SharePoint 2007 farm, and have set up a 2008 R2 SharePoint 2010 farm that we are going to move to through a database attach upgrade. I've got two web front ends on both farms. The 2003 farm has been working great with NLB for a couple of years now.

Issue: I've got five web applications on SharePoint that must be load balanced. I can only have 4 Network adapters due to limitations with the number of adapters and VMWare. This worked fine in the 2003 farm, as I just had one adapter dedicated to the machine itself and the other dedicated to the 5 NLB applications (I just added additional IPs to the one net adapter through advanced TCP/IP properties).

Should this work on the 2008 R2 farm? Necessarily when you add additional IPs to the net adapter through advanced TCP/IP you can no longer work with NLB through the NLB interface--you must add the NLB IP to each of the front ends through advanced TCP/IP and then ensure that the web app on IIS on each front end is associated with that NLB IP.

I've been testing--and it does seem to be working, but kind of slow.



Can anyone suggest what could be the reason of installation error- access is denied

while installing sql server 2008 sp2 express edition on my window 7 professional machine as a domain administrator.

I tried installing as a local administrator also but it gives the same errror.

can we install SQL Server 2008 R2 - 64bit on Window Server 32bit?

can we install SQL Server 2008 R2 - 64bit on Window Server 32bit?

Max files in a single WSS 3.0 Database (SBS 2008 Server - Window Internal DB)


This site appears to indicate that the max documents per database is 32,767 :


This seems extremely small to me. Is that an accurate number? We have a customer with 300,000 documents and about 30 users. Is this going to be too much for a single DB?


Window 7 allowed me to install the SQL Server 2008 express only as a "domain Administrator".

I could not installed it with any other admin account including Loacal Administrator. Is there any UAC problem with widow 7/SQL server 2008.

The same problem i faced when i was installing "Sql 2008 R2 standard" on window 2008 Server.

Can onyone respond to this ?



Problem while installing SQL Server 2008 Enterprise Edition on Window server 2003 x64 OS


I am trying to install SQL Server 2008 Enterprise Edition on Windows Server 2003 x64 OS.

I have followed below steps:

  • Installed .NET Framwork 3.5 SP1 on the system.
  • Installed Windows Installer v4.5
  • then tried to execute the setup.exe of SQL Server 2008.

Am getting below error:

"Microsoft .NET Framework 3.5 Installation has failed."

"SQL Server 2008 requires .NET Framework to be installed."

Please suggest me on how to proceed further with this installation.





console.writeline in window 2008 64bit seems very slow


console.writeline in window 2008 64bit seems very slow

any ideas / hints for fixing it.

The following code is running smoothly in XP/32 bit OS.

Have tried build w/ x64 config for testing.

Sample code for test:
using System;
using System.Collections.Generic;
using System.Text;

namespace TestConsole
    class Program
        static void Main(string[] args)

            for (int i = 0; i < 10000; i++)
                Console.Out.WriteLine(DateTime.Now.ToLongTimeString()+": " + i);

Can not start SQL Server 2008 Services on window 7


I Currently installed SQL Server 2008 Enterprise on Window 7 and whenever i try to start SQL Server (MSSQLSERVER) Services it give an error with these statements:

Windows could not start the SQL Server (MSSQLSERVER) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 17058


The request failed or the service did not respond in a timely fashon. Consult the event log or other applicable error logs for details.

Except that SQL Server Services i am able to start all other SQL Services like Integration Services, Analysis services

I have Installed .NetFramework 4 and also SQL Server Support Files (SqlSP1_setephelp) for Local Computer and applied SQL Server 2008 SP1 for fixing the Issues on Window 7

Is there a way to rectify this problem without Uninstalling, What is the parameter or path to start the services for SQL Server 2008 Enterprise on Window 7

Kindly Help me regurding my this Problem your reply will be appreciated  

Just Think About innovative things
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend