November 22, 2013 at 6:33 pm
I'm getting the following error when i try to connect to the Northwind database in SSMS 2012. The wizard can find the server but not the databases.
The error message i'm getting is below. I've also attached a picture.
TITLE: Connection Manager
------------------------------
Test connection failed because of an error in initializing provider. Login timeout expired
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
TCP Provider: No connection could be made because the target machine actively refused it.
------------------------------
BUTTONS:
OK
------------------------------
November 22, 2013 at 6:48 pm
I was getting this error because the service wasn't started. I went to Administrative Tools Services and I made sure the services were started. Even though it as set to automatic, evidently that didn't mean it was running.
November 23, 2013 at 10:52 am
Are you inputting the right server/instance name?
Is the service for SSIS run?
Under which account it is running? check the account permissions.
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com
November 23, 2013 at 2:47 pm
Everything seems to be fine Igor. I just needed to start the service.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply