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

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

SQL 2008 express wont open this morning

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :ASP.Net

Everything was working fine yesterday afternoon before going home.. shut down with no issues and this morning when i try to open SQL i get  error message with the following, im on a deadline with this project and cant afford to lose what i have setup already. Is there anything i can do to correct whatever issues there may be?


TITLE: Connect to Server


Cannot connect to local.



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) (Microsoft SQL Server, Error: -1)


View Complete Post

More Related Resource Links

FLV file in Visual Web Developer Express 2008


I'm trying to embed a flv in my web page and I don't have a clue how to do it.

I downloded and installed ASPNetFlashVideo and the tools do not appear in my toolbox.

So if anyone has a work around it would be greatly appreciated.

CSS support in visual studio 2008 express edition


I have several css style sheets I want to work with.  I have copied them into the appropriate directory structure in my project.  The styles are applied correctly.

But the manage CSS styles tool bar on the left margin doesn't seem to work correctly.  At one point I had generated a style sheet and worked with it there, but now it not only can't find the one it generated, but the attach style sheet link doesn't respond at all, nor does anything in this bar.  Same deadness with the CSS Properties bar.  With or without a style sheet loaded in the editor -- a style sheet that is active in the project such that when I run it, the styles are applied.

VB version of studio, running on Vista home basic.

PS, the design mode works a lot better than the professional version I use in my day job on XP and server 2003.

Need help uninstalling incomplete Visual Web Developer 2008 Express Edition with SP1


I need to get a list of programs/files that were installed when I was trying to install VWD 2008 so I can go through and remove them.  The installation did not actually install the main part of the program so I can't start with removing Microsoft VWD 2008 (a folder was created in Program files but it is empty.  I found this (below) but I'm not sure that it applies. I don't want to remove programs/files that are being used by other programs. (I can't just try to install again because there is not enough room on my hard drive)

Uninstalling Previous Versions of Visual Studio 2008

This article applies to pre-Release versions of Microsoft Visual Studio 2008. For 2005 version of this document, see Uninstalling Previous Versions of Visual Studio 2005.

For best results, Visual Studio 2008 should b

How to connect to local instance of SQL Server 2008 Management Studio Express ?


I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

Cannot connect to PC-NAME\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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

guide to uninstall sql express 2008 and install sql express with managment studio

i have installed sql express 2008 and i need to install sql express 2008 with management studio what steps do i have to follow ? I have downloaded the 3 variances of sql1.sql express 2. sql express with management studio . 3.sql express with advanced servicesHow can i completely uninstall sql 2008 express and install it with management studio?Thank you for your timeAlex

Can't Create ODBC to Local SQL Server Express 2008

Hello. I have SQL Server Express 2008 SP1 LOCALLY on my Windows XP Professional SP3 box. I have databases already created in Access 2007 that I imported into SQL. Now I want to keep the front end Access forms for data entry but have them connect to the databases in SQL. What I can't seem to do is connect from Access to the SQL db's because I can't create the ODBC connection. When I try to connect, I get the following two 'Connection failed' errors: 1. SQLState: '08001' SQL Server Error: 10061 [Microsoft][SQL Server Native Client 10.0]TCP Provider: No connection could be made because the target machine actively refused it. 2. SQLState: 'HYT00' SQL Server Error: 0 [Microsoft][SQL Server Native Client 10.0]Login timeout expired Additionally, this information may help. 1. Windows firewall is turned off. 2. In SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for SQLEXPRESS, Shared Memory, Named Pipes and TCP/IP are all 'Enabled'. The order is Shared Memory (1), Named Pipes (2) and TCP/IP (3). 3. In SQL Server Configuration Manager > SQL Native Client 10.0 Configuration > Client Protocols, the above three are also 'Enabled'. The order is Shared Memory (1), Named Pipes (2) and TCP/IP (3). Double-clicking TCP/IP tells me that the default port is 1433. 4. Running "netstat -ano", I see no entries for [myIPaddress]:1433.

Deploying problem with SQL Express 2008 R2

