Hello All Great Developers,My Brothers...
blease help me
I am a new in this domain, I need to Know if I can make c# porject
with SQL server Express Database,
and I need to make install to this project to work in any PC without install any another tool or sqlserver program,
blease answer me ,blease
Hi,
I'm looking for a solution to run querys (create databases ed) after a silent installation of SQL 2005 Express edition (example with a .sql file). So users can run a installation unattended with all databases installed and so on.
What I got is a document about how to run a silent installation (document " Using Command Prompt Options to install SQL Server Express") but this docs there's no solution how to run querys after the installation.
Thanks
Robert-Paul
Following is the error log the installtion gave. I have widows 2000 professional running on my machine.
Please help...thanks
The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.0.4 {version}
Running checks for package '.NET Framework 2.0', phase BuildList
Running external check with command line "C:DOCUME~1csk044LOCALS~1TempVSD6A.tmpdotnetfxdotnetchk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'DotNetInstalled'
Reading value 'Version' of registry key 'HKLMSoftwareMicrosoftInternet Explorer'
Read string value '6.0.2800.1106'
Setting value '6.0.2800.1106 {string}' for property 'IEVersion'
The following properties have been set for package '.NET Framework 2.0':
Property: [DotNetInstalled] = 1 {int}
Property: [IEVersion] = 6.0.2800.1106 {string}
Running checks for command 'dotnetfxinstmsia.exe'
Result of running operator 'ValueExists' on property 'VersionNT': true
Result of checks for command 'dotnetfxinstmsia.exe' is 'Bypass'
Running checks for command 'dotnetfxWindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true
Result of checks for command 'dotnetfxWindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
Running checks for command 'dotnetfxdotnetfx.exe'
Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true
Result of checks for command 'dotnetfxdotnetfx.exe' is 'Bypass'
'.NET Framework 2.0' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2005 Express Edition', phase BuildList
Running external check with command line "C:DOCUME~1csk044LOCALS~1TempVSD6A.tmpSqlExpressSqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpresssqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.4': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Install'
Running checks for command 'SqlExpresssqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Bypass'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
EULA for components 'SQL Server 2005 Express Edition' was accepted.
Copying files to temporary directory "C:DOCUME~1csk044LOCALS~1TempVSD6A.tmp"
Downloading files to "C:DOCUME~1csk044LOCALS~1TempVSD6A.tmp"
(5/11/2006 8:36:41 PM) Downloading 'SqlExpresssqlexpr32.exe' from 'http://ct11pcsapp111/testcentralpoc/SqlExpress/sqlexpr32.exe' to 'C:DOCUME~1csk044LOCALS~1TempVSD6A.tmp'
Download completed at 5/11/2006 8:36:46 PM
Verifying file integrity of C:DOCUME~1csk044LOCALS~1TempVSD6A.tmpSqlExpresssqlexpr32.exe
WinVerifyTrust returned 0
File trusted
Running checks for package 'SQL Server 2005 Express Edition', phase BeforePackage
Running external check with command line "C:DOCUME~1csk044LOCALS~1TempVSD6A.tmpSqlExpressSqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpresssqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.4': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
Verifying file integrity of C:DOCUME~1csk044LOCALS~1TempVSD6A.tmpSqlExpresssqlexpr32.exe
WinVerifyTrust returned 0
File trusted
Installing using command line '"C:DOCUME~1csk044LOCALS~1TempVSD6A.tmpSqlExpresssqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1'
Process exited with code 70095
Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'
Hi experts;
I have a problem with unicode character 0x2300
I created this table
create table testunicode (Bez nchar(128))
Insert Data
insert into testunicode (Bez)values('¢')
with 2 Unicode characters
= 0x2300
¢ = 0x2122
Selecting the data
select Bez from testunicode
I see
"?¢"
¢ = 0x2122 is ok but instead of 0x2300 there is 0x3f
When I modify the insert statement like that ( 8960 = 0x2300 )
insert into testunicode (Bez)values(NCHAR(8960)+'¢')
and select again voila i see
"¢"
Does anyone have an idea?
Thanks
I am trying to 'load' a copy of a SQLServer 2000 database to SQLServer 2005 Express (on another host). The copy was provided by someone else - it came to me as a MDF file only, no LDF file.
I have tried to Attach the database and it fails with a failure to load the LDF. Is there any way to bypass this issue without the LDF or do I have to have that?
The provider of the database says I can create a new database and just point to the MDF as the data source but I can't seem to find a way to do that? I am using SQL Server Management Studio Express.
Thanks!!
I have an app that uses a sqlserver 2000 jdbc driver to connect to a sqlserver 2000.
Is it possible to do a direct replacement of sqlserver 2000 with sqlserver 2005 express just by reconfiguring the app to point to the express? The app would still be using the sqlserver 2000 jdbc driver to try and make the connection.
If that is a possibility, what can be some differences in the configuration? Previously with 2000 the config information I entered is:
server name: "machinename"( or ip). I've also tried "machiname/SQLEXPRESS"
DB name: name of db instance
port: 1433(default)
user and pass.
My attempts so far results in
"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket."
and
"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL."
Regarding KB935356, is there a "post" service pack 2 update for SQLServer Express?
Thanks.
Hi,
I failed to install SQL Server 2005 to my Win2003 server which has AVG antivirus/firewall installed. It still not work even I disable the firewall. Please advice
Here is the error log
2006-11-17 13:45:12.25 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2006-11-17 13:45:12.25 Server (c) 2005 Microsoft Corporation.
2006-11-17 13:45:12.25 Server All rights reserved.
2006-11-17 13:45:12.25 Server Server process ID is 3300.
2006-11-17 13:45:12.25 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2006-11-17 13:45:12.26 Server This instance of SQL Server last reported using a process ID of 2768 at 11/17/2006 1:45:00 PM (local) 11/17/2006 9:45:00 PM (UTC). This is an informational message only; no user action is required.
2006-11-17 13:45:12.26 Server Registry startup parameters:
2006-11-17 13:45:12.26 Server -d C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2006-11-17 13:45:12.26 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2006-11-17 13:45:12.26 Server -l C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2006-11-17 13:45:12.28 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-11-17 13:45:12.28 Server Detected 2 CPUs. This is an informational message; no user action is required.
2006-11-17 13:45:12.43 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2006-11-17 13:45:12.45 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2006-11-17 13:45:13.48 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2006-11-17 13:45:13.48 Server Database Mirroring Transport is disabled in the endpoint configuration.
2006-11-17 13:45:13.48 spid5s Starting up database 'master'.
2006-11-17 13:45:13.51 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2006-11-17 13:45:13.59 spid5s SQL Trace ID 1 was started by login "sa".
2006-11-17 13:45:13.60 spid5s Starting up database 'mssqlsystemresource'.
2006-11-17 13:45:13.78 spid5s Server name is 'VSMRND'. This is an informational message only. No user action is required.
2006-11-17 13:45:13.78 spid9s Starting up database 'model'.
2006-11-17 13:45:13.85 Server The certificate was successfully loaded for encryption.
2006-11-17 13:45:13.85 spid9s Clearing tempdb database.
2006-11-17 13:45:13.85 Server Server local connection provider is ready to accept connection on [ \.pipeSQLLocalMSSQLSERVER ].
2006-11-17 13:45:13.85 Server Server local connection provider is ready to accept connection on [ \.pipesqlquery ].
2006-11-17 13:45:13.87 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2006-11-17 13:45:13.87 Server Dedicated admin connection support was established for listening locally on port 1434.
2006-11-17 13:45:13.87 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2006-11-17 13:45:13.90 spid5s Starting up database 'msdb'.
2006-11-17 13:45:14.09 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2006-11-17 13:45:14.25 spid9s Starting up database 'tempdb'.
2006-11-17 13:45:14.31 spid5s Recovery is complete. This is an informational message only. No user action is required.
2006-11-17 13:45:14.32 spid12s The Service Broker protocol transport is disabled or not configured.
2006-11-17 13:45:14.32 spid12s The Database Mirroring protocol transport is disabled or not configured.
2006-11-17 13:45:14.39 spid12s Service Broker manager has started.
2006-11-17 13:57:11.79 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2006-11-17 13:57:12.34 Server The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. This is an informational message only. No user action is required.
2006-11-17 13:57:12.34 Server Error: 17054, Severity: 16, State: 1.
2006-11-17 13:57:12.34 Server The current event was not reported to the Windows Events log. Operating system error = 31(A device attached to the system is not functioning.). You may need to clear the Windows Events log if it is full.
2006-11-17 13:57:12.49 spid12s Service Broker manager has shut down.
2006-11-17 13:57:13.15 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Hi,
I just installed VS.NET 2005 on my computer and along the way SQL Server Express edition got installed too. What is the default sa password right out of the box? I actually want to use Windows authentication but was not able to set my domain account in there w/ administrative rights. I'd appreciate some help here.
Thanks,
Sam
HI,
i have one instalation file of SQL CE 2.0 named setup.exe ,i installed that in my desktop it works well.i could not install the same file inside the pocketPC.Can any one give me some information about how to get the installation file of SQL CE 2.0 and how to install that in real pocketPC.Thanks in advance.
Best Regards
Ihsan
Is there a way to transfer data from a SqlServer db to a SqlServer Express db. I tried to use the backup file of SqlServer, but this file is not valid for SqlServer Express. Or there any alternatives?
thanks,
Henk
it's my laptop, i try to install sql server 2005. the installation program dies at the first stage.
the program seem cant finish the Native Client installation and stops for ever. theres no error msg.
the installation program works well on my desktop. does anyone knows what goes wrong?
Hi
I've succesfully installed Visual C# and I've made a couple of example projects. I now want to try and create a database and see if I can make a C# application that talks to it.
So I've installed SQL Server Express. I was hoping I could open it up and get started with creating tables etc. Instead, my Start menu shows:
Microsoft SQL Server 2005
>>>Configuration Tools
>>>>>>SQL Server Configuration Manager
>>>>>>SQL Server Error and Usage Reporting
>>>>>>SQL Server Surface Area Configuration
Where do I go now? Is there some configuring to do before I can start making tables and storing data? Or, have I misunderstood what SQL Server is about?
Thanks
Rich
I tried to install sqlserver express on a tablet pc compaq T1000 with windows xp sp2, 512 ram.
A warning appears: hardware incompatible and the installation crashed trying to start sqlserver.
Any similar experience ?
Thanks
Hi, can someone explain which are the limits o maximum values that SQLServer Express permit?
I dont see anywhere a compare table in which it says, 10 concurrent connections, etc.
Thanks in advance.
Can anyone tell me if there is a $ price for a license if SQLserver Express is used on a website? I want to replace Mysql.
Thanks
Rich
After installing Visual Studio 2005 everything has installed fine EXCEPT SQLSERVER 2005. I remember having had the same problem some moths ago, but can't remember now how to fix it. I deinstalled VS2005 and installed back again, but the result was the same. SQLSERVER failed to install
thanks
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
Hi to all GURUS,
I am very (almost two days) new to SQL Server Express (in fact SQL Server). In my old applications I am using VB.Net 2005 Express with MS Access database and now I wants to go for SQL Server Express.
One thing I am unable to find till now is : if SQLServer Express is installed on my Server machine (say ServerPC) with attached database (say MyDB.mdf), how I can access it through ADO.Net 2.0 from client machine. (using VB.Net Express)
Thanks and hope you will encourge me to use SQL Server .
Ok from what I understand, sqlserver 2005 is FREE, and it is not limited by the number of concurrent connections etc etc.
So this means you can put sqlserver 2005 express on a dedicated server, and it can pretty much handle all the load you can throw right? (except if your say running myspace hehe)
Comments?
Hi,
View 1 Replies View Related
All the Componets are grayed out disabled and not available to proceed further while installing.
All of them have a red cross mark on it saying "Unavailable"
I actually wanted to instal Reporting services component and related services in my machine
Note : MY database server(sqlserver 2005) is connected to this report server(above) by LAN.
Could you please let me know where and how I could install Reporting services
Thanking you in anticipation
Srinivas
I would really like to be using SQLServer Express 2005 for some desktop database applications and replace MSDE. However, I am using VS.NET 2003 and so far I have not been able to discover if that combination will work.
Thanks,
Sid.
I have followed the link to download SP1 of SQLServer 2005 Express Edition, but, on that page nowhere it is mentioned that downloads offered are of SP1, it simply says that SQLServer 2005 Express edition.
What is the correct link and am I really on the correct page of SP1 ?
I would like to import data to a sqlserver express database. The database I am interested in importing was created in MSDE. I tried backing it up and using the restore function in sqlserver express but with no success. I have not been able to find an import function in the Management Studio Express interface. Is it possible to import this information, or should I get busy with my data entry?
View 4 Replies View RelatedWhen I try to run the install it detects some previous versions
components. The remove all previous beta components fails and I have
removed everything from the Add/Remove Programs.
Any advice would be helpful
Irina
Hi,
How should I do to access a table in SQLServer Express database using VB.NET and ADODB?
Thanks!
I am not sure which one I downloaded. whether it was the one with or without "extra" analysis and reporting features.
View 5 Replies View RelatedI use Access 2007 SQLserver Upsize but get errors saying SQL Server not found. Is there another way of copying tables from Access to SQL Server 2005 Express.
I am not very familiar with SQL Server Express but did a course in SQL Server programming.
I just implemented full text search on a table and it doesn't work like I expected. I am using a stored procedure to search a company name column.
CREATE PROCEDURE swsp_GetCompanyRecord
@companyName varchar(120)
as
begin
select recID, companyName
from TABLE
where contains (companyName, @companyName)
end
I use the stored procedure as follows:
swsp_GetCompanyRecord '"Reynolds Aluminum"' (Quotation marks inside single quote)
If I search for a company (e.g., Reynolds Aluminum), I get the following results:
Search Returns
Reynolds Reynolds Aluminum
Reynolds A Reynolds Aluminum
Reynolds Al nothing
Reynold nothing
Aluminum Reynolds Aluminum
I guess I expected this to work similar to 'LIKE' in that it would return the full company name if I gave it any portion of the name. Is there something wrong with the way I've implemented this?
I am currently Using SQL Server Express for testing purposes while waiting for SQL 2008 to be issued. (Our project will take some 2-3 years to complete so concerns about using a 'new' version of SQL Server are not pertinent). We have ordered this week Visual Studio 2008 as the shrink wrap version is due out the end of this week.
I have been able to migrate all our data from the old database (Superbase) but only field names and field types.
Indexes and validation stuff is lost.
The problem I have is that:
I can only import to an empty database, therefore if I start to create Indexes and otherwise modify the structure of this database in SQL Server then I will lose all this work on the next occasion I need to import (as Superbase will still continue to be our firm's current daily data handling tool for another year or two)
My thoughts where to create a copy of the original import, develop the constraints, indexes etc. on this secondary copy. then (on the day we are ready to migrate) empty the copy of data and import the data only
Does SQL Server Express have the tools to do this?
If not then are my best options to use SQL Server Beta until the new software is realeased (but notice that Visual Studio 2008 does not like SQL2008 - is there a fix for this?)
I hope this is the right forum for these questions
Thanks in advance
I am building a Visual Web Developer site with a SQL Server 2005 Express backend. I am trying to create the login page, I have written a stored procedure that takes in the username and password and returns a value which indicates whether the user is valid or not.
My problem now is integrating this stored procedure into the page. In Visual Studio 2003 you could just drag and drop the stored procedure from the Database Explorer window and it would create the neccessary SQLCommand which you can then pass parameters too and recieve return values, i.e:
sqlcommand1.Paramters[ "@username" ].value = TextUsername.Text;
sqlcommand1.Paramters[ "@password" ].value = TextPassword.Text;
sqlConnection1.Open();
sqlCommand1.ExecuteNonQuery();
Int Result = (int)sqlcommand.Parameters["@returnvalue"].value;
sqlConnection1.Close();
I see in VWD there are SqlDataSource's etc, is this what I need to use to do what I'm looking for and how do they exactly work? Ideally what I'm looking for is when a user clicks login, the contents of the 'username' and 'password' text boxes are queried against the database. What controls and configuration is required to achieve this?
Many thanks in advance,
Mervski
Iām working with an Sqlserver 2005 Express database on my local machine, and using vs.net 2005.I need to enable the sqlserver cache by the way:
aspnet_regsql -E -d Northwind -ed
I encountered the remote connection problem(error:40).The northwind database was restored to the sqlserver 2005 express by the db file downloaded,and I added the ASPNET user.I also enabled the TCP/IP by using SQL Server Configuration Manager.
But all the web application connected to the Northwind database is working through the connection string:
"Data Source=WKS-DEV-04SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"
Any help will be much appreciated, thank you very much for reading my post