Sharing A SQL Express Database Between Applications

Feb 7, 2007

Hi;

I have an ASP.NET application with a SQL Express database.
Here is the connection string used on the web application:

"Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|admindata.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"

Now, i create a Windows application which will run on the server to perform some scheduled tasks, for the Windows application I used this connection string:

"Data Source=.SQLEXPRESS;AttachDbFilename=D:WebSitesmywebsite.comwwwApp_Dataadmindata.mdf;Integrated Security=True;User Instance=True"

The problem is, when the web site is running and using the database, the windows application can't connect to the database and i don't know where i'm doing wrong, if it's the web application connection string or, if it's the windows application connection string.

I hope someone had the same experience and can point me to a direction.

Thank you;

Emerson Brito



 

View 7 Replies


ADVERTISEMENT

Sharing SQL Server Express Among Workgroup

Sep 27, 2005

Hello -- Please excuse my extreme newbieness -- trying to get up to speed fast on SQL Server Express for work. I've been able to set up the software, create a database, and access it with no problems on my local computer, but I need to make the database available to other computers in my workgroup. I followed instructions -- enabled TCP/IP and Named Pipes and turned on SQL Server Browser, and I was actually able to manipulate one system database (the "master" database) from another computer but not any other databases, not even the other system databases. I can connect to any of the databases with the SQLCMD commands, but if I try to do any SELECT commands (other than in "master") I get an error: "SELECT permission denied on object '[MyTable]', database '[MyDatabase]', schema 'dbo'". I was only able to get into "master" after adding "guest" as a user, but adding this user to the other databases has no effect. One interesting thing: When I used the sp_table_privileges command on each database, all but "master" showed all privileges being granted to and from "dbo", but "master" didn't show anything being granted to or from anybody. Does anyone know what could be going on here? Am I missing something obvious? Thanks for any and all help!

View 1 Replies View Related

SQL Express Db With Both Win / Web Applications

May 17, 2006

I have a SQLexpress db that i would like to be able to access from both a windows app and web app (both running on the same machine) at the same time.  Is this possible. I've been able to connect either one or the other, but not both at the same time.
Thanks   

View 1 Replies View Related

SQL Express And Windows Applications

Apr 26, 2006

I have a windows application that uses a small MySql as its data source. I would like to convert it to SQL Express. I would like to continue to manage the data from the windows application, but would like to make it available to the web using Visual Web Developement. I can create the new database in VWD, but how do I access the data from my application? I can use either ODBC or ADO.

View 1 Replies View Related

Is Sql Server Express Edition Enough For My Web-applications?

Apr 28, 2008

Good morning,After long hours of search on the subject, I could not find a clear answer to my question.I understand what are ths physical limit fo the express version (1Gb or Ram, 4Gb database, 64 bit WOW).My configuration is as follow, windows webserver 64bit, I have 4 database of 10Mb each for 4 web-application. The maximum concurent connection  is a total fo about 8 for all the web-application together.Therefore due to the cost of buying a workgroup of standard license, I was hoping to be able to  use the express edition.Please let me know your thought.ThanksArno

View 6 Replies View Related

Develop Multiusers Applications With SQL Server Express

Feb 3, 2006

Can I develop applications with SQL Server Express that I have more than one user in several computers working with the same database on a server, or I can only develop applications with only one user with a local database with SQL Server Express?

View 3 Replies View Related

Using Sql Express Databases With Windows Forms Applications

May 17, 2006

Hello all,

I would like my newly converted to .NET 2.0 Windows Forms application to use an Sql Express database instead of MSDE. Previously, development was done on the default SQL Server instance using the full SQL Server 7.0. When deployed, MSDE was used with a named instance. The connection string in the application settings needed to be modified as part of the deployment. Now I've converted to .NET 2.0 and to Sql Server 2005, and/or Sql Express.

What I'd really like to do now is have a project within my solution that, when built, creates the database by running scripts, and deploys that database to the output directory of the executable.

