SQL Server Express 2005 - How To Delete/drop A User Instance
May 23, 2008
Hi,
I have been working around with SQL Server Express 2005 on VISTA. I created a small C++2008 application which interface with SSE 2005. When running my application, it automatically created a user instance which I would like to get rid of. I just forgot from start to set "User Instance = False" in my connectionstring. (oups...)
I'm aware, from readings I did, that a couple of tables as well as log files, etc. are created under directory "utilisateurs...AppDataLocalMicrosoftMicrosoft SQL Server DataSQLEXPRESS". SQLEXPRESS is the instance name chosen during install of SSE2005.
For the first time, I want to set up the configuration of my SQL Server Management Studio Express (SSMSE) to allow me in doing the non-User-Instance/ADO.NET 2.0 programming from my VB 2005 Express. The SSMSE and VB 2005 Express are in my Windows XP Pro PC that is part of our NT 4 LAN System in our office. I read the article "How to configure SQL Server 2005 to allow remotre connections" in http://support.microsoft.com/kb/914277/ about (i) "Enable remote connections for SQL Server 2005 Express", (ii) Enable the SQL Server Browser service", (iii) Create exception in Windows Firewall, and (iv) Create an exception for the SQL Server Browser service in Windows Firewall. I entered the SQL Server Surface Area Configuration and I could not decide what options I should take for doing the non-User-Instance/ADO.NET 2.0 programming from my VB 2005 Express. I have the following questions on the page of "Minimize SQL Server 2005 Surface Area": (1) I saw "Configure Surface Area for localhost [change computer]". I clicked on [change computer] and I saw the following: Select Computer The Surface Area Configuration of this surface area of this computer or a remote computer. Specify a computer to configure: O Local computer O Remote computer Should I choose the "Local computer" or the "Remote computer" option? (2) Below the "Configure Surface Area for localhost [change computer]", I clicked on "Surface Area Configuration for Service and Connections", Select a component and then configure its services and connections: |-| SQLEXPRESS |-| Database Engine Service I picked => Remote Connection On the right-hand side, there are: O Local connections only O Local and remorte connections O Using TCP/IP O Using named pipes only O Using both TCP/IP and named pipes Should I choose O Local and remorte connections and O Using named pipes only?
Please help and tell me what options I should choose in (1) and (2).
Hello, I'll try to make the description of this multi-problem scenario as short and sweet as possible.
First Problem The default named instance of "SQLEXPRESS" was somehow installed on my machine and nothing can get rid of it. However, it is somehow invisible to everything else on my system, so I can't use it. How do I get rid of the instance or repair it?
Second problem I installed another instance of the SQL Server 2005 Express and named it, "SQLEXPRESS02". I attached a database to it and successfully retrieved data from it using an application that used the following connection string:
Data Source=(local)sqlexpress02;AttachDbFilename=|DataDirectory|MyDatabase.mdf;Initial Catalog=MyDatabase;Integrated Security=True;User Instance=True
Next, I tried to use a different application to retrieve data from a copy of the same database located in a different directory and used the same connection string as that shown above. When I do this, I receive an error message similar to the following:
Database 'C:PathToMyOriginalProjectinDebugMyDatabase.mdf' already exists. Choose a different database name.
Cannot attach the file 'C:PathToMyNewProjectinDebugMyDatabase.mdf' as database 'MyDatabase'.
I then tried, out of curiosity, to change the Initial Catalog portion of the connection string to "MyDatabase2" and attempt the data retrieval again. The connection string looked like this:
Data Source=(local)sqlexpress02;AttachDbFilename=|DataDirectory|MyDatabase.mdf;Initial Catalog=MyDatabase2;Integrated Security=True;User Instance=True
Interestingly enough, it worked. However, when I switched back to the original connection string, I got the same error message as before.
What's going on here? I thought that one of the virtues of user instances was that they would attach at run-time, then disconnect when the application was through with them. If that's the case, then why am I getting errors stating that a database of the same name is already attached? Is there a way to detach these databases from a user instance? Can it be done by some value in the connection string?
I get the following message after updating to sql server express 2005 advanced. Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
I noticed that in my C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Data I have not databases? How do I get them back?
I also had to add back the aspnet to the permissions and the network and network service to the app_data folder.
Hi all, I have read/studied (i) Working with Databases in Visual Web Developer 2005 Express in http://quickstarts.asp.net/QuickStartv20/aspnet/doc/data/vwd.aspx, (ii) Xcopy Deployment (SQL Server Express) in http://msdn2.microsoft.com/en-us/library/ms165716.aspx, (iii) User Instances for Non-Administrators in http://msdn2.microsoft.com/en-us/library/ms143684.aspx, and (iv) Embedding SQL Server Server Express in Applications in http://msdn2.microsoft.com/en-us/library/ms165660.aspx. I do not understand the concepts and procedures to do Xcopy and User Instances for non-administrators completely-I do not know how to connect to databases and create database diagrams or schemas using the Database Explorer. I have a stand-alone Windows XP Pro PC. I have created a ChemDatabase with 3 dbo tables in the SQL Server Management Studio of my SQL Server Express and a website of my VWD Express application with an App_Data folder. I am not able to proceed to use Xcopy and user instance to bring the 3 dbo tables of ChemDatabase to my App_Data folder. Please help and give me some detailed procedures/instructions to bring the 3 dbo tables of ChemDatabase (or ChemDatabase itself) from the SQL Server Management Studio Express to the App_Data folder of the website of my VWD Express project? Thanks in advance, Scott Chang
Is there a way to re-index a SQL Server Express User Instance? If I try to open the .mdf while the website is still running, I get a message stating that the file is in use. If I shut down the web service and open the .mdf, then restart the website, then the website cannot access the .mdf while I have it open in VStudio (reminds me a lot of Access). In the past I tried to open a user instance with SQL Server Management Studio, but then it goofed up my user-instance...so I am hesitant to try that again. Is there any way to re-index? Thanks!
how do I attach my user instance mdf and chagne scheme etc? for example my mdf is at c:sqldatamyapp.mdf
I tried attach and got
TITLE: Microsoft SQL Server Management Studio Express ------------------------------
Attach database failed for Server 'IEI-A64SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
Got windows Vista Business edition, installed Visual Web Developer Express, SQL Server 2005 Express SP2, SQL Server Management Studio SP1 in that order. I was developing in VWD express without problems using WinXP but now on Vista Business, the local connection to SQL server appears to be a problem. I know there's nothing wrong with my web.config or anything like that as it was working perfectly prior to running under Vista. If i specify the database on the live website, it works fine. If I specify the test database in app_data folder, I get the following exception:-
Server Error in '/UKSD' Application.
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed. 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: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.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): Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +736211 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1959 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +237 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +374 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +192 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 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.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlRoleProvider.GetRolesForUser(String username) +771 System.Web.Security.RolePrincipal.IsInRole(String role) +272 System.Web.Configuration.AuthorizationRule.IsTheUserInAnyRole(StringCollection roles, IPrincipal principal) +120 System.Web.Configuration.AuthorizationRule.IsUserAllowed(IPrincipal user, String verb) +300 System.Web.Configuration.AuthorizationRuleCollection.IsUserAllowed(IPrincipal user, String verb) +191 System.Web.Security.UrlAuthorizationModule.OnEnter(Object source, EventArgs eventArgs) +3509206 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
Version Information: Microsoft .NET Framework Version:2.0.50727.312; ASP.NET Version:2.0.50727.312
I am taking a guess it's somerthing to do with access issues, but can't find anything out on searching the forums etc.. I am setup as an administrator, running VWD as an administrator and for the record, SQL Server Management Studio express works fine. Another small issue, when I run the application from VWD, I always have to minimise the application and restore it as the graphics get corrupt. Please help!! I cannot debug when running of the live website.
As a starter i tried to modify and translate the Personal Website Starters kit from the VS2005Team SDK.
When i'm working on the machine were it's installed , under debugging, all works great.
But when i try to develop from my laptop, via RDP on the develop machine, i've got this message and can not debug (connect to the SQLxpres Server)
Does anybody now a solution ?? Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
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: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
Source Error:
Line 5: Sub Application_Start(ByVal sender As [Object], ByVal e As EventArgs) Line 6: AddHandler SiteMap.SiteMapResolve, AddressOf Me.AppendQueryString Line 7: If (Roles.RoleExists("Administrators") = False) Then Line 8: Roles.CreateRole("Administrators") Line 9: End If
my web app was working fine but as soon as i added in a page and few store procedures and 2 tables it just pop up with that error message. Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
i did go into the folder C:Documents and SettingsdnguyenLocal SettingsApplication DataMicrosoftMicrosoft SQL Server Datasqlexpress and delete the directory but this didnt help much. I still get the same error message. please help
I have just reinstalled windows xp pro with service pack 2 and framework 2.0. I am using SQL Express and visual studion 2005. I am trying to run my website and i keep getting this error message, i followed few instructions but i still failed to make it work. could someone who faced similar issues guide me,
thanks
MM
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed
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: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
Source Error:
Line 112: Public Overridable Property Theme() As String Line 113: Get Line 114: Return CType(Me.GetPropertyValue("Theme"),String) Line 115: End Get Line 116: Set Source File: C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Fileswroxunitedeecd65d2e1a6a798App_Code.ws-dzmjl.6.vb Line: 114
Stack Trace:
[SqlException (0x80131904): Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.] 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.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) +766 System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties) +428 System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) +410 System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName) +117 System.Configuration.SettingsBase.get_Item(String propertyName) +89 System.Web.Profile.ProfileBase.GetInternal(String propertyName) +36 System.Web.Profile.ProfileBase.get_Item(String propertyName) +68 System.Web.Profile.ProfileBase.GetPropertyValue(String propertyName) +4 ProfileCommon.get_Theme() in C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Fileswroxunitedeecd65d2e1a6a798App_Code.ws-dzmjl.6.vb:114 Wrox.Web.GlobalEvents.ThemeModule.app_PreRequestHandlerExecute(Object Sender, EventArgs E) in C:WebsiteWroxUnitedApp_CodeThemeModule.vb:30 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
I am new in .NET development and currently trying to learn VWB through Microsoft online tutorials.
Here is the problem that prevents me from getting further:
in VWB, when you right click App_Data and chose "Add New Item" and then select SQL database, the following error message is displayed:
"Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed."
If I cancel out of it, it does generate mdf file under App_Data folder in Solution Explorer, but when I try to open it, it says:
"The item does not exist in the Web directory. t may have been moved, renamed or deleted." and that is where the whole sharade deadends.
I can connect via mycomputersqlexpress under Data Connections in Database Explorer (it then adds "master.dbo" to the path) and then create custom tables, but that is not the same, isn't it? I mean, this will not integrate my database tables through default configuration that I am trying to follow?
when I try to connect to an mdf as a power user, --------------------------- Microsoft Visual Basic 2005 Express Edition --------------------------- Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed. --------------------------- OK ---------------------------
I was able to do do this before until Saturady when I had to re-install sql server, and express etc due to some system problem on my xp Pro PC. What have I misconfigured?
I do see the service SQL Serer(SQLEXPRESS) started under Network Service and SQL Serfver(MSSQLSERVER) started under local system.
My power user ID does have modify access to the sql 90 database folders. and to the mdf.
No wonder Microsoft is giving it away for free. It€™s not worth anything. I am very disappointed in this version of SQL server. I decided to start learning VB so I downloaded and installed VB 2005 express edition and SQL 2005 express. I tried to build a personal website using the starter kit. I kept getting the following error message, for which I have seen numerous postings on this forum. €œFailed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.€? I went out and bought the Standard version of VS 2005 thinking there may be a feature that the free express version is lacking. I uninstalled the express version, cleaned the registry, deleted all the folders it created and installed the Standard edition. Then I tried to create a personal web using the starter kit and it does the same thing again. I can not create a database file, connect to a database file. I can not create or attach a database on the SQL 2005 express from VS 2005. The SQL server Express seems to be working OK since I can attach to it using Microsoft SQL Server Management Studio Express. There is something about the way VS tries to connect to the database server that is not working. VB does recognize the local computer as a SQL server but can not connect to it. SQL server is set to accept Shared memory, TCP/IP and named pipes for local clients. What is causing this? This is some information on the system I am using:
MS XP (SP2)
Microsoft Visual Studio 2005 Version 8.0.50727.42 (RTM.050727-4200) Microsoft .NET Framework Version 2.0.50727 Installed Edition: Standard
Microsoft SQL Server Management Studio Express 9.00.1399.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 6.0.2900.2180 Microsoft .NET Framework 2.0.50727.42 Operating System 5.1.2600
I am now to programming but nor computer illiterate. I have been working with MS SQL servers since version 6.5 and have MCSE, Network+, A+ and Security plus certifications. Installing and using VS should not be this problematic. What is wrong with Microsoft?
I've set up a website on another computer using sql server express and visual web developer express, and it works as expected. However halfway through the development i've had to move to another computer. I installed visual web developer express + sql server express, and copied the project files across, but now when I attempt to run it I get the error:Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed. I've tried reinstalling the software and it doesn't help. Any idea why this is happening, and what I can do to fix it?thanks
Hello everybody,I was configuring a SqlDataSource control using SQL Authentication mode.I first added a database file (testdb.mdf) through Solution Explorer-Add New Items. Then through Database Explorer I created a table named "info"Then while configuring the SqlDataSource control I used the SQL Authentication mode and attached the "testdb.mdf" database file.Test Connection showed success. But when I hit the Ok button of the wizard it displayed the following error message:Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance.While configuring the SqlDataSource control I clicked "New Connection". Under Data Source section I tried both Microsoft SQL Server and Microsoft SQL Server Database File. And in both the cases I attached a databese file(testdb.mdf). Plz enlighten me on this.Thanks and Regards,Sankar.
ProblemWhen Remote Desktop to my main office machine, and when trying toconnect to SQL Express, I was becoming increasingly frustrated with thefollowing error:Error: 'Failed to generate a user instance of SQL Server due to afailure in starting the process for the user instance. The connectionwill be closed.'What is the solution?Solutions: ( pick any of the 3)1. Obtain and apply the patch http://support.microsoft.com/?id=8966132. Wait for the next Windows Service pack3.Of course if you can not get the patch, you can always do this (Note:You must have WinVnc server running in your remote computer)1. In the remote desktop session, reboot your computer.Click Start->Windows Security->Shutdown->Restart.Wait for some time to get machine up.2. Use your vncviewer to login to your remote computer. You can chooseto do all work via VNC or go to next step.3. Use remote desktop to login (this automatically closes the winvncsession).There you go, You did not create a remote session, but reused yourlocal session.
I'm new to SQL Server and just installed VS 2005 and SQL Server 2005 Express. My question is, is there any naming rules for an instance? When I open Express Manager it is asking me to enter an Instance name. Thanks for any suggestions or help,
Do the restrictions for SQL 2005 express apply to each instance or per server? For example, if there are two instances installed on a dual CPU machine, can each instance be configured to use 1 CPU and 1 GB of RAM?
We have a secuiry review and they have recommended dropping several xp_ stored procedures. I have tried the drop procedure with no luck, Error 3701, or right click delete in Man Studio, same error. I have granted the user alter permission to the master database and when I try to delete get Error 4606. I try to grant CONTROL permission of the stored proc to the user and get another 4606 error.
Do I just have to control the permissions of these procedures tightly?
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
I have a database created in server 2000, and now I have moved it to server 2005.
All works do fine, but there is a user which cannot be removed.
In the user properties window, the assigned schema is empty. The user is a db_owner of the database. When I was trying to update the user, it asked me for the login. The login is empty, but the field is disabled.
Hi, As per my understanding, if the user instance property is set to true for an express database then it is not multiuser/shared. A copy of the database is made for each user so he works on his private data. On the other hand, if user instance property is set to false then the express database is multiuser/shared. Thus different users will connect to the same instance of the database and changes by one user will be seen by the other users. Now, if we use an express database with asp.net and our application is installed on IIS then it is mandatory for the express database to have the user instance property set to true. But we see that in this case when different users visit our website, the data they enter goes into the same common database, ie. all the users share the same common database, even though user instance is true for the express database. Please shed some light to explain the correct functionality of the user instance property as related to the express database. Regards, Sandy
(have reposted this here from Setup group, since no answers there)
Hi, I am having a lot of trouble connecting to a user instance I've created. User instances have been enabled, Named pipes are also enabled. Running on XP SP2 with SQL2K5 SP2. I also have a standard SQL2005 instance running on this development machine.
When using SqlClient in a .Net2.0 application, my connection string to create the user instance looks like: "Data Source=.SQLEXPRESS;integrated security=true;attachdbfilename=c: emp3500.mdf;user instance=true"
This connection succeeds and I see the new service being started etc. I also see the log file being created in my Application Data area. The log file all looks normal except for these lines at the very top of the report.
2008-04-15 16:29:13.57 Server Error: 17156, Severity: 16, State: 1. 2008-04-15 16:29:13.57 Server initeventlog: Could not initiate the EventLog Service for the key 'D69F8BFF-E490-47'. 2008-04-15 16:29:13.67 Server Error: 17054, Severity: 16, State: 1. 2008-04-15 16:29:13.67 Server The current event was not reported to the Windows Events log. Operating system error = 6(The handle is invalid.). You may need to clear the Windows Events log if it is full. 2008-04-15 16:29:13.67 Server Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
I can also run a query on the main express instance to check if a child instance is running: SELECT owning_principal_name, instance_pipe_name, heart_beat FROM sys.dm_os_child_instances
If i try to connect via sqlcmd with this command line: C:Program FilesMicrosoft Visual Studio 8VC>sqlcmd -S np:\.pipeD69F8BFF-E49 0-47 sqlquery -l 60
this will give: HResult 0x57, Level 16, State 1 SQL Network Interfaces: Connection string is not valid [87]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.. Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
If i try to connect via SSMS using the pipe name above and everything else defaulted, i get the following error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) (.Net SqlClient Data Provider)
Both errors are pretty similar. I am running this locally, so I suspect the 'remote connection' error text is a red herring. The connection string is pretty minimal so I cant see why the connection string is invalid.
Heres another wierd thing. It used to consistently work. It now consistently fails. I have also tried creating a VM with SQLX. Now that works initially but once it fails, it seems to fail consistently. Reboots of the VM dont seem to fix it. That sort of leads me to believe that I've done something to my server (ie a setting somewhere).
Any help getting this connection issue sorted would be appreciated!
following is the code which i am trying to use it throws an error and dosent work. error details: Unable to cast object of type 'System.Data.Linq.DataQuery`1[tbl_temp_bank]' to type 'tbl_temp_bank'. source code(aspx.vb file) Dim c As New temp_business_bankDataContextDim tag = From t In c.tbl_temp_banks Where t.TIN = Convert.ToInt32(tin.Text) Select t c.tbl_temp_banks.DeleteOnSubmit(tag) c.SubmitChanges()
I originally installed SQL Server Express 2005 on my computer using Windows Authentication mode, and discovered when I tried to add another user/login that I didn't have permission to do so. This is rather odd as the windows account that I installed SQL server with is the system admin for the computer.
I have successfully changed the login mode to mixed, and have tried to login in as "sa", but it appears that "sa" was given some sort of password (did SQL server automatically generate one?), and I don't know what it is. When I go into command prompt and try to change the password, it says that it cannot alter the login 'sa' because it does not exist or I do not have permission (i'm pretty sure it's the later, as 'sa' shows up on the list of logins in SQL server express).
This forum is unbelievably huge, so i have no idea if this is the right place to post this...
I have an ASP.NET application, which is part of a work based project. I am developing in Visual Web Developer and my database is SQL 2005 Express (SP2). I cannot get the database to log in.
This is because my account is not an admin, as Vista disables SQL Admin rights by default...
So the Surface Area Configuration tool has the "Add New Administrator" tool.
I go to use it, it shows me the list on the left, i hit the button to shift it across to the right, sure enough, no problems. I hit OK. It does nothing. This is on Vista, on an Adminitrator account with all prieveleges. I have tried it with UAC turned on and turned off.
No matter what i do, it doesnt give me the rights. If i open the SQLProv tool again, all the list has shifted back into the left panel, as if the form never submitted.
Hi,I found this SQL in the news group to drop indexs in a table. I need ascript that will drop all indexes in all user tables of a givendatabase:DECLARE @indexName NVARCHAR(128)DECLARE @dropIndexSql NVARCHAR(4000)DECLARE tableIndexes CURSOR FORSELECT name FROM sysindexesWHERE id = OBJECT_ID(N'F_BI_Registration_Tracking_Summary')AND indid 0AND indid < 255AND INDEXPROPERTY(id, name, 'IsStatistics') = 0OPEN tableIndexesFETCH NEXT FROM tableIndexes INTO @indexNameWHILE @@fetch_status = 0BEGINSET @dropIndexSql = N' DROP INDEXF_BI_Registration_Tracking_Summary.' + @indexNameEXEC sp_executesql @dropIndexSqlFETCH NEXT FROM tableIndexes INTO @indexNameENDCLOSE tableIndexesDEALLOCATE tableIndexesTIARob
Hi all hope some one can help - please bear with me new to this Basically I have had to change pc's so I copied and pasted my ASPNET.MDF and LDF from my old pc to new PC including webpages/apps etc.. created. However now all I get is "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path """" Just don't understand what permissions the db should have, does it need to match the SQL Express owner...
