Hi every body, I had made a database in sql server2008 on server,i create the login for tat & assign it some roles,i want to connect this database remotely,i had made the following steps on the server 1- enable TCP/IP 2- restart the sqlserver 3- add exception to windows firewall,sqlserver(process) & oso port 1433 but when i try to connect from my sql server instance to tat remote sql server using the IP address of the server,Sql authentication,login & password i get the following error msg,
'A network related or instance specified error occurred while establishing a connection to sql server.The server was not found or was not accessible.verify that the instance name is correct and that sql server is configured to allow remote connection (Provider: Named pipes provider,error 40- could not open a connection to sql server)(Microsoft sql server Error, 53) '
i had searched a lot but nobody gave me a clean idea,plz help me in this regard