Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
 Posted - 2011-05-27 : 00:46:15
|
| Hi,can one tel what setting has to make to access sql server instance by remote.i have done following steps..i included server and browser in exception list.turned off firewall .enabled 1433 and 1434 port in firewall..even after above steps i am not able to connect.i am getting error 26. can one help me in this regard. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-05-27 : 02:22:44
|
| 1)Are you using the correct SQL Server name?2)Is the Browser Service turned on?3)Can you ping the server, do a telnet session?DNS checks?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
Posted - 2011-05-27 : 02:31:45
|
| yes..browser is running.and i can ping that ipaddress from remte sys |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-05-28 : 01:49:02
|
| Have you tried from a number of clients? Is Vista the client you're using?Can you access the SQL Server instance from the server itself?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
sQL ERROR