August 23, 2011 at 11:48 am
In my SQL 2008, I setup Hide Instance=Yes from TCP/IP setting in order to make our DB be more secure.
But after that our application can not connect to SQL Server, even I use Management Studio in this server but I aslo cannot connect to SQL Instance, I get error 26.
Please help me what to do ?
Thanks
August 23, 2011 at 1:41 pm
The following would be of help to you.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 24, 2011 at 4:36 am
But I just have problem when I change "Hide Instance" to Yes. I don't have this issue before.
August 24, 2011 at 4:13 pm
Since this keeps the SQL Browser service from exposing it, I'm going to say that your application will need to provide the port in addition to the server name/IP Address.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 25, 2011 at 1:51 am
I find out the issue, I forgot port parameter in connection string. Now it's OK. Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply