I am having trouble updating my database. I have seen a couple of other people had the same problem. Two answers I had found and tried did not work. The updating if newer I had already came across in a step by step class room tutorial written by a college professor and to make sure the save procedure came after the update procedure. I did need to make this last change but its still not updating. Any further advice on this subject would be appreciated.
.
I've created an sql database in VB express, created some tables, and entered some data in those tables. My problem now lies with actually using that data. What i'd like to do is have a Sub use the database's data and fill in a series of variables. Right now i have the Sub using an Excel file to assign the information, looks like this:
Public Sub CharStatDefault() 'loads each character's default stats
CharSheet = xlBook.Worksheets(2)
P.initialize()
For excelInt = 1 To 22
P.C(excelInt).Initialize()
With P.C(excelInt)
.Vit = CharSheet.Range("AC" & excelInt).Value
.Phy = CharSheet.Range("AD" & excelInt).Value
.Mag = CharSheet.Range("AE" & excelInt).Value
.Off = CharSheet.Range("AF" & excelInt).Value
.Def = CharSheet.Range("AG" & excelInt).Value
.Agl = CharSheet.Range("AH" & excelInt).Value
End Sub
So basically i want to change the CharSheet.Range("XX" & excelInt).Value to something that utilizes the data from my database.
I recently converted a program I made in C# from Access to Sql Server Express and I noticed something odd.
Anytime I update or insert data into the database, it only sticks around until the program closes. I can insert new records but as soon as the program quits, the inserts are gone.
Is this a bug or is there something else I need to do?
I am trying to connect to SQL Server Express using the following VB code from an aspx.vb page: ' Create and open a connection to the database Dim conn As New SqlConnection("Data Source=YOUR-FE632222CE\SQLEXPRESS;Initial Catalog=scotfree;Integrated Security=SSPI") conn.Open() This code fails on conn.Open() however giving me the following exception:System.InvalidOperationException: Instance failure.Stack trace:[InvalidOperationException: Instance failure.] System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +1804 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +606 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +193 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +501 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +429 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +70 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +512 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89 System.Data.SqlClient.SqlConnection.Open() +160 Default3.OnLoad(EventArgs e) in C:Documents and SettingsLiamMy DocumentsVisual Studio 2005WebSitesTestDefault3.aspx.vb:15 System.Web.UI.Control.LoadRecursive() +49 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3743The strange thing is that I replicated the code in C# and it works fine. Any ideas.
Hi, I have a problem, it is that when I try to update a record in my SQL server database, it is not updated and I recieve no error messages. This is the code behind the update button. The stored procedure is "sqlupdate".
Code Snippet
Dim ListingID As String = Request.QueryString("id").ToString Dim con As New SqlConnection(ListingConnection) Dim cmd As New SqlCommand("sqlupdate", con) cmd.CommandType = CommandType.StoredProcedure Dim id As SqlParameter = cmd.Parameters.Add("@id", SqlDbType.UniqueIdentifier) id.Direction = ParameterDirection.Input id.Value = ListingID
Dim PlaceName As SqlParameter = cmd.Parameters.Add("@PlaceName", SqlDbType.VarChar) PlaceName.Direction = ParameterDirection.Input PlaceName.Value = PlaceNameTB.Text
Dim Location As SqlParameter = cmd.Parameters.Add("@Location", SqlDbType.VarChar) Location.Direction = ParameterDirection.Input Location.Value = LocationTB.Text
Dim PropertyType As SqlParameter = cmd.Parameters.Add("@PropertyType", SqlDbType.VarChar) PropertyType.Direction = ParameterDirection.Input PropertyType.Value = PropertyTypeTB.Text
Dim Description As SqlParameter = cmd.Parameters.Add("@Description", SqlDbType.VarChar) Description.Direction = ParameterDirection.Input Description.Value = DescriptionTB.Text
Try con.Open() cmd.ExecuteNonQuery() con.Close() Catch ex As Exception
Hi I have Visual Studio 2005 with SP1 installed, and I want to install the Management Studio. I tried many times installing that and I always got the same problem, which is when I try to create a database in VS I just don’t get trough as I used to. A message appears saying that I’ve to enable some estance. So to resolve the problem I saw if is everything ok with the SQL Server, which seemed to be fine, but I couldn’t start the Report service. Now I just formatted the computer and I’m afraid to happen all over again. May be the version with only the Management would be fine, I don’t know if it adds something beside of that.
Hi All, I have just installed Microsoft SQL Server Management Studio Express.. Once I did this first it was working fine, but now their is this error each time I try to connect the object explorer.. the error is as follows :-Could not load file or assembly 'System.Data, Version=2.0.0.0, Culture=neutral publickeyToken=b77a5c561934e089' or one of its dependencies. Signature specified is zero-sized. (Exception from HRESULT: 0x80131237). Could anybody help me with getting rid of this error. I have no clue what to do?
Hi there, i have sometimes trouble to write data to a table in a sql server expr. database.
i have a vb.net application that writes every 2 minutes data to a table. sometimes (no regulary phenomen) the error appears after some hours, sometimes after some days. then i cannot write data in the table. it seems that the database sleeps or is offline.
before i write the data i check if the connection is open and i can write data. if i cannot write the data i try several times and often after the third try i can write the data.
i have checked everything (no power save's on or other power off modes)
i have also test it with SqlClient.SqlConnection.ClearAllPools()
and many other things to find the bug, but no success at the moment.
it seems that the database or the table is away ?? or sleeps for some seconds ?!? i have no idea.
Hi I have Visual Studio 2005 with SP1 installed, and I want to install the Management Studio. I tried many times installing that and I always got the same problem, which is when I try to create a database in VS I just don€™t get trough as I used to. A message appears saying that I€™ve to enable some estance. So to resolve the problem I saw if is everything ok with the SQL Server, which seemed to be fine, but I couldn€™t start the Report service. Now I just formatted the computer and I€™m afraid to happen all over again. May be the version with only the Management would be fine, I don€™t know if it adds something beside of that.
I've developed a desktop application for a company. It uses click once deployment and has a few prereqs: .NET Framework 2.0, j# .NET redistributable, windows installer 3.1 and SQL Server 2005 express edition.
Most of the time the application downloads and installs fine. However, one user has a problem. I'm fairly certain it's machine / OS related and I wonder if there is a way to get around it.
The user has a Windows 2000 machine, Pentium III, with 512 MB of RAM.
On their first try, they received an error while installing SQL Server 2005 Express. The error code the user found in the install log was 70095. Apparently the user found some information directing them to install the current MDAC 2.8 SP 1. After rebooting and trying the install again, it errored out. The new error code is 1706. Below is the install log.
As I said, I'm faily certain it's an OS issue, but I do hope there is a way around the issue other than trying to get the user to upgrade. If you need any other information, please let me know and I'll try to get it from the user.
Thanks,
AaronThe 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~1craigpLOCALS~1TempVSD8.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 'Microsoft Visual J# .NET Redistributable Package 2.0', phase BuildList Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpVJSharpRDPvjsrdpchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'VJSRDPInstalled' Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpVJSharpRDPdotnetchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'DotNetInstalled' The following properties have been set for package 'Microsoft Visual J# .NET Redistributable Package 2.0': Property: [DotNetInstalled] = 1 {int} Property: [VJSRDPInstalled] = 1 {int} Running checks for command 'VJSharpRDPvjredist.exe' Result of running operator 'ValueNotEqualTo' on property 'VJSRDPInstalled' and value '0': true Result of checks for command 'VJSharpRDPvjredist.exe' is 'Bypass' 'Microsoft Visual J# .NET Redistributable Package 2.0' RunCheck result: No Install Needed Running checks for package 'Windows Installer 3.1', phase BuildList The following properties have been set for package 'Windows Installer 3.1': Running checks for command 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe' Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.1': true Result of checks for command 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass' 'Windows Installer 3.1' RunCheck result: No Install Needed Running checks for package 'SQL Server 2005 Express Edition', phase BuildList Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.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~1craigpLOCALS~1TempVSD8.tmp" Downloading files to "C:DOCUME~1craigpLOCALS~1TempVSD8.tmp" (12/14/2006 11:16:32 PM) Downloading 'SqlExpresssqlexpr32.exe' from 'http://go.microsoft.com/fwlink/?LinkId=37280&clcid=0x409' to 'C:DOCUME~1craigpLOCALS~1TempVSD8.tmp' Download completed at 12/14/2006 11:17:02 PM Verifying file integrity of C:DOCUME~1craigpLOCALS~1TempVSD8.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~1craigpLOCALS~1TempVSD8.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~1craigpLOCALS~1TempVSD8.tmpSqlExpresssqlexpr32.exe WinVerifyTrust returned 0 File trusted Installing using command line '"C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpresssqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1' Process exited with code 1706 Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'
Here is the information that I have... ( ps all information is not the actuall information )
1) URL abc.somehostingcompany.com IP: 211.11.111.1 PORT: 1433 ( NOTE: if I go to a cmd promt and type in ping abc.somehostingcompany.com I get a response )
2) dbname = mydatabase
3) userUid = sa pwd = sa
Inside SQL Server Configuration Manager --> SQL Server Network Configuration --> Protocols for SQLEXPRESS, I enabled TCP/IP and Shared Memory. Inside the properties of TCP / IP, I made sure under the "IP Address" tab that the
IP1: Active = yes
IP1: Enabled = yes
IP1: IP Address = abc.somehostingcompany.com
IP1: TCP Dynamic Ports = 0
IP1: TCP Port = < empty string >
I clicked "OK", and I stopped and started the SQL Server 2005 Services --> SQL Server (SQLEXPRESS). Then I started up SQL Server Brower.
Lastly I go to SQL Server Management Studio Express and try to connect to this remote server and database and I keep getting timeout issues and a message saying that the default settings for SQL Server Express do not allow remote connectioning by default.
Any ideas what I could be doing wrong? Should I use the port number instead of Dynamic Ports? Should I use the real IP address? Does the LOG ON AS under SQL Server (SQLEXPRESS) properties need to be updated?
I have a SQL Server 2005 Express edition instance set up on one server, and IIS on another server.
The SQL Server process account is a domain user account, which I have added to the local groups that SQL Server created during installation (I originally used a local user account instead of domain account; however, the problem occurs with both).
SQL Server runs fine, and if I set my IIS application pool identity to a domain admin, my web app can access the database and retrieve the data necessary.
However, I have a domain user account that I want to use to run the app pool and retrieve the data. The domain user account is added to the IIS_WPG group on the web server. On the database server, I have created a login for the account, as well as added it to the db_datareader role of the database that is used for the site.
However, the user is not able to connect to the SQL Server. I get the "Login failed for user <user account>" error in ASP.NET. I also tried connecting with SQL Server Management Studio, and I get the same error. I checked and the user has connect permission to the database server.
With admin accounts, there are no problems logging in, etc.
Any pointers are appreciated,
Thanks,
SA.
Edit: I was able to find out that the State is 11 for the error. According to http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx, this indicates "Valid login but server access failure." I am not sure how to resolve this.
I am installing Visual Studio 2005 Professional Edition. Everything goes well until the installation of SQL Server Express occurs. SQL Express installation progresses fine until very end of the installation. At that point it becomes stuck.
The installation says "Current component is installing" and is stuck on that message. The installer does not seem to be frozen as the picutres changes. However CPU usage for the setup processes is 0.
I have disabled all virus scanning software already.
Hello everyone. Pretty new to SQL Server and i've run into some trouble with something I am attempting to do.
Basically, we imported one of our databases on one of our SQL Servers to a new sql server that we just setup. That went ok with no problems. The DB is now in the new SQL Server.
Now, we need to copy the contents of a second DB from the original server into this new sql server DB. For reference:
We imported a DB Called: siebeldb We want to import/overwrite another DB into that same DB. We backedup the DB and moved the file to the new SQL server.
So:
Import/Restore: sbprd01(a backup file) into siebeldb
I hope that makes sense.
I have the following command that I am trying to execute in the SQL Query analyzer:
RESTORE DATABASE siebeldb FROM DISK='C:Documents and SettingsAdministratorDesktopsiebelprddb092509.bak' WITH MOVE 'siebelprddb_Data' TO 'C:Program FilesMicrosoft SQL ServerMSSQLDatasiebeldb_Data.mdf', MOVE 'siebelprddb_Log' TO 'C:Program FilesMicrosoft SQL ServerMSSQLDatasiebeldb_Log.mdf', REPLACE
It is running right now, but seems to be running into errors. I just added the 'REPLACE' option according to the t-sql reference guide.
Does my script look ok? Am I doing anything wrong?
During web-site development, I am using VStudio 2005 with SQL-Express. I frequently publish changes to my web server that is running SQL- Server 2000 standard edition. Is there a simple way to replicate changes in database tables design without copying the whole mdf-file and loosing the existing data in the target database? thanks, Reinhard
Hello, I'm installing MOSS 2007 as stand alone which includes SQL Server 2005 Express edition. My install is failing during the DB install. The server is Windows Server 2003, Enterprise Edition SP 2.
The error I'm receiving states "Setup has encountered an unexpected error while updating security settings on HTTP Services".
Here are snippets including the "return value 3" found in the log "SQLSetup0001_COHNTFS15_SQL.log".
Snippet 1: <Func Name='LaunchFunction'> Function=Do_sqlPerfmon2 <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_sqlPerfmon2 PerfTime Start: Do_sqlPerfmon2 : Thu May 01 08:36:14 2008 <Func Name='Do_sqlPerfmon2'> <EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'> PerfTime Stop: Do_sqlPerfmon2 : Thu May 01 08:36:14 2008 MSI (s) (D8:EC) [08:36:14:535]: Executing op: ActionStart(Name=Do_PropSetLoginModeNT.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Setting SQL Server Authentication Mode,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (D8:EC) [08:36:14:535]: Executing op: CustomActionSchedule(Action=Do_PropSetLoginModeNT.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_PropSetLoginModeNT,CustomActionData=010Setting SQL Server Authentication Mode50000MSSQL.1) MSI (s) (D8:40) [08:36:14:535]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI538.tmp, Entrypoint: Do_PropSetLoginModeNT <Func Name='LaunchFunction'> Function=Do_PropSetLoginModeNT <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_PropSetLoginModeNT PerfTime Start: Do_PropSetLoginModeNT : Thu May 01 08:36:14 2008 <Func Name='Do_PropSetLoginModeNT'> Switching server to NT integrated security <EndFunc Name='Do_PropSetLoginModeNT' Return='0' GetLastError='0'> PerfTime Stop: Do_PropSetLoginModeNT : Thu May 01 08:36:14 2008 MSI (s) (D8:EC) [08:36:14:566]: Executing op: ActionStart(Name=Do_HttpServiceSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Updating security settings on HTTP services,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (D8:EC) [08:36:14:566]: Executing op: CustomActionSchedule(Action=Do_HttpServiceSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_HttpServiceSecurity,CustomActionData=100Updating security settings on HTTP services100000) MSI (s) (D84) [08:36:14:566]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI539.tmp, Entrypoint: Do_HttpServiceSecurity <Func Name='LaunchFunction'> Function=Do_HttpServiceSecurity <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_HttpServiceSecurity PerfTime Start: Do_HttpServiceSecurity : Thu May 01 08:36:14 2008 <Func Name='Do_HttpServiceSecurity'> Error updating HTTPFilter service security (5)
<EndFunc Name='Do_HttpServiceSecurity' Return='1603' GetLastError='0'> PerfTime Stop: Do_HttpServiceSecurity : Thu May 01 08:36:14 2008 Gathering darwin properties for failure handling. Error Code: 1603 MSI (s) (D8!20) [08:36:14:785]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29528. The setup has encountered an unexpected error while Updating security settings on HTTP services. The error is: Fatal error during installation.
Error 29528. The setup has encountered an unexpected error while Updating security settings on HTTP services. The error is: Fatal error during installation.
<Failure Type='Fatal' Error='1603'> <EndFunc Name='LaunchFunction' Return='1603' GetLastError='0'> MSI (s) (D8:EC) [08:36:14:800]: User policy value 'DisableRollback' is 0 MSI (s) (D8:EC) [08:36:14:800]: Machine policy value 'DisableRollback' is 0 Action ended 8:36:14: InstallFinalize. Return value 3.
Snippet 2: <Func Name='LaunchFunction'> Function=Set_CommitFlag <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='F' GetLastError='0'> Doing Action: Set_CommitFlag PerfTime Start: Set_CommitFlag : Thu May 01 08:36:22 2008 <Func Name='Set_CommitFlag'> Set_CommitFlag called successfully.Rollbacked <EndFunc Name='Set_CommitFlag' Return='0' GetLastError='0'> PerfTime Stop: Set_CommitFlag : Thu May 01 08:36:22 2008 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (D8:EC) [08:36:22:988]: Executing op: ActionStart(Name=RollbackSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing temporary files,) MSI (s) (D8:EC) [08:36:22:988]: Executing op: CustomActionRollback(Action=RollbackSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=RollbackSupportFiles,) MSI (s) (D8:7C) [08:36:22:988]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI54B.tmp, Entrypoint: RollbackSupportFiles MSI (s) (D8:EC) [08:36:23:004]: Executing op: End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0) MSI (s) (D8:EC) [08:36:23:004]: Error in rollback skipped. Return: 5 MSI (s) (D8:EC) [08:36:23:004]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices.AdomdClient,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:004]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:019]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:019]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Instapi,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:019]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:019]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:019]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SqlTDiagM,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:019]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:035]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:035]: Entering MsiProvideAssembly. AssemblyName: MSClusterLib,Version="1.0.0.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="1.0.0.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:035]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:050]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:050]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.MgdSqlDumper,Version="9.0.242.0",Culture="neutral",processorArchitecture="x86",PublicKeyToken="89845dcd8080cc91",FileVersion="2005.90.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:050]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:050]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:050]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Rmo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:050]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:066]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:066]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices.DeploymentEngine,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:066]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:082]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:082]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:082]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:082]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:082]: Entering MsiProvideAssembly. AssemblyName: Microsoft.DataWarehouse.Interfaces,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:082]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:097]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:097]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.RegSvrEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:097]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:113]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:113]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.BatchParser,Version="9.0.242.0",Culture="neutral",processorArchitecture="x86",PublicKeyToken="89845dcd8080cc91",FileVersion="2005.90.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:113]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:113]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:113]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.ServiceBrokerEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:113]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:129]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:129]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.WmiEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:129]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:144]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:144]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.ConnectionInfo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:144]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:160]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:160]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SqlEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:160]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:207]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:207]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:207]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:207]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:207]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SString,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:207]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:222]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:222]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Smo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:222]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:238]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:238]: No System Restore sequence number for this installation. MSI (s) (D8:EC) [08:36:23:238]: Unlocking Server MSI (s) (D8:EC) [08:36:23:238]: PROPERTY CHANGE: Deleting UpdateStarted property. Its current value is '1'. Action ended 8:36:23: INSTALL. Return value 3.
last few lines of log: Property(S): RSVirtualDirectoryManager = Reports$OFFICESERVERS Property(S): SOURCEDIR = d:a1847ef4f3beaf9c2353Setup Property(S): SourcedirProduct = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F} Property(S): InstallNgenTicks = 110000 Property(S): SQLBROWSERACCOUNT = NT AUTHORITYNETWORK SERVICE Property(S): SQLBROWSERSCMACCOUNT = NT AUTHORITYNetworkService Property(S): SQLSCMACCOUNT = NT AUTHORITYNetworkService Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {B266876E-56D9-493C-9322-0C01155F1C52} Property(S): ProductToBeRegistered = 1 MSI (s) (D8:EC) [08:36:23:441]: Note: 1: 1708 MSI (s) (D8:EC) [08:36:23:441]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.
MSI (s) (D8:EC) [08:36:23:457]: Cleaning up uninstalled install packages, if any exist MSI (s) (D8:EC) [08:36:23:457]: MainEngineThread is returning 1603 MSI (s) (D84) [08:36:23:566]: Destroying RemoteAPI object. MSI (s) (D8:E0) [08:36:23:566]: Custom Action Manager thread ending. === Logging stopped: 5/1/2008 8:36:23 === MSI (c) (104) [08:36:23:597]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (104) [08:36:23:597]: MainEngineThread is returning 1603 === Verbose logging stopped: 5/1/2008 8:36:23 ===
I'm suspecting it's a permission error, but I can't verify this. Any thoughts? Thanks in advance.
Actually I should have said #22 but this is beyond the point. It seems the errors pop up and then go away for no reason, then appear again.
I had Sql Server Express with Advanced Features set up all right as far as I can see. It is the connection issue that is causing the headache.
Currently when I try to make a connection with an Sql database I get an error in Visual Studio:
Generating user instance in Sql Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.
So I go to Sql Server, log in, open a new query and type:
sp_configure 'user instances enabled' GO
I get a table where I can see that
name minimum maximum config_value run_value user instances enabled 0 1 1 1
Are they enabled? I think, yes. I go back to Vsisual Studio and get the same error. It is possible that I will have to log out in order for all this security garbage to take effect and I will try it but in the meantime, how can I set more than one instance.
I want to complain that these new security provisions that came apparently with SP2 and Vista are totally unnesessary for my applications. I do not have any high security info to worry about, e.g. social security numbers, etc. I would not mind to turn all this stuff off if it is possible at all.
When trying to install SQL Server 2005 Express, it hangs up on "Detecting Installed IIS". This happens if I have IIS installed, and if I do not. My computer is running XP Media Edition. I found a similar question asked by flashg on these forums, but there was no answer to the problem. There were a few other people who posted the same problem.
Is there any fix to this? I am writing software that I planned on using SQL Server Express to store its data with. But if SQL Server is going to cause problems on my customer's computers then I cannot use it.
This is the end of the log file for my SQL Server installation:
MSI (c) (00:20) [20:47:22:140]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action 20:47:22: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. Detecting Installed IIS Action start 20:47:22: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. MSI (c) (00:04) [20:47:22:140]: Invoking remote custom action. DLL: C:DOCUME~1KYLEOL~1LOCALS~1TempMSI1AA.tmp, Entrypoint: CheckIIS <Func Name='LaunchFunction'> Function=CheckIIS MSI (c) (00!60) [20:47:22:155]: PROPERTY CHANGE: Modifying InitStatus property. Its current value is '16'. Its new value: '20'. <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: CheckIIS PerfTime Start: CheckIIS : Wed Oct 18 20:47:22 2006 <Func Name='CheckIIS'> Action 20:47:22: CheckIIS. Detecting Installed IIS MSI (c) (00!60) [20:47:22:171]: PROPERTY CHANGE: Adding IISCHECKED property. Its value is '0'. MSI (c) (00!60) [20:47:22:171]: PROPERTY CHANGE: Adding SqlASPNETInstalled property. Its value is '1'. Skipping RS Feature Dependency Check <Func Name='GetXMLAttributeValue'> Error to find XML node /configuration/system.web/compilation <EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'> Failed to get ModuleID_RS_Server when getting the ASP Temp directory.
I was trying to install visual studio 2005 and as part of it I wanted to install sql express as well. It installed the rest okay but not the sql express. Going through the log file I figured out that there was some incompatible beta version installed and hence had to be removed. In the log file I got the following error messages. Going through the forum suggestion I was trying to use msiexec /x to deinstall each of them but got the error message that "The setup has encountered an unexpected error in datastore. The action is Write_CommitFlag. The error is unable to write property into cache: flagCommit. Unable to write property into cache: "flagCommit" XmiRW Error: Failure loading xmlrw.dll CheckAllProcedures. returned 2". After this error message when I check the sql server configuration manager, I still see the old instances running.
I followed up another forum suggestion where I completely installed the old CTP and used the tool provided in the DVD(sqlbuw) to uninstall it but it only removes the one instance and leaves the rest on the system.
I will really appreciate help...
ERRRR:...
icrosoft SQL Server 2005 Setup beginning at Sun Nov 19 16:49:19 2006 Process ID : 5736 c:87450d2367f159d42610acad33156dbcsetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2006/10/19 16:49:18 Complete: LoadResourcesAction at: 2006/10/19 16:49:18, returned true Running: ParseBootstrapOptionsAction at: 2006/10/19 16:49:18 Loaded DLL:c:87450d2367f159d42610acad33156dbcxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2006/10/19 16:49:19, returned true Running: ValidateWinNTAction at: 2006/10/19 16:49:19 Complete: ValidateWinNTAction at: 2006/10/19 16:49:19, returned true Running: ValidateMinOSAction at: 2006/10/19 16:49:19 Complete: ValidateMinOSAction at: 2006/10/19 16:49:19, returned true Running: PerformSCCAction at: 2006/10/19 16:49:19 Complete: PerformSCCAction at: 2006/10/19 16:49:19, returned true Running: ActivateLoggingAction at: 2006/10/19 16:49:19 Complete: ActivateLoggingAction at: 2006/10/19 16:49:19, returned true Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result. Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__5736" returned false. Running: PerformSCCAction2 at: 2006/10/19 16:49:19 Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435 Product "{2373A92B-1C1C-4E71-B494-5CA97F96AA19}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06 The Product Name is "Microsoft SQL Server 2005 CTP" Product "{CD080F4B-BF2C-4A0E-B923-CDA7F6EAB1C9}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06 The Product Name is "Microsoft SQL Server 2005 CTP" Product "{481DFF26-7C67-4085-9A27-758283EA494A}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06 The Product Name is "Microsoft SQL Server 2005 CTP" Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06 The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP" Product "{63A5DC0D-1EDD-4D69-8F31-87FAEB1F7084}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06 The Product Name is "Microsoft SQL Server 2005 Notification Services CTP" Product "{E0A41F96-7231-4AE8-A654-EEB34F935462}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06 The Product Name is "Microsoft SQL Server 2005 Data Transformation Services CTP" Product "{90032DD0-ABEE-4424-AC1E-B076BDD4E350}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06 The Product Name is "Microsoft SQL Server 2005 Tools CTP" Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435 Error: Action "PerformSCCAction2" threw an exception during execution. Return Code: 70032 Message displayed to user SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result. Message pump returning: 70032
It is not in the add and remove programs. I did what was told and stopped all processes of SQL, I had SQL 2000 running, now I am getting: The setup has encounted an unexpected error in datastore. The action is Write_CommitFlag. The error is Unable to write property into cache: "flagCommit" XmRW Error: Failure loading xmlw.dll CheckAllProcedures[] return 2, I get this when running msiexe /x {the number for the beta}
Could someone please help me, I need to have this install to take courses this weekend, Want to complete the install today, which is Friday.
Hello again!I think what I need to do should be simple, but it is proving difficult.I am displaying a page with data drawn from three different SQL Server tables. Most of the fields on the page correspond to fields in one of the three tables, and these fields can be updated by the user. I then want to propagate these updates to SQL Server, refill the DataSet, and rebind.What I'm currently doing is basically this. I've set up a separate SqlCommand for this update. I have a ParameterCollection defined for this SqlCommand that includes the key field to be used in my WHERE clause and all the fields I want to update.When the user clicks on the [Save Customer Review] button, I (1) set the values of the parameters to the values of the corresponding screen fields, in most instances using one of the Convert methods so the data being assigned to the parameter has the correct type; (2) open an SqlConnection; (3) do SqlCommand1.ExecuteNonQuery(); (4) close the SqlConnection; (5) fill the DataSet; (6) bind.I've experienced multiple kinds of failure in this process, but the primary kinds of failure I've experienced are these:- The one value I'm actually updating (a text field) doesn't get updated on the database. No other fields are touched.- Two fields with Int values (SQL Server shows them as length 4; does that correspond to Int32?) are set to NULL.- The ExecuteNonQuery complains that I'm not supplying a value for the one field that is type DateTime. (In the SQL Server database, this field is permitted to be NULL, and in the record I'm playing with, it is in fact NULL. However, since TextBox.Value is of type String, I'm having to set it to Nothing [Visual Basic] if the text box is blank.)One thing I don't like about this is that I can't see what values the parameters are taking on as I do my processing, even in the debugger. At least I don't know of any way to examine or watch them. One reason this bothers me is that I have a rather strong suspicion that there's something wrong with the way I've set up the parameters, but I can't tell what's happening to them to confirm that, and I also can't see the SQL that's being generated (or can I?).Any thoughts?Thanks,TimPS Be gentle, please -- this is my first Web application. :-)
I'm taking over an SQL Serverdatabase which is often updatedwith data from an Access database.Knowing little about either, thissimple task has become a challenge.I'm told that the previous personused to type some simple SQLcommands and this would updatethe SQL server database but thecommands have been lost and theprevious person is unavailable.The Access database has exactlythe same column names as the SQL-server databaseand it is something simplelike:Control ID Phone Name Address1 Address2Does anyone know the SQL commandsto do this kind of SQL server database update from theabove mentioned Access database?The previous person left an app which connectsthe two databases and leaves a placewhere the SQL commands are to be typed.ThanksTAK
Hello, I'm using Visual Studio 2003 and I need to be able to connect to an SQL Server 2005 Express database on the same machine using ASP.NET pages, but I'm having difficulty getting the pages to make a connection. I'm new to ASP.NET and I'm probably making some totally elemental mistake. I'd appreciate any assistance anyone can offer. I have pasted in part of the codebehind file for a web form (asterisking out the database name) and the error report that appears in the browser when I call the page.using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Data.SqlClient;using System.Drawing;using System.Web;using System.Web.SessionState;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.HtmlControls;namespace WebApplication2{ /// <summary> /// Summary description for WebForm1. /// </summary> public class WebForm1 : System.Web.UI.Page { private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here string strConnection="Integrated Security=SSPI;Persist Security Info=False;"; strConnection +="initial catalog = ******;server=WILL-000993DB49\SQLEXPRESS;"; SqlConnection objConnection = new SqlConnection(strConnection); objConnection.Open(); objConnection.Close(); } #region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN: This call is required by the ASP.NET Web Form Designer. // InitializeComponent(); base.OnInit(e); } /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.Load += new System.EventHandler(this.Page_Load); } #endregion }} Server Error in '/WebApplication2' Application.
Cannot open database "******" requested by the login. The login failed.Login failed for user 'WILL-000993DB49ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database "******" requested by the login. The login failed.Login failed for user 'WILL-000993DB49ASPNET'.
Source Error:
Line 24: strConnection +="initial catalog = ******;server=WILL-000993DB49\SQLEXPRESS;";Line 25: SqlConnection objConnection = new SqlConnection(strConnection);Line 26: objConnection.Open();Line 27: objConnection.Close();Line 28:
Here is the way SQL Server 2005 Express is currently setup:
SQL server has IP of 192.168.8.200. (DMZ zone - 192.168.8.*)
Web server has IP of 192.168.8.81. (DMZ zone - 192.168.8.*)
My workstation has IP of 192.168.1.100. (Trusted zone - 192.168.1.*)
So, I've been developing a web application that was stored in the trusted zone, and this application didn't have any problem connecting to the database on *.8.200. I even have SMSE running and I can manage the database without any connection problems. I moved the web application to the web server, without changing the web.config file, and now it will not connect from the webserver.
In the web.config file, the connection string is pointed to 192.168.8.200SQLEXPRESS. I'm confused because it seems that since the SQL server and the Web server are in the same zone, there shouldn't be any connection problem.
In the Firewall, I have port 1433 open for TCP/UDP for ANY -> ANY...so I think the firewall is configured correctly?
I am creating an install for our product and as part of the changes I am making, I want to upgrade a user's DB engine, if they are still using MSDE 1.0, to SQL Express 2005.
The upgrade path we have chosen is the following.....
MSDE 1.0 --> MSDE 1.0 sp4 --> SQL Express 2005
I believe this should work, yes? Anywho, I am trying to run a "passive" install of SQL Express and I am using the following parameter list:
This is my first post ever so forgive me if this is too basic a question.
I have an Access 2000 database that I'm trying to make into a SQL 2005 Express database. Both databases are on the same machine (I've given up with the networking of this) and, after straightening out several problems I've ran into one I can't seem to fix.
Using the Upsizing Wizard in Access 2000 I try to connect to SQL 2005 Express but I keep getting this error: http://www.paulmauer.com/SQL%20connection%20error.doc
SInce both programs are on the same machine I don't understand what is happening. Any help would be appreciated.
When I downloaded/started using Visual Web Developer I was under the impression that I needed to install SQL Server Management Studio Express in order to create/manage databases, and to provide the engine to access the data. Since then I have found tutorials and have successfully created/used databases solely from within Visual Web Developer. I'm assuming that Visual Web Developer includes a database engine, much like the webserver that is included. (This is an awesome thing). When I tried to upload my web application with database to my production server, the database would not work, it started working after I installed SQL Server Management Studio Express on the server. Is it my understanding that you need SQL Server Management Studio Express if you do not have Visual Web Developer Express installed in order to provide the data access engine? Also, I am unable to "attach" my Visual Web Developer Express created database to SQL Server Management Studio Express. Are there any posts that provide more information about this topic?
The only reason I'm asking is that I have extra whitespace on the end of my text fields, and I thought ANSI_PADDING was turned on. I do not see the option in Visual Web Developer Express, but have found it in SQL Server Management Studio Express.
I am a newbie so i apologies beforehand for any mistakes i make on this forum. Anyway, i created an asp.net website using the MS Visual Web developer tool. This has a couple of SQL SERVER databases within it. I then latervinstalled the SQL SERVER management studio express in order to manage the SQL SERVER DBs that i had as part of my website but they do not appear within the management studio db list. As this is the express version, is there anyway of importing the existing SQL SERVER dbs that i have to the management studio so i can manage them from there?
Okay, I've read massive topics on ClickOnce, and embedded database applications, etc, etc.
I need a handful of good suggestions how I can create a deployment package, to get my sql express database onto a SQL Express server.
The database will need to be multi-user, because I am also developing a WinForms application to connect to the SQL Express database.
I'm thinking I need to use some automated scripting features, to generate scripts for the database once I am done (unless you have a better suggestion).
After that, I need to know what to do with those scripts, and how can I create a setup / deployment packages to run those scripts against a SQL Express server.
The other alterntative obviously is to copy my sql express database, and run an attach command. This will work the first time, only because this will have been the first deployment of this database.
Please keep in mind when answering this question, that I will not be embedding the database, and as far as I understand ClickOnce is a feature for use with embedded databases or user instance databases (not sure).
Hi, I'm completely new to SQL Server and ASP.NET, so please bear with me on my learning curve! I've installed Visual Web Developer Express and SQL Server Express (on the same PC). I then used Web Developer Express to successfully create a new database with a couple of tables in it. So far so good. I then installed SQL Server Management Studio Express on the same PC and tried to connect to my new database. The connection to the SQL Server instance appears to work OK (using Windows Authentication) but I can't see the database I previously created. All I can see are the System Databases. Does anyone know what the solution might be?
In the last one and half years, I used the Northwind Database in SQL Server Management Studio Express (SSMSE) to learn the programming of SqlConnections, Data sources, Database Exploere, ADO.NET 2.0, etc. via VB 2005 Express.
The Northwind Database in my SSMSE got lost very often, but I was not aware of it. How can I know where the Northwind Database is used or processed by my VB 2005 Express projects that were the examples of some tutorial books or my trial projects? How can I release the Northwind Database back to my SSMSE from the VB 2005 Express projects? Please help and advise.
I am new to this type of programming and and have read all articles on adding an image to the database and it seems they all use sql queries to add an image but I want to add an image at design time. I am using Visual Basic 2005. I am also using Visual Basic 2005 Express Edition to try the same thing. I am trying to build a Translator program for english to Brazilian Portuguese and the reason I want to add the images is so that when I translate the word cat from english to Portuguese, I can also show an image of a cat. Can anyone please help me
