Le 4 mai 2021, la plateforme Yahoo Questions/Réponses fermera. Elle est désormais accessible en mode lecture seule. Aucune modification ne sera apportée aux autres sites ou services Yahoo, ni à votre compte Yahoo. Vous trouverez plus d’informations sur l'arrêt de Yahoo Questions/Réponses et sur le téléchargement de vos données sur cette page d'aide.

Aaron a posé la question dans Computers & InternetProgramming & Design · il y a 1 décennie

SQL Server 2008 Express connection question?

I have a server which contains SQL 2008 Express, it has the default name of SQLEXPRESS with a database name Trentlink60. The IP of the server is 192.168.1.50. I also have a client computer which will contain SPC software utilizing the database I've made. I am able to successfully telnet 192.168.1.50 1433.

Now my question- When I install the software, according to the directions under the server name, they tell me to enter ".\SQLEXPRESS" (without quotes) for the server. When I install the software with that setting, it's unable to connect. Instinct tells me to put the IP/computer name in, but I am unsure if I should deviate from their directions.

Is that the reason why I can't connect?

Mise à jour:

The name of the computer is a random xyz-123456767 name. The SQL name is SQLEXPRESS.

2 réponses

Pertinence
  • il y a 1 décennie
    Réponse favorite

    Your instinct is right.

    There are 2 parts to the server name, seperated by a \

    machinename\databasename

    . is shorthand for localhost, so what you are using now is really

    localhost\SQLEXPRESS

    But that's wrong, of course, since the database isn't on localhost.

    Either of these should work:

    192.168.1.50\SQLEXPRESS

    xyz-123456767\SQLEXPRESS

  • il y a 1 décennie

    Try just "SQLEXPRESS" (without quotes).

    No IP needed as you can ping it.

Vous avez d’autres questions ? Pour obtenir des réponses, posez vos questions dès maintenant.