SQL server doesnot exists or access denied

[rupaliannetsite]

Hi,

I have C# application and SQL Server database.
This application runs fine locally however when migrated to production server it gives "SQL server doesnot exists or access denied" error message.

Need help urgently

[bikerchick]

can the new server "see" the SQL database? can you check via enterprise manager, or by setting up a new ODBC connection?

I've had a little trouble with this in the past, one of the reasons was that the SQL server was unavailable, and needed turning back on(!!), and the other was that it needed to be configured (using the SQL "Client Network Utility") to use "named pipes" as TCP/IP didn't seem to allow me to connect.

[bikerchick]

Also, if integrated authentication to SQL is being used, check the account that the application is running under, check that SQL is configured to allow access to that account.