Scientific software package works fine with SQL Express 2008 R2 on developing (mother) PC and Admin login mode, but difficulties are found elsewhere during installing and deploying on the client PCs.  We have used from year 2000 BDE (Borland Database Engine), which worked fine until now, but recently customers had been installing problems with Vista, Windows 7 and the local administration rights or permissions.   Thus I thought to test NT AUTHORITY\NETWORK SERVICE authentication, as this system is hopefully working again decades with coming new Windows versions. As not need to touch databases, ADO and authentication matters during last decade, I’m newbie with those topics.  Worked now few days with this problem, installed and unistalled SQL servers according to instructions, tested different connecting strings and now cannot found correction.  Solution is maybe and hopefully simple.   Attached is log data cut from (old and many times corrected) the main mother XP platform in Admin and Client (Guest) modes.  Same tests are done also with fresh XP installation on VirtualBox.  Used connecting strings are presented inside log files:           Main mother XP at Admin login:   2010-08-20 08:24:45.82 Server      Server local connection provider is ready to accept connection on [ \\.\pip

SQL express 2008 r2 on windows server 2003

install ends with the following error : "MsiEnumRelatedProducts failed to enumerate products with UpgradeCode='{1B117BA7-5BC1-419E-820E-7D4F3F412C7B}'. Error code: 1610."

How I can remove The Microsoft SQL Server 2008 Express installation manually.

How I can remove The Microsoft SQL Server 2008 Express installation manually ?   Other components uninstalled via Add/Remove but i cant remove SQL Server 2008 Express     From Add/Remove the following is installed:Microsoft SQL Server 2008   I have attempted to uninstall it via the Add/Remove method and this also failed.

Having problems installing/setting up SQL Server 2008 Express/R2 for ASP.NET user management on deve

I'm a bit new to installing and configuring, well, just about anything regarding databases, so please bear with me. I'm currently building a couple of ASP.NET MVC 2 sites.  I'm following along with the MVCMusicStore tutorial, and am trying to set up user management using ASP.NET's configuration tool.  The problem is that ASP.NET can't 'see' the database. I have SQL Server 2008 installed on my laptop.  It's the version which is available on the Web Platform Installer (I believe it's Express).  When I try running the aspnet_sqlreg.exe program to set up my user management database, it can't tell that I'm running any version of SQL Server at all.  I get an exception about 'named pipes', and some other things I don't understand at the moment. Obviously, this is all a bit over my head.  Is there an idiot proof guide or tutorial available that describes, step-by-step, how to: 1. Install SQL Server 2008 on a development PC 2. How to configure it to be used by Visual Studio 2010 Professional 3. How to properly upload/modify the db on the production server with what's on the development PC Essentially, all the things that the ASP.NET tutorials gloss over.  Any suggestions, links to documentation, or other nudges in the right direction would be immensely appreciated.

Was installing SQL 2008 Enterprise last night via RDP. When I came in this morning, I was disconnect

When I opened a connection, the old connection was gone, perhaps a reboot? I am able to connect to the instance from the server and create a table  and query a DB.  I am however unable to connect to the Instance from my 2005 client. How can I tell the install was successful? Looking in the event logs and not seeing anything around the time it would have completed. Additionally: I checked and Remote connections is enabled. TCP and Pipes are enabled. SQL Browser is stopped,when attempt to access to start that I get an error: The service cannot be started, either because it is disabled or because it has no enabled devices asssociated with it [0X80070422] I can't telnet into 1433 on the server.. might be firewall. Do I really need to open that manually? My client is SQL 2005, I believe I've connect to sql 2008 DBs. Should I upgrade the client on my client? I attempted to stop and start the instance. when I started it I got this mess: Server stack trace:    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.FindObjectExplorerFrame()    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.GetObjectExplorer(Boolean activateWindow)    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ShowError(Exception e)    at Microsoft.SqlServer.Management.UI.

SQL Server Express 2008 Setup fails. Support Rule "Restart Computer" Failed

Hi, I have been trying to install SQL Server Express for most of the day now without any luck.  Whatever I do setup fails at the stage of Setup Support Rules, Rule "Restart Computer" - Failed.  Needles to say I have restarted (several times!) and I have tried downloading  and installing the "Advanced", "Tools" and "Basic" versions, all give the same error.  Trying a repair does the same.  I have been searching the net for an answer without success, any help would be MUCH appreciated. Further info: I am trying to install a stand-alone installation on to a single PC running under XP SP 3 with .NET 3.5 SP1 installed.  The PC did have some earler versions of SQL server installed but I (?hopefully?) removed all of these through Control Panel.  Before trying the first SQL install I installed Windows installer 4.5 and PowerShell 1.0 as per the Microsoft Instructions. Running SQL Server Configuration Manager results in an error (MMC could not create the snap-in. The snap in might not have been installed correctly).  A directory structure for SQL server exists in "Program Files".  Services MSC shows SQL Server (SQLEXPRESS) as Automatic Statup (not running).  Trying to start this manually gives error 14001: "application configuration incorrect - re-install to fix" .......... Which is precisely what I'm trying to do.........:(

Problem connecting to SQL Server 2008 R2 Express from Access 2007

I have a problem with SQL Server 2008 R2 Express with MS Access 2007. I am running Windows 7 with 8 gigs memory. I installed SQL Server 2008 R2 Express. Do I now need to install SP1 because I am running with Windows 7? I can open SQL Server using the Management Screen but I cannot connect to MS Access 2007 using SQL Server Express as the database. When trying to connect to SQL Server from Access 2007, I keep getting the message that SQL Server 2005 cannot be found. It will not allow me to sign onto sql server 2008 stating that it cannot be found. Do I have to now run the SQL Server 2008 R2 Express SP1? Is there an upgrade to MS Access 2007 which will allow me to use SQL Server 2008 R2 Express?

Unable to install SQL Server 2008 Express R2 after installing .NET 4.0

Hi experts, I intend to redistribute SQL Server 2008 Express R2 in my installer. I've extracted the setup files from SQLEXPR32_x86.exe and pass in the appropriate command line parameters during the setup. Recently, I noticed if I applied the following Windows Update: .NET 4.0 Client Profile, I will hit into the following error when I installed SQL express. .NET Runtime 4.0 Error Reporting EventType clr20r3, P1 setup100.exe, P2 10.50.1600.1, P3 4bb67524, P4 mscorlib, P5, P6 4ba1da6f, P7 44f0, P8 32, P9 system.security.security, P10 NIL. .NET Runtime Application: setup100.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.Security.SecurityException Stack: at Microsoft.SqlServer.Chainer.Setup.Setup.DebugBreak() at Microsoft.SqlServer.Chainer.Setup.Setup.Main() Running the setup.exe from a file server will give these errors but if I copied the entire setup files to a local folder and run setup.exe from there, it runs fine. May I know what am I missing? I definitely need to support to install SQL express running from a file server location. Thanks, MK  

how do I uninstall "Management Tools - Basic in SQL Server 2008 R2 (Express)

how do I uninstall "Management Tools - Basic in SQL Server 2008 R2?  The regular remove program does not have this option highlighted.    I am trying use some of the advance option and learn something more and now ssms is useless.         the discovery report tells me these are installed but I have no way of uninstalling.  .  I want to replace this with my developer edition that I purchased but have lots of trouble installing because of the express version.  Please help.  I'd really appreciate it. " Sql Server 2008     Management Tools - Basic 1033 Express Edition 10.50.1092.20 No Sql Server 2008     Client Tools Connectivity 1033 Express Edition 10.1.2531.0 No Sql Server 2008     Client Tools Backwards Compatibility 1033 Express Edition 10.1.2531.0 No Sql Server 2008     Client Tools SDK 1033 Express Edition 10.1.2531.0 No "

attach sample database failed in sql 2008 express RTM

I'm having a trouble attaching sample database northwnd database,screen show me the error attach database failed for server 'computername\sqlexpress' additional inforamtion: the database 'northwind' cannot be opended because it is version 661.this server supports version 655 and earlier.a downgrade path is not supported.could not open new database 'northwind',create database is aborted,()microsoft sql server,error:948) my os is xp sp3,sql express version is  Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)   Jul  9 2008 14:43:34   Copyright (c) 1988-2008 Microsoft Corporation  Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)  I 'm sure database 'northwind' is ok.I can used database 'northwind' on my other computer.the other computer install express 2008R2 .    install RTM computer  ,database route is C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS,not C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. actually I 'm install sample database in sql express RTM on my computer.I just wonder why attach good database failed,how to solved this issue. http://sqlserversamples.codeplex.com/releases/view/45923 this link is avialable   thanks for you help

SQL 2008 Express with advanced services and Visual studios 2010

Hi could someone please help me. Im running the following software: SQL 2008 Express R2 with advanced services Visual Studios 2010 Ultimate   I am trying to using Sql in Visual studios to use full text indexing but I am attaching a database that already exists. My problem is that I can use the full text indexing? I had it working once but then when i tried to FREETEXT search through my table it said that I didn't have an index on that table when I know I do cause I went to make sure. I think that perhaps its referencing the wrong database because I cant seem to add the database into my project? I am so confused as to how SQL express instances work so not sure what I am doing wrong? PLEASE HELP? 
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