Before I start peppering this forum with questions I'll start with one that might help me figure out others...
I'm trying to debug a custom component I'm developing. All the texts I've read state that the first thing I should do is attach to the devenv.exe process. When I choose this, the window that lists the available processes I can attach to does not contain devenv.exe.
Is this a security issue? Any other ideas? I'm an administrator on the box. Most of my career's been spent in UNIX environments, so perhaps I'm missing something basic I'm unaware of.
Hey everyone. I've been using .NET and SQL server for almost 2 years. I know most of the ins-and-outs, but we hit a bug that requires us to use remote debugging to track down. Like most people, remote debugging does not work out-of-box, but, I've actually tried most of the tips and I still cannot get it to work. Here is a summary of my problem:
------------------------------
Trying to remote debug a SQL Server 2005 database on a workgroup. I am not using CLR, just plain T-SQL.
In Visual Studio, I use the Server Explorer with a data-connection pointed to my remote server and it uses Windows Authentication. It correctly enumerates the available databases. "Step into Procedure" shows the "Run Stored Procedure" dialog with the various input/output parameters. Continuing, I get a dialog that says
"T-SQL execution ended without debugging. You may not have sufficient permissions to debug."
SQL Server is run under Windows Server 2003's window account: 'sqlusr' Created user on local workstation called: 'sqlusr' The 'sqlusr' on remote server and local workstation have same password, and are in the Administrator groups 'SERVERNAMEsqlusr' is in SQL Server's bulkadmin, dbcreator, diskadmin, processadmin, securityadmin, serveradmin, setupadmin, and sysadmin roles Simply running Visual Studio 2005 Professional as my local user does not allow me to authenticate with SQL Server. Running: 'runas /userqlusr "devenv.exe"' will let me authenticate. So - user authentication is apparently working. I imagine that 'Remote Debugging Components' are installed, since msvsmon.exe is available on the server. RPC and RPC Locator are running on remote server and local machine There are no firewalls on the local workstation or remote server (Windows firewall is totally disabled, no 3rd parties..) Debugging a local SQLEXPRESS database on my workstation works. 'SERVERNAMEsqlusr' has full control over the debugging folder: 'C:Program FilesCommon FilesMicrosoft SharedSQL Debugging' I haven't seen any errors in the remote server's 'Event Viewer/Application' list The Stored Proc name I am executing does not contain any single or double quotation marks SQL Server and Windows Server both share the same name 'SERVERNAME' Edited DCOM Access Limits and Launch Limits in both the workstation and local server. Allowed 'Remote Access' for Everyone Any help? I'm out of ideas. Thanks in advance!
I get this error message each time i try to run the vb application in visual studio .net environment. -------------------------------------------------------------------------------- "Unable to start SQL debug session. Ensure sqldbreg2.exe and proxy/stub DLL sqldbg.dll are registered on this machine" -------------------------------------------------------------------------------
I am running visual studio and sql server 2000 on the same machine. I have given permission to sqldebugger user to access the system32 folder and sql debugging folder. This error message is followed by
------------------------------------------------------------------------------- Attaching the T Sql debugger to process[proj1.exe] on machine 'my machine name' failed Error code 0x80004004 ------------------------------------------------------------------------------
I am running MS SQL Server 2000 on windows 2000 adv server.
what can be done to remove this error. Thaks in advance
I have written Custom delivery extension, I am trying to debug this by attching the process ReportingServicesService.exe , I am getting error "Unable to Attach to the Process.Access is denied". I am Admin on my sytem, ASP.net is also part of admin and debuggers group. I am using Visual studio 2005, reporting services 2005, ReportingServicesService.exe is also under my login
i have a database wich is part of a vb.net project tha database worked fine..i wanted to change the location of the mdf file to the application folder so i copied it to that folder but then i tried to attach it to the server using the management studio right click database select attach that opened the add dialog box with the tree to locate the mdf file but the tree does not expand into the application folder and i can't get to the mdf file.so i tried to attach with attach command and i got the error message that access is denied error 5.i checked the security settings in all files and parent folders and everything seems ok
A co-worker deleted the log file to a database that was running. At that point the database showed as suspect and stopped running. I was able to detach the database but I am unable to attach the database. I get a msg stating the logfile cannot be found would I like to create a new one. I select yes. I get the following error.
Error 1813: Could not open new database 'dbname'. CREATE DATABASE is aborted. Device activation error. The physical file name 'fullpath to the original log file' may be incorrect.
I had to detach the database to delete the transaction log as it tookthe hole disk space.No I am trying to attach database, however I am not able to do so.The engine is asking me whether I want to continue and create new logfile. I agree to it, however then I am receiving an error:Error 1813: Could not open new database 'db_name'. CREATE DATABASEaborted. Device activation error. The physical file name 'E:SQLDatabasesMSSQLDatadb_name.ldf' may be incorrect.Then after I have message than attaching database failed.In event viewer I have:17204 :FCB::Open failed: Could not open device E:SQL DatabasesMSSQLDatadb_name.MDF for virtual device number (VDN) 0.In the error log I have:2008-01-23 10:28:59.00 spid52 Starting up database 'db_name'.Do you have any ideas where the problem is?I have never had this problem before, only now. And I didn't have thisproblem with other databases for which I have deleted the log file.
I had to detach the database to delete the transaction log as it took the hole disk space.
No I am trying to attach database, however I am not able to do so.
The engine is asking me whether I want to continue and create new log file. I agree to it, however then I am receiving an error:
Error 1813: Could not open new database 'db_name'. CREATE DATABASE aborted. Device activation error. The physical file name 'E:SQL DatabasesMSSQLDatadb_name.ldf' may be incorrect.
Then after I have message than attaching database failed.
In event viewer I have:
17204 : FCB:pen failed: Could not open device E:SQL DatabasesMSSQLData db_name.MDF for virtual device number (VDN) 0.
In the error log I have: 2008-01-23 10:28:59.00 spid52 Starting up database 'db_name'.
Do you have any ideas where the problem is? I have never had this problem before, only now. And I didn't have this problem with other databases for which I have deleted the log file.
This is by FAR, the most frustrating problem I have dealt with for a while.I have a project containing a SqlExpress database that I created in Visual Studio 2005. Everything works perfectly on my development machine. However, upon copying the site up to the webserver, I get an error stating:An attempt to attach an auto-named database for file D:ContentwwwFMakerApp_DataClassAd.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC shareI have read almost every article/forum post that resulted from a search with google. I also searched these forums, to no avail.Note - SQLExpress had just been downloaded and installed on the server, so it wasn't being used yet. Server is Windows Server 2003. Here are the following steps I have already taken:Used SSEUTIL.EXE to verify that another database of the same name was not already attachedUninstalled & reinstalled SQLExpress multiple timesTemporarily granted 'Full Control' permissions to 'Everyone' on the site folder to verify that it was not a permissions issue.Created a very simple website, with a new database, one page - with one listbox control, and a sqldatasource. Got the exact same error. Should rule out a problem with my application.Tried various flavors of the web.config connection string.Probably other stuff that I forgot about, but will add if I remember.The only things I could imagine being wrong are either a problem with my connectionString, or the fact that SQLExpress is installed on C:, and webstuff is on D: (Wasn't able to install SqlExpress to D: for some reason)Connection String <connectionStrings> <add name="ClassAdConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ClassAd.mdf;Integrated Security=true;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings> So I have had like 12 strokes today. If anybody could help me get this fixed, I will spread tales of your awesomeness throughout the landsI have included some extra info below in case it is needed. Thanks, Adam.Entire Error An attempt to attach an auto-named database for file D:ContentwwwFMakerApp_DataClassAd.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
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: An attempt to attach an auto-named database for file D:ContentwwwFMakerApp_DataClassAd.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Source Error:
Line 1705: }Line 1706: ClassAd.CategoriesDataTable dataTable = new ClassAd.CategoriesDataTable();Line 1707: this.Adapter.Fill(dataTable);Line 1708: return dataTable;Line 1709: }
Source File: c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Filesforms9d7c504b4b8a576eApp_Code.3dq8tdsl.9.cs Line: 1707
Hello, I just recently installed SQL Express 2005 on a new OS which is on Vista Ultimate. When I try to attach a database by clicking the add button, I receive this error: =================================== Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) ------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------Program Location: at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.SqlManagerUI.BrowseFolderHelper.GetBrowseStartPath(ISettingsStorage settingsStorage, ServerConnection serverConnection, Type controlType, String settingKey) at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.GetStartPath(String settingName) at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.buttonBrowse_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) =================================== An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------Program Location: at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Smo.ExecuteSql.ExecuteImmediate(String query) at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult erParent) at Microsoft.SqlServer.Management.Smo.Environment.GetData() at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci) at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request) =================================== The server principal "MyComputerKarl" is not able to access the database "model" under the current security context. (.Net SqlClient Data Provider) ------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476 ------------------------------Server Name: MyComputerSQLEXPRESSError Number: 916Severity: 14State: 1Line Number: 1 ------------------------------Program Location: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
When I try to creat a new database I receive this error: =================================== Create failed for Database 'TestDB'. (Microsoft.SqlServer.Express.Smo) ------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476 ------------------------------Program Location: at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl() at Microsoft.SqlServer.Management.Smo.Database.Create() at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.ApplyChanges(Control marshallingControl) at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForSql(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender) =================================== An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------Program Location: at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery, ScriptingOptions so) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl() =================================== CREATE DATABASE permission denied in database 'master'. (.Net SqlClient Data Provider) ------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476 ------------------------------Server Name: MyComputerSQLEXPRESSError Number: 262Severity: 14State: 1Line Number: 1 ------------------------------Program Location: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) On my previous computer which had WinXp Pro I had no such problems Any Help would be much appreciated Thanks Karl
Hello, I have a SQL Express database created with VWD 2005 and I want to attach it to the server using the SQL Server Management Studio. It is not the first time when I attach a database, but now, I don't know from what reason, it is not working anymore. So, I copy/paste the mdf and ldf files from the website location (the SQL Server Management Studio is not opening the folder C:usersmyuser in Vista Home Premium, don't know why) to a new location and try to attach. The error message is: TITLE: Microsoft SQL Server Management Studio Express------------------------------ Attach database failed for Server 'GEORGE-PCSQLEXPRESS'. (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 ------------------------------ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ Unable to open the physical file "E:SQLaria.mdf". Operating system error 5: "5(error not found)". (Microsoft SQL Server, Error: 5120) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476 ------------------------------BUTTONS: OK------------------------------ The file location is OK, what can I do?
This is by FAR, the most frustrating problem I have dealt with for a while.
I have a project containing a SqlExpress database that I created in Visual Studio 2005. Everything works perfectly on my development machine. However, upon copying the site up to the webserver, I get an error stating:
An attempt to attach an auto-named database for fileD:ContentwwwFMakerApp_DataClassAd.mdf failed. A database with thesame name exists, or specified file cannot be opened, or it is locatedon UNC share
I have read almost every article/forum post that resulted from a search with google. I also searched these forums, to no avail.
Note - SQLExpress had just been downloaded and installed on the server, so it wasn't being used yet. Server is Windows Server 2003.
Here are the following steps I have already taken:
Used SSEUTIL.EXE to verify that another database of the same name was not already attached Uninstalled & reinstalled SQLExpress multiple times Temporarily granted 'Full Control' permissions to 'Everyone' on the site folder to verify that it was not a permissions issue. Created a very simple website, with a new database, one page - with one listbox control, and a sqldatasource. Got the exact same error. Should rule out a problem with my application. Tried various flavors of the web.config connection string. Probably other stuff that I forgot about, but will add if I remember.
The only things I could imagine being wrong are either a problem with my connectionString, or the fact that SQLExpress is installed on C:, and webstuff is on D: (Wasn't able to install SqlExpress to D: for some reason)
So I have had like 12 strokes today. If anybody could help me get this fixed, I will spread tales of your awesomeness throughout the lands
I have included some extra info below in case it is needed. Thanks, Adam.
Entire Error
An attempt to attach an auto-named database for fileD:ContentwwwFMakerApp_DataClassAd.mdf failed. A database with thesame name exists, or specified file cannot be opened, or it is locatedon UNC share. Description: Anunhandled exception occurred during the execution of the current webrequest. Please review the stack trace for more information about theerror and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException:An attempt to attach an auto-named database for fileD:ContentwwwFMakerApp_DataClassAd.mdf failed. A database with thesame name exists, or specified file cannot be opened, or it is locatedon UNC share.
Source Error:
Line 1705: } Line 1706: ClassAd.CategoriesDataTable dataTable = new ClassAd.CategoriesDataTable(); Line 1707: this.Adapter.Fill(dataTable); Line 1708: return dataTable; Line 1709: } Source File: c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Filesforms9d7c504b4b8a576eApp_Code.3dq8tdsl.9.cs Line: 1707
Stack Trace:
[SqlException (0x80131904): An attempt to attach an auto-named database for file D:ContentwwwFMakerApp_DataClassAd.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739123 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +170 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 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) +359 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.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +107 ClassAdTableAdapters.CategoriesTableAdapter.GetCategoriesByPropCode(String PropCode) in c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Filesforms9d7c504b4b8a576eApp_Code.3dq8tdsl.9.cs:1707
I was having problems on myt PC so i did a fresh installation. However I had backed up my SQL database (I only have the MDF file and not the log file).
I have tried restoring and attaching options but nothing works :(
I also get the error saying
"Can not open backup device.... Device error or device off-line. See the SQL server error log for more details. RESTORE database is terminating abnormally".
Please this is urgent. WIll be VERY grateful for your urgent reply.
I was having problems on myt PC so i did a fresh installation. However I had backed up my SQL database (I only have the MDF file and not the log file).
I have tried restoring and attaching options but nothing works :(
I also get the error saying
"Can not open backup device.... Device error or device off-line. See the SQL server error log for more details. RESTORE database is terminating abnormally".
Please this is really urgent. Will be VERY grateful for your urgent reply.
Hi I'm creating a database instance with the MSDE 2000 using the Command line(executing a batch File) and once the installation is finished(from the same batch file) I'm trying to attach a database to it. but the database is not attached to the database. but when I go to the sql server and register this new database and run the same command the database is attaching.
can any one suggest how to do this without going to Enterprise manager and registering the database again.
Our GIS group is working with SQL Server 2005 in conjunction with ESRI's ArcGIS software. SQL Server is being used as a test bed until we formally migrate our existing Microsoft Access mdb's over. So, at this time we are conducting various tests and have the freedom to "blow up" our databases.
We are currently testing ArcSDE Workgroup edition, which will only work with SQL Server Express (SSE). SSE will let us create spatial joins and relationships, while maintaining data integrity. So one possible workaround was to detach the database from SQL Server 2005 and then attach it to SSE. Unfortunately, we ran into a problem in re-attaching the database back to SQL Server 2005.
The exact steps are as follows:
Back up database using back up tool in SQL Server 2005.
Detached database from SQL Server 2005.
Attached database to SQL Server Express (hereafter SSE).
Created a table in database while it was attached to SSE.
Detached database from SSE.
Attempt to attach database to SQL Server 2005 failed
Successfully restored database in SQL Server 2005 using Restore tool. Step number 6 above failed and generated the following error:
TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataLNRIS_SQL_Test.mdf'. (Microsoft SQL Server, Error: 5123) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=5123&LinkId=20476
Questions:
Why did I get this error?
Can incorrect or missing permission or ownership settings generate this kind of error?
Please help! I cannot debug CLR procs remotely. Whenever I try to start debugging in VS2005 I get the error: Unable to start T-SQL Debugging. Could not attach to SQL Server process on .... I have clr enabled set to 1 and I have Allow SQLCLR Debugging set on. But I continue to get this error. Any help would be greatly appreciated.
Now that everyone helped me install SQL Server, it's time to use it... then...
I'm trying to work my through the MS Press book ADO.Net Step by Step. After installing the practice files, there is a step to attach the sample database provided. Within the folder which contains the sample files, I'm told to execute an app which I believe was called "Config.exe". This app brings up a form with 3 text-boxes, to collect the Server Name, Database Name, as well as the Database MDF Filename. There are also 2 buttons, "Attach" and "Detach".
This book assumes, that SQL Server Express is installed. In the book, the author does mention that if this isn't the case, to adjust the Server Name as necessary.
(The following do not include the quotes, but you probably already knew that...)
In the form mentioned above, the default Server Name is "(local)SQLEXPRESS",
I changed this to "(local)MSSQLSERVER".
The next text-box for Database Name contains: "AdoStepbyStep"
The last text-box for Database MDF Filename contains: "c:ADO.NET 2.0 SBSSampleDBsAdoStepbyStep_Data.MDF"
The path/spelling of the text in the above is indeed correct. Clicking the "Attach" button, results in the following:
--- ERROR ---
Function: AttachDB
Description: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]InvalidConnection.
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (ParseConnectParams()).
I've never used SQL Server, so please any advice needs to be at a relatively elementary level. I've primarily been a mainframe programmer, so this is new to me.
I've installed Visual Studio 2005 Professional evaluation edition on both my desktop & on the server to try out the Debugger to be used with my Stored procedures
I got this error message every time i try to 'Step into Stored Procedure' from my desktop to connect to the stored procedure which resides on the Server.
Error message: Unable to Start T-SQL Debugging. Could not attach to SQL Server Process on 'Server1'.The RPC server is unavailable
The 'Step into Stored Procedure' works though if I open the stored procedure directly on the server.
Both my PC and Server has been installed with Remote Debugger and my windows login has been assigned permission to debug on the debugger that resides on the Server and has sysadmin server role on SQL 2005 both on PC and Server.
Can someone tell me what i miss out to debug Stored procedure in the SQL Server 2005 on the Server from my PC?
I'm having some problems debugging SQL Server stored procedures on a SQL Server 2005 server. I have installed Visual Studio 2005 on a workstation running Windows XP, now I'm trying to debug a ASP.Net web application that has some code that executes the stored procedures on a Windows 2003 Server running SQL Server 2005.
I opened VS2005 ... created a connection to the SQL Server 2005 instance ... open the Stored procedure ... right click the stored procedure name and selected Step into Stored Procedure and the following message is displayed:
Unable to start T-SQL debugging.Could not attach to SQL Server process on 'ServerName'.
This issue has been raised in a tangentially related thread (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=301467&SiteID=1) but no thread has been started specific to this issue. When trying to deploy a reporting services project using devenv on the command line, the following error is raised for each report.
Code Snippet
Error : Invoke or BeginInvoke cannot be called on a control until the window handle has been created
We have a single solution with multiple reporting services projects, one project for each folder in our directory tree. We are trying to use the solution file as a "make file" by issuing the following batch command.
An attempt to attach an auto-named database for file C:WebApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. My web.config file, the connection strings <connectionStrings> <add name="POAdatabaseConnectionString1" connectionString="Data Source=sss;Persist Security Info=True;Initial Catalog=POAdatabase.mdf;Integrated Security=SSPI" providerName="System.Data.SqlClient" /> </connectionStrings> I cann't really find the statement for attaching aspnetdb.mdf. I don't where to find it. Is there any other web.config file in the C drive? Thanks for help!
(select count(*) from dto_initial_screening where (dto_initial_screening.facilityNo = ref_facility.facilityNo and dto_initial_screening.testDt between '2007-01-01' and '2008-01-01')) as 'TotalScreened',
(select count(*) from dto_initial_screening where (dto_initial_screening.testResult = 'POS' and dto_initial_screening.facilityNo = ref_facility.facilityNo and dto_initial_screening.testDt between '2007-01-01' and '2008-01-01')) as 'NoOfPositives'
from dto_initial_screening left join ref_facility on dto_initial_screening.facilityNo = ref_facility.facilityNo left join ref_region on ref_facility.adrRegionCd = ref_region.regionCd
where ('NoOfPositives') < (select Cast(paramVal as UNSIGNED) from ref_param where paramCd = 'minPositives')
See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at HP.CUE.Video.PlaybackControl.UpdateProgressBar() at HP.CUE.Video.PlaybackControl._ProgressTimer_Tick(Object sender, EventArgs e) at System.Windows.Forms.Timer.OnTick(EventArgs e) at System.Windows.Forms.Timer.Callback(IntPtr hWnd, Int32 msg, IntPtr idEvent, IntPtr dwTime)
************** JIT Debugging ************** To enable just in time (JIT) debugging, the config file for this application or machine (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled.
When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the machine rather than being handled by this dialog.
Hello guys! I am trying to debug a sql procedure inside Server Explorer but I can seem to step into each line. When I run the procedure it doesn't stop in the breakpoint I set.
How to test @au_lname's value sends to the following following sql command? Dim MyCommand As New SqlCommand("UPDATE [authors] SET [au_lname] = @au_lname", MyConnection)MyCommand.Parameters.Add(New SqlParameter("@au_lname", SqlDbType.NVarChar)).Value = me.au_lname.text I tried to print the "MyCommand.CommandText.ToString" but only get UPDATE [authors] SET [au_lname] = @au_lname with no value in the command text. Thanks!
