February 22, 2010 at 8:47 pm
I have the same .net database application as my friend. The application connect to sql server database in the server (say Server2003, database HumanManage). Server2003 has two instances of sql server. The default instance is SQL Server 2000, the other instance is named instance of SQL Server 2005. Both instances has database HumanManage. Using the database application, we both try to login to sql server 2000 database HumanManage, and we both can login successfully. But, when we tried to login to sql server 2005 named instance in the server using the same user name and password, my friend has successfully login, and have access to database. But, unfortunately I cannot login, and the application show the message : “SQL Server does not exists or access is denied”. We both have the same connection string to connect to sql server 2005 name instance like this “Server=192.168.0.3\MSSQL2005; Database=HumanManage;uid=sa;pwd=aliansi”. By the way, I turned off my firewall.
Why this can happen ? Any solution ?
February 23, 2010 at 5:25 pm
Is the server listening on TCP/IP for the 2005 instance?
Joie Andrew
"Since 1982"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply