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.
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?
The name of the computer is a random xyz-123456767 name. The SQL name is SQLEXPRESS.
2 réponses
- RatchetrLv 7il y a 1 décennieRé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