How To Deploye SQL 2005 Express With My Application
Nov 21, 2006
Hello,
I have an application that uses SQL Server express. I'd like to be able to
package the SQL Server Express set up file and deploy it with my application
but all the searching I've done only tells me how to deploy SQL Server
Express manually (i.e. how to set it up yourself). I can script my set up
to see if an instance of SQL Server Express already exists but if it
doesn't, I'd like to know the best way to deploy this on the target machine
automatically.
Any help or direction would be greatly appreciated.
Thanks!
Rick
View 2 Replies
ADVERTISEMENT
Sep 10, 2007
Hi,
I'd like to get the experts' advice on whether SQL server 2005 Express edition (SSE) is suitable for medium scale web applications.
I have looked through the reviews of SSE. From what I understand, its limitations over the MSSQL 2005 Standard are:
1. SSE limits database size to 4GB and memory to 1GB.
2. Support for only 1 CPU.
3. No analysis or reporting services.
4. No full text indexing
5. No SQL Agent.
I have a web application that is currently running on a shared web host with a shared MSSQL 2000 database. I'm thinking of shifting to a Virtual Private Server, where I can install SSE for free.
Currently my app has about 14,000 page views a month, and each of them pulls out data from the database. I don't use any analysis or reporting services, or full text indexing or SQL Agent (for now).
My questions:
1. Is 1GB memory sufficient for this type of application?
2. Is there any reason I should not be using SSE for my type of application?
Thanks in advance for the help.
View 5 Replies
View Related
Feb 4, 2007
Hello,
Can I confirm whether pooling=false in the connection string is still required for SQL Server 2005 (Express Edition)?
Various google searches say pooling has to be turned off for SQL Server 2000, but I was just wondering whether it is still a limitation for SQL Server 2005
Thanks
John
View 5 Replies
View Related
Dec 12, 2006
All,
I'm a newbie here so forgive me if I have missed something completely obvious.
I have bought a shopping cart script of a well known company (Evolve Merchant 5) and I wish to set it up locally on my development server, I created a virtual directory, set the web application up and get the asp pages to display perfectly. However, in the configuration file (global.asa & web.config) for the application it reguests information to be provided: <add key="DBName" value="Database name" />
<add key="DBServer" value="IP address of server" />
<add key="DBUserName" value="User name" />
<add key="DBPassword" value="password" />
<add key="AltPassword" value="password" />
What I can't determine is what the SQL Server 2005's IP address is? the pages of this application show when I type http://localhost/catalogue into IE, so I presumed the server address would be the IP of localhost, when typed ping localhost into command promt it gives me 127.0.0.1, but when I enter this into the config file and try to load the application it just hangs and then eventually says:
"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied./catalogue/global.asa, line 54"
I have created a new database in SQL Express called: merchant509 and restored the tables to it as the manufactures help files state, I created a new login called shop which uses SQl authentication, so as I can provide a password. So the settings should look like this:
<add key="DBName" value="Database name" />
<add key="DBServer" value="127.0.0.1" />
<add key="DBUserName" value="shop" />
<add key="DBPassword" value="1684" />
<add key="AltPassword" value="1684" />
But it doesn't work, does anyone know what i have done wrong?? the SQL server is runnign on the same computer as I am trying to access it from, it is set to accept all forms of comunication i.e. TCP/IP etc.. in the server configuration manager the IP address part of TCP/IP in protocols shows IP1 as 192.168.2.2 active yes enabled yes, and IP2 as 127.0.0.1 active yes and enables yes, I have tried the 192.168.2.2 and this gives the same errors, this is my registed IP on my home network.
I'm now stumped, I haven't a clue what else I can try, I would be very greatfull if anyone has any ideas.
Regards,
Daniel Coates
View 1 Replies
View Related
Jul 24, 2007
I am tring to access the SQL 2005 Express which installed in remote machine. Front end app is on Visual Studio 2005. Try to connect SQL Express using the application Layer which is installed on the computer where SQL Express is installed. Could not fetch data from the SQL Express. What could be the problem?
With Regards,
ADK
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
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
Mar 6, 2008
I install SQL Express from my application with Process.Start().
But the installation tells me that i have to close my application.
"The following application should be closed before continuing...."
Why ? What is checked by setup?
View 1 Replies
View Related
Jul 17, 2007
Hi,
I need your help guys. Am devolving a windows application by c#. I have problem of insert Arabic text to sql express 2005. I always get ???? instead of the Arabic letters. I change the collation of the database field to windows collation and choose Arabic but still I get the same problem.
Your help is appreciated
View 7 Replies
View Related
Jun 25, 2007
I am very frustrated. Everything works on the local host but when I upload to server I can login to the admin role I created, but when I try to access pages that have role priveleges I get the following error:
The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.
The ASPNETDB.MDF database was uploaded using the Database Publishing Wizard.
Please help!
View 1 Replies
View Related
Jan 13, 2007
Here is the situation:
I have SQL server express 2005 installed on my pc as instance SQLEXPRESS.
I have created a Visual Basic applicaion with the following as connection to the SQL server express 2005 running on the same PC:
****************************************************************************************************
Dim lconnectionString As String Dim builder As New SqlConnectionStringBuilder Dim cmd As New SqlCommand Dim reader As SqlDataReader Dim parameter As SqlParameter builder("Data Source") = ".SQLEXPRESS" builder("Initial Catalog") = "" builder("AttachDbFilename") = "C:My DocumentsVisual Studio 2005Projectsabcabcabc.mdf" builder("Integrated Security") = True builder("User Instance") = True lconnectionString = builder.ConnectionString Dim sqlConnection1 As New SqlConnection(lconnectionString) cmd.CommandText = "SP_add_collection" cmd.CommandType = CommandType.StoredProcedure cmd.Connection = sqlConnection1 sqlConnection1.Open()
*******************************************************************************************************************
It seems that i can not connect to the abc.mdf in SSMSE while the VB program is running. (ERROR:
Database 'C:My DocumentsVisual Studio 2005Projectsabcabcabc.mdf' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (.Net SqlClient Data Provider) )
If i connect to the abc.mdf first in SSMSE, then run the VB program afterwards, it gives me the error on this line -- sqlConnection1.Open()
I want to be able to access the abc.mdf database with both SSMSE and VB at the same time. Could anyone help me on this ?
Thanks very much !
apple
View 4 Replies
View Related
Jan 21, 2008
Hi there
I am new to SQL Server, but the current project that I am working on has the following requirement:-
1) Migrate the application (a servlet based web application on Apache Tomcat) from Solaris to Wintel
2) Migrate the supporting database from SQL Server 2000 to Sql Server 2005
3) Get IIS to communicate with Tomcat for serving servlet/jsp etc to the client
Though I successfully completed item 1 above, am stuck at item 2. Details are below
Actions taken for item 2
A. Installed MS 2005
B. Created new database in MS 2005 (logged in as user 'sa')
C. Generated SQL scripts (such as create table table_A etc) from existing MS 2000
D. Genearted SQL scripts (such as insert into table_A etc) from existing MS 2000
E. Created new schema in MS 2005
F. Ran scripts C & D in the new schema. All tables are records populated.
G. Obtained new JDBC driver and test run to see if connection is working fine, and it worked. Even ran an sql statment
Code Block[select count(*) from sa.table_A]
and got appropriate response.
H. When I made the application to talk to this new database (which is a copy of Production from step C, D above), it's behaving as though it cannot find the record.
I. When I further debugged, I realised that the web application is excuting queries without mentioning the schema. For eg.
Code Block[Select firstName, lastName from table_A]
Or rather it assumes that the user connecting to database is same as the schema name.
J. To further ascertain my point, I ran the query
Code Block[Select firstName, lastName from sa.table_A]
and it worked!
Now the real problem is that I cannot modify the existing code to append a schema name and this approach is rather not recommended best practise.
I tried to match the user name with the schema name, even made this schema as default to the user. But still not finding any luck.
I request all you experts out there to help me out with this problem.
Regards,
prad.nair
View 3 Replies
View Related
May 5, 2006
Hi All,
I've developed an application that connects to a SQL Server 2005 Express database. I created a DSN to connect to the database through ODBC. Currently, I am testing locally and everything works fine.
I would now like to install my application on another workstation and connect remotely to the database located on my development machine.
The client workstation does not have SQL Server 2005 Express installed on it because I would just like my application to connect remotely by creating the DSN and using ODBC. What I'm missing here are the database drivers. The "SQL Natice Client" is not available on this client workstation. How can I deploy the necessary drivers with my installation file so that I may create the required DSN name using the SQL Native Client driver?
Thanks!
View 6 Replies
View Related
May 26, 2006
I am using a windows xp sp 2. I have visual web developer 2005 express edition. .net Framework 2. but when i downloaded the sql 2005 express edition. when i click on the sqlexpr.exe. I receive a message " sqlexpr.exe is not a valid win32 application".
just to try I downloaded the framework 2. for win32 , when i click on the exe file I receied the same message.
Well someone help me please with the sql server. i have almost given it up and using this tool for my last resort.
Thanks
trying hard
View 4 Replies
View Related
Aug 3, 2007
hi friends,
i was created the virtual directory ( http://yh861/REPORTSS)
when i click on the deploy i am getting the error
TITLE: Microsoft Report Designer
------------------------------
A connection could not be made to the report server http://yh861/REPORTSS.
------------------------------
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)
------------------------------
The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)
------------------------------
BUTTONS:
OK
------------------------------
please help
View 3 Replies
View Related
Sep 23, 2007
I have several general questions about this but I thought I would describe what I am doing first. My senior project team is developing a web application that will wind up using SQL Server for the database. We are writing it in ASP.net and developing the database on SQL Server Express. My job is to develop and deploy the database. I have an ERD designed and am getting ready to start coding the tables, constraints and stored proceedures but am unsure of a couple of things.
1) How do I create a new schema?
2) I can see how to create tables in the GUI but what I am trying to do is create scripts that can be used to create the tables and objects on the actual server that our client will be using. How do I create scripts in 2005 Express? Do I just go click on the new query button?
3) Are scripts that work for Express going to have any problem executing on SQL Server?
View 1 Replies
View Related
Dec 11, 2006
Hi,
I'm trying to learn some VB programming with the VB 2005 Express Absolute Beginner Series video tutorials (which I think is great) and have come across a problem that I can't solve.
When I follow the instructions in Lesson 9 (Databinding Data to User Interface Controls) my application will display the data from the database correctly and I can edit it (and as long as the debugger is running the data remains changed). However, the changes won't propagate back to the database. I don't get any error messages but after I edit the data, save (with the save button on the BindingNavigator toolbar), and end debugging the data in my database remains unchanged. When I use a MessageBox to show how many rows where edited/updated in the
Me.myTableTableAdapter.Update(Me.myDatabaseDataSet.myTable)
I get the correct number back. I'm sure the problem is not due to coding errors since I've also tried running the accompanying Lesson 9 project file that can be downloaded from MSDN and the problem persists.
I'm using Windows XP SP2, SQL Server 2005 Express Edition and VB 2005 Express Edition. I've tried installing SQL Server 2005 Express with a number of different settings, including default settings, but it doesn't make any difference.
Would greatly appreciate any feedback on this as I'm keen to resolve this problem so I can get on with the next tutorial lesson.
Thanks,
Ieyasu
View 6 Replies
View Related
Jul 1, 2005
Hey everyone, I'm having trouble connecting to my sql express instance through my vb.net application. I can connect to it from Visual Studio and the management tools, but get an error when connection with a connection string. What should my connection string look like? I'm using the a default SQLEXPRESS instance.
View 3 Replies
View Related
Dec 21, 2005
I have created a Web application that uses a SQL Express file Database (mdf). I have also created a console application that looks to the (mdf) in the Web Directory to process some server-side tasks, (Email, process data, etc). Everything works well on my Development Machine, however when I Publish my Web App and Console application to a server, the Web App works fine, the Console App is buggy. The main error I get is ;that the user logged into the server cannot access the Database. (User domcholman cannot access). However this is not always the case, sometimes it works.
Question is, how does SQL Express authenticate credentials when in Windows Auth mode? Shouldn't it allow the Service account to access the database? Are there any best practices? Should I use an account and password instead? thanks...
View 1 Replies
View Related
Jul 6, 2007
I have a small ASP.Net application developed in VS 2005 that I would like to deploy with SQL Express.
I have included the MDF file in the Application and added SQL Express as a pre-requisite for the Setup and Deployment project.
It installs SQL Express but when it tries to connect I receive:
"This is not a valid login Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITYSYSTEM'."
I don't seem to have any options using the "prerequisite options in VS 2005 in terms of command line deployment parameters.
Likewise I would prefer to attach the database to the instance (because I need to write a connection string from a PDA using RDA and I have zero clue how to do RDA directly back to the file).
Thanks for any help!
View 1 Replies
View Related
Sep 13, 2006
HiIm trying to connect Visual Basic Express 2005 to a remote SQL Server Express 2005. I cant find how i can do that in VB.net Express.In Web developer there are no problem to connect to a remote SQL server but i cant find it in VB.net Express. The XP with the SQL server that i want to connect to is on the local network. Greatful for help!
View 1 Replies
View Related
Aug 18, 2006
This problem only occurs after deployment, not when debugging. In the table I am having a problem with I have an ID field designated as the primary key with the identity increment set to 1 and the identity seed set to 1. There is no data in the table when deployed. I can add records to the datagridview control but when I try updating the dataset I get this error indicating that the ID field already has a value of 1 present. If I close the application and re-start it, the exception no longer occurrs when I update the dataset. I am including the code to update the tables incase something is wrong there. Any suggestions?
Private Sub UpdateMemberTable()
Me.Validate()
Me.TblMembersBindingSource.EndEdit()
Me.TblMembersTableAdapter.Update(Me.ChurchFamilyDataSet.tblMembers)
Me.TblMemberDependentsBindingSource.EndEdit()
Me.TblMemberDependentsTableAdapter.Update(Me.ChurchFamilyDataSet.tblMemberDependents)
Me.TblMemberContributionsBindingSource.EndEdit()
Me.TblMemberContributionsTableAdapter.Update(Me.ChurchFamilyDataSet.tblMemberContributions)
End Sub
View 3 Replies
View Related
Jun 13, 2007
Hi Guys,
I created a Product database table using Visual Basic 2005 Express and SQL Server 2005 Express. I have just added a new column [Picture] to the database table, which of course, should store an image or picture of a product. I am writing to kindly ask you guys for help .
i) How do I include image files into this column [Picture]?
ii) How do I get this image to display on Visual Basic 2005 Express form, so that when a product is selected the product image is displayed accordingly?
Your help much appreciated. Thanks.
Paul
View 8 Replies
View Related
Aug 8, 2006
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.
How can apply SQL Server 2005 Express SP1 to update this existing instance?
Currently, if I run this query:
SELECT @@version
I get the following:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
After applying SP1, I should get 9.00.2047.00.
Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:
http://msdn.microsoft.com/vstudio/express/sql/download/
Thank you,
Bashman
View 11 Replies
View Related
May 14, 2007
Hello,
Fairly new to asp.net developers community. Can't believe I havent took interest in this before!
Please let me know what I need to learn in terms of resources for creating the mentioned functionality on my asp web page.
I already have a sqldatabase and tables created with data. (This database is reading from another system every 15 mins)The problem is not the database, its working fine, I even have a MS Access frontend that I use.
I want to take the query functionality on the web. ( par number look up to display description, price and unit of measure
I need to have a box for the user to enter a number (1-xxx)..Populate 4 columns with xxx rows.In column one enter 'partnbr"...that looks up the "partnbr' in the "partlist_table" and send back "description" "price" "unit of measure"
Once the info remains on the , I can create masterpages to resemble a quote.
Thank you much for your help.
Dev
View 2 Replies
View Related
Jan 25, 2007
Dear friends I have a problem with the use of DELPHI and MSSQLServer!
I have installed in a PC a MSSQLServer Express. The PC is connected
with a other via a small network. I have developed an application in DELPHI
which runs also in the two computers. I have regulated SQLServer so as
to is accessible via TCP/IP, make that I tryed after in the other PC I
installed SQL Server Management Studio Express and had access in the
database via the network. While in the beginning both applications
worked normaly and were connected regularly in the base suddenly
one day they couldn't be connected giving as message the following
"DataBase Server Error: SQL State: 08001, SQL Error Code: 17 ", as there was no server. That is to say without I have teased the
properties the access to DataBase was impossible via the application but possible via the SQL
Server Management Studio Express and the environment of Borland Delphi
2005 from both PC's. That is to say
suddenly only the application simply could not be connected. I tryed
a lot of solutions but no one it did not work. When I installed the
MSSQLServer Express in the other PC the application could be connected
from this but no from the other via network always giving the same
message. Has anyone any idea why I am in impasse from solutions!!!!
Thak you in advance!
View 2 Replies
View Related
Mar 8, 2007
I'm trying to connect to a sql express database on my local machine, using the following connection string:
SqlConnection thisConnection = new SqlConnection(@"Data Source=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataTest.mdf");
However, I keep getting an error message saying "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."
Why would my application be trying to connect remotely when the database is on my local machine? And how can I fix this problem?
Thanks
View 3 Replies
View Related
Mar 30, 2008
I am getting this error
"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)(Microsoft SQL Server,Error:2)"
in SQL EXPRESS 2005
1.Just changing the service config settings that is TCP/IP to enable will it work?i changed i run my application but it didn't work they have written the code to the server(connection string to their server- if it was to common how to write the code ?) & is there any other changes ?
2.I have developed a VB.NET EXE file -In that application(inside the code) i am using run time connection string queries to connect to the sql server database & created run time tables.
Suppose if i want to install the application to all clients/users how to Configure that application - self configuration/self installer to the installing machine SQL SERVER.
How can i do this ?
3.Is there any way i can write config file for sql server along with exe application code ? How can i do this ?
Pls answer with details/screenshots or diagramatical (if possible)
pls reply asap
Dotnetnewbie
View 1 Replies
View Related
Sep 28, 2006
How do I get rid of this error message when tring to log into my web site user account stored on the default ASP.NET 2.o generated database on my local computer?
Server Error in '/FundACure.org' Application.
Cannot open user default database. Login failed.
Login failed for user 'LANBOYASPNET'.
Where "LANBOY" is the name of my computer. I am logged in as myself "LANBOYKEVIN" My web page is trying to log into the server using the name "ASPNET" which I assume is a standard ASPNET user name.
I thought it was failing because I needed to grant access to this user in the server, so I added the account for the server. Same problem.
So I thought I needed to create this user in my Windows XP user list. When I tried it said "this user already exists" even though it isn't displayed in the list. That is when I realized that it is a standard user established by ASP.NET. It is probably supplied in the C# code through a base class.
So, how do I get this DB to connect? Is the user missing, or is it that my connection string is wrong?
View 1 Replies
View Related
Oct 29, 2006
We are thinking of using a Sql Server Express database (.mdb.mdf) as a data resource in a Windows Forms application that we will be distributing to clients. When the application is built, the mdb file is copied to the bin directory.
In order for clients to access this database, will they need to have an instance of the SQLEXPRESS server installed on their computer? Or since the .mdb.mdf file is being accessed from a .Net 2.0 application, there is no need to install a separate db component?
If I do have to separately install the db component on the client end,
is this the way to go about it? This? Or is there a different/better way?
View 6 Replies
View Related
Aug 31, 2006
I have an ASP application which is currently using a SQL 2000 Database, attaching via SQLOLEDB. I am getting ready to migrate my ASP application to .NET using SQL Server 2005 Express. The only problem, is that I am unable to connect successfully from my ASP applcation to my DB under SQL Express.
I have taken all of the steps that I have read, including the blog by Ming Lu. I still cannot be through.
I have included both the messages that are thrown and comments about the drivers and connection strings.
I have enabled TCP/IP and Named Pipes for SQL 2005 EE. I have also included the executable, port 1433, port 135, etc. in the firewall exceptions.
I have defined the DB in ODBC using both the Native Sql driver and the SQL Driver. Connection authentication is via SQL Server Authentication.
If anyone has any input, I would be grateful.
Error Messages:
Named Pipes Provider: Could not open a connection to SQL Server [53]. - using SQLNCLI - SQL Native Driver
::[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. - using SQLOLEDB - SQL Native Driver
::[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. - using SQLOLEDB - SQL Server Driver
Named Pipes Provider: Could not open a connection to SQL Server [53]. - using SQLNCLI - SQL Server Driver
connection string for SQLOLEDB: "PROVIDER='SQLOLDEB';DATA SOURCE='.SQLEXPRESS';User ID='Abilities2005';Password='abilities';Initial Catalog='nbdc2005';"
connectdion string for SQLNCLI: "PROVIDER='SQLNCLI';DATA SOURCE='.SQLEXPRESS';User ID='Abilities2005';Password='abilities';Initial Catalog='nbdc2005';
source name varied from .SQLEXPRESS, localhostSQLEXPRESS and machinenameSQLEXPRESS
Thanks, Tom
View 8 Replies
View Related
Feb 4, 2008
How do I get SQL Server 2005 Express Edition Service Pack 2 to show up in the prerequisites list when publishing the application?
Thanks
View 1 Replies
View Related
