Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Markuu
Starting Member
9 Posts |
 Posted - 2007-11-14 : 12:29:02
|
| Hi everyone.I built my page using Visual Web Developer 2005 Express Edition. I made a new database (let's call it dbname.mdf) in the App_Data folder. It's populated with data, and when I run my site on my local machine, everything works fine. All the SELECT and INSERTs work as expected.So, I copied all the files on my C: into the httpdocs folder on my webpage. Now it seems my connection string doesn't work anymore. Do I have to change something when I put it online, even though my database is still in the App_Data folder? Should I try and put the .mdf right into SQL Server 2005 that comes with Plesk 8.2.0 (and how do I do that?)This is the error message I get: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)SORRY FOR THE LONG QUESTION! Any help is greatly appreciated!! |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-11-14 : 12:37:59
|
| this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.this says to me, check your SQL SERVER settings for allowing a remote connection.[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
Markuu
Starting Member
9 Posts |
Posted - 2007-11-14 : 14:21:14
|
| I don't know where my SQL Server settings are. I thought ASP.Net had a built-in "SQL Server Express", and just put the database in the App_Data folder. Where would I look for this? I am using Plesk 8.2.0 For Microsoft Windows, and ASP.Net Enterprise Manager. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-14 : 22:16:52
|
| Did you see sql services in services applet on the machine? |
|
|
|
Markuu
Starting Member
9 Posts |
Posted - 2007-11-16 : 15:37:28
|
| I am not sure of using services applet on the machine, I was using the SQL Server Express in Visual Web Developer Express Edition. Then I moved all my files over to my webserver, and do not know how to change the SQL settings on there anymore :( |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 00:37:24
|
| Does your web server have sql installed? Copy db files over doesn't make it sql server. |
|
|
|
Markuu
Starting Member
9 Posts |
Posted - 2007-11-17 : 15:59:05
|
| Ya, it has MS SQL Server installed.MySQL databases quota 28.0 KB 40.0 MBMicrosoft SQL databases quota 1.68 MB 40.0 MBThat is what it says when I log in. I have 1 MS SQL database, but I do not know where to change settings for it.. cause it uses ASP Enterprise Manager for its webadmin, and that program is useless :( |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 21:01:15
|
| Can you see that db in ssms on the server? |
|
|
|
|
|
|
|
|
Trying to get ASP.Net page up. SQL Server problems