| Author |
Topic |
|
barnabeck
Posting Yak Master
236 Posts |
 Posted - 2010-02-27 : 12:19:36
|
| A week ago I set-up IIS on xp professional, SQL Server 2008 and now I was working on a aspx page using datasourse connection. Everything worked pretty well... then after a normal debugging problem the IIS reported to me, I am not able to get any connection to a SQLDataBase back with ASP. The queries work fine being run on the SQL Server, and any other ASP pages would load. But I can't connect to the DB from ASp... any idea? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-27 : 13:08:24
|
| Password changed?Server name changed? |
 |
|
|
barnabeck
Posting Yak Master
236 Posts |
Posted - 2010-02-27 : 21:21:56
|
| No, no... nothing of these. I was working on the code... writing, reloading, writing, reloading... and then, the thing got stuck. Changed the page to the last working version, but since this happend, I can't get any dataconnection to sql run. As if the possibility to link asp to sql was switched off, without any error message |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-28 : 00:59:54
|
| SQL has to be set to allow remote connections, perhaps that got turned off (I've had the message that "Remote connections are not enabled" on SQL 2005 when it had crashed and needed restarting!!) but it seems unlikely that would have changed (I'm presuming this is all on one PC and that you are in control of it all - rather than some helpful Admin having taken it on themselves to reconfigure a server that is remote to you?!) |
|
|
|
barnabeck
Posting Yak Master
236 Posts |
Posted - 2010-02-28 : 08:59:28
|
| Well the SQL Server is running on that same localhost; actually I think it has do with the SQL Server Configuration, and I'm trying to figure out how the settings are supposed to be. Is it normal that the SQL Server Agent is stopped? I'm using the express edition and start or any other command than properties is greyed out. The services that are running are the SQL Server and SQL Server Browser |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-28 : 09:13:40
|
| SQL Express does not come with SQL Agent - so SQL agent "stopped" would be normal (and in any case should not stop you connecting to the DB) |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2010-02-28 : 16:12:45
|
| what error message are you getting. Also its best to use objectdatasource rather than sqldatasource in your code |
|
|
|
barnabeck
Posting Yak Master
236 Posts |
Posted - 2010-03-05 : 16:13:25
|
| africa... there was no error message. It started to load and than got stuck.In the meantime I was seeking for a probable misconfiguration in the sql server manager. But this made things worse:I changed the logon to a different account trying the build-in accounts, but ever since I did that I can not get the service back to running, even with the original account I had set-up the SQLEXPRESS some 10 day ago. It throws always the "cannot find object or property" error. I followed some hints I googled, clearing the certificate settings for the protocols, but nothing works. I guess it should be related to the accounts and I really don't understand which account should be running the SQL Service. I'm the only one on that computer, I have admin rights off course and don´t want anybody else to connect... so what would be the most likely setup. Why did it worked, and than, just after stopping the service I can not start it over again... really frustrating. sigh |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2010-03-08 : 06:48:22
|
| can you ping the server ???check your connection string, see this http://www.connectionstrings.com |
|
|
|
barnabeck
Posting Yak Master
236 Posts |
Posted - 2010-03-08 : 15:37:19
|
| No, as I explained, after touching the configuration, I can't get the server started... I will do a complete de-installation, although I loose my databases... grrr |
|
|
|
CSears
Starting Member
39 Posts |
Posted - 2010-03-08 : 16:14:26
|
| If you cannot get the server started, have you tried checking to see if the service is running? Sounds basic, but worth it rather than losing your data... |
|
|
|
barnabeck
Posting Yak Master
236 Posts |
Posted - 2010-03-08 : 17:42:44
|
| Well it definitely was not running, and the databases I just started to design... Anyway I deinstalled SQL.During reinstallation an error showed up "An error occurred during the installation of assembly 'Microsoft.SqlServer.ManagedDTS,fileVersion="10.0.1600.22",version="10.0.0.00000",culture="neutral",publicKeyToken="89845DCD8080CC91",processorArchitecture="MSIL"'. Please refer to Help and Support for more information."This is getting from bad to worse |
|
|
|
|
asp connection to sql datasource doesn't work