Connection properties vs. SSMS server properties

  • I have an ODBC connection string that is working fine with the following properties:

    Database="XXXXXXX",Network="YYYYYY"; strangely no server is specified in the string, but it is specified in the ODBC Connection file.

    I am trying to do a new server registration in SSMS for this database.

    However, I don't understand where the network spec is placed.

    Under Registered server name I've tried:

    \\YYYYYY\XXXXX

    When I browse the server for the database instance list, I receive "network path was not found".

    I even tried:"XXXXXXX",Network="YYYYYY" for the registered server name.

    Same error message.

    What am I doing wrong ?

  • Maybe it's using the IP address. Try that. In general, you won't use the database name to connect from Management Studio. Just the server name. It's also possible you're AD login doesn't have permission to the server.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • A session today our focus will be on who and hell's and the topic is called cells each diet and will also be talking out the are sound English-language the RR sounds are as in rounds and rock so at our focus I we're going to wait a minute for some participants to T-Advance[/url] joins check your audio check your camera are and up back in just a minute okay so I let's get started with topic we're talking about diets we’re talking about something called sows Beach diet each okay the South Beach Diet so this is tied diet each he I ET right that where theclinton or chat so that everybody agents yet be ok okay I'm not getting the clinger chat doesn’t seem to be working today some going to be riding.

    You can easy contact, visit this site >>>>>>> http://www.optimalstackfacts.org/t-advance/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply