February 16, 2009 at 10:41 am
dear experts i am facing problem that when ever i try to connect sql server 2008 remotely i get error sql server does not exist
i have set following properties -> remote connection by right clicking on its instance.
have added port in exception portion of fire wall.
tcp port is enabled in sql server configuration manager.
i am giving ipadress\instance in username
then password in same machine on which sql server is installed it gives same message.
can any one guide me what mistake am i doing or how to resolve it???
February 16, 2009 at 12:51 pm
umer (2/16/2009)
i am giving ipadress\instance in username
Do you mean ipaddress\instance in the server name? Are you sure you have the correct IP Address and and instance?
Are you sure the user you are connecting with has been created on the SQL Server?
What is the exact error message?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 17, 2009 at 12:16 am
ok my problem has resolved i have set port number = 1433 in tcp/ip of configuration manager and it resolved my problem....
November 5, 2009 at 9:38 am
I have had similar connectivity issues.
Can connect locally on the box but not by IP.
Remote connections enabled but still no luck.
In Sql Server Configuration Manager, SQL Server Network Configuration, Protocols fo MSSQL Server,
you must enable the network protocol. i.e. TCP/IP.
Hope this helps someone out.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply