Able to access SQL express remotely using SQL mgt Studio after certain configuration.
But notice that I must use IP address/SQLEXPRESS for server name in order for connection to work. What is this "/SQLEXPRESS" ? Is it a standard surfix for SQL Express ?
I have installed the Oracle Transparent Gateway on the machine with SQL Express and setup the tnsname for SQL Express. For the tnsname, have used IP address/SQLEXPRESS as the host name but it gave this error :
ORA-28545: NCRO Failed to make RSLV connection
Tried with just the IP address and it gives the same error.
Any idea ? ? Help !
Hi,
What is this "/SQLEXPRESS"
That si the instance name, as you can deploy several instances (liek in Oracle on one machine, with the difference that one instance can have more than one database :-) ), the instances are bound to a port, if it is not the default port (1433), you have to specify it, either within the connectionstring are in your Gui.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||I check the SQL Server configuration manager and it shows that the instance name is MSSQL.1. So which one is the instance name ?
No comments:
Post a Comment