May 25, 2009 at 3:23 am
Hi Experts,
when i try to connect named instance remotly to sqlserver dev edition
iam getting following error
error - --When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote
connections. (provider: SQL Network Interfaces, error: 26 - Error )
can you please give your valuble solution to solve this issue
Thanks in advance
May 25, 2009 at 4:09 am
Is it set to allow remote connections?
Try sp_configure or surface area config.
Cursors never.
DTS - only when needed and never to control.
May 25, 2009 at 5:49 am
Also ensure the appropriate protocols are enabled. You can check these using the SQL Server configuration Manager under SQL Server 2005 Network Configuration.....Protocols for MSSQLSERVER.
May 25, 2009 at 8:04 am
....Also make sure that SQL Server service is started..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply