G
Guest
Is there a configuration trick for getting ADO.NET 1.1 applications to work
with:
2005 Express Server
2005 Standard Server
Enzo
with:
2005 Express Server
2005 Standard Server
Enzo
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
William \(Bill\) Vaughn
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.
__________________________________
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.
__________________________________
G
Guest
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
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
K
Kevin Yu [MSFT]
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."
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."
W
William \(Bill\) Vaughn
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.
__________________________________
--
____________________________________
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.
__________________________________