Cannot DTS connect to SQL Server 2005

I have installed SQL Server 2005 Beta 2 on my PC. When I try to make a
connection to it from the DTS environment, I get following error:

=============================================
Could not get server list. (DTS Import/Export Wizard)
=============================================
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied. (Microsoft OLE DB Provider for SQL Server)
------------

Making a connection from within SQL Server Management Studio works fine.
If I try to connect from within a .NET program using SQLConnection, it
fails on the conn.Open() call. But SQL Server Management Studio works
fine.

Has anyone run into this? Could someone please help?

RobIf it works from one application but not from another, then I would
guess that it's an incorrect connection string, the wrong
authentication mode or something similar. There are connection string
samples here:

http://www.able-consulting.com/ADO_Conn.htm

And this KB article covers possible reasons for the error:

http://support.microsoft.com/defaul...306&Product=sql

Simon

Cannot connect to Sql Server 2005 Express. Any idea why ?

Hi everybody
I have a system with :
WinXP Pro, MSDE 2000, Framework 2.0 beta. On top of it i installed SqlServer
2005 Beta with Mixed Mode. I am using Query Analyzer and Enterperise Manager
from SQLServer 2000 to connect to it (manual says I can) but with no
success. I tried to log on with windows authentication as well as with Sql
authentication . I tried the following names to connect :
(local)\SQLEXPRESS; COMP_NAME\SQLEXPRESS; SQLEXPRESS; MSSQL$SQLEXPRESS and
so on but never got connected. It always say that the
SQL Server does not exist or Access denied.
I checked in the services where it is set to automatic and is running. I
also stopped and restarted but with no success. What i am missing ?
At the end I uninstalled everything and reinstalled only Framework 2.0 and
Sql Server 2005 Beta but having the same problem.
Anyone know how to fix this ?
Thanks in advance
Raja
hi, Raja,
"Ing. Rajesh Kumar" <iambad(Without This)@.post.cz> ha scritto nel messaggio
news:OFSx33CcEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi everybody
> I have a system with :
> WinXP Pro, MSDE 2000, Framework 2.0 beta. On top of it i installed
SqlServer
> 2005 Beta with Mixed Mode. I am using Query Analyzer and Enterperise
Manager
> from SQLServer 2000 to connect to it (manual says I can) but with no
> success. I tried to log on with windows authentication as well as with Sql
> authentication . I tried the following names to connect :
> (local)\SQLEXPRESS; COMP_NAME\SQLEXPRESS; SQLEXPRESS; MSSQL$SQLEXPRESS and
> so on but never got connected. It always say that the
> SQL Server does not exist or Access denied.
> I checked in the services where it is set to automatic and is running. I
> also stopped and restarted but with no success. What i am missing ?
> At the end I uninstalled everything and reinstalled only Framework 2.0 and
> Sql Server 2005 Beta but having the same problem.
frorm microsoft.private.sqlserver2005.express newsgroup:
1. Enable Protocols
a. Launch SQL Computer Manager
b. Expand "Server Network Configuration"
c. Expand Protocols for "SQLEXPRESS"
d. Enable Np (for local access)
e. Enable TCP (for remote access)
2. Restart SQL Express
a. can be done from either SQL Computer Manager, Services applet, or
command line
3. Start SQL Browser service from Service applet or command line
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Cannot connect to SQL Express Remotely

I have SQL Express April CTP (from VS Beta 2) installed on machineA, but I cannot connect to it from machineB using the command "sqlcmd -S machineA\sqlexpress -E". This command works just fine from machineA.

I have enabled the TCP/IP protocol for the SQLExpress instance through the configuration manager, and turned off the Windows Firewall on machineA.

Any ideas on what I'm doing wrong?

Hi Michael,

By default network protocols (TCP/IP, named pipe) are disabled for SQL Server Express Editions.

You can use SQL Server configuration manager tool to Enable the server protocols on which the instance of SQL Server will listen.

hope this is helpful...

thanks..
Rajesh|||Does this help:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx|||Thanks Euan -- That did the trick!|||Hi,

I have the same problem, I cannot connect remotely to sql server express

I have done all the steps in that article http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

but still not working remotely although locally is ok

I have tried also on domain lan and on workgroup lan

On domain, on different client computers with different domain users I received different error messages:

...login failed for user. the user is not asociated with a trusted sql server conenction...
or
...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 ... error locating server..
or
...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 ... login failed...

I am connectiong to my_machine\SQLEXPRESS with windows authentication, same as on the server machine

I cannot figure out what should be the problem, any help would be apreciated.

Thank you for your time.
Corina

Cannot connect to SQL Express Remotely

I have SQL Express April CTP (from VS Beta 2) installed on machineA, but I cannot connect to it from machineB using the command "sqlcmd -S machineA\sqlexpress -E". This command works just fine from machineA.

I have enabled the TCP/IP protocol for the SQLExpress instance through the configuration manager, and turned off the Windows Firewall on machineA.

Any ideas on what I'm doing wrong?

Hi Michael,

By default network protocols (TCP/IP, named pipe) are disabled for SQL Server Express Editions.

You can use SQL Server configuration manager tool to Enable the server protocols on which the instance of SQL Server will listen.

hope this is helpful...

thanks..
Rajesh|||Does this help:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx|||Thanks Euan -- That did the trick!|||Hi,

I have the same problem, I cannot connect remotely to sql server express

I have done all the steps in that article http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

but still not working remotely although locally is ok

I have tried also on domain lan and on workgroup lan

On domain, on different client computers with different domain users I received different error messages:

...login failed for user. the user is not asociated with a trusted sql server conenction...
or
...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 ... error locating server..
or
...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 ... login failed...

I am connectiong to my_machine\SQLEXPRESS with windows authentication, same as on the server machine

I cannot figure out what should be the problem, any help would be apreciated.

Thank you for your time.
Corina