sql-serversql-server-2008-r2odbcwindows-server-2008-r2hyperion
SQLServer Error: 18546 - SQLState 28000
I have a 3-level application running. WebServer IIS7.5 and SQLServer 2008 R2 Express Database and OS WinServer 2008 WebEdition.
When I try to connect via ODBC from a PC on the network have this error.
Remote connections with MSSM (Microsoft SqlServer Managemet Studio) work properly. I want to use this ODBC to connect Hyperion to SQLServer
Can you help me?
Solution
I resolve to enable TCP/IP service in SQL Server Configuration Manager.
After this , if problem persist disable firewall on private/domestic net and try again.
- Audit table update trigger does not work using a stored procedure
- Entity Framework | Sequence contains more than one matching element
- How can I alter column name in Sql server
- How to partition into batch of records with max batch size limit
- LOAD DATA INFILE error in MySQL
- Cannot perform an aggregate function on an expression containing an aggregate or a subquery with STRING_AGG
- Perform a row count of each table in my list of tables
- Entity Framework Core 3.1.6 Item With Same Key Has Already Been Added
- Split a string with no delimiters into columns
- Each GROUP BY expression must contain at least one column that is not an outer reference
- Add custom columns to pivot table
- Parameterized raw sql query much slower than query with actual values
- SQL Server database backup restore on lower version
- Add a value on their SESSION_CONTEXT for all sys.dm_exec_sessions
- How can I create a unique constraint on my column (SQL Server 2008 R2)?
- Summation of a column using certain conditions
- Natural join in SQL Server
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to Renumber Set/Subset of Table Based on Numbering of A Second Table
- Using Azure Devops deploy release to multiple repos
- SQL Server Cursor vs WHILE loop
- SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
- Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
- SQL-How to Insert Row Without Auto incrementing a ID Column?
- Why can't I use an alias in a DELETE statement?
- Can ransomware encrypt a mounted SQL database? Hypothetical
- Grant user DDL permissions on specific schema
- How do I perform a GROUP BY on an aliased column in SQL Server?
- Collecting data from a joined table based on condition(s) in the joined table
- Stored procedure for auto generating roll no?