I want this to run as part of a continuous integration solution that, so that every so often, the entire project is checked out, built (code and data), all is copied to a bin/[debug,release] directory, unit tests run, etc.

Has anyone done this successfully? Any pointers?

Thanx,

WNC

View 3 Replies View Related

Is SqlServer Express Good For Desktop Applications?

Mar 21, 2007

Do you believe that SqlServer Express can work absolutely without any administration?
That is to say: my clients are people without any technical knowledge and they usually communicate never with me.
Is SSE the correct database for this status, or should I use a desktop database like VFP or Access?

View 4 Replies View Related

SQL Server Express Starter Kits (Sample Applications)

Aug 30, 2007

When I registered SQL Server Express I received an e-mail back showing all of the resources available to get started. There were 6 Starter Kits available, Teacher, Colection Manager, Amazon Enabled Movie Collection, and three others. When I click on the links to download the Starter Kits, the link comes back as invalid. Can you provide the correct links to use to get the Starter Applications, or can you e-mail me code? Thanks for you attention to this matter.
Charlie Cappello
CIGNA

View 5 Replies View Related

Is It Possible To Send Message From SQL Server Express To Applications Using It On Different Machines ?

Mar 8, 2008

Hello,

Is it possible to send message from SQL Server Express to Applications using it on different machines ?

For example When an important record is inserted or updated, a message appears on Application user's screen.

If yes then how ?

Thanks

View 3 Replies View Related

Sharing A Database - Authentication!?

Apr 17, 2007

I am writing a DB-driven application, using Visual Studio. I have a database that i want to be able to move from one computer to another, and still be able to access it. It's probably something simple, but I must be missing out something.

The problem is that if i choose windows authentication, then the DB cannot be used on another computer. I also had no luck when using SQL Authentication.

How can this be done? What form of authentication should be used and how, so that I can just copy my DB from one computer to another, then log into the DB using a username and password?

*Any* help would be greatly appreciated!

View 3 Replies View Related

SQL Server Express Starter Kits And Sample Applications Downloads Links Are Bad

Sep 22, 2007



1. The download links shown below for the Starter Kits found at this URL do not work:

http://msdn2.microsoft.com/en-us/express/aa718396.aspx


Teacher Starter Kit
VB http://msdn.microsoft.com/vstudio/eula.aspx?id=4d31bb50-22da-411f-b747-a7b2288fc720
C# http://msdn.microsoft.com/vstudio/eula.aspx?id=06b20449-cbba-4f2f-ab8c-b99c1266cc7e
Collection Manager Starter Kit
http://msdn.microsoft.com/vstudio/eula.aspx?id=98c8074d-d28e-49e1-be44-94f0114f372a
Club Web Site EventCalendar control source code
http://www.asp.net/starterkits/downloads/eventcalendar.zip

2. None of the download links shown below for the Sample Applications found at this URL work:

http://msdn2.microsoft.com/en-us/express/bb403187.aspx


Internet Explorer Favorites Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=3bdccf1b-88c6-45a6-9dcf-7499ad664dab
Skills Manager Sample

http://msdn.microsoft.com/vstudio/eula.aspx?id=09305c92-890f-4dc7-a20d-f58b611d23c7
Survey Manager Sample

http://msdn.microsoft.com/vstudio/eula.aspx?id=98171070-e0f6-4fcd-948e-9c5af497ab4f
Help Desk Sample

http://msdn.microsoft.com/vstudio/eula.aspx?id=009e3b2d-98b1-46dc-8476-676a2519eafa
Reports for Web Sample

http://msdn.microsoft.com/vstudio/eula.aspx?id=79610b4f-fc7e-4ca8-9ae2-8ca8a5a6de0d
Reports for Windows Sample

http://msdn.microsoft.com/vstudio/eula.aspx?id=9c9a8d75-58b1-4be7-91be-50fefbe5d28c

View 2 Replies View Related

Sharing Data Between Website And Internal Database

Sep 26, 2007

