Because I can't connect to my database for the life of me! I've seen a few suggestions here on the emssage board and I've tried them all. Here's what I have in my config file <connectionStrings> <clear /> <add name="SiteDataConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\SiteData.mdf;user id=blah;password=blah" /> </connectionStrings> But every time I try to connect, I get this error 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) I've tried using "(loca)\SQLEXPRESS", I've tried using "LocalSqlServer\SQLEXPRESS", I've even tried removing the DataSource property all together so I can just attach. Nothing... Nada... bupkus. I'm trying to get this developed to a specific level first before I push it out there (and incure the extra cost of the db) but now I'm thinking they're somehow blocking this since I don't have the full SQL add-on??? or am I don't something stupid... again? Ah yes, I've tried it with integrated security, but I plan on using Forms Authentication so it doesn't make sense to useintegrated securityin the connection string. Thanks! Drew
Import the data in that DB to your DASP DB. Then use the SQL connect command shown in your CP. You can only connect with the method you're trying on your local box. But you can get the data from that DB into an actual SQL Server DB.
but that's my point. that's what I'm trying to do, connect to the db on the local box. I should have stated, I have my sitedata.mdf file in the App_Data folder of my site. I just want to connect to that db to do the basic dev of my site. Once i'm done, I'll purchase the full SQL server account and import that data, but I'm no where near that yet. Has anyone successfully connected to a SQLExpress DB on DASP? if so, have you already bought the SQL Add-On or can you access it like an Access DB?
Express isn't supported but you can do what you are aware of locally. You can also work with Access until your DASP SQL Server is available. Access tables are very easy to upgrade.
I'm aware that it's not supported, but I wasn't clear if that meant I just couldn't create a help desk ticket for the product, or if it's disabled completely. I'm not sure I understand your statement 'what you are aware of locally'. I figured I could use it to bootstrap my application but now I'm thinking it's not even installed (i.e. the mssql$sqlexpress service is running) and configured for tcp (default install is not). So that's why I was wondering if anyone has successfully connected to SQLExpress on DASP? I don't have msaccess installed and would prefer to avoid it if possible. Does it even work with the data tools in VS Express?
I'm trying to help, really, but I know some of this is getting confusing for you. The express versions of SQL Server are a service like the full versions. Currently DASP doesn't run the service for Express versions. The reason I mentioned Access is that any of the versions still work nicely in ASP.NET You can even create Access DB's on the server via code, in both ASP and ASP.NET As for the support in VS Express, I have no idea but you can dig through the Msft forums, lots of support there. Use my Google CoOp to do some Digging: http://www.google.com/coop/cse?cx=009244845836111659857%3Albvxsjj8mho
It's not confusing, I just needed a concise answer. The answer is that you don't run the mssql$sqlexpress service at all, that's concise. You don't "support" it could mean many things. There are many things that Microsoft doesn't support, but that doesn't mean it's not possible. However, itis IMPOSSIBLE on DiscountASP because the service isn't even installed. Personally, I wasn't even aware that it needed the service if we attach like an access db file so I learned a lot. In the end, I gave up and added a SQL DB to my account. However NOW I can't seem to figure out how to actually manage the database... (another learning curve issue for me). I'm used to the full blown VS versions and am trying to understand the experience from a startup entrepreneur / developers experience and compare it to the LAMP stack. So I'm trying to keep the costs as minimal as possible. So far I've only had to spend money on the hosting (web site + db), but I think I've hit a road block here. Unless I know all the osql commands to do it at the command line, I think I'm screwed. To be clear, I know DASP is by FAR one of the best hosters out there when it comes to ASP.NET (I know, I work for MS and have worked with hosters). That's why all my sites are with you. Kidos to you on that! You're not nearly as prominant in the field asyou should be. Your marketing spend doesn't reflect your proficiency... but that's good for me Anyhow, this struggle of mine is soley due to my own learning experience. I'm used to the full blown VS versions, full SQL, MSMQ, BizTalk, SharePoint and all that stuff. I'm trying not to leverage any of my freebies and only experience (and pay for) the things that a startup entrepreneur would encounter and things that I just expect to be there are completely gone! very frustrating! I welcome any responses from struggling entrepreneurs out there who'd like to clue me in and share their stories. However,I doubt many will read this thread now, so I'll post these new questions to another, more appropriate, thread. Cheers, Drew
Drew, I do what I can to help but I am not employed by DASP. Matter of fact, I'm a Stay at home Dad with no income at all. Salute, Mark
