How To Packaging A SQL Server Database For Installation As Part Of A Custom Application
Sep 30, 2005
Hi all, How to package sql server database as part of our custom application (VB application) using install shield or any software. That setup should detect the presence of sql server. If sql server is not present in the client machine, then our set up should install the sql server and deploy our database. If sql server is present in the client machine, then our set up should install our database alone. How to do that. Please help me. Regards, S.Sevugan.
View 1 Replies
ADVERTISEMENT
Mar 6, 2008
I have a 14GB database thats needs to be sent to a vendor.
I'm just curious of different ways of packaging the database to be sent.
FTP is too slow.
CDROM is to small unless split up.
Any suggetions guys working with data of this size?
thanks,
Jonathan
View 14 Replies
View Related
Nov 16, 2005
I know that by default asp.net 2.0
creates the aspnetdb sql express database for storing membership, role
management, profiling etc. And I saw we have the aspnet_regsql tool to
have this installed in a standard sql server. But what should I do to
have these stored procedures, tables etc installed in an existing sql
express database? Aspnet_regsql doesn't seem suited for that.
I've noticed some sql scripts in the framework folder like
InstallCommon.sql, InstallMembership.sql, etc. They seem to be used to
create the regular aspnetdb.mdf database, should I just modify those
and run them against my own sql express database or is there a tool or
an easier way?
Cheers,
Frank.
View 1 Replies
View Related
Jul 16, 2006
I have found a lot of info on MS site regarding installing SQL Server 2005 Express as part of an application. I have found these articles to be extremely inaccurate or at best incomplete.
1. The documentation says all I need is the setup.exe from SQLEXP but this is not true.
2. When I do launch setup.exe during my app's install, it fails because setup.exe trys to run the support.msi. Of course this causes failure because my install is also an msi.
So, does anyone know how to install SQLEXPRESS as part of my app's install?
Thanks.
View 1 Replies
View Related
Sep 4, 2000
Hi forlks ,
I am stuck.
I have a product which is made in visual basic and using sqlserver 7
as backend. Now the question is how do i bundle this product along with the sqlserver 7 so that when the user inserts the Install CD, both the product and the database gets installed.
help in this matter would be greatly appreciated..
regards
vikas methta
View 2 Replies
View Related
Mar 13, 2006
A month or so ago I instigated this thread- http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=243117&SiteID=1 which talked about how to conditionally add a column to my component depending on the value of a custom property. If the custom property is TRUE then the column should appear in the output (and vice versa).
Bob Bojanic said I should use the SetComponentProperty() method to do this and that is working pretty well. However, it bothers me that SetComponentProperty() could be called, the column will then be added, and then the package developer could press 'Cancel'. In this instance the value of my custom property would be inconsistent with the presence of the extra column.
How do you get around that?
Thanks
Jamie
View 3 Replies
View Related
Dec 28, 2007
I've configured a min. of two drives.. C and D.. we typically install
the database files on d.. ie: d:datasql databasesinstancenameshere
When i run setup.. i let it pick the defaults.. then afterwards i
change the default database path to D:
Is there any reason NOT to do this..
IE: choose this path d:...sql when i click advanced during setup..
and have the program files placed there too.. IE: master db's etc
too..
(does having a seperate backup of the master database files even matter, ie: if reinstalling say on a different box or even the same box, dont these need to be recreated from scratch anyway?)
What are most doing.. with multi logical drive letter installs?
Cheers
View 3 Replies
View Related
Aug 28, 2001
Hi,
I made my own DTS custom task with Visual Basic 6.0.
The DTS custom task work but when i delete it from the DTS package
a mmc.exe application error occur about written memory.
I trie an other DTS custom task that i dowloaded from this site, the
same error occur.
My SQL Server version is the 7.0 with Service Pack 1.
Many thank's for advance
Stephane
View 1 Replies
View Related
Feb 21, 2008
how do i re-install the uncdms.dll application? anyone know? hmm
View 4 Replies
View Related
May 24, 2007
I have some changes I want to make to an existing cube - that is, I'd like to add some Measures and Dimensions to the Team Foundation Server cube. I would like these changes to be applied in one quick process, where the system administrator can just run an MSI that makes the changes.
I looked at XMLA but there doesn't seem to be much support for making incremental changes to the cube. Is AMO the way to go? How have people dealt with this in the past?
Suggestions appreciated,
Paul
View 1 Replies
View Related
Jun 3, 2014
1) We are providing a e governance solution for an organization,where we are providing a centralized database,Client have provided 5 Database server for the same.how can we position the Database Server? there are 5000 Concurrent users and 25000 users,SAN Storage for approx. 60 TB,Database size of 2 TB and growth of 1 TB every year
2) How many instance can we have for above said Case?
3) How much RAM Required ?
View 0 Replies
View Related
Aug 29, 2007
Hello Experts,
I am relatively new to VB 2005 and SQL Express. I have a question concerning where I can find the SQL-database file (*.mdf) after I have installed (published) my VB 2005 database-application (the *.mdf file was created by Visual Studio Express?). It seems it is nowhere in the disk of the of pc it is installed on. So, what happens to *.mdf file after installation of the application, in what way I can connect to the *.mdf file after the application - the file is part of - is published?
In need of help,
MY
View 5 Replies
View Related
Oct 16, 2007
When I try to install SQL server 2005 developer edition I get an error about:
Application popup: setup.exe - Application Error: The application failed to initialize properly (0xc0000005). Click on OK to terminate the application.
I have Cisco security agent and Symantec AntiVirus running on the machine, so they maybe interfering with the install. Unfortunately, I cannot shut them off.
Any ideas on what is causing the issue and how to verify that is the problem? Thx.
View 3 Replies
View Related
Apr 8, 2015
My company is migrating all their servers to a new data center and I get to specify what we need for the db servers.
We've got a 22 prod servers (mainly physical) with a couple of TB of data on sql 2000 to 2012.
We expect to move to sql2014, and consolidate and virtualise where ever possible.
But I'd like start with specifying an overall architecture for this: some Best Practices to guide the build at a server and an installation level
View 1 Replies
View Related
Aug 3, 2007
I have a SQL server database that I am trying to connect to from VS2005 in the Server Explorer.
I am not using the standard port for my SQL server listening port and I don't see where I can tell the Server Explorer to use a different port?
Can someone point me in the right direction for connecting to my database?
Thanks.
View 2 Replies
View Related
Apr 3, 2008
Hi,
I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error.
Here is the error:
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Here is the Environment:
App Server:
Windows Server 2003 Standard Edition
Inside Company's Firewall/ Network
Database Server:
Windows Server 2000 Advanced Edition
SQL Server 2000 SP4
Remote Connections to the Server is checked
Enable Protocols: Named Pipes & TCP/IP
TCP/IP Port: 1402 (I don't know why it isn't the default of 1433)
The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition.
I can ping the db server from the app server using the IP address.
I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server).
I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP?
What do I tell the network admin to change?
Any help would be appreciated.
Thanks,
Oran
View 4 Replies
View Related
Sep 10, 2006
Hi All, I will shortly (hopefully) begin devleoping an ASP.Net web application to let users manage a remote sql server 2005 database (kind of like the php myAdmin tool for MySQL databases). Were not talking a server managament tool for DBAs, more an end user tool for managing personal databases (it seems that web hosting companies provide tools for MySQL, but if you use SQL Server, you're stuck unless you have management tools on your PC - and what about mac users?).Given that premise, what features should i attempt to include? Creating and modifying tables structures and data is an obvious inclusion, but what else? I also haven't yet decided whether to go about this using scripts or using SMO. I've read that SMO is backwards compatible across versions of SQL Server...how true is this? are there issues or is it seamless? Please post any comments or thoughts you have, and thanks for taking the time.
View 4 Replies
View Related
Nov 24, 2004
hi
i want to develop a web application that use SQL Server Database, i have installed SQL Server & VS.NET in my local computer and i'm ready to develop, but before getting started, i want to know how i will upload mydatabae in my host,
actually i want to know should i know the settings & properties of my host that support SQL Server, or without know them i can devekop my apploication and after developing localy with just a few tasks upload my ( Sql Server) database?????
i'm worry actually about this, plz say what you know about this.
thanks
View 1 Replies
View Related
Jan 15, 2008
Hello.
I have my database and client application. I want my application to know (and to do certain things) when something has happened to a database (for example a row has been inserted). By means of what can it be done??I hope this forum is right place to ask such questions. Thanks for replies!
View 7 Replies
View Related
May 20, 2004
How to connect to SQL server database from Oracle 9ias Application Server (9.0.3) & Test & Verify the Connection. Is it posible.
View 1 Replies
View Related
Jun 23, 2007
I need some opinion about coping data tables from auto-generated ASP.NET database into SQL 2000 database.
View 2 Replies
View Related
Apr 21, 2008
Hi all,
I think I can do this, just want to check
Can I have an sql server database (mdf file) on a server and allow windows applications at different site manipulate the database.
As far as I am concerned the only thing that needs to be configued is the connection string..is this correct.
[i would rather use windows applications rather than asp pages]
If I can, the best way to manipulate the database is to use stored procedures. How would I do the following to create and execute the following proposed procedure:
Insert data into a table
Update another table as a result
Execute the store procedure on a form to execute these two statements
Thanks in advance
Peter
View 5 Replies
View Related
Dec 5, 2005
Server Error in '/' Application.
Database 'C:INETPUBDEMO.TRUTHSTONE.COMAPP_DATAASPNETDB.MDF' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
Hi,
Strange one. I have copied my working web-site to the production server and get this message.
Tried copying new set of database files and reset the server to ensure no applications could be accessing the database files. Still get the same error.
Works fine on my Visual Studio VWD Express version.
Mitch
PS I am not trying to upgrade the database, just use it!
View 1 Replies
View Related
Sep 13, 2006
I have been programming an application with VC++ 2005 and SQL Server 2005. I have converted an old 16-bit database to 32-bit managed code and SQL server and the application seems to be good. Now I want to deploy the application to another server for testing.
I have installed XP SP2, Windows Installer 3.1, Net framework 2.0 and SQL Server 2005 express to the test server. I have transferred the application with WI 3.1 and the program works well in the test server till the first SQL command. I have made a back up of the database and restored it in the test server. In the test server I can log in the database with Server Management studio and I can read the data there correctly. I have enabled both named pipes and TCP/IP for the database in the test server. With Surface Area Configuration I have enabled Local and Remote Connections Using both TCP/IP and named pipes. I only need Windows authentication at this time.
After all this when I come to the first SQL command in the application on the test server I receive the error message:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 Could not open a connection to SQL Server).
My connection string to the database is:
'connection->ConnectionString = "Persist Security Info=False; Integrated Security =SSPI;"
"Data Source=TESTSERVER; Initial Catalog=TESTDATABASE;";'
When I use "Data Source=DevelopmentServer", the application works well on the development server.
Can't understand what is still wrong. Can you possibly have an answer for me?
View 4 Replies
View Related
May 9, 2007
Hi,
I have been trying to install SQL Server 2005 developer version on my second laptop IBM Thinkpad Windows XP PRO, for the first time. All other components installed successfully except the database. I 've tried selecting the named instance and default instance it didn't make any difference. I have a Admin role on the laptop and as a service id I selected my user id. password and domain. I am running the setup behind my company's firewall.
The error in the log is :
Doing Action: Do_UpdateETWMOFWithGUID
PerfTime Start: Do_UpdateETWMOFWithGUID : Wed May 09 11:07:46 2007
<Func Name='Do_UpdateETWMOFWithGUID'>
Calling installSqlEvent Trance
The arguments that are passed to InstallSqlEventTrace are InstanceName: SQLSERVER2005 , ProductCodeL: {2373A92B-1C1C-4E71-B494-5CA97F96AA19} , BinPath: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn
INFO: Checking installed version
INFO: Writing MOF file
ERROR: Unable to open registry key: HRESULT = 0x80070005, Key = SYSTEMCurrentControlSetControlWMISecurity
The value returned is -2147024891
<EndFunc Name='Do_UpdateETWMOFWithGUID' Return='1603' GetLastError='0'>
PerfTime Stop: Do_UpdateETWMOFWithGUID : Wed May 09 11:07:46 2007
Gathering darwin properties for failure handling.
Error Code: 1603
MSI (s) (88!E0) [11:09:48:898]: Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered an unexpected error while Updating Installed Files. The error is: Fatal error during installation.
Error 29528. The setup has encountered an unexpected error while Updating Installed Files. The error is: Fatal error during installation.
I have tried to attach the log but I think it is too big. I cannot post this message.
Please let me know another way to send the log file.
Any help is appreciated.
View 1 Replies
View Related
Mar 26, 2008
Hi!
I have an original database that I want to copy once to another database. Then I want to update the data weekly with the data of the original database. I dont change any tables or columns in that part of the database. Just some tables more in the new database (than the tables from the original database) with some references to the tables that have to be updated weekly.
How can I do this? (if you know what I mean... it's a sort of a datawarehouse where different sources come together.. that part that represents the original database is just a part of the datawarehouse. That part is exactly the same structure as the original database.)
Thanks,
Sandra
View 1 Replies
View Related
Aug 3, 2006
Hi,
I am trying to install multiple application services on 1 sql server database. Is this possible? I do not know how to install anything but the default application services settings for the membership, roles, etc.
Please help if you can.
Thanks,
Ezeibe
View 1 Replies
View Related
May 1, 2008
Hello, we have the hosting account with GoDaddy Server. We have using Visualstudio.net and MSSSQL Server 2005.
For hosting the files for the remote server ( Godaddy ) we are using FTP Cute client to upload the files. For Uploading a database they given a seperate login and we are hosted my data as a Transact SQL File. Up to this its going fine.
After that I want to retrieve my data from GoDaddy Database server. They are not allow the remote connections directly. But they told to use the File DSN to retrieve the data from thier server ( GoDaddy Server ). I don't Know how to use thier File DSN to connect My ASP.Net 2.0 Application to thier GoDaddy Database Server.
If I asked to GoDaddy Support team they are sending this file.
Connecting to a Microsoft SQL Server Database Using ASP/ADO
View 10 Replies
View Related
Mar 28, 2007
Hi!
I have setup a database mirroring session without witness - ServerA is the principal, ServerB is the mirror,. Each SQL Server instance is hosted on its own machine on sql2005 EE SP2. The mirroring is working correctly. If I submit to server ServerA command:
ALTER DATABASE MYDBNAME SET PARTNER FAILOVER
, ServerB becomes the principal, it means that mirroring works correctly.
My issue is with the SQL Native Client and a front-end ASP application (actually IIS 6.0 site) that needs to make use of this database. I have setup my front-end application to use SQL Native Client and specified the failover server in connection string. Here is the connection string that I am using :
PROVIDER=SQLNCLI.1;Server=ServerA,1433;Failover Partner=ServerB,1433;Database=MYDBNAME;Network=dbmssocn;Integrated Security=SSPI;
Everything works perfectly on my front-end application when ServerA is the principal. If I execute on server ServerA command:
ALTER DATABASE MYDBNAME SET PARTNER FAILOVER
, ServerB becomes the principal, and the failover occurs correctly on the database side. The problem is that my front-end application is not able to query the database on ServerB. The error appears:
Microsoft SQL Native Client error '80004005'
Cannot open database "MYDBNAME" requested by the login. The login failed.
This behavior my appication till I unload IIS 6.0 pool application. After that my front-end application becomes work correctly with ServerB.
When I swap server, I execute on server ServerB command:
ALTER DATABASE MYDBNAME SET PARTNER FAILOVER,
my IIS 6.0 application automaticly turn back to ServerA without any action on my side.
I am using SQL Native Client last version http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/sqlncli.msi (issued in February 2007). Has anyone experienced this issue? I'm thinking that it's a problem in the SQL Native client
View 10 Replies
View Related
Apr 21, 2008
Hi All,
I am new to MS SQL SERVER 2005.
My web application using SQL Server 2005 as back end database to store all the information.
I am using connection pooling to get connection form db.
But my fron end user( user who logged in into webapplication) lost his identity b'coz for database user is application server.
Now I wanna to track front end user in db.
In oracle I can do it by using CLIENT_IDENTIFIER. But in sql server I don't know how to do it.
in oracle i can do it as below
public void setIdentity(Connection conn, String identity) {
PreparedStatement ps;
try {
ps =
conn.prepareCall("begin dbms_session.set_identifier(?); end;");
ps.setString(1, identity);
ps.execute();
ps.close();
} catch (SQLException e) {
// Handle the exception
}
}
<!--[if !supportLineBreakNewLine]-->
once the transaction is complete, the application should reset the identity as follows:
public void clearIdentity(Connection conn) {
PreparedStatement ps;
try {
ps = conn.prepareCall("begin dbms_session.clear_identifier(); end;");
ps.execute();
ps.close();
} catch (SQLException e) {
// Handle the exception
}
}
<!--[if !supportLineBreakNewLine]-->
Please guide me for same.
Thanx in advance.
Bhadu<!--[endif]-->
View 6 Replies
View Related
Oct 29, 2007
I have SSRS 2005 SP2 configured to work in Sharepoint integration. Everything works fine except that I am not able to programmatically change any property of report viewer web part (instance) that I have added on on home page of my sharepoint site.
I can do same thing via sharepoint UI but not through program. When my programs runs it fetches all web parts been added on home page, then I need to iterate through each one and find report viewer web part.
While iterating, as soon as I arrive to report viewer web part it is named as "Error web part" with error message as
"Windows SharePoint Services cannot deserialize the Web Part. Check the format of the properties and try again"
If someone has a solution, please respond at your earlist.
Thanks
Shankar
View 1 Replies
View Related
Dec 7, 2007
I have a table with a column named measurement decimal(18,1). If the value is 2.0, I want the stored proc to return 2 but if the value is 2.5 I want the stored proc to return 2.5. So if the value after the decimal point is 0, I only want the stored proc to return the integer portion. Is there a sql function that I can use to determine what the fraction part of the decimal value is? In c#, I can use
dr["measurement "].ToString().Split(".".ToCharArray())[1] to see what the value after the decimal is.
View 3 Replies
View Related
Dec 10, 2005
4 Layered Web Application for Inserting data into a database using sql server as the back end and a web form as the front end using C# .
Can someone provide with code as I am new to this architecture and framework.
Better send email.
Thanks In Advance,
A New Bie
View 1 Replies
View Related
