Web Hosting Forum | Lunarpages

Author Topic: How to set up MSSQL Express DB?  (Read 11757 times)

Offline dhawk

  • Newbie
  • *
  • Posts: 3
How to set up MSSQL Express DB?
« on: February 17, 2011, 05:51:36 PM »
Anyone know how to set up an MSSQL Express database?

I tried simply uploading a working site from Visual Web Developer Express (including the database in the App_Data directory and the unchanged connection string) to my LunarPages website, and got the following error:

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: 26 - Error Locating Server/Instance Specified)

What am I missing?

Thanks,
Dave

Offline Lucky:)

  • Space Explorer
  • ***
  • Posts: 7
Re: How to set up MSSQL Express DB?
« Reply #1 on: March 07, 2011, 09:49:29 PM »
Hi dhawk,

I'm not sure, that express db can be uploaded to the server.

Can you create backup file in express?

Offline annaharris

  • Spacescooter Operator
  • *****
  • Posts: 46
    • PHP Development Comapny
Re: How to set up MSSQL Express DB?
« Reply #2 on: May 07, 2013, 04:18:24 AM »
Check out below link which contains helpful information about How to setup SQL Server Express. http://msdn.microsoft.com/en-us/library/ms143722%28v=sql.90%29.aspx

Offline MrPhil

  • Senior Moderator
  • Berserker Poster
  • *****
  • Posts: 6207
Re: How to set up MSSQL Express DB?
« Reply #3 on: May 07, 2013, 04:45:36 AM »
If this is for a shared server, it might not be permitted (excessive resource usage). You should check with support. On a VPS it might be permitted, and certainly on a dedicated.
Visit My Site

E-mail Me
  
-= From the ashes shall rise a sooty tern =-

Offline davidssmith01

  • Newbie
  • *
  • Posts: 4
Re: How to set up MSSQL Express DB?
« Reply #4 on: July 07, 2016, 02:41:35 AM »
To create a new data source from a SQL Server database file using the Add New Data Source command

    *On the Data menu, choose Add New Data Source.

    *Select Database on the Choose a Data Source Type page.

    *Select New Connection to create a new data connection.
   
    *In the Choose Data Source dialog box, select Microsoft SQL Server Database File. Click OK.

    *The default provider is .NET Framework Provider for SQL Server. For more information, see Choose/Change Data Source   Dialog Box.

    *Enter the path to the database file you want to access, or click the Browse button to locate the database file.

    *Select the authentication mode and login information required by your database. For more information, see Add/Modify  Connection (Microsoft SQL Server Database File).

    *Click OK, and then click Next.


Note:
If the Data source is not Microsoft SQL Server Database File, then select Change to open the Choose/Change Data Source dialog box


<spam link removed>
« Last Edit: July 07, 2016, 04:25:19 AM by MrPhil »

 

Share |