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 |
|
JosephMollek
Starting Member
2 Posts |
 Posted - 2009-06-08 : 23:16:45
|
| Hi to All,1- I developed a Web Site using MS VS 2008 Standard Edition, embedded in it SQL 2005 Express and SP1. I faced difficulties in publishing the ASPNETDB.MDF Schema and data to the remote server of the internet hoster. So, I un-installed SQL 2005 and installed SQL 2008.2- VS Standard Edition didn’t see the database and I started getting many error messages.3- I un-installed VS and SQL and installed the new Web Platform 1. The Visual Web Developer still doesn’t create neither ASPNETDB.MDF database nor the connection. I get the following messages.A- In the security section of ASP.NET Configuration of any new web site, I get the following message. There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. Unable to connect to SQL Server database.B- I allowed Port TCP 2077 and Port UDP 2078 through windows Fire Wall.C- In SQL Server Configuration Manager, I enabled the protocols: Shared Memory, Named Pipes and TCP/IP.D- In SQL Server Configuration Manager: SQL Server(SQLEXPRESS) Running. SQL Server Agent(SQLEXPRESS) Stopped. SQL Server Browser. Stopped. I couldn’t start them because all menu items are dimmed.In summary, neither VS Standard Edition nor V Web Developer 2008 express, generate the default database, ASPNETDB.mdf.I would sincerely appreciate any help.Joseph. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-06-15 : 17:21:35
|
| In the course of trying to kill the fly, ...Sounds to me, you shot yourself in the foot.The best approach to solving this problem is 1. What do you intend to achieve with your site, esp the db.Personally, i would never recommend an mdf database, unless its for a small project.But, moving on... to get your db, back go to the wwwroot and open your site, and in the app_data folder, your mdf should still be there.SOLUTIONDepending on what you want to achieve, reinstall VS and setup your db. I can take you through the step by step process of getting your db up and running and publishing it to the remote server, either if you choose to use SQL2008 or express edition. But i recommend SQL2008 rather than express. |
 |
|
|
JosephMollek
Starting Member
2 Posts |
Posted - 2009-06-23 : 23:00:49
|
| Hi Afrika,I decided to discard the old Web Site and to re-build a new one. So, I un-installed VS 2008 and re-intall it again. I bought and installed SQL 2008 Developer Edition. The installation completed, however, at the end I got the following message. Analysis Services: Failed. And no information as to how to fix this problem.Whenever, I build a new Web Site, using VS 2008 Standare Edition and SQL 2008 Developer Edition, and try to access the database, I get the following message:(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 in configured to allow remote connections. (provider: SQL Network interfaces, error: 26- error Locating Server/Instance Specified))In the Security Section of the Web Administration Tool, I get the following error: (There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database.)I would sincerely appreciate your help.Joseph. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
|
|
|
|
|
|
|
SQL & Visual Studio