SQL Server Management Studio - Error connecting to remote DB

991

Solution 1

I'm assuming you've remembered to include the instancename (server\SQLEXPRESS)?

Try to create an ODBC against the same server. If you get the same error; create another ODBC, but use regular "SQL Server" driver, and on the "Client Configuration" settings choose "Named Pipes".

Also, SQLChickens tip about making sure the SQL Browser is started on the server is valid.

Also, try using IP-address instead of the NetBios name.

Solution 2

If its a SQL Express engine you need make sure the SQL Browser service is running otherwise the client won't be able to see named instances on the server side.

Share:
991

Related videos on Youtube

Rajasekar
Author by

Rajasekar

Updated on September 17, 2022

Comments

  • Rajasekar
    Rajasekar over 1 year

    I have a search result which includes images. When the user hover over the image, the image should expand like we see in bing http://www.bing.com/images/search?q=world&go=&form=QBIR&qs=n . Please help.

  • Julien Poulin
    Julien Poulin almost 15 years
    I checked, this service is up and running.
  • Julien Poulin
    Julien Poulin almost 15 years
    I don't what was wrong but I tried everything you suggested and now it woks. Thanks a million.
  • Rajasekar
    Rajasekar over 14 years
    if i change the height and width it only crops and not the whole image is enlarged. Please help