I am in the process of designing a web application for our application that will be available to the general public.Basically will be used to collect information for a case report. I need to know if there is a way from our internal database driven application to push certain data up to the website that the database may be behind a firewall so I cannot make a direct connection to the external database. I thought I heard about some sort of data sharing protocol. I then will be storing the users entered data in the website database and pulling it from the internal application. So basically I need a secure way of sending and receiving data between a server/client app on a LAN system to the Web site database that could be hosted outside the LAN.
 I hope this made sense.

View 4 Replies View Related

Delete Database File On Server -&> Sharing Violation

Oct 17, 2007

Hi,I have some database files (.MDF, .LDF,...) on the server. When I tryto delete them, the warning "Cannot delete file: There has been asharing violation. The source or destination file may be in use."appears.Since I am new to the environment I don't know where the files comefrom and where they might be used.Can anybody tell me what to do to delete those files?Thank you.

View 36 Replies View Related

Sharing Website(asp.net) Mdf Database On A Network In Multiuser Environment

Sep 19, 2007

simple question:

I have create a web site in visual studio with form user authentication. Thats create a mdf database in this path:

c:inetpubwwwrootwebsiteapp_dataaspnetdb.mdf
thats use Sql server

i would like to access this database with c# form application on a network with multi-user.
if i change the drive letter of the path above to f: (mapped drive) or \serverc, i got this message


System.Data.SqlClient.SqlException: The file "h:InetpubwwwrootwebsiteApp_DataASPNETDB.MDF" is on a network path that is not supported for database files.
An attempt to attach an auto-named database for file h:InetpubwwwrootwebsiteApp_DataASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

i read that sql server did not support database sharing with mapped drive or unc share.

So how can i share website database with c# application???

Note: of course if i develop the website and the application on the same machine its work. I want this application run on several work station accessing all the same mdf database with his web user member.

View 7 Replies View Related

Unique Database For Various Applications?

Oct 18, 2007

There is a possibility of a unique database for various applications. Example users of a table that has the name, email, registro.Uma application included in a user table and other application also included in this table.

View 2 Replies View Related

Possible To Deploy Website Applications Using MDF Database File?

Nov 26, 2007

Hi,A quick question, is it possible to deploy a website on a shared hosting environment which attaches to a MDF database file stored in the App_Data folder? 

View 1 Replies View Related

Two Different Database Belong To Two Different Applications Stay In The Same Server

Aug 17, 2000

Hello....

Does anyone know if two different database belong to two different applications stay in the same physical SQL server 7.0 with one server license would affect their performance?

Would the performance be better off if each database stored in different physical SQL Server 7.0 with different server license?

Thank you in advance!

View 1 Replies View Related

Multiple Report Server Instances Sharing A Single Report Server Database

Mar 30, 2007

I would like to know if it is possible to have different applications on separate report servers sharing one report server database. If so are there possible issues or ptfalls to this type of architecture?



Thanks,



thecoleman

View 3 Replies View Related

Sql Data Sharing

Sep 17, 2004

Hey guys,

I have a quick question about SQL 2000 server data sharing.

I am currently using SQL 2000 Server Enterprise and I need to do synchronous data sharing with flat files. I have an ODBC connection to the files. I was able to easily share this data by using linking in Microsoft Access, however, for the life of me I cannot figure out how to do the same in SQL. We are in the process of converting legacy code. The old code will of course be communicating with the flat files and the new code will be talking to SQL server. So it is vital that the 2 access methods are both pulling the same data. Does anyone have any ideas???

Help would be greatly appreciated
Thanks
Dax

View 3 Replies View Related

Sqlsever Sharing

Jan 21, 2008

hello sir
i have sql sever 2000 installed on my PC which i would like to share on network.
when i am trying to create ODBC connection from other pcs on network i am getting error -- specified sql server not found.
pls help me
gayatri

View 4 Replies View Related

Sharing Remotely

Jul 11, 2006

Can you use SQL Express remotely instead of locally.

I have been told that I might be able to use SQL Express as my network server for sharing files. Is this possible, or do I need a different version of SQL to do this?

