Cant get the connection from asp to sql server (to any db) I got installed asp express 2008 and sql 2008 express(with SQL MANAGEMENT STUDIO) installed on my machine. On the services.msc The sql server express the status is started. The sql server agent status is disabled and don't have the option to start. The sql server explorer status is disabled and don't have the option to start.
View 6 RepliesI am having trouble installing SQL Server on my system ... it appears to install ok but when I try to connect it using Visual Web Developer Express 2008 it will not connect and mentions something about versions. I downloaded the Northwind database to carry on with the tutorials .. this also asked me to download the MS SQL 2000 version which I tried and this also did not work, other versions include 2005 and 2008. When I tried to open the program through the programs file from "Start Menu" only the configuration manager folder is there.
I have also tried to install the trial version from the website but to no avail. Each time I have restored to factory settings on my laptop and it still fails to connect. I notice that when I restore to factory settings there are loads of icons where the uninstall window lists all of the programs and there is still SQL Server 2008, lots of Icons. I think that version 2008 came with the laptop as it is a business sony vaio sr vgn-sr46gd model with vista business.
SQL Server Express 2008 R2 installation is failed...plese see the error log ...i gave the password "sa"..please guide me Overall summary Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup. Exit message: The specified sa password does not meet strong password requirements. For more information about strong password requirements, see "Database Engine Configuration - Account Provisioning" in Setup Help or in SQL Server 2008 R2 Books Online.
View 1 RepliesI have run aspnet_regsql.exe beaucoup times and it creates the database aspnetdb.db. I have created it in my primary database connection and in the SQLExpress connection.
Then I open Visual Studio 2008 and run the ASP.net Web Site Configuration Tool. I click on Provider tab and select Select a single provider for all site management data. The provider shown is AspNetSqlProvider. A book that I'm reading says it should be aspnetdb.
When I click on the test link, I get the following message
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
In my book, it looks like the aspnetdb database should appear in the app_Data folder of my web site. What is supposed to put it there? Does it get moved from the SQL Server Data folder?
I am facing the error: Connection refused, When i am browsing any web page on my local machine.I even tried to browse the web pages in my default web site, but facing the same error.My machine is having visual studio. net 2008 and 2005. the data base I am using is Sql server 2005.The OS is windows xp sp 3
View 1 RepliesI have a datalayer that uses Linq to SQL , inorder to maintain properly I removed various references to the connection strings to be placed in the same location.
So used the base(ConfigurationSettings.ConnectionString[""].ConnectionString,mappingsource) in the dbml.designer.cs file.
But doing this we have to define the connection strings in the web.config of all the projects that are going to use the data layer.. instead is there a way where in I can define the connection strings in the app.config of the data layer project and have the dbml.designer.cs file to pick from this one place?
I just installed sql server 2008 R2 on my computer. I am trying to connect to sql server throught my C# code and everytime I run the C# program,
I get this 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "
The connection string that I used in my web.config file is
[Code]....
I am not sure what am I doing wrong, but I followed this article below step by step and still I am getting the same error
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
My instance name is MSSQLSERVER and the server that I am using is on my local machine and it has my computer name in it.
i have been trynig to have "ASP.Net Web Site Administration Tool" save all user information in my database , is that doable?
if yes, how i can have all those asp_tables in mine?
I am using sqlserver express 2008 (Microsoft Web Platform Installer) and visual studio 10 professionnel.
I am also using last Silverlight4_Tools.exe.
When i enter in Web Site Administration Tool / security I obtain this 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 in diagnosing the problem:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
When I try userprovider
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
I have VS 2010 professional. I am trying to open "ASP.Net Configuration" through Project -> ASP.Net Configuration.
It pops up the Notification about the ASP.Net Development Server localhost but doesn't open ASP.Net Configuration in the default browser.I clicked on the Root Url (by double clicking on the 'development server' at the right bottom from Notification Manager).
It throws following error
"An error was encountered. Please return to the previous page and try again."
Clicking on "How do i use this tool".It opened page with error.
Tool Has Timed Out
I need help making selections on my installation of SQL Server 2005 Developer Edition onto my Laptop (the only computer in my house). I need to develop a couple of different databases and use them from my Visual Studio applications. Then I will upload the SQL databases and the Web Applications to GoDaddy for deployment to general public.My question is that installation is asking me questions I honestly don't know how to answer because I am using a different SQL this time around after reformatting my hard drive"
1. Do I use Default or Named Instance?2. Do I use the Built-In System account or a Domain User account?3. If answer 2 is Domain User then I am in trouble because I don't think I have a Domain, and I don't know what one is. Where would I find the user name, the password, and the domain?
I have a major problem. I have windows 2003 serverm in it I have installed sqlserver and on it several databases that was published for months. Now, the windows 2003 server crashed and I cannot login ti windows anymore. What I have done is to create a new installation of windows and installed again the sqlserver...
Now, how do I get back the latest database from the previous corupted installation? I still have access to the files in the previous installation.
i am trying to install SQL Server R2 on my windows 2003 server (I downloaded the x64 version) but on the installation directory, just before i click next, to get the error, the path is as follows: C:ProgramFiles(x86)Microsoft Sql Server im not too sure if thats the problem though, just guessing, since i dont know anyother problem, and its a new server. I also tried multiple server restarts and still got the same error.
View 6 RepliesIn machine XPSP2, I tried to install SQL SErver 2005 express edition (downloaded from the microsoft site) - after mode selction form (Windows/SQL server authentication) - system restarted, automatically.Again restarted, Again restarted,Again restarted,Again restarted,a 1000 times or more.finally I unplugged the system from the UPS
View 2 RepliesI am working on the migration of the server. Our new server is Windows server 2008 with IIS7.0 I have a great difficulty in browsing the pages hosted in virtual directories. I have followed the proper steps of creating a virtual directories and converting them into applications. But when i try to browsing the pages of the virtual directory, i get the 404 error. Note: The .Net Framework 4.0 is installed on the server and the web applications which i am trying to configure in the virtual directories are developed in Visual Studio 3.0. Even the http://localhost also don't work.
View 9 RepliesWe had a website deployed on IIS server remotely say www.liveserver.com.
We recently decided to make a copy of the website internal to the organisation so we brought a server and copied all the code from live server and configured it and say it is http//archives-testserver.com
Everything seems to work fine but while navigating and clicking on certain module links within http//archives-testserver.com......the domain name is getting rewritten to www.liveserver.com and user is made to navigate on the live site. I wonder where this configuration is with in IIS...
I looked under properties under website identification and everything is referring it as http://arhives-testserver.com. also thr is a file called securityRedirect.inc and ifor handling errors and all the references have been changed and couldn't find anything in web.config.
I'm using Visual Studio 2008, and my database is SQL Server 2000.
I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.
But when I click OK, I get the error:
Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.
This issues has been driving me nuts. I am trying to follow the tutorial on [URL] I am trying to connect to a database in Microsoft SQL Server 2008. The way I do this is by right clicking on the "Data Connections" > Add Connection. Afterwards the Add Connection window comes up, I make sure my data source is "Microsoft SQL Server (SqlClient). And, I choose a server name; the only server I can choose is DomainSQLEXPRESS. The issue is when I go down to the "Select or enter a database name" drop down box, I do not see my database listed. I have also made sure in the SQL Server Management Studio that I have given my user all the privileges for the database. I know my explanation is kind of vague, but would anyone know the reason why I would not see my database?
View 3 Replies I am getting an error saying "ASPNET account is not present in this machine" when I try to install Sitecore on my machine after I installed visual studio 2008..
- My machine is running on windows XP sevice pack 3
- I installed Visual Studio 2008 and .NET framework version 3.5 SP1 on that machine
- I can see that ASPNET User group account Under Users and Groups and it doesn't have "Account is locked out" ticked under general tab
- Also I ran aspnet_regiis -i many times but didn't help; actually I red in one post that I should delete ASPNeT account first and run the script but still didn't help
- when I view http://localhost on IE I can view the ASP home page without any problem but Firefox asks me to enter user name and password.
Net Framework 2.0 Net Framework 3.5 and above, but not addobjects that I use when I use ajax added. Why can not I add the NetFramework 2.0.
View 1 RepliesSo bit the bullet and installed vs2010 finally. However, when loading an existing vs2008 project, I am getting this error: "The project type is not supported by this installation." the only thing special about this project is that it's a "web application projects" type. what I've tried so far are these steps, but none of these solve my problem:
(1) run "devenv /setup"
(2) regsvr32.exe "%ProgramFiles%Microsoft Visual Studio 10.0Common7IDEProjectAggregator.dll"
I have created a MSI file for my windows service but at the time installtion it is prompting set Service login for login name, Password and confirm password. So I am not able to install that service.
View 1 RepliesI changed my OS from Windows XP to Windows 7. I installed .net Framework SDK v2.0. Now i am trying to configure Asp.net Quick Start Tutorial. When i run ConfigSamples.exe in the Log file following details available.
AM 6:57:22 19 March 2010: [Begin Samples Configuration]
AM 6:57:23 19 March 2010: [Info] ConfigSamplesDll_DoTasks: Starting
AM 6:57:23 19 March 2010: [Info] Config_NETSDK_Detect: .NET Framework SDK installation (detecting): SOFTWAREMicrosoft.NETFramework
AM 6:57:23 19 March 2010: [Info] Config_NETSDK_Detect: .NET Framework SDK installation (found): SOFTWAREMicrosoft.NETFramework
AM 6:57:23 19 March 2010: [Info] ConfigSamplesDll_DoTasksWithGUI: Starting
AM 6:59:51 19 March 2010: [Info] Config_ASPNET_Detect: ASP.NET installation (detecting): IIS://localhost/W3SVC
AM 6:59:51 19 March 2010: [Info] Config_ASPNET_Detect: ASP.NET installation (not found): [Info] Config_ASPNET_Detect: ASP.NET installation (not found)
AM 6:59:51 19 March 2010: [Info] Config_ASPNET_Detect: ASP.NET installation (not found): IIS://localhost/W3SVC
AM 6:59:51 19 March 2010: [Info] Config_SSE_DNLD_Detect: SQL Express service instance (detecting): MSSQL$SQLEXPRESS
AM 6:59:52 19 March 2010: [Info] Config_SSE_DNLD_Detect: SQL Express service instance (found): MSSQL$SQLEXPRESS
AM 6:59:52 19 March 2010: [Info] Config_SSE_INST_Detect: SQL Express service instance (detecting): MSSQL$SQLEXPRESS
AM 6:59:53 19 March 2010: [Info] Config_SSE_INST_Detect: SQL Express service instance (found): MSSQL$SQLEXPRESS
AM 6:59:53 19 March 2010: [Info] Config_IIS_Detect: IIS (Internet Information Services) installation (detecting): IIS://localhost/w3svc/1/root,IIS://localhost/w3svc/AppPools
AM 6:59:53 19 March 2010: [Info] Config_IIS_Detect: IIS (Internet Information Services) installation (found): IIS://localhost/w3svc/1/root,IIS://localhost/w3svc/AppPools
AM 6:59:54 19 March 2010: [Info] Config_QUICKSTARTDB_Detect: Quickstart Database and User Registration (detecting)
AM 6:59:55 19 March 2010: [Info] Config_QUICKSTARTDB_Detect: Quickstart Database and User Registration (found)
AM 6:59:55 19 March 2010: [Info] Config_QUICKSTART_Detect: Quickstart Samples Previous Build (detecting): SOFTWAREMicrosoft.NETFrameworksdkQuickStartSetupRun
AM 6:59:55 19 March 2010: [Info] Config_QUICKSTART_Detect: Quickstart Samples Previous Build (not found)
AM 6:59:56 19 March 2010: [Info] Config_NETSDK_Detect: .NET Framework SDK installation (detecting): SOFTWAREMicrosoft.NETFramework
AM 6:59:56 19 March 2010: [Info] Config_NETSDK_Detect: .NET Framework SDK installation (found): SOFTWAREMicrosoft.NETFramework
AM 7:04:39 19 March 2010: [Info] Config_ASPNET_Install: ASP.NET QuickStart registration (installing)
AM 7:04:57 19 March 2010: [Pass] Enabling ASP.Net for QuickStart virtual directory. Command: C:WindowsMicrosoft.NETFrameworkv2.0.50727aspnet_regiis.exe -ir -enable.
AM 7:04:57 19 March 2010: [Info] Config_ASPNET_Detect: ASP.NET installation (detecting): IIS://localhost/W3SVC
AM 7:04:57 19 March 2010: [Info] Config_ASPNET_Detect: ASP.NET installation (not found): [Info] Config_ASPNET_Detect: ASP.NET installation (not found)
AM 7:04:57 19 March 2010: [Info] Config_ASPNET_Detect: ASP.NET installation (not found): IIS://localhost/W3SVC
AM 7:04:57 19 March 2010: [Fail] Config_ASPNET_Install: ASP.NET QuickStart registration (failed): ASP.NET QuickStart registration component could not be detected after installation
AM 7:04:57 19 March 2010: [Begin Samples Rollback]
Why am i getting Config_ASPNET_Detect: ASP.NET installation (not found)?
i'm getting error while installing sql server on xp sp2. i have already installed visual studio sp1. while installing sql server it install hotfix for xp KB942288-v3 and KB954550-v5 after show following error message. SQL Server Setup has encountered the following error: Object of type 'Microsoft.SQL.Chainer.Package.PropertiesTypeProperty' cannot be converted to type 'Microsoft.SQL.Chainer.Package.PropertiesTypeProperty'..
View 2 RepliesI have Sqlserver2008 setup. It is work in wndows Xp. But I have to Install it on Windows 7 ,during installation process it requires some patch and I am unable to get it.
View 4 Replies