But I'm not quite clear on what will happen if you currently have SQL Server Express 2005 installed with User Instances, and then you launch the installer for SP1.
Will it also update the User Instance? If so, how could I tell? When I go to the registry for the User Instance it has the older version value ie.
When I am in Visual Studio 2005, and I try to add an SQL database, I get the following error "generating user instances in sql server is disabled. use sp_configure user instances enabled to generate user instances." I am currently using SQL server 2005 Express. What do I need to do, to create an SQL database? Thanks in advance.
My client has a server running MS 2003 Server for Smal Business Server, and it has SQL Server Express 2005 installed (I believe it is installed 3 times, as part of SharePoint, Veritas Backup Exec and ACT! applications).
I am trying to implement an application that uses SQL Server 2000, but the Server 2003 SBS does not support that version. So I need to launch an additional instance of SQL Server Exp 2005.
To do so, do I need to download and install SQL Server Express 2005 software again? Or can I just run SQLSVR.exe from an existing instance, but with a different instance name (sqlservr.exe -s<InstanceName>?
The reason I need another instance is that these existing instances limit DDL statements.
I am new to this and compare it to launching MS Word multiple times - you don't need to reinstall Word to run it multiple times.
Is launching from the command line a bad idea - and if it is, what is the better way to ensure that it launches under the local system context a service?
Thanks in advance for any help and insights. It is much appreciated.
Hi all, I want to do SQLCLR by Connecting to SQL Express User Instances in Management Studio via VB 2005 Express and I have read the following articles and books: (i) Connecting to SQL Express User Instances in Management Studio in http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-insta... (ii) Managing SQL Server Express with SQL Server 2005 Management Studio Express Edition in http://www.microsoft.com/technet/sql/2005/mgsqlexpwssmse.mspx (iii) Chapter 16 - Going Beyand Transact-SQL: Using the SQL Common Language Rutime (SQLCLR) in Microsoft SQL Server 2005 Express Edition for Dummies (iv) Chapter 21 - Working with the Common Language Runtime in Microsft SQL Server 2005 Programming for Dummies (v) Chapter 4 - Introduction to Common Language Runtime (CLR) Integration in Programming SQL Server 2005 by Bill Hamilton. I want to create an SQLCLR project "HelloWorld" by Connecting to SQL Express User Instances in Management Studio via VB 2005 Express. But I am still not sure how to get it started, because I do not understand the following things: (1) Pipe Name for a User Instance, (2) Enabling (or Disabling) the CLR by using Transact-SQL, (3) Creating a Transact-SQL script, (4) Creating an Assembly, (5) Creating a backup device, etc. I need to see some simple examples of SQLCLR by Connecting to SQL Express User Instances in Management Studio via VB 2005 Express. Please help and tell me where in the websites I can find them.
I have a general question relating to SQL Express User Instances. Our application connects to a local SQL Express database through the default SQLEXPRESS user instance. My question is simply whether a user may experience a problem in connecting to our application's database should another application already be connected through the same default user instance (SQLEXPRESS)? The two applications are therefore running similtaneously. Also, are there any limit to how many applications could use the same service similtaneously?
I would like to have more info on UserInstances concept of SQLExpress 2005.
Can i find any code samples for this feature in MSDN.
I have tried using the following links.. http://msdn2.microsoft.com/en-us/library/ms143401(SQL.90).aspx http://msdn2.microsoft.com/en-us/library/ms143684(SQL.90).aspx http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp http://msdn2.microsoft.com/en-us/library/ms254504.aspx http://msdn2.microsoft.com/en-us/library/ms165690(SQL.90).aspx http://msdn2.microsoft.com/en-us/library/ms143446(SQL.90).aspx
any other links will be helpful for me in this regard.
I have used SQL Server Management Studio Express (SSMSE) and Visual Basic 2005 Express (VBE) for more than one year to pick up the Transect-SQL, ADO.NET 2.0, SQL Server 2005 Express, SQLCLR, etc. Yesterday, I used SSEUtil to execute: C:SSEUtil>SSEUtil -l I got the following: 1. master 2. tempdb 3. model1 4. msdb 5. 56713D4D965AE4455_TSVISUAL STUDIO 2005PROJECTSMYFIRSTAPPSSE-VBEXPRESS-WINDOWSAPPLICATION1BINDEBUGMYDB1.MDF 6. C:DOCUMENTS AND SETTINGSCOTT H CHANGMY DOCUMENTSVISUAL STUDIO 2005PROJECTSMASTERDETAILMASTERDETAILBINDEBUGMYDB1.MDF 7. C:ADONET2CODE-JOHNSONVBCHAPTER02CONNECTEDCLASSESSETBINDEBUGPUBS.MDF 8. C:PROGRAM FILESMICROSOFT SQL SERVERMSSQL.1MSSQLDATANORTHWIND.MDF 9. C:ADVENTUREWORKSLTADVENTUREWORKSLT_DATA.MDF I created some VBE projects and used some examples from some tutorial books and websites in the past. But, I thought that user instance timeout is 60 minutes and user instances should be gone after 60 minutes. Why do I have the above-mentioned user instances remained in SSEUtil now? Please explain this thing for me.
I have found no real documentation on this, so any links would be greatly appreciated.
We have an existing 2 node active active cluster.
A default and and named instance SS2005 Enterprise Edition are installed on the cluster.
Recently we acquired new hardware, 2 servers, which we added to the cluster so we now have a 4 node cluster.
The 2 new nodes have OS etc installed.
Now i have installed sql on a new multi node cluster, i have upgraded sql server in an existing cluster BUT i have never installed sql on an existing cluster for new nodes for multiple instances.
Now i presume you simply run the install on one of the new nodes, do this for a default instance, selecting both 2 new nodes to installl on. And do this again for the named instance.
But in the past I have never been promoted for which nodes to install sql on, it simply does all the nodes BUT i do not want this.
And how will the cluster know where the binary files are for each instance on the new nodes?
In a nutshell, how do i install sql server 2005 for 2 new nodes in an existing 4 node cluster for multiple instances ?
Can we install two instances of report server on the same machine?. We want to use the same hardware for two different methods of custom authentication. Both the server applications would then talk to the same database.
If I install a new named instance of SQL Server 2008 R2 on a machine that already has 3 named instances that are upgraded to service pack 3, will the install of the new instance overwrite any of the current SP3 files? Will I have to re-apply SP 3 to the existing instances?
I am relatively new to sql developer. There is a new user that just joined our organization. I am trying to grant him the same direct grants privilege to the tables that an existing user has. The existing user has a ton of direct table access privileges and it will take days if I had to do each grant one by one like: grant select,insert,delete,update on 'table name' to 'user id'. Is there a way of copying or inserting an existing user's privilege and granting it to a new user.
Hi, I am trying to install multiple application services on 1 sql server database. Is this possible? I do not know how to install anything but the default application services settings for the membership, roles, etc.
I have installed integration service on a SQL Server 2005 development server and could not start the service. Windows Server 2003 Standard Edtion (SP2) + SQL Server 2005 Developer Edition (SP2) are installed on the server. When trying to start the service from SQL Server configuration tool or directly from service, got message saying that the service did not start in a timely fashion. Nothing is logged to event log.
Found this this kb. http://support.microsoft.com/kb/918644 The problem description is similar but not sure whether it is the same problem.
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?
Hi. I am trying to connect to a database but keep encountering the same error. I have a free hosting account with quantasoft (qsh.eu) who fully support SQL express user instances. I have also used the connection string generator on their site. This is the result of the error. Cannot create file 'H:HomeWebsqsh.eu ransmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009wwwApp_DataDatabase_log.LDF' because it already exists. Change the file path or the file name, and retry the operation.Could not open new database 'transmission.qsh.eu_a45add63-33a4-4414-b09c-6880f10717b3'. CREATE DATABASE is aborted.Cannot attach the file 'H:HomeWebsqsh.eu ransmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009wwwApp_DataDatabase.mdf' as database 'transmission.qsh.eu_a45add63-33a4-4414-b09c-6880f10717b3'.File activation failure. The physical file name "C:Documents and SettingsJamesLocal SettingsTempVWDWebCacheftp_transmission.qsh.eu_wwwApp_DataDatabase_log.LDF" may be incorrect. 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 create file 'H:HomeWebsqsh.eu ransmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009wwwApp_DataDatabase_log.LDF' because it already exists. Change the file path or the file name, and retry the operation.Could not open new database 'transmission.qsh.eu_a45add63-33a4-4414-b09c-6880f10717b3'. CREATE DATABASE is aborted.Cannot attach the file 'H:HomeWebsqsh.eu ransmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009wwwApp_DataDatabase.mdf' as database 'transmission.qsh.eu_a45add63-33a4-4414-b09c-6880f10717b3'.File activation failure. The physical file name "C:Documents and SettingsJamesLocal SettingsTempVWDWebCacheftp_transmission.qsh.eu_wwwApp_DataDatabase_log.LDF" may be incorrect.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException (0x80131904): Cannot create file 'H:HomeWebsqsh.eu ransmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009wwwApp_DataDatabase_log.LDF' because it already exists. Change the file path or the file name, and retry the operation. Could not open new database 'transmission.qsh.eu_a45add63-33a4-4414-b09c-6880f10717b3'. CREATE DATABASE is aborted. Cannot attach the file 'H:HomeWebsqsh.eu ransmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009wwwApp_DataDatabase.mdf' as database 'transmission.qsh.eu_a45add63-33a4-4414-b09c-6880f10717b3'. File activation failure. The physical file name "C:Documents and SettingsJamesLocal SettingsTempVWDWebCacheftp_transmission.qsh.eu_wwwApp_DataDatabase_log.LDF" may be incorrect.] System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.WebControls.Repeater.GetData() +50 System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +232 System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +53 System.Web.UI.WebControls.Repeater.DataBind() +72 System.Web.UI.WebControls.Repeater.EnsureDataBound() +55 System.Web.UI.WebControls.Repeater.OnPreRender(EventArgs e) +12 System.Web.UI.Control.PreRenderRecursiveInternal() +77 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360 ------------------------------------------------------------------------------------------------------------------------------------------------------------------ When i remove the database= tag i get this An attempt to attach an auto-named database for file H:HomeWebsqsh.eu ransmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009wwwApp_DataDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I have been developing and testing my app for some time without worrying about the question of user instances. Due to the nature of the app, I would want the database to be copied to laptops, where data would be added and then merged back into the "main" DB.
To facilitate this, when the (VB) app first installs, it copies the DB files from the data directory to an easily accessible folder which it creates in the C: drive (if they are not already there - to facilitate application upgrades).
The code is written and working. However, then I thought about user instances. With User Instance set to True, I suspect that this concept of a DB file created by a user on a given machine being readable by another user with a laptop is likely to fail (unfortunately I only have access to a single machine).
So I tried to change the User Instance to false (in the App.config file). This stopped the application from running. I checked in the Modify Connection (Advanced) screen which still showed User Instance to be True. I tried to change this but got an error message.
I can see a way around this, but I don't like it. I guess, rather than "export" the DB files to the laptop, I could send the data as an XML file. However, this seems to me to compromise security as it would be very easy for anyone to filter any actual data they wanted from such a file - unless there is a way to password protect an XML file?
So, is there any way that I can make these DB files (on the C: drive) available to any user, on any machine who is running the application so that they can import the data to their version of the App, add to it and then send the changes back to the original?
So if the connection strings for say 2 separate users is configured for a user instance, what is the best approach to synchronising the user instances against each other and the Server instance?
This architecture suits remote users and I'm very interested to learn more about it.
Given than once SQL Server 2005 is installed, SQL Server Studio has to be used instead of Enterprise manager, can both SQL 2000 and 2005 be used on the same machine, be it development or production? (The second one to be installed probably would be a named instance.) Any experiance of doing this or a pointer to a Microsoft recommendation would be appreciated.
On first run, my app takes the blank database from the data directory and sticks it into a folder on the C: drive. Lets call this folder ABC for convenience.
Now, sometimes, we need to take this DB to use on another machine. So I have a "Guest" button available at logon screen of the app that allows the user to browse the file system and select a different DB to use then creates the appropriate connection string for say, a DB on a USB stick or wherever.
Con = "Data Source=.SQLEXPRESS;AttachDbFilename="
Con += OpenFileDialog1.FileName
Con += ";Integrated Security=True;Connect Timeout=30" ';User Instance=True"
No problems here, it works for Express Edition.
However, someone else who is trying to use the app has SQL 2005 (not Express Edition installed) and it wouldn't work because the connection strings had User Instance = True in them.
Okay then, we'll just remove that bit of the connection string and it should work. They should be an Admin so no reason for User Instances.
It works fine if we browse to any DB file other than the one in ABC folder.
However, it is impossible to connect to the DB in ABC folder unless User Instance is set to True.
Secondly; for the app to work with the non-express version, would the connection string need to be changed (SQLEXPRESS)? If so, how do you detect programmatically which version the user has?
We have developed an application that uses User Instances of the database for each user. We have a stored proc that enables and disables the triggers on the various tables of the database. In our first round of debugging we have found that the applciation hangs when we try to either enable or disable the triggers. Can you modify triggers in user instances???
I couldn't reply the another thread so I'm continuing here.
Was about "Enable user SQL instances" and the Report Service didn€™t started too. How do I enable this remote connections? And in the instalation, Should I Add a user to the SQL Server Administration Role?
And also in the step "ready to install" of the SQL Server SP2 shows the following:
I nearly went nuts before finding out that SqlExpress Names Instances don't listen on Port 1433. Having discovered that I now think I can nominate a specific port, is that correct.?
My main question. I copied my databases from my development machine to a server, which will be accessed from an internal domain, and also through VPN tunnels. Should I change from User Instances on the server, and if so, how do I do this.?
My original application wasn't using User Instances, but chnaged to them somehow, when my PC had a name change.
I have DBA that is convinced that they need domain admin rights to install SQL 2005 into an existing cluster. The domain groups and service accounts for SQL have been created already. Is having domain admin rights required during the install of SQL 2005 in a cluster?
I have recently returned to developing a website using Visual Web Developer Express 2008. I want to store information in a database. I have SQL Server 2005 Express edition installed on my pc. When I try to Add New Item -> SQL Database from VWD2008 by right clicking in the App-Data folder and completing the dialogue I get the following error message:
Generating user instances in SQL Server is disabled. Use sp_configure ‘user instances enabled' to generate user instances. I have SQL Server Management Studio installed but do not seem to be able to resolve this issue. My operating system is windows XP Home SP2. Some guidance on solving this would be appreciated. Many thanks Roger L
I just want to know if SSCE 3.0/3.5 can cater for Multi-user instances? I have a desktop application that I want to allow multiple Windows-user accounts to access. basically I need a datastore that can be lightweight (which SSCE is) and support "User Instances" (like in SQL Server Express)
I am attempting to restore a backup of a 2008 R2 database to my new 2012 instance. I am receiving the message, "FILESTREAM feature is not supported on user instances."Â I am running v11.0.5343.0 (X64), Express Edition.I was under the impression from the features supported page [URL] .... that FILESTREAM was supported across editions. I can't seem to find anything online specific to 2012 as to why I am not able to restore.
This is my first C# (2.0) Windows based app accessing a local SQL Server database. Ive build a couple of web based apps using C#.
First I just copied a datbase access wrapper class from one of my web apps and used that. It works, but, the database shown in Server Explorer in VS2005 shows the table as empty. The table in /bin/ however, is updated as expected. Before I realised that there were seperate instances of the database i stripped everything down to a very simple example
This little tester windows based app has a simple tester drag and dropped grid view in it. When i run /pathToApp/bin/Debug/<AppName>.exe, independantly of VS, the grid view is full of the value "atest" as expected, but not when ran under visual studio. As I said above i found (at least i think this is right) there is a debug and user instance of the database. So im guessing I need two connection strings if i want to update both whilst dev'ing the application.
Ive had a look throuhg connectionstring.com and, to be honest, im confused... Any help for what the second connection string should be would be greatly apprecaited.
Using SQL Express, UNDER COMPUTER management, SQL Server Configuraqtion Manager, SQL Server 2005 Network configuration Ihave the following listed instances
CSOLUTION - not listed under services
MSSQLSERVER - Disabled
SQLEXPRESS - Diaabled
SQLTEST - Disabled
SQLEXPRESSDATA - used by VB05 program
Questions
a) how do I delete all the instancces I do not use. In MSDE, each instance could be removed via the add/remove programs, but I don't see how to remove it under express
b) since SQLEXPRESS is the default for an SQL Express installation, I would like for the VBB05 program to use that instance; how do I do that?
I am developing an application that uses SQL Server Express. Everything is running great, except that I can't figure out how to copy a DataBase from my server at work onto my laptop so that I may test it at home...
How can I copy the DataBase from my Server at work to my laptop? I'm on the network at work, I just can't figure out how to copy it...
The disabled instances will not start due to various error messages.
Under Computer, Manager, Services, more instances are listsed, which also will not start:
SQLEXPRESSDATA for example (which is disabled)
I would like to remove CSOLUTION since it is not used; it will not remove from control panel or manually via http://support.microsoft.com/default.aspx/kb/909967 . You get various error messages, such as
Another application has exclusive access to the file c:program files...errorlog. Please shut down all other applications, then try again.
Even after a reboot, I still get this error.
I want to install and use instance SQLExpress, and I cannot remove it, but it will not start, and trying to reinstall it fails.
It was simple under MSDE 2000, no2 it seems to be impossible.
Does anyone have any ideas?
Honestly, I would like to uninstall SQL Express 2005 completely (except the BCM instant), and start over, but canot find a way to do this. SQL Express is a mess, I have spent days trying to resolve this, and am still where I started. Thanks, bob