I have been reading the VBE forums and from what I gathered was that SQL Express is only for a local table only, is this true?

If not, what is the work around, and how do I go to another pc to find out if it is sharable?

I would hate to get several months in my app design and learn that I was headed in the wrong direction.

Thanks

David

View 8 Replies View Related

Sharing Stored Procedures

Feb 6, 2004

How can I share stored procedures so I can call them form different databases ?

Basically, all databases have identical table names and structure but containing different data and I don't want to replicate all stored procedures on every database. There are too many and will also be very unpractical to maintain the code.

Thanks,
Moshe

View 4 Replies View Related

Sharing Tables Between .MDF Databases

Jan 2, 2006

Hi :)

I would like to know if it is possible to link two databases together
(in my case ASPNETDB, and another mdf database) so that I can run
queries on those shared tables. For example, I would like to use the
uniqueidentifiers from the ASPNETDB tables in my own tables.

Thank you!

(I do use the latest version of Visual Web Developer).

View 3 Replies View Related

Non Sharing Data Cluster

Jul 20, 2005

Hi:I'm trying to setup a MS Cluster but I don't know if it is feasible toconfigure it in the way I think.I have two machines with win2k server and MSSQL-2000 one of them iscurrently performing as the production database and the other one isthe backup. The secondary one is keeping updated via the "LogShipping" technic.We almost covered all the other possible failures of the othercomponents (ie: network, power, application servers, etc), the data ismaintaned in a raid which is ok but we want to cover also thepossibility of that failure too (yes, you can call us paranoids!! ).The thing is we want to create a cluster that do not share the data,but each machine of the cluster have thei own set of the same data.My intention is to configure the cluster to detect a failure of onemachine and initiate the failover to the remaing one using theappropiate scripts related to the promotion of a secondary serverkeeped updateusing "log shipping".Have anyone some experience with that kind of solution ??Thanks in advanceLeonardo

View 2 Replies View Related

Sharing Multiple Reports

Oct 30, 2007

Hi,


Can we share and schedule whole report folder(not just one report) by using management studio?

Thanks

View 1 Replies View Related

Sharing ASPNET.MDF Between Multiple Apps

Sep 27, 2006

Hi guys,I've got two apps that are going to have pretty much the same users and i wanted them to have the same ASPNET.MDF user database. Is it possible to store the ASPNET.MDF in a different location and then have the two apps access it from there or alternatively have it in the App_Data folder of one of the apps and then have the second app access it from there?Thanx

View 2 Replies View Related

Multiple Databases Sharing Device

Jul 14, 1998

Does 7.0 allow multiple databases to share a data file/log file?
Will a large data device file shared by 10-25 databases present any problems?

Thanks

View 2 Replies View Related

Replication, Workgroup, And Sharing NT Login

Nov 15, 1999

Would someone please tell my how to share the same NT Login on a Publisher and a Subscriber Server. For example, one of
the requirements for Replication is that the Publication Server and
Subscription Servers should share the same SQL Executive account. I tried
doing this in Control Panel, Services Applet, Startup, and This Account Box. The Subscribing Server is not allowing me to map the login of the Publishing Server. I also tried within NT User Manager for Domains. I am not able to figure this out. I am trying to get Replication to work within a Workgroup on two NT 4.0 Servers SP3, with SQL Server 6.5 SP5a.

Thanks, Kevin

View 2 Replies View Related

Sharing A Dataset In Multiple Reports?

Sep 26, 2007

I'm looking for some advice on how to manage reports that use the same query in their datasets. I have multiple reports that use several datasets that are the same. If I need to make a change to one dataset, I need to remember to update the other datasets. Of course I don't always remember to do that!

Is there a way to create a dataset in a single location and then share it? I was thinking of using a View but I don't think it'll accept the parameters.

I've been cutting & pasting the entire query as I make change but I'm afraid it'll mess that up or forget to update a dataset.

How do you do it?


Any suggestions you have would be helpful.

Rob

View 7 Replies View Related

Sharing An SSIS Package With Other Developers

May 31, 2007

