TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Fafeman
NA
3
3.4k
Error nº 26 - Sql server 2005 (Error locating server/instance)
Sep 26 2011 1:49 PM
Hi,
I am trying to connect a windows 7 professional client to sql server 2005 installed on a windows 7 professional. I am getting the error nº 26 "Error locating server/instance".
Both firewalls are disable.
The ping command works in both sides and I run the portqry command on the two computers and I get a successful result .
The Browser is running in a "Network service", the protocol
TCP/IP
is enable with tcp dynamic ports.
My string connection is:
"Data Source=Desktop\\xxx; Initial Catalog=SII; Network Library =DBMSSOCN; User ID=admin; Password=yyy"
;
Where
xxx
is the instance name and
Desktop
is the name of the server machine. I am using visual studio 2010 C#.
The Remote server connections are on. I have tried everything but the error keeps appearing.
In the server side, the program runs perfectly.
What can I do…I am losing my mind L
Thanks
Reply
Answers (
3
)
Guidence needed about SSRS
SSRS:Datetime functions in SSRS