Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to configure sql server 2008 client

19 views
Skip to first unread message

Porlock

unread,
Feb 5, 2010, 10:36:51 AM2/5/10
to
Hi,

I've this trouble ...

- I've got this server: Windows XP SP3 with SQL Server 2008 Express
installed.
I've just enabled the SQL Server Browser and TCP-IP (an even Named Pipes
protocol, they were all-disabled).

- I've got one client: Windows XP SP3 with SQL Server 2008 Native Client
installed.

Fron client I cannot connect to Server in any way !!!
what else can I configure ?

thanks in advice !
Paolo

Erland Sommarskog

unread,
Feb 5, 2010, 6:12:51 PM2/5/10
to
Porlock (porlock@_cavami_infinito.it) writes:
> - I've got this server: Windows XP SP3 with SQL Server 2008 Express
> installed.
> I've just enabled the SQL Server Browser and TCP-IP (an even Named Pipes
> protocol, they were all-disabled).
>
> - I've got one client: Windows XP SP3 with SQL Server 2008 Native Client
> installed.
>
> Fron client I cannot connect to Server in any way !!!
> what else can I configure ?

1) Did you restart SQL Server?
2) What you do you specify when you try to connect?
3) Any firewall?
4) Is the Browser service running?


--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Uri Dimant

unread,
Feb 7, 2010, 3:56:47 AM2/7/10
to
Hi
What is the error? Can you see what is wrtitten in the ERROR.LOG?

"Porlock" <porlock@_cavami_infinito.it> wrote in message
news:usSWLknp...@TK2MSFTNGP02.phx.gbl...

Porlock

unread,
Feb 8, 2010, 5:55:57 AM2/8/10
to

"Erland Sommarskog" <esq...@sommarskog.se> ha scritto nel messaggio
news:Xns9D1723B8...@127.0.0.1...
> Porlock (porlock@_cavami_infinito.it) writes:
[...]
>

> 3) Any firewall?

ok. It was the windows firewall. I put exception for TCP 1433 and UDP 1434
and now I can easly connect to the server.
Thank you.

Paolo


0 new messages