aspnetdb.mdf will it work ?

[hobkirkweb]

Hi

I have developed an asp.net app using visual web developer 2008.

It works fine on my development system but when uploaded to plesk it bombs out with SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I am using this db for bog standard user logins.

Will it work or am I wasting my time ?

regards

[Alfred]

Hello,

Aspnetdb.mdf file is system database file and attaching database file is not supported on Shared Server.

I'd recommend you to follow these steps to get your DB working :

1) Create a blank MSSQL DB from Plesk control panel.

2) Take a backup of your old DB in .BAK format & upload the BAK file into your webspace.

3) provide us the exact location of your DB-BAK file & update your connection string with the new DB details.

4) [We will get the DB-BAK] restored into your blank DB properly, once done, you can access the DB through your scripts.

In a word, the reason that we get this error message is the client stack could not receive SSRP response UDP packet from SQL Browser. It's easy to isolate the issue. Here are the steps:
1) Make sure your server name is correct, e.g., no typo on the name.

2) Make sure your instance name is correct and there is actually such an instance on your target machine. [Update: Some application converts \\ to \. If you are not sure about your application, please try both Server\Instance and Server\\Instance in your connection string]

3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server (not always true).

4) Make sure SQL Browser service is running on the server.

5) If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception.

Regarding Connection String, you can refer below Connection String in web.config file.

<add name="String_name" connectionString="Data Source=Server IP\SQLEXPRESS;Initial Catalog=DB_Name;User ID=DB_USER;Password=DB_PASSWORD" providerName="System.Data.SqlClient" />


Cheers..
Alfred.