SQL Server - Error while installing sqlexpress 2008

Asked By Nami123
10-Feb-12 01:59 AM
 sir,
    icannot connect to sqlserver 2008 . it shows the error

TITLE: Connect to Server
------------------------------

Cannot connect to LOCALHOST\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

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)

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

------------------------------
BUTTONS:

OK
 sir please tell me how to fix it. Also sqlserver service is not installed in my system please tell me what to do ?

Thanks&Regards
Nami
  Web Star replied to Nami123
10-Feb-12 02:15 AM
This error comes means your sql express services are not running so check it
All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager >> SQL Server Services, and check if SQL Server service status 

if not running than restart it , that will fixed your problem.

also see this link more elobrate the network issue
http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/ 
  Somesh Yadav replied to Nami123
10-Feb-12 02:20 AM

Hi,

Please first check if there is a named instance of SQL Server called “SQLEXPRESS” running on the host server. The error message indicates that the specified server/instance is not valid. Please check if you specify the correct server/instance name.

I noticed that you specify “user instance = true” in the connection string. User instance is a feature of SQL Server Express and does not supported by other editions of SQL Server like Enterprise or Standard. If there is no SQL Server Express instance on your host server, you need to attach the database to the SQL Server instance and modify the connection string.

Please refer to the following link to attach databases: http://msdn.microsoft.com/en-us/library/ms190209.aspx

If it’s a default SQL Server instance, you can change the connection string to:

Data Source=.;Database=ASPNETDB;Integrated Security=True;

If it’s named instance, you can the connection string to:

Data Source=.\InstanceName;Database= ASPNETDB;Integrated Security=True;

For more information regarding the error and SQL Server user instance, please see:

http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

http://msdn.microsoft.com/en-us/library/ms254504.aspx

  Nami123 replied to Web Star
10-Feb-12 02:38 AM
 sir,
   i checked for the service but service is not get installed .
  Web Star replied to Nami123
10-Feb-12 04:43 AM
If there are services are not installed than how can you connect it, you need to first install the sql server express instance on that machine than only you will be able to connect.
Create New Account
help
sql server 2008 wht are the different edition of sql server 2008 i have sql server 2008 r2 is sql server 2008 R2 different from sql server 2008 R2 express edition
SSIS package in sql server 2008 SQL Server I am using sql server 2000 and want to move to sql server 2008 How to create / edit a ssis(dts) package in sql server 2008? Previously
SQL Server 2008 R2 SQL Server Is this a full or cutdown version of SQL Server 2008 Enterprise? SQL Server Discussions SQL Server 2008 R2 (1) SQL Server 2005 (1) Windows Server
linked servers between different sql versions?? SQL Server Can a SQL Server 2008 server have a linked server that is SQL Server 2008 R2?? We presently use a SQL Server 2008 for reporting
SQL 2005 Studio connect to SQL 2008 SQL Server How can I make my SQL Server 2005 Management Studio to connect to a remote SQL Server 2008? SQL Server Tools Discussions SQL Server 2000 (1) SQL Server 2008 (1) SQL