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 RepliesWhen 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 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 have created my database in SQL Server 2005 Enterprise Edition and now planning to tranfer this databse to another server, But this other server is SQL Server Standard Edition, So if i try to attach my database which is created in Enterprise Edition will get sucesully connected to Standard Version ? or i will get any error message or i am doing something wrong ? This situation is fine or Version should be kept same ?
View 2 RepliesI have SQL Server Standard 2008 installed on my machine, alongside Visual Studio 2008.
My current hosting provider (not a huge fan) requires me to access my db's remotely via SQL Server Management Utility. To date, I've been doing it by connecting remotely in VS2008. Their troubleshooting documentation/steps, though, are for the SQL Server Management Express 2008, and i'm having a lot of connectivity issues with them.
I followed the steps here: [URL] to "add additional features to an existing installation" - but when I did so, the setup wizard indicated that the Management Tools-Basic were already installed.
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 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 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've created an application using ASP.NET with Access DB, now I found somee.com who support only SQL Server DBs, so Now I must convert my Access DB to SQL Server DB.
Is there any tool who can do the trick ?
This is some code I'm using in my web application :
Public Shared Function conecter() As OleDbConnection
Dim MyConnexion As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & System.AppDomain.CurrentDomain.BaseDirectory & "/Learning.mdb")
MyConnexion.Open()
Return MyConnexion
End Function
Public Shared Function lecture(ByVal requete As String) As OleDbDataReader
Dim Mycommand As OleDbCommand = conecter().CreateCommand()
Mycommand.CommandText = requete
Dim myReader As OleDbDataReader = Mycommand.ExecuteReader()
Return myReader
End Function
In this case, If I convert my database I must change the OleDbConnexion and other things or I can just leave them like that ?
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 ?
Currently my code resembles this:
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="CustomPanel.ascx.cs"
CodeFile="CustomPanel.ascx.cs" CodeFileBaseClass="System.Web.UI.WebControls.Panel"
Inherits="MyProject.CustomPanel" %>
...
namespace MyProject
{ public partial class CustomPanel : System.Web.UI.WebControls.Panel
{ ... }
}
However, I'm really not sure how to proceed from here, because this does not appear to follow a logical inheritance path that includes System.Web.UI.UserControl / Am I doing something wrong? How can I inherit Panel and extend standard event-handlers, such as PreInit?
How can convert DTS package from SQL Server 2000 to SQL Server 2005
View 2 RepliesI have a local database which is updated regularly. Now I need a good way to reflect the local database changes into the remote sql server. Both the server have same database structure.
All the above pocess should work automatically from the local database server because I need to update the remote one so that the website visitor can get the updated results in the morning.I need a detailed description/ procedure to accomplish the work.
I 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 have date in a text box in the following format "dd-MM-yyyy"How do i convert this into standard datetime format, i could do DateTime.Parse(txtDate.Text).Date but how do i define the current format of this date before parsing, i mean how do i tell the parser that this date is currently in the format "dd-MM-yyyy" usualy parser assume date to be in "MM-dd-yyyy" format i guess?
View 7 RepliesThis 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 RepliesI have created a server product that is connecting to some social network servers and sending to data which status update etc. The server already authenticated to necessary social networks servers by users who is using this solution.
Actually, I have no problem at this time, but I think I will.
My server will be open a thousands of concurrent request to neccessary servers via Http with C# HttpWebRequest instance. I already know that It's possible to change concurrent request limits with below propery.
ServicePointManager.DefaultConnectionLimit AFAIK, this limit is max 100 evet you set more than 100. So, I will be faced with bottleneck problem with HttpWebRequest even change the DefaultConnectionLimit property of ServicePointManager.
I have visual studio 2005 and sql server standard edition installed on my desktop. Im trying to get my head around the authentication and role administration part of visual studio controls.
At the moment Im using the browser version to configure the settings.
While im attempting to access the security tab to develope, users and roles i keep getting a message saying im unable to connect to the database. However, when i use my collogues PC with SQL server express installed it connects with no problems.
Does anyone have an idea how i configure this tool to use SQL server standard edition so i dont have to go back to express?
I have the following query, the relationship is mutiple pictures per dog and multiple dogs per registered User. the query below will return dogs that belong to users that have not expired. the problem is that some users have many dogs and other users only have one dog listed, the query below will return a record for every dog. What I would like to do is return a random dog per user and only one dog per user each time the query executes. therefore if I have 10 users and 50 dogs I would like my quesry to only return 10 dogs one beloinging to each user, and the next time the quesry executes it would be nice if it once again return 10 dogs but a different 10 dogs 1/per user where it was able..
[Code]....
I want to convert sql server 2000 database into sql server 2005 database. I am using sql server 2005 express.
I am trying by taking backup/Restore method, but it not work.
I 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.