at work, I'm trying to use Native client under ODBC to connect to another pc have the SQl Expess server, but never get connect. the message said the sql express may not allow remote connect.
I run a test, install sql express at home and install native client on the second pc and get connect easily.
So what do I miss here. Please help. thanks
You need to explicitly enable remote connections for SQL Express since they are off by default. You can enable them during install using the DISABLENETWORKPROTOCOLS flag:
(From template.ini)
;--
; The DISABLENETWORKPROTOCOLS switch is used to disable network protocol for SQL Server instance.
; Set DISABLENETWORKPROTOCOLS = 0; for Shared Memory= On, Named Pipe= On, TCP= On
; Set DISABLENETWORKPROTOCOLS = 1; for Shared Memory= On, Named Pipe= Off (Local Only), TCP= Off
; Set DISABLENETWORKPROTOCOLS = 2; for Shared Memory= On, Named Pipe= Off (Local Only), TCP= On
; Note: DISABLENETWORKPROTOCOLS if not specified has the following defaults.
; Default value for SQL Server Express/Evaluation/Developer: DISABLENETWORKPROTOCOLS =1
; Default value for Enterprise/Standard /Workgroup: DISABLENETWORKPROTOCOLS =2
or after install using TSQL or following this blog:
http://support.microsoft.com/kb/914277
Thanks,
Sam Lester (MSFT)
Tried it, still not connect. Any other way? Thanks
No comments:
Post a Comment