SQL Server does not exist or access denied error

sql-server-2005 sharepoint ms-office performancepoint
Sheehan Alam picture Sheehan Alam · Jan 12, 2009 · Viewed 7.1k times · Source

I have an application that runs fine when executed off the server. When clients try to connect, they receive the following error:

Failed to get data. *Data provider could not be initialized *SQL Server does not exist, or access denied

on my Office Web Components (MDAC). I am guessing there is some security or server configuration error, but I'm not able to pinpoint it. I am running SQL Server 2005.

*Note - clients can't change their security settings, company policy.

Answer

SqlRyan picture SqlRyan · Jan 12, 2009

When you try this from a command prompt:

TELNET servername 1433

What happens? If you get a blank screen, then SQL Server is listening and you've got something wrong in your client settings. If you get an "Access denied" or "no response"-type answer, it's most likely either a firewall issue or SQL Server isn't listening, but in either case, it's a server issue.

Related questions

The tail of the log for the database "DBName" has not been backed up

I tried to restore a database using the following query: ALTER DATABASE [DatabaseName] SET Single_User WITH Rollback Immediate GO RESTORE DATABASE DatabaseName FROM DISK = 'C:\DBName-Full Database Backup' ALTER DATABASE [DatabaseName] SET Multi_User GO but instead of restoring …

Read More
Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

Read More
Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? Select all data from BusinessLine into tmpBusLine works fine. select * into tmpBusLine from BusinessLine I am trying the same, but …

Read More