The parameter is incorrect, SqlException (0x80131904)

0

I'm trying to upload my ASP.NET MVC project to my website, I managed to upload it via "Publish" option in Visual studio, and then, I opened a database on GoDaddy's website using Plesk ( both my host and the database is on GoDaddy ), and trying to change the web.config to that:

<add name="DefaultConnection" 
     connectionString="data source=HOSTIP;uid=DATABASEUSER;pwd=PASSWORD;database=DATABASENAME" 
     providerName="System.Data.SqlClient" />

and then I get this error:

[Win32Exception (0x80004005): The parameter is incorrect]

[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)]

System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +357
System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +79
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource
1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +201
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +156

I tried to find some more information on the internet related to this issue, but I also get the error: "[Win32Exception (0x80004005): The parameter is incorrect]", So perhaps the whole syntax of my add tag is wrong?

c#
asp.net
asp.net-mvc-4
asked on Stack Overflow Sep 30, 2019 by Dorki • edited Sep 30, 2019 by Dorki

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0