I have read a number of threads in this forum concerning SSIS packages and Protection Level. I regret to say that I did not manage to find one that covers the problem I am experiencing.



I have saved a package that contains a SQL Server Authentication login and password. In Properties for the Package I have set



ProtectionLevel = EncryptSensitiveWithPassword



I then save my Package and use F5 to run it in Visual Studio 2005 Team Edition. It runs just fine.



I then walk over to a co-worker's desk, have him "Get Latest Version" in Source Control Explorer, and then have him double-click on the SSIS Package. It indicates that he must enter the password, which we do, and then it begins validation of the package. By changing to EncryptSensitiveWithPassword (instead of EncryptSensitiveWithUserKey) many of the earlier error messages went away.



We still get one fatal error, though, which prevents him from pressing F5 to run the package on his PC. The error message is one reported in some other threads in this forum:



Error loading PackageName(C2097).dtsx: Failed to decrypt protected XML node "DTSassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.



Naturally we are running this on a computer different from the one on which the package was created/last-saved, and running with a different Windows user.



The package is a fairly simple one: it merely copies a few dozen tables from Access to SQL Server 2005 on a central server.



Might the error message be related to the Access connection? (He has the same rights to the Access database that I do, but those are based on Windows Authentication -- which makes me wonder if that might be the problem. The Access database is located on a central server, and the access rights are controlled through User Groups in the Windows File System.)



I would like for others to be able to run this and other SSIS packages I have developed.



Ultimately we would like to store completed SSIS packages in the File System (rather than in SQL Server 2005), and allow anyone in our team, who knows the password(s) for the packages, to run them without difficulty.



Is this possible?



Dan

View 12 Replies View Related

How? Sharing Configuration Info Among Packages

Mar 7, 2007

Ok, I understand it is possible, but I still can't quite get the mechanics of it to work.



I create a new BIDS project, and add a package to it, and add 3
connection managers, and set the server, instance, DB, etc. for SQL
connections. I change the name of each connection manager so the server
name is not there, but use something more like a generic name of what
the database is. Fine. I right click in the Control Flow area and go to
configurations. I enable configurations, and save to a common place on
the C drive. Save everything, exit, VS, fine, and I export all
connection managers properties.



Then I start Visual Studio again. Create another new BIDS project, add
a package to it, and add 3 connection managers. I don't actually
connect them, but use those same generic names from the first
iteration. I enable configurations for the package. I am somewhat
expecting to see the connections change from the same-o-default to the
data I used in the first go around.



I am obviously missing something big here.

View 3 Replies View Related

Sharing An Encryption Certificate Between Servers

Apr 17, 2008

Hello,

We have a couple of databases set up, and we replicate data from certain tables between the two database. One of the tables we replicate is the Users table, in which we'd like to encrypt user passwords. Initially I created a certificate on both servers, and found that I could not DecryptByCert a password that was encrypted on the other server, and vice versa. It looks like all I was forgetting to do with supply a 'ENCRYPTION BY PASSWORD = ' parameter to CREATE CERTIFICATE. So, now I have the following:

CREATE CERTIFICATE Cert_UserPassword
ENCRYPTION BY PASSWORD = 'pGFD4bb925DGvbd2439587y'
WITH SUBJECT ='TestingCertificate'

I ran that query on both of our servers, and I find I am able to decrypt the password on both servers. So, as far as I can tell, this is exactly the way I want it to work.

So, now for the question: Is this the right way to go about it? In order to decrypt the password on either server, it means I need to pass the 'pGFD4bb925DGvbd2439587y' password to the DecryptByCert command, which doesn't seem very secure. But if I don't use the 'ENCRYPTION BY PASSWORD', then the cert will be signed by the Master key, which is different on both servers, which will result in a certificate that can't decrypt what was encrypted on the other server.

Is there a way to take the actual certificate on one server, and export it to the other server, so that they're both using the exact same certificate to encrypt and decrypt? I would like to not have the password included in the Decryption command, if I can help it.

Thanks.

-Dan

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved