SQL 2005 and ADO.NET 1.1 connectivity problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a configuration trick for getting ADO.NET 1.1 applications to work
with:

2005 Express Server
2005 Standard Server

Enzo
 
Ah, not really. The default configurations of these versions of SQL Server
are configured to prevent external access. They can be reconfigured with the
new SQL Server Surface Area Configuration tool. It can enable the protocols
and interfaces needed to see these versions as "servers" on the LAN.

See my blog for more details.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Bill,

I tried the following per Microsoft:

1. Start >> All Programs >> Microsoft SQL Server 2005 >> Configuration Tools
2. Open Sql Server 2005 Network Configuration >> Protocols for SQL2005

3. By default, only Shared Memory is turned on. You will likely need named
pipes for a local server and TCP/IP for remote

4. If you are accessing remotely, you need to turn on SQL Server Browser, as
well (under SQL Server 2005 Services)

5. Restart SQL Server 2005

.....while I am able to connect, I recieve an error as soon as I attempt a
SELECT

Enzo
 
Hi Enzo,

Please also check if there is any firewall on the server. If an error
message occurs, could you post the exact massage? I can connect to SQL 2005
and run a SELECT successfully.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Did you walk through the checklist on my blog?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Server 2005 and ADO.NET 1.1? 3
Sql Server Express won't let me connect 8
Can't insert record into SQL server express from ADO.NET inside IIS 4
error numbers which can be generated by ADO.Net (Not SQL Server) 4
Why doesn't ADO.Net reuse the connections in the connection pool 2
ado.net application 1
auto translate=false in ADO.NET 2.0 0
From ADO.NET 1.1 to SQL 2005 and SQL 2008 1

Back
Top