When we create or install any database using Visual Studio - The database gets saved in SqlExpress instance.How I can see the list of all the database that are ins SqlExpress and how to delete any of those database?Is it possible using DOS ? I don't have SQL Server Management studio
View 6 Repliesvs asp2008 instance cant recognize the sqlExpress 2008 instance on my machine
I have wonder if you could try to help me with the fallowing issue:When trying to add a new sql server connection (local or remount) from VS(visual studio) 2008 express - on the add connection dialog
box: server name: are Empty!!
The vs couldn't point to any database, like dont recognize the sqlExpress 2008 instance i got on my machine.
1. Have tried to "play" with sa property's(from sqlS: Databases: security: login tree folder) and with the sql
s windows service: stop and restart
2. And so with the target db.
3.
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.
4. And so reinstalled the asp.
i desgin web site with sqlexpress 2008 now i want to convert it to sql standard enterprise i can or not? if it posible how i can convert my database from sqlexpress limit to sql server standard unlimit
View 4 RepliesI designed SqlExpress database for online store ( Asp.net).And these is tables
Department Table:
dep_Id (PK)
dep_name
dep_description
this has to be the longest day of my life!!! have been trying to fix this for 2hrs now!
I have installed on my machine the following:
1. VISTA Enterprise (UAC turned off)
2. MICROSOFT VISUAL STUDIO 2010 ULTIMATE (Visual Web Developer 2010)
3. MICROSOFT SQL SERVER 2008 R2
4. INTERNET EXPLORER 7
5. .NET 3.5 SP1
I have an web aplication and I am trying to attach a database to my App_Data folder and it gives me the error as discussed...
I have tried everything to changing the permissions of (sql, vs2010) folders and the owner of the folders to me. But I cant still attach a DB.
I have a server that doesn't have MSSQL, can I use the default SQLExpress database somehow on the server to store my provider information? Or do I need to use a different databse with custom providers?
View 1 RepliesI would like to use the Role Membership and User Security database as my application database too. That is, just add the tables and relationships required by my application's data access layer to the Membership and Roles Database to save on hosting fees, (I have to pay extra for having two databases instead of one). Of course, the connection string would have to be adjusted, but I don't see a downside considering the application's database is actually an Access database. What can I say, it was a requirement at the time.
Basically, I would like to do the opposite of this:
http://forums.asp.net/p/1162485/1925262.aspx#1925262
I used visual studio 2008 and sql server 2005(for database) in my website project. After finishing my project i used publish to web option and got the files into an folder. I have installed .NET framework ,IIS, i have also set the remote connection ,firewall setting etc. But when i run i.e., In the IIS manager when i click browse it gives me the following error. Can anyone pls tell me what went wrong in this. My code works fine when run on visual studio 2008. Server Error in '/EBUSINESS' Application.
View 1 RepliesI added "MvcMusicStore.mdf" to my project. I corrected my connection string in web.config. [Code]....
How do i create DB in my ./sqlexpress because when i look it with SQL Server manegment studio,
i don't see the database and the tables that are created in my mdf file.
Current Web.Config
View 4 RepliesI have just developed a website with VS 2008, ASP.NET 3.5. It contains a long range of pages and one contact page. The contact page is connected to a SQLExpress database, where details about all the visitors' requests are stored. The website works fine at the development environment, but when I deploy it to the internet host, the Contact page will not open any longer, due to all sorts of problems with the database. I have the database files located in the App_Data folder under the main directory for the website.
I have tried with all kinds of connection strings, setups, etc. - to no avail. I have also tried using the ISP's tool for creating a new database with the intention of copying the original database to it. But when I use the Publishing Wizard and generate a SQL script, then the Web Administration Tool for the remote database won't run the script. Now my question is, plainly: Is there any step-by-step procedure I can use, if I want a data-enabled website. It seems incredible that it has to be so frustratingly difficult. Basically, what I need, is:
* A database, located in the App_Data folder, to store all information received via the Contact.aspx page.
* All visitors of the site should be able to post messages on the Contact.aspx page.
* I have got the information from the ISP that I can connect to MSSQL via the server "host55.nethotel.ccSQLEXPRESS".
If a general procedure can be advised, and some directions about how exactly the database should be set up with authentication, rights, etc., for such a - supposedly ordinary - system, then I will be grateful for any information - or somebody who could point me in the right direction of a solution.
I created web form which gets data from local database (SQLEXPRESS). It gives me an error when I publish the website. I can upload regular aspx page into my site. It works fine. How can I publish data-driven web form into my website?
View 8 RepliesI'm trying to create a database within the app_data folder of an asp.net mvc project using the IDE, but i am getting a "Required Components Missing" message indicating "Connections to SQL Server files (*.mdf) requireSQL Express 2005 ....."
I am using
- Windows 7 Enterprise
- VS2008 Team System SP1
- SQL Server 2008 Developer Edition SP1
I have altered the database connection to use the default instance by setting to blank using
Tools -> Options -> Database Tools -> Data Connection : SQL Server Instance Name
I also note from the SQL Server Books Online that the user instance feature will be removed in the future, but for now it suits my effort in developing an application where a number of people are working on the project.
Has anyone managed to create a database in the same manner?
IDE: MS Visual Studio 2008 / SQL Server 2005 Express / SQL Server Management Studio Express 2005
Skills: BeginnerI was trying to delete a table from my database ASPNETDB.MDF ,that DB was previously used for User login information i made it by using asp.net built in login support by opening ASP.NET configuration ,but now i want to built my own simple login control...so i want to remove all the tables made by ASP.NET configuration.I got this error when deleting one of the table"Could not drop object 'dbo.aspnet_Applications' because it is referenced by a FORIEGN KEY constraint"
i am trynig to connect to sql server 2005 express with Web Site Administration Tool in visual studio 2008 but i got this error in security tab: 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: 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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
i have already checked following links and done all hint but nothing [URL] i have MSSQLSERVER running but i can not run SQLEXPRESS
So I've intalled SQL 2005 Express and Sql Server Management Studio Express (SSMSE). I don't have any problems connecting to it using Windows authentication. But I would like to set it up so that I can log in using Sql Server Authentication with a username and password.
But I'm getting an error message of "A connection was successfully established with the server, but then an error occured during the login process. (provider: Shared Memory Provider, error: 0- No process is on the other end of the pipe) (Microsoft SQL Server, Error: 233).
What I've done
I've created a new "Login" in the Security node. Provided all necessary role access level. Granted permission to connect to database and enabled login.
I've used the Sql Server Surface Area Configuration to set the Remote Connection type to "Using TCP/IP only" or "Using Both TCP/IP and named pipes" (tried both, but in either situation I get the same error message when attempting to login to SSMSE with the user name and password). I also made sure to restart the service.
I have a id in label1 ...
on button click i want to delete the data of id from database ...
I have a site witl forms authentication using te login control. I altered my sql server, I added a connectionstring and used the connectionstring in both, <rolemanager> and <Membership>. That part of the web.config is listed below.
The problem is that the login control goed to SQLserver to check the users and their passwords, but it goed to the SQLExpress database for the roles.....
[code]...
I have created roles and users using ASP.NET configurations for login validations, it works fine if I run my application within project but when I publish my site and try to run from my Inetpub it giving this error. I tried all shorts of solutions posted in website but nothing worked for me.
"Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed"
I recently found out that you can only do full text indexing with the advanced series of SQL Express and I managed to download and install it on my machine. My question is how do I integrate it with Visual studios 2010 so that I can do the full text indexing ?
When I installed SQL Express with advanced series 2008, it created an instance of SQL Server management studio so im wondering if I have to do it there and then move the database into my project or if I can do the full text indexing from inside my project
i have added to my web.config page this instruction:
<globalization culture="en-GB"></globalization>
all the dates in my web page are formated as dd/mm/yyyy but my database is still under mm/dd/yyyy is there a way to also change the format of sqlexpress to dd/mm/yyyy ?
How to write a Sql Query for insert, Delete for Image from sql server 2005.
View 2 RepliesI am using sql server 2005. In my project i wanna auto delete the data from the database after a fixed interval of time say (30 days); Is there any automatic process to delete the data from the database without the user intervention..
View 19 RepliesI'm having a gridview in my aspx page with checkbox, User can select one or more than one record(s) at a time and clicks on delete button, Then i'm constructing an object of my DTO and adding all the checked row's Primary Key (DataKeyNames - GUID's in case) to a serializable class and generating an XML and sending it as parameter to the Stored Procedure.
My Doubt is, can i bulk delete all the rows from database table those are present in my XML document??
If it works, I can do bulk update with XML only, i already did bulk insertion by generating an XML..
My Another Question is, Will it affect the performance? Each time when i construct an DTO object and adding it to the Generic List??
WHich one is better, I mean ObjectDataSource or SQLDataSource or my XML method?
My XML will be like this
<root>
<Customer>
<CustomerID>GUID1</CustomerID>
<CustomerID>GUID2</CustomerID>
<CustomerID>GUID3</CustomerID>.....
This is my House_p table
Iamge3 Image2 Image1 Name ID
3.JPG 2.JPG 1.JPG SARA 1