I use connection string like that:
server=10.10.10. 1;uid=xuser;pwd=xpasword;database=xdatab
ase;Connection
Timeout=60;Pooling=True;Min Pool Size=1;Max Pool Size=50
And I can't connect to the server.
when I connect to \\10.10.10.1\c$ with administrator rights then connection
to sqlserver (10.10.10.1) works.
What is wrong?
RemisHTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Remis" <remiskaune@.kalnieciai.lt> schrieb im Newsbeitrag
news:OZpGYODaFHA.2900@.TK2MSFTNGP15.phx.gbl...
>I use connection string like that:
> server=10.10.10. 1;uid=xuser;pwd=xpasword;database=xdatab
ase;Connection
> Timeout=60;Pooling=True;Min Pool Size=1;Max Pool Size=50
> And I can't connect to the server.
> when I connect to \\10.10.10.1\c$ with administrator rights then
> connection to sqlserver (10.10.10.1) works.
> What is wrong?
> Remis
>|||Try to check out on what port your sqlserver is listening on and use this in
your connection string to connect to the server.Even the share c$ uses
another port than the sql server standard (or that you have defined) it
could be blocked by a firewall whereas the share access port isnt blocked.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Remis" <remiskaune@.kalnieciai.lt> schrieb im Newsbeitrag
news:OZpGYODaFHA.2900@.TK2MSFTNGP15.phx.gbl...
>I use connection string like that:
> server=10.10.10. 1;uid=xuser;pwd=xpasword;database=xdatab
ase;Connection
> Timeout=60;Pooling=True;Min Pool Size=1;Max Pool Size=50
> And I can't connect to the server.
> when I connect to \\10.10.10.1\c$ with administrator rights then
> connection to sqlserver (10.10.10.1) works.
> What is wrong?
> Remis
>
Friday, February 24, 2012
Cant connect to sqlserver
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment