sql-serversql-server-2008

SQL Server 2008 problem with Authentication

I try to login to SQL SERVER 2008 from another computer. The database name is MSSQLSERVER2008, TCP protocol is port 49172. The account is SQL Server Authentication.

  1. I read from an article here to login to the database engine from another computer. Server name is "tcp:10.225.3.137,49172" and it works. Here is the sceenshot:

enter image description here

  1. I try to login from another computer to this database with server name is "10.225.3.137\MSSQLSERVER2008" but it doesn't work. Here is the screenshot. However, with the same server name on computer that installed SQL SERVER 2008, it works.

enter image description here

Anyone here can explain for me please? And how to login to that database from another computer with server name is "10.225.3.137\MSSQLSERVER2008"?

Solution

  • Be sure that SQL server is listening on default port and is set up for remote access and firewall is set up for default port 1433 and TCP/IP connections are enabled.

    Looking at both images, it looks like it is not listening on port 1433 but 49172. Then change your connection to read:

    10.225.3.137,49172\MSSQLSERVER2008

    (you might prefix with tcp:)

    Note: I have an old series of videos on youtube if you kike to watch, that shows setting up SQL server express locally and then connecting from remote using a custom port (search for "AccuSQL installation" on youtube and you would see 4 parts of videos - part 3 or 4 was about remote connection).

    And BTW that is called an "INSTANCE" not database.