asp.net connection string
-
hi i developed a website using asp.net c# and sqlexpress (2005). It works fine on my machine but when publish it to host i always take this error message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) My database files are in App_Data directory. I am accessing them from there. the host doesnt allow remote connections. I think the connection string can cause this problem but i dont know how to solve it. Here is my connection string: And for databases, i use windows authentication. Can it be about it? i dont know how can i create user for a database in App_Data folder. thanks.
-
hi i developed a website using asp.net c# and sqlexpress (2005). It works fine on my machine but when publish it to host i always take this error message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) My database files are in App_Data directory. I am accessing them from there. the host doesnt allow remote connections. I think the connection string can cause this problem but i dont know how to solve it. Here is my connection string: And for databases, i use windows authentication. Can it be about it? i dont know how can i create user for a database in App_Data folder. thanks.
Is SQLExpress installed on your host?
only two letters away from being an asset
-
Is SQLExpress installed on your host?
only two letters away from being an asset
Yes it is installed, they told me "use SQLExpress" before
-
hi i developed a website using asp.net c# and sqlexpress (2005). It works fine on my machine but when publish it to host i always take this error message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) My database files are in App_Data directory. I am accessing them from there. the host doesnt allow remote connections. I think the connection string can cause this problem but i dont know how to solve it. Here is my connection string: And for databases, i use windows authentication. Can it be about it? i dont know how can i create user for a database in App_Data folder. thanks.
check whelter you sql server allows remote connection or not... please check in sql server configuration manager and put enable tcp/ip also.
-
check whelter you sql server allows remote connection or not... please check in sql server configuration manager and put enable tcp/ip also.
It will not help, if i will change my sql server settings. Because the problem is when publishing website on my host. And my host does not allow remote connections with sql server. I am asking what my connection string should be to not make a remote connection.
-
It will not help, if i will change my sql server settings. Because the problem is when publishing website on my host. And my host does not allow remote connections with sql server. I am asking what my connection string should be to not make a remote connection.
ok may be you windows firewall is ON.If so, please OFF your firewall and then check.
-
ok may be you windows firewall is ON.If so, please OFF your firewall and then check.
How can i close firewall on host? :confused:
-
How can i close firewall on host? :confused:
i mean you have to close the firewall of the computer where your sql server resides.If your sql server is in the host computer, then you have to request them to close....or change some configuration in the firewall so that firewall recognizes your sql server.