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.
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.
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
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.
I had a server with SQL Server 7.0 I installed a named instance of SQL Server 2000 and then i passed all my DB of the 7.0 instance to the 2000 instance. Then i removed the 7.0 instance, that was the default instance. So at the moment there is only the 2000 version, but it isn't the default instance Can the 2000 instance become the default instance? (So that clients can connect to it simply through computer name, and not creating an alias)
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.
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.
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?
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 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.
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.
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.
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.
This is my first time to deploy an asp.net2 web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed" (only in pages that try to access the database) Help pleaseee
Hi Dears, How can i detect the Local SQL Server instance (server name, uid, pwd) installed in a standalone systemusing C# 2.0?I used the fucntions available in odbc32.dll, but it only returns the result while the systemis connected in network.can any one resolve this....?thanks in advance...yenkay
with sql server 2000, it is possible to have multiple instances on one server. Now I want to make the second server a subscriber for specific tables before there are some tests/major changes. Has anyone experience with this on the same server. Note : sql server subscriptions between different servers in sql server 7 is not the issue.
I created a named instance of SQL Server 2000 on my notebook. I inadvertantly set the trusted SQL connection to Windows Authentication. This is creating a problem with COM because of username and password. I want to reset it to use SQL Server authentication but I can't find where to do it. Can I do this or do I have to delete this instance and create a new one.
Dear SQL Guru,I just found out this morning that my SQL Server box had been added 1more instance. Below is the example:PPAPP0075FINANCE (Old instance)PPAPP0075ACCOUNTING (Old instance)PPAPP0075Accounting (new instance)This is a case sensitive MS Sql server (third party vendor App). TheACCOUNTING instance is the one we have been using for our currentapplications. I found out the new one(Accounting) when I scan thenetwork by using OSQL -L utility. However, when NT engineers tried toverify the physical files location ofAccounting, and it did not exist. When I tried to register it and itdoes not appear from Enterprise Manager.Please keep in mind NT Engineers have been monkey around on this serverquite a lot in last a few weeks, especially modifying Registry keys.My question is, where did PPAPP0075Acounting come from? We never evertried to install any more instance on this server.Please help,Thanks,Silaphet,
I already have a copy of SQL SERVER 2000 installed on my current local machine. How is it possible that I create another second instance for example TEST/silkkeng in SQL Server Enterprise Manager? OR SQL query ? Is it possible ? Or the only solution is ReInstall SQL to create another instances?
Hi, I've got an application which uses the DBFactory Provider to enumerate a list of available SQL instances on the local network.
I've just reformatted though and put everything back on, and my application will now see the sql server instances on the network, but not the instances on the local computer (only the server name), eg, it will see "BENSQLEXPRESS" on a computer (BEN) on the local network, and give the version info, etc, but it only sees "DAN" instead of "DANPCP" and "DANSQLEXPRESS" on the local computer (DAN).
Login Failed for user , the user is not associated with a trusted sql server connection. (microsoft SQL Server,Error:18452)
hi , i am getting the above error message once in a while maybe two or 3 times a week , and then it goes away in 10 to 15 minutes or 5 minutes ,
our mode is set to mixed and we are able to connect and use both sql and windows , but once in a while , it will give us the above message when we try connecting throught sql server management studio client (using sql 05) using windows login , although it lets us connect using sql login while the windows login is denied, and after a while it lets us connect with both.
occurs randomly on some days , we run our servers on VM ware virtual machines using windows 2003 r2 enterprise 64 bit with sp2 with esx 301 virtual machine.
Hi all,I just asked some people to help me out and phone microsoft with thefollowing information, kindly they refused unless we setup a supportcontract with them first, for pre-sales information. (That really doesnot sound like good business sense to me - anyway here is our problem,if anyone could help thanks)."To tell and ask microsoft:We will be setting up a microsoft sql server 2000 instance running on awindows 2003 server.1) We need to check this can run alongside a microsoft 2003 sql server(either workgroup or standard edition), on the same machine. Are thereany .dll clashes if we do this? If there are can we run SQL Server2000, in a virtual machine running windows 2000 professional. (I have alicenced copy we can use for this).2) If we run one instance of 2000, and one of 2003 of the sql servers,can one use the processor licence model, and one use the CAL licencemodel."Thanks for any help, and any idea why they actually force you to usenews groups for pre-sales information?David