Remote SErver
-
How can i connect to a sql server(2005) which is out of network. I couldnt see the display of my server name to be conected in the list of servers, it has to be registered.
I have authentications with ip address,server name,domain and sql port
-
Are you just trying to connect to a remote instance of SQL server on a different port? If so, create an alias for the server in the SQL Server configuration manager and you can then register the server is SSMS.
Tommy
Follow @sqlscribe -
I tried creating alias but acces denied.
-
Can you telnet to the server? i.e. Start -> Run -> Cmd -> telnet MYSERVERNAME 1433
Tommy
Follow @sqlscribe -
yes i can do a telnet
-
Are you getting the access denied error message when attempting to create the alias? i.e.
Tommy
Follow @sqlscribe -
yes, when i click apply i get
WMI Provider Error
Access Denied(0x80041003)
-
The WMI provider objects are wrapped by SMO. Perhaps an issue w/ the installation of SSMS? What build are you running? Take a look at http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx
Tommy
Follow @sqlscribe -
If your ping and telnet works , then you will be able to access your sql server without issues but you need to use only SQL Server account and not your windows account to login to the server. also in the server check if remote connections are enabled.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply