Error locating SQL Server

[ZmrAbdulla]

I am getting a message like below when I am trying to connect with SQL Server Express 2005. I am using SQL Server CTP.
=========================================================
TITLE: Browse Server for Database
------------------------------

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not 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?Prod...rver&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

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

OK
------------------------------
===========================================================

The link provided here doesn't have any more detail.

Is there any clue to findout the reason of this problem?

OS = Win2000
NON Admin user.





________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[7280]

It seems that remote connections are not allowed:
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

Try to connect locally and if it fails contact your dba.

 

[ZmrAbdulla]

I am trying to connect locally still gets the same message.
SQL Server Express installed in my workstation.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[gmmastros]

Can you connect to it using the management studio?

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[manmaria]

What is the server name you are using? Is it localhost or something else?
And what type is the authentication? Is it windows or server?

 

[ZmrAbdulla]

George & manmaria,
I can't connect it with "Management studio CTP".
============================
The dialog shows

Database type = Database Engine (disabled)
Server Name = ZAMEERABD\SQLEXPRESS
Authentication= Windows Authentication
============================

But I CAN work with SQL Server through Visual Web Developer express.
then the connectionstring will be

    <connectionStrings>
  <add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\AB.mdf;Integrated Security=True;User Instance=True"
   providerName="System.Data.SqlClient" />
  <add name="ABConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Intranet\App_Data\AB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
   providerName="System.Data.SqlClient" />
 </connectionStrings>

I am able to manipulate database and data.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[ZmrAbdulla]

Other info from SQL Server CTP
===========================
Microsoft SQL Server Management Studio Express = 9.00.1399.00
Microsoft Data Access Components (MDAC)= 2000.085.1022.00 ((Webdata).030220-1508)
Microsoft MSXML = 3.0 4.0 6.0
Microsoft Internet Explorer = 6.0.2800.1106
Microsoft .NET Framework = 2.0.50727.42
Operating System = 5.0.2195

I remember I have worked with it from the same machine earlier.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.