+ Post New Thread
Results 1 to 2 of 2
Wireless Networks Thread, sql network interfaces error 26 error locating server instance specified microsoft sq in Technical; Hi all, this is my first post so please be gentle. I have a problem connecting to an instance on ...
  1. #1

    Join Date
    Nov 2009
    Location
    Rotherham
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    sql network interfaces error 26 error locating server instance specified microsoft sq

    Hi all, this is my first post so please be gentle.

    I have a problem connecting to an instance on one of our sql servers.

    The sql server currently has a number of other instances on it which seem to be working fine, but this one instance is proving a little awkwards.

    I was able at one point to access the instance from sql management studio on my laptop, but then it was left for a while with no use and this morning I tried again and could not connect from anything outside the server.

    I have checked the services are running ok.

    I cannot ping the instance directly, but our server team guys can, I can still map a drive to the instance but that about all.

    Getting the error message 'sql network interfaces error 26 error locating server instance specified microsoft sql server' when I try to connect from the management console.

    is there any reason why it should stop working afte a period of time, and what could be causing this issue?

    Cheers

  2. #2

    Join Date
    Nov 2009
    Location
    Rotherham
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi all, I found the issue.

    We had not opened up the UDP port 1434, once that was opened it worked fine.

    Cheers

SHARE:
+ Post New Thread

Similar Threads

  1. FMS SQL Error
    By Rawns in forum Educational Software
    Replies: 6
    Last Post: 3rd June 2014, 03:18 PM
  2. Replies: 6
    Last Post: 2nd October 2009, 12:21 PM
  3. error: 26 - Error Locating Server/Instance Specified
    By Strotzyl in forum Wireless Networks
    Replies: 4
    Last Post: 14th March 2009, 02:46 PM
  4. SQL server VVS Writer error message....
    By flashsnaps in forum Windows
    Replies: 1
    Last Post: 8th December 2008, 08:59 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •