SQL Server is configured to allow remote connections

4 votes

1 answer

38432 views

sql-server ssas visual-studio-2012 tabular-model

                          I use SQL Server 2012 and SSAS Tabular Mode (My Instance Name Is MSSQLSERVER2012T)

Then I download AdventureWorks Tabular Model SQL Server 2012 From This link 

I open it with Visual Studio 2010 and configure my Instance Name like this picture :

When I deploy my project I have This picture : 

But after one minute I get this error : 

And when I click on Details Of Error I get this message :

    OLE DB or ODBC error: Login timeout expired; HYT00; 
    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.; 08001; 
    Named Pipes Provider: Could not open a connection to SQL Server . ; 08001.

    A connection could not be made to the data source with 
    the DataSourceID of 'a16b8d9d-3811-4be1-91e7-a9d0a2df4d38', 
    Name of 'SqlServer localhost'.

And

But it not work for me???

In my SSAS one Database was created like this picture :

Asked by Ardalan Shahgholi (457 rep)

Jan 28, 2014, 07:40 AM
Last activity: Oct 5, 2015, 12:07 AM

SQL Server is configured to allow remote connections

Related Questions