When trying to connect to the database engine with SQL Server Management Studio the server name doesn't show in the login box. I can reach Analysis Services but not database Engine. I also get “Access is Denied” error when I try to log in to the Integration Services.
TCP/IP is enabled and the Firewall contains a rule that allows SQL Server through port 1433.
Is there any way I can get the server to allow remote connection without using SQL Management Studio?
I should say that the Server is on a network and I have full access to it.
One more thing, when I run SQL Configuration Manger, I don't see the database Engine.
I see SQL Server Integration services, analysis services and sql server browser . I can stop and run each one of them.
But where is database